Excel Intermediate

Microsoft Excel Intermediate
Course Overview
Take your Excel skills beyond the basics and learn how to work more efficiently with larger worksheets and datasets. This hands-on course introduces powerful tools for organizing information, analyzing data, and creating professional reports.
Participants will learn practical techniques that improve productivity and help transform raw data into meaningful business information. Through real-world examples and exercises, students will gain confidence using many of Excel’s most valuable features.
Who Should Attend
This course is designed for:
• Excel users with basic spreadsheet experience
• Administrative professionals
• Project coordinators
• Office managers
• Analysts
• Anyone who regularly works with Excel and wants to improve efficiency and data analysis skills
Prerequisites
Participants should be comfortable with:
• Entering and editing data
• Creating basic formulas
• Using common functions such as SUM and AVERAGE
• Formatting worksheets
• Sorting and filtering data
Knowledge equivalent to Excel Fundamentals is recommended.
Topics Include
Working with Excel Tables
• Creating and formatting Excel Tables
• Table styles and features
• Structured references
• Using Total Rows
Conditional and Logical Functions
• IF functions
• Logical tests
• Using functions to automate decisions
• Error checking techniques
Lookup and Reference Functions
• Understanding lookup concepts
• XLOOKUP
• VLOOKUP
• Retrieving information from related tables
Working with Multiple Worksheets
• Linking worksheets
• Creating formulas across sheets
• Managing workbook structure
• Consolidating information
Data Validation
• Drop-down lists
• Restricting data entry
• Input messages and error alerts
• Improving data accuracy
Conditional Formatting
• Highlighting key information
• Data bars
• Color scales
• Icon sets
Managing Lists and Data
• Advanced sorting techniques
• Multi-level sorting
• Advanced filtering
• Removing duplicates
• Subtotals
PivotTables and PivotCharts
• Creating PivotTables
• Summarizing large datasets
• Filtering and grouping information
• Creating PivotCharts
• Interactive data analysis
Chart Enhancement
• Modifying chart elements
• Improving chart readability
• Presenting information effectively
Learning Outcomes
After completing this course, participants will be able to:
• Use Excel Tables to manage and analyze data
• Validate and control data entry
• Apply logical and lookup functions to solve business problems
• Work with multiple worksheets and workbooks
• Analyze information using PivotTables and PivotCharts
• Create more effective reports and visualizations
• Work more efficiently with larger datasets
Lighthouse Training Difference
Lighthouse Training focuses on practical business applications rather than simply demonstrating software features. Participants learn techniques they can immediately apply to improve productivity, analyze data, and make better business decisions.
Shining a guiding light on technology.