Excel Essential Skills Course covering basic understanding of excel workbook/worksheet, basic formulas and shortcuts
Welcome to the Excel beginner level skills course. I have more than 9 years of experience in Microsoft Excel and a leading Microsoft Office educational channel so i decided to design a course for excel beginner and intermediate level knowledge individuals.
What you’ll learn
- Basic Microsoft Excel Formulas.
- Basic Microsoft Excel Shortcuts.
- Learning about Workbook/Worksheet.
- Learning about Standard Ribbons.
Course Content
- Introduction –> 1 lecture • 4min.
- Basic Formulas –> 1 lecture • 11min.
- 15 Useful Shortcuts –> 1 lecture • 3min.
- Flash Cell –> 1 lecture • 2min.
- Net Working Days Formula –> 1 lecture • 2min.
- Chart Creation –> 1 lecture • 2min.
- Protect Workbook/Worksheet –> 1 lecture • 3min.
- Sort and Filter –> 1 lecture • 2min.
- Formatting of Data –> 1 lecture • 3min.
- Ribbons of Microsoft Excel –> 1 lecture • 7min.
Requirements
Welcome to the Excel beginner level skills course. I have more than 9 years of experience in Microsoft Excel and a leading Microsoft Office educational channel so i decided to design a course for excel beginner and intermediate level knowledge individuals.
After completion of this course you will gain a variety of essential excel skills as listed below in the content of the course. Included in this course are 10 simple and easy to follow videos.
In this tutorial you will learn the most commonly used functions, shortcuts and basic formulas which are required for performing day to day tasks:
-Understanding of Workbook and Worksheet
-SUM, Division, Percentage, MIN/MAX, IF and other basic formulas
-Important Basic Shortcuts
-Flash Cell
-Net Working Days Calculation
-Charts
-Protect Excel File
-Sort and Filter
-Formatting of Data
-Understanding of Ribbons
All functions and formulas taught on the course are explained in a simple manner with easy to follow examples and scenarios to make the most of your learning. At the end of the course, you will proficient enough to work in excel.
This course is for excel beginner or intermediate level user and will help to understand Microsoft Excel application with simple and easy examples.