fbpx

Basic Excel

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

In this course, we learn the basics of Microsoft Excel.

If you want to enrol for the Advanced Excel Course but have not worked on Excel before, then it is suggested that you complete this Basic Excel course to understand advanced level functions & formulas better.

This course will help you understand the user interface of Microsoft Excel and get started with its fundamentals.

After completing this course, you can confidently use Microsoft Excel for your day-to-day database management.

If you want to learn more than what is covered here then you can enrol in the Advanced Excel Course where you get FREE access to all the contents of this course.

Show More

What Will You Learn?

  • Understanding Microsoft Excel user interface and how to create a new workbook
  • How to enter text and numbers to create our data
  • How to use formulas & functions
  • What are relative and absolute cell referencing
  • How the Autofill feature helps us to save our time
  • How to format text to make the database look awesome
  • How to format numbers to make them easy to understand
  • How to format dates or times
  • How to manage columns
  • How to manage rows
  • How freeze panes help us to read headers of large datasets
  • How to apply borders and background fill colour
  • How to create charts to visualize our data
  • How to add more details to the charts
  • How to print workbooks

Course Content

Getting started with Microsoft Excel

  • Understanding Microsoft Excel User Interface And How To Create A New Workbook
    06:03
  • How To Enter Text And Numbers To Create Our Data
    08:27
  • How To Use Formulas And Functions
    08:24
  • What Is Relative And Absolute Cell Referencing
    08:57
  • How The Autofill Feature Helps Us To Save Our Time
    04:39
  • How To Format Text To Make The Database Look Awesome
    05:03
  • How To Format Numbers To Make Them Easy To Understand
    04:55
  • How To Format Dates Or Times
    03:07
  • How To Manage Columns
    05:53
  • How To Manage Rows
    04:31
  • How Freeze Panes Helps Us To Read Headers Of Large Datasets
    05:45
  • How To Apply Borders And Background Fill Color
    05:06
  • How To Create Charts To Visualize Our Data
    03:49
  • How To Add More Details To The Charts
    04:38
  • How To Print Workbooks
    04:18
  • Next Steps
    00:04