Price$20$8
What you’ll learn
- Master Microsoft Excel from Beginner to Advanced
- Build a solid understanding on the Basics of Microsoft Excel
- Learn the most common Excel functions used in the Office
- Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
- Maintain large sets of Excel data in a list or table
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
- Access to a Professional Trainer with 10+ years of Excel Training
Section 1Excel for Beginners
Lecture 1 Getting Started MS Excel
Lecture 2Adding and Editing Text and Formulas
Lecture 3Basic Excel Functions
Lecture 4Modifying Excel sheets
Lecture 5Formatting data in excel
Lecture 6Inserting images and shapes
Lecture 7Creating basic charts in Excel
Lecture 8Printing Excel Worksheets
Section 2Excel for intermediate
Lecture 9Working with Excel List
Lecture 10 Excel list Functions
Lecture 11 Excel Data Validation
Lecture 12Pivot table
Section 3Advanced Level
Lecture 13IF function
Lecture 14Working With Excel Based Function
Lecture 15Working with Name Range
Lecture 16Protecting Excel Workbook