About the Course

• Creating Workbooks: Saving, Closing, and Opening
• Understanding the Ribbon and Basic Navigation
• Working with Cell References
• Selecting Rows, Columns, and Cells
• Inserting and Hiding Rows and Columns
• Freezing Screens for Better Navigation
• Deleting Data and Basic Formatting
• Formatting Cells and Ranges, Including Number and Date Formats
• Applying Borders and Fill Colours
• Using the Format Cells (Ctrl+1) Feature
• Copying, Pasting, and Using Paste Special
• Format Painter for Efficient Formatting
• Finding and Replacing Text, Numbers, and Blanks

Basic Sums and Functions

• Understanding the Rule of Maths (BODMAS)
• Using Basic Operators (+, -, /, *)
• SUM, MAX, AVERAGE, MIN, and COUNT Functions
• Editing Formulae and Key Commands for Dates and SUM

Step Values and AutoFill

• Creating Step Values for Dates and Numbers
• Using AutoFill to Speed Up Data Entry

Filtering and Sorting Data

• Sorting a Column and Using Custom Sorts
• Filtering a Column with Text, Number, and Date Filters
• Formatting Data as a Table

Printing and Layout Adjustments

• Setting Print Areas
• Repeating Columns and Rows for Printing
• Adding Headers and Footers
• Adjusting Layouts (Normal, Page Break, Print Layout)

Referencing and Charts

• Locking Cells: Absolute, Mixed, and Relative Referencing
• Creating Basic Charts (Column, Line, Pie)
• Formatting Charts
• Key Commands for Charts

Audience Profile
This course is designed for delegates with little or no experience in Microsoft Excel. It provides the essential skills needed to confidently navigate Excel, manage data, perform basic calculations, and format workbooks effectively for professional use.