From Beginner to Highly Advanced. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft Office 365
I have designed this course to take you from a complete beginner to a highly advanced user. You will learn:
What you’ll learn
- Learn the Most Useful and Common Excel Functions.
- Sort large amounts of data.
- Learn Excel Pivot Table.
- Insesrting Shapes and Images.
- Learn to use Charts.
- Database Functions.
- Protection in Excel.
- Data Validation.
- Printing Options.
- Learn Tips and Trick in Excel to work efficiently.
- Learn to build formulas with functions like VLOOKUP, HLOOKUP, MATCH, INDEX, SUMIF AND MORE.
- SO MUCH MORE!!!.
Course Content
- Getting started with Excel –> 8 lectures • 17min.
- Values, Referencing and Formulas –> 5 lectures • 20min.
- Getting Started with Excel Functions –> 3 lectures • 11min.
- Adjusting Excel Worksheets –> 5 lectures • 13min.
- Protection in Excel –> 3 lectures • 8min.
- Formatting to Make Cells Look Good –> 7 lectures • 19min.
- Inserting Shapes and Images –> 3 lectures • 13min.
- Learn to use Charts –> 5 lectures • 19min.
- Printing –> 4 lectures • 17min.
- Excel Templates –> 2 lectures • 6min.
- Sorting Data –> 6 lectures • 22min.
- Data Validation –> 5 lectures • 18min.
- Database Functions –> 4 lectures • 27min.
- Pivot Tables –> 6 lectures • 27min.
- Excel’s Conditional Functions –> 5 lectures • 22min.
- Excel’s Lookup Functions –> 5 lectures • 22min.
- “Whatif” Tools –> 2 lectures • 5min.
- Text Based Functions –> 2 lectures • 6min.
- Auditing –> 5 lectures • 13min.
Requirements
I have designed this course to take you from a complete beginner to a highly advanced user. You will learn:
. Adjusting Excel Worksheets
. Protection in Excel
. Formatting to make cells look good
. Inserting Shapes and Images
. Using Charts
. Shapes and Images
. Printing
. Excel Templates
. Sorting Data
. Data Validation
. Database Functions
. Pivot Tables
. Excel’s Conditional Functions
. Lookup Functions
. WhatIf Tools
. Text Based Functions
. Audit Formulas
Course Phisolophy:
I have created short videos for every topic in Excel to make it convenient for you to learn Excel even on a very tight and busy schedule. To take full advantage of this course, please watch a video and practice it to see if you understood the contents of the video and have a schedule to practice the things you learned in this course because practising is the most important part of this course. Learning excel relies more on practice rather than memorisation. Try to use the things you learn in this course in your Excel projects more and more to understand them in a deeper sense. I have also included a Excel Practice file in the section 11 of this course with already made formats ready to be used to practice the things you learn in this course.