Excel Pro (Basic to Advance)
Want to Learn Excel from Basic to Advance?
Excel is the most powerful tool to manage and analyze various types of Data.
This Microsoft Excel Pro Training for beginners or intermediate users covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.
This course will help you learn Excel basics, Intermediate and advance logics.
Training Modules
- Getting Started with Excel
- Data Entry, Data Editing, and Number Formatting
- Data Formatting
- Working with Cells and Ranges in Excel
- Managing Worksheets
- Introduction to Excel Tables
- Auto-fill
- Custom List
- Flash Fill
- Number Formatting in Excel
- Excel Formula Basics
- Logical Formulas in Excel
- Math Formulas in Excel
- Lookup and Reference
- Formulas in Excel
- Stats Formulas in Excel
- Text Formulas in Excel
- Date and Time
- Formulas in Excel
- Formulas Mix and Match
- Named Ranges in Excel
- Data Validation in Excel
- Data Sorting and Filtering in Excel
- Using Conditional Formatting in Excel
- Introduction to Excel Charting
- Advanced Excel Charting Examples
- Dynamic Charts in Excel
- Overview of Excel Pivot Table
- Formatting the Pivot Table
- Grouping data in an Excel Pivot table
- Calculated Field/Items in Pivot Table
- Pivot Table Slicers
- Pivot Charts
- Protection in Excel
Introduction to - Macros and VB Editor
After Training, you will be able to:
- 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
Duration
4 Weeks
Training Fee
₦70,000