Advanced Excel
This course is designed for students and professionals to build practical Excel skills, from beginner to advanced levels. Learn the essentials of navigation, formulas, and data management, progress to creating pivot tables and visualizations, and master automation with macros and dynamic dashboards. Whether you’re organizing data, analyzing trends, or creating reports, this course equips you to excel in any field. Transform your Excel abilities and unlock your potential today!
$350
10-Module Program
Perfect for beginners and professionals alike!
Live, Instructor-Led
Learn from experienced instructors in real-time.
10-Hour Course
3 Hours/Week, Weekend classes
Online Classes
Join the course from anywhere. Save on travel-time.
Course Modules
Module 01 - Introduction to Excel
- Excel Interface: Ribbon, Quick Access Toolbar, Formula Bar, Status Bar.
- Basic Navigation: Moving around cells, Selecting cells and ranges.
- Creating and Saving Workbooks: New workbooks, Templates, Saving and sharing options.
- Data Entry: Entering text, numbers, dates, autofill.
- Basic Formatting: Font, cell alignment, borders, number formats.
Module 02 - Data Management Basics
- Sorting and Filtering Data: Basic sort, multi-level sorting, custom sort, filter data based on conditions.
- Data Validation: Setting up rules, dropdown lists, validation for numbers, dates, text length.
- Removing Duplicates: Identifying and removing duplicates across columns.
- Conditional Formatting: Rules for highlighting cells, color scales, data bars, icon sets.
Module 03 - Essential Formulas
- Basic Math Operations: Using SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, SUBTOTAL.
- Logical Functions: IF statements, AND, OR, nested IF.
- Text Functions: CONCATENATE (or CONCAT), LEFT, RIGHT, MID, LEN, FIND, UPPER, LOWER, PROPER, TRIM.
- Date and Time Functions: TODAY, NOW, YEAR, MONTH, DAY, HOUR, MINUTE, NETWORKDAYS, EOMONTH.
Module 04 - Working with Tables
- Creating and Formatting Tables: Converting ranges to tables, using Table Styles, table naming.
- Structured References: Using column names instead of cell references in formulas.
- Table Design: Adding/removing rows and columns, total row, header row.
- Working with Large Datasets: Freezing panes, splitting windows, navigating large tables efficiently.
Module 05 - Data Analysis with Pivot Tables
- Creating Pivot Tables: Setting up a Pivot Table from scratch, using different data sources.
- Filtering and Sorting in Pivot Tables: Filtering data, sorting fields within Pivot Tables.
- Grouping Data: Grouping dates, numbers, and custom groups.
- Creating Pivot Charts: Visual representation of Pivot Table data with Pivot Charts, customizing chart options.
Module 06 - Advanced Formulas
- Lookup Functions: Using VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP (for newer versions).
- Nested IFs: Combining IF functions with other functions (AND, OR, etc.).
- Array Formulas: Basic array functions, working with multi-cell arrays, dynamic arrays.
- Dynamic Named Ranges: Creating named ranges that automatically expand as new data is added.
Module 07 - Data Visualization Basics
- Creating Charts: Selecting data for charts, types of charts (Bar, Line, Pie).
- Customizing Charts: Changing colors, adding labels, axes options, legend.
- Sparklines: Miniature charts within cells, line, column, win/loss types.
- Advanced Chart Techniques: Combo charts, secondary axes, adjusting scales, trendlines.
Module 08 - Advanced Data Analysis
- Data Analysis Tools: Goal Seek for “what-if” scenarios, using Data Tables for sensitivity analysis, Solver for optimization problems.
- Scenario Manager: Creating and managing different scenarios for forecasting.
- Data Analysis Expressions (DAX Basics): Introduction to DAX language, creating calculated columns and measures for analysis.
Module 09 - Automation with Macros
- Introduction to Macros: Understanding macros, setting up security levels.
- Recording and Editing Macros: Recording a basic macro, viewing the code, making edits.
- Introduction to VBA: Basic VBA concepts, syntax, using VBA to automate tasks.
- Automating Common Tasks: Writing simple VBA codes to automate repetitive tasks, creating buttons for automation.
Module 10 - Advanced Data Visualization
- Power Query Basics: Importing, transforming, and combining data from multiple sources.
- Power Pivot: Creating relationships, data modeling, using measures.
- Advanced Chart Customization: Creating custom charts like waterfall, histogram, sunburst.
- Dashboard Creation: Combining multiple charts, slicers, and interactive elements to create dynamic dashboards.
Course Outcomes
- Master Data Management: Organize, sort, filter, and validate data efficiently.
- Develop Analytical Skills: Use formulas, pivot tables, and advanced tools to analyze data and uncover insights.
- Create Impactful Visualizations: Build charts, dashboards, and dynamic reports for clear and engaging data presentations.
- Automate Tasks: Leverage macros and VBA to streamline repetitive tasks and boost productivity.
- Apply Real-World Excel Solutions: Solve practical challenges in data analysis, forecasting, and decision-making.
Join Now