Building a solid foundation in Microsoft Excel is essential for professionals across industries. This two-day course equips participants with the knowledge to perform core spreadsheet functions, format data, create visualisations, and manage workbooks effectively. It introduces both basic and intermediate-level skills to improve productivity and support data-driven decisions.
Learning Outcomes:
Navigate Excel interface and customise its layout
Enter, format, and manage various types of data
Apply formulas, sorting, and filtering to work with datasets
Create and customise charts and tables
Set up worksheets for printing and presentation
Key Topics:
User interface, backstage view, and quick access toolbar
Selection techniques, column/row management, number/text formatting
AutoFilter, table styles, calculated columns, and multi-level sorting
Basic formulas, error checking, and function use
Data management tools and chart creation (2D/3D)
Page setup, print areas, headers, and scaling
Lesson 1: Getting Started with Excel
- Starting Excel
- The User Interface
- Using Microsoft Excel Help and Resources
- Exit Excel
Lesson 2: Working with Workbook and Worksheets
- Cells Navigation
- Using GoTo
- Entering Data
- Shortcuts for Data Entry
- Spell Check
- Working with Selections
- Working with Rows and Columns
Lesson 3: Formatting the Worksheet
- Apply Number Formats
- Apply Text Formats
- Apply Borders and Fill
- Format Painters
- Clearing Formats
Lesson 4: Formulas and Functions
- Using Basic Formulas
- Entering Formulas
- Basic Functions
- Using the AutoSum Button
- Using Statistical Functions (MAX, MIN, COUNT, AVERAGE)
- Using AutoFill
- Editing Functions
- Using Date Functions
- Error Checking
- Create Absolute Reference
- Using IF Function
Lesson 5: Data Management with Tables
- Apply Table Formats
- Changing Table Style
- Adding Table Rows and Columns
- Adding Total Row in Table
- Apply Table Filters
- Sorting
- Finding Data
- Replacing Data
Lesson 6: Charts
- Recommended Charts
- Inserting a chart
- Resizing a chart
- Deleting a chart
- Adding a Chart Title
- Changing the Chart Background
- Formating chart legend, axis
- Changing a column, bar, line or pie slice colors
- Changing the chart type
- Adding a Data Table
- Changing the Chart Layout
- Creating 3-D Chart
- Adjusting 3-D View
- Moving charts
- Deleting chart
- Insert Sparkline
Lesson 7: Preparing outputs
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Add Headers and Footers
- Scaling your worksheet to fit a page(s)
- Repeating Row and Column Labels
- Changing Page Breaks
- Setting/Removing a Print Area
- Printing Options
