Ms. Office – Advanced Excel Course
Microsoft Excel is a popular and widely used office automation tool in a variety of industries, including banking, insurance, telecommunications, government, and many small and medium-sized businesses, for performing complex calculations, data analysis, reporting, dashboard creation, financial modeling, and learning. Participants will learn all of the key Excel functions and features using Advanced Microsoft Excel tools, ranging from basic to mastery-level excel expertise.
After completing the course, participants will be able to perform their day-to-day tasks in a more productive and professional manner, thereby improving organizational performance.
Advanced Excel Course
Course Content:
Module-I – Excel Foundation
- Getting Started with Excel
- Data Entry, Data Editing, and Number Formatting
- Data Formatting
- Working with Cells and Ranges in Excel
- Managing Worksheets
- Save Your Worksheets
Module-II – Formula | Data | Charts Concepts
- Formula Basics & Cell References
- Auto Fills & Custom Lists
- Working with Basic Excel Functions
- Using Smart Tables
- Sorting & Filtering Data
- Working with Conditional Formats
- Working with Charts
Module-III – Using Advanced Functions
- Working with Named Ranges
- Using Complex Excel Functions
- Using Multi-sheet Formulas
- Using Advanced Filters
- Data Validation & Protection
- Consolidation & List Management
- Automating with Macros
Module-III – Reporting & Dashboards
- Business Reporting with Excel Dashboards
- Advanced Charting & Visualizations
- Using Sparkline Charts
- Creating Interactive Dashboard Reports
Module-IV – Working with Macros & Custom Functions
- Writing Customized Macros
- Using What-If-Analysis
- Working with Financial Functions
- Creating Custom Excel Functions
International Student Fee : 150 USD
Flexible Class Options
- Corporate Group Training | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training