About the Course
Microsoft Excel Intermediate aims to advance the data analysis and reporting skills of participants who already know Excel basics. The training covers intermediate formulas, data management tools, and visual reporting techniques so participants can use Excel more effectively and professionally.
Target Audience
Users with a foundational knowledge of Excel
Office professionals actively using Excel in daily workflows
Staff responsible for reporting and data analysis
Professionals looking to take their Excel skills to the next level
Learning Outcomes
Use intermediate and advanced formulas and functions effectively
Perform data analysis and reporting operations
Apply conditional formatting and data management techniques
Work faster and more accurately with larger datasets
Prepare professional Excel reports tailored to business workflows
Curriculum
Module 1 – Introduction
Excel Interface
Using the File Menu
Using the Help Menu (Tell Me What You Want to Do)
Using the Quick Access Toolbar
Customizing the Quick Access Toolbar
Module 2 – Formatting
Using the Home Tab
Font, Date, and Number Formatting
Defining Custom Number Formats
Working with Dates and Date Settings
Formatting Excel Tables
Find, Replace, and Go To Special
Module 3 – Working with Worksheets
Inserting and Deleting Cells, Columns, and Rows
Moving and Copying Worksheets Within a Workbook
Adding and Deleting Worksheets
Moving and Copying Worksheets Between Workbooks
Creating Custom Lists
Flash Fill
Module 4 – Printing Workbooks
Using Workbook Views
Using Scaling Settings
Adjusting Page Margins
Printing Titles
Setting the Print Area
Header and Footer Options
Using Page Layout View
Inserting, Showing, and Deleting Comments
Printing Comments
Module 5 – Worksheet Navigation and View Controls
Splitting, Hiding, and Unhiding Worksheets
Freezing Rows and Columns
Module 6 – Conditional Formatting
Applying Conditional Formatting to Text, Numbers, and Dates
Working with Data Bars, Color Scales, and Icon Sets
Module 7 – Charts
Creating Charts
Using Recommended Charts
Adding and Removing Chart Data
Using Chart Formatting Options
Creating Trend Charts
Using Sparklines
Module 8 – Tables and Data Management
Sorting Tables and Custom Multi-Level Sorting
Applying Filters and Filtering Tables with Advanced Filter
Defining Names and Using the Name Manager
Module 9 – Using Formulas and Functions
Building Formulas
Performing Calculations with Functions
Copying Formulas and Functions
Using Absolute References
Module 10 – Lookup and Conditional Functions
Lookup and Database Functions (VLOOKUP, HLOOKUP)
Conditional Functions (SUMIF, AVERAGEIF, COUNTIF)
Other Courses in This Category
-
Advanced Excel
Advanced Microsoft Excel training covering XLOOKUP, INDEX/MATCH, SUMIFS, database functions, data validation, PivotTables and PivotCharts, workbook security, and recorded macros.
- Live Course
- 8 modules
-
Basic MS Project
Foundational Microsoft Project training covering project scheduling, Work Breakdown Structure (WBS), task dependencies (FS, SS, FF), resource assignment, and Gantt Chart tracking.
- Live Course
- 8 modules
-
Advanced MS Project
Advanced Microsoft Project training covering Critical Path analysis, resource leveling, cost and budget variance tracking, and Earned Value (EV, PV, AC) performance analysis.
- Live Course
- 8 modules
-
Excel VBA Training
Automate Microsoft Excel with VBA: macro recording, Excel Object Model programming, custom functions, interactive UserForms, error handling, and Access/SQL Server integration.
- Live Course
- 9 modules
-
Excel Expert Level
Expert-level Microsoft Excel training covering array formulas, XLOOKUP, INDEX/MATCH, advanced PivotTables, Goal Seek, Solver, What-If Analysis, form controls, and Power Query.
- Live Course
- 8 modules
-
Microsoft Word, PowerPoint and Project for knowledge workers and project teams: long-form corporate document templates, Slide Master and data-driven executive decks, WBS, critical path (CPM) and resource scheduling.
- Live Course
- 5 modules
Get in touch
