Excel Essential Training
Master Microsoft Excel from basics to advanced features. Learn formulas, pivot tables, data analysis, and automation with macros.
$39.99/month for LinkedIn Learning
Updated on March 8, 2026
Why This Course?
Master Excel formulas and functions. Create pivot tables and charts. Analyze data efficiently. Automate tasks with macros. Increase productivity and efficiency.
Excel fundamentals and interface, formulas and functions for calculations, pivot tables and data analysis, charts and data visualization, macros and VBA automation, and real-world business scenarios.
Office workers using Excel daily, business analysts needing Excel skills, students preparing for business roles, or anyone wanting to master Excel.
Master Excel formulas and functions. Create pivot tables and charts. Analyze data efficiently. Automate tasks with macros. Increase productivity and efficiency.
Step-by-step video tutorials
Module 1: Excel Basics (2 hours)
- Excel interface and navigation
- Entering and editing data
- Basic formulas and functions
- Formatting cells and worksheets
Module 2: Formulas and Functions (4 hours)
- Mathematical operators and order of operations
- Essential functions: SUM, AVERAGE, COUNT, IF
- Text functions: CONCATENATE, LEFT, RIGHT, MID
- Date and time functions
- Logical functions: AND, OR, NOT
Module 3: Data Management (3 hours)
- Sorting and filtering data
- Data validation and drop-down lists
- Removing duplicates
- Text to columns and data cleaning
- Find and replace with wildcards
Module 4: Data Analysis (5 hours)
- PivotTables and PivotCharts
- Conditional formatting
- Data tables and what-if analysis
- Goal Seek and Solver
- Subtotals and grouping
Module 5: Charts and Visualizations (3 hours)
- Creating and formatting charts
- Chart types and when to use them
- Sparklines and data bars
- Combination charts
- Dynamic charts with named ranges
Module 6: Advanced Functions (4 hours)
- VLOOKUP and HLOOKUP
- INDEX and MATCH
- XLOOKUP (Excel 365)
- Array formulas
- SUMIFS, COUNTIFS, AVERAGEIFS
Module 7: Collaboration and Automation (3 hours)
- Protecting worksheets and workbooks
- Sharing and co-authoring
- Comments and notes
- Macros and basic VBA
- Excel templates
Comprehensive Excel training from beginner to advanced Learn essential business skills applicable across industries Hands-on exercises and downloadable practice files Regularly updated for latest Excel versions Includes Excel 365 features Affordable LinkedIn Learning subscription
Requires LinkedIn Learning subscription ($39.99/month) Some advanced features only available in Excel 365 Limited coverage of Power Query and Power Pivot
Dennis Taylor - Microsoft Certified Trainer with 30+ years of Excel experience, LinkedIn Learning instructor since 2012, teaching over 1 million students worldwide
Loading reviews...