Microsoft Excel Basic Formula and Functions

In this course, we will be equipping you with all you need to become super confident while working with an Excel spreadsheet

Our goal in this course is to make sure you have the skills required to analyze enormous amount of data and gain great insights from your data using Excel.

This course covers Microsoft Excel version 2010, 2013, 2016 and 2019.

This course has lots of practical exercises in each module that will help you internalize all that you will learn.

We have divided this course into two levels – Beginner and Intermediate level

For the beginner level, we will be looking at: 

1. Basic Excel workbook and worksheet skills
2. How to format data
3. How to use different fill options in Excel to speed boring tasks
4. How to sort and filter data
5. How to print professionally in Excel
6. How to protect worksheets and workbook 
7. How to create links in excel 
8. How to consolidate different worksheets into one worksheet

While for the Intermediate level, we will be looking at:

1. Keyboard shortcuts
2. Data Formatting techniques
3. Data Validation techniques and Named ranges
4. Logical functions
5. Lookup functions
6. Additional Functions
7. Data presentation techniques