Microsoft Excel Intermediate 1
Develop practical Excel skills, enabling users to work more efficiently with spreadsheets, organise and analyse data, and present information clearly. Delegates will learn to use Excel Tables, conditional formatting, sorting and filtering, formulas and charts.
Complete Course Syllabus
Reviewing Formulas and Calculations
- Overview of Excel formulas and calculations
- Understanding relative, absolute and mixed cell references
- Common time-saving tips and keyboard shortcuts
Working Efficiently with Worksheets
- Group editing worksheets
- Using AutoFill and Flash Fill
- Customising Excel options
- Changing the default number of worksheets
- Creating custom AutoFill lists
- Adding tools to the Quick Access Toolbar
Working with Excel Tables
- Creating, formatting and managing Excel Tables
- Creating calculated columns
- Using slicers to filter table data
- Using totals to calculate statistics
- Removing duplicate records
- Converting Tables back to normal ranges
Conditional Formatting
- Applying conditional formatting
- Customising conditional formatting rules
- Using icons in conditional formatting
- Applying conditional formatting using formulas
Sorting and Filtering Data
- Sorting database records
- Applying basic filters
- Using AutoFilter and Search
- Sorting by multiple levels
- Sorting using custom lists
Creating and Formatting Charts
- Creating charts from start to finish
- Exploring the different chart types
- Formatting chart elements and styles
- Filtering charts by series or categories
More Excel Courses
Microsoft Excel Introduction
Master workbook navigation, efficient data handling, and essential formulas. Create professional-looking spreadsheets, design clear charts, and produce polished print-ready reports.
Microsoft Excel Intermediate 2
Building on the skills developed in Excel Intermediate 1, this course introduces more advanced formulas, workbook techniques and data analysis tools. Delegates will learn to use logical and lookup functions, work with named ranges and linked workbooks, apply advanced filtering techniques, enhance charts and gain an introduction to PivotTables.
Microsoft Excel Advanced
The goal of this course is to provide you with the knowledge required to use advanced functions and formulas, analyse complex data using PivotTables and PivotCharts, perform What-If Analysis, audit and troubleshoot formulas, validate and consolidate data, import and transform external data using Power Query, and automate repetitive tasks using macros.