Introduction to Excel 365

Who should attend: Those people who are new to Excel and who require an introduction to this popular spreadsheet application.
Please note that bespoke courses may be created using topics of the client's choice, free of charge.


Topics Include

Getting Started With Excel 365
The Excel 365 Interface
Spreadsheet Concepts
Selecting Areas in a Worksheet
Understanding Pointer Shapes
Customising the Quick Access Toolbar
Filling In Data Series Automatically

Preparing Sheets for Printing
Headers and Footers, Orientation, and Scaling
Setting Print Area
Repeating Print Titles
Using Different Views
Page Break Preview and Page Layout View

Applying Cell Styles
Changing the Workbook Theme
Utilising the Undo and Redo Commands

Setting Number Formats
Percent, Currency, Decimal Places
Formatting Dates
Setting Text Format
Adding Borders
Changing Font, Colour, and Size
Using the Format Painter to Copy Formats

Setting Conditional Formatting Rules
Finding and Editing Rules
Top and Bottom Rules
Clearing and Deleting Rules
Data Bars, Colour Scales, and Icon Sets

Understanding Formula Creation
Using Mathematical Operators
Understanding use of BODMAS
Copying Formulas
Formulas Vs Functions
Using the AutoSum Icon
Summing Ranges Using SUM Function
Sub-Totals and Grand Totals
Using AVERAGE, MAX, MIN, and COUNT Functions

Creating Charts
Using Recommended Charts
Editing and Formatting charts
Applying Built-In Chart Styles
Adding and Removing Chart Data
Creating a Default Chart in One Step

Inserting and Deleting Rows/Columns
Understanding Format Options Available
Inserting and Deleting Cells
Clearing Cell Contents
Hiding and Unhiding Rows/Columns

Understanding Cell Addressing in Formulas
Absolute and Relative Addresses

Multiple Sheet Handling
Inserting, Moving, Copying, and Deleting Sheets
Setting Sheet Colour
Hiding and Unhiding Multiple Sheets
Linking Sheets Using Formulas
Using the Watch Window
Grouping and Ungrouping Sheets

Opening and Arranging Windows
Viewing Different Workbooks Side by Side
Setting Synchronous Scrolling
Viewing the Same Workbook in Multiple Windows
Splitting Windows
Freezing and Unfreezing Panes
Setting Zoom Options
Hiding Gridlines, Headings, and Formula Bar

Working With Data
Splitting Data Using the Text to Columns Feature
Understanding Data Filtering
Sorting Data
Creating Excel Tables
Applying Table Styles
Adding a Total Row
Using Slicers to Filter Data