Understanding MS Excel – Basics
- Home
- Understanding MS Excel – Basics
2 day INTENSIVE course
Understanding MS Excel – Basics
What is it about?
This programmed is designed for beginners who want to build a solid foundation in Microsoft Excel. By the end of the course, participants will be able to navigate Excel efficiently, create and format spreadsheets, use basic formulas and functions, and visualize data with charts.
Who is it for?
A 2 programme that is a must for all beginners.
Content
- Overview of Excel and its applications
- Understanding the Excel interface (ribbons, toolbars, and workspaces)
- Navigating workbooks, worksheets, and cells
- Opening, saving, and closing Excel files
- Data entry basics: text, numbers, and dates
- Editing and deleting data
- Copying, cutting, and pasting data
- Using AutoFill and Flash Fill
- Sorting and filtering data
- Adjusting column width and row height
- Formatting text (font, size, colour, alignment)
- Applying number formats (currency, percentage, date, etc.)
- Using cell styles and themes
- Conditional formatting for data visualisation
- Introduction to formulas and cell references
- Using basic mathematical operations
- Understanding relative and absolute cell references
- Creating and formatting tables
- Sorting and filtering table data
- Introduction to charts and graphs
- Creating bar charts, pie charts, and line graphs
- Adding, renaming, and deleting worksheets
- Moving and copying worksheets
- Using freeze panes and split view
- Printing worksheets (page setup, print preview, headers & footers)
- Setting data validation rules (drop-down lists, number limits)
- Protecting worksheets and workbooks with passwords
- Hiding and locking cells
- Essential keyboard shortcuts
- Using Find and Replace efficiently
- Quick analysis tools for data interpretation
