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.
Complete Course Syllabus
Getting Started with Excel
- What Excel is and how it is used in real jobs
- Explore the Excel interface: ribbons, tabs and tools
- Navigate workbooks with ease
- Save, open, and use templates
Managing Worksheets Like a Pro
- Add, rename, move, copy or delete sheets
- Work efficiently with multiple sheets
- Navigate quickly within large workbooks
Working with Cells, Rows and Columns
- Select, move, copy and delete data
- Use Find and Replace to save time
- Understand different data types
- Insert and resize rows and columns
Formulas and Functions Made Easy
- Understand how formulas work in Excel
- Use essential functions: SUM, AVERAGE, MAX, MIN
- Absolute, Relative, and Mixed references
- Perform basic calculations step by step
Make Your Spreadsheets Look Great
- Format text and numbers professionally
- Add borders, shading and colour
- Align and style cells for easy reading
Introduction to Charts
- Create your first chart in seconds
- Choose the right chart for your data
- Format charts to look polished and professional
Page Layout and Printing
- Set up pages for clean printing
- Adjust margins, orientation and page breaks
- Add headers and footers
- Print selected areas or full workbooks
More Excel Courses
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.
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.