EXCEL · 1 Day

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.

Duration: 1 Day From £550/day (up to 8 learners) 1-to-1 or Groups of up to 8 Learners (Larger by Arrangement) M365 (Desktop & Web) · Office 2021/2024 Certificate · Manuals · 1-Year Support

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
Copied to Clipboard ✓

Ready to Share