
Excel Introduction
Duration: 1 day
Attendees: 1 - 10
Format: Virtual
This course is designed for learners and teams who wish to gain the skills to create, edit, format and print Microsoft Excel worksheets.
This course is suitable for users of Microsoft Excel 2013, 2016 or 365 subscription editions.
Excel Environment
-
Exploring Excel 2016 Ribbons Working with the Excel layout Introducing the Excel Sheet and tools
Working with Ranges
-
Working with ranges Selecting ranges with the keyboard and mouse Entering values into a range Copying/cutting and pasting data Using the AutoFill feature Filling cells
Using Formulas
-
Entering formulas Using the SUM function Using MAX, MIN, AVERAGE and COUNT functions Creating an absolute cell reference Copying and Moving Data Working with Quick Analysis
Sorting and Filtering
-
Sorting data alphabetically and numerically Creating a Custom Sort Filtering Data Applying a Custom Filter
Formatting Cells/Numbers
-
Applying Currency, Date, % and Number Formatting Applying Cell colours Adjust Row/Column height and width Add, Delete and Adjust Rows/Columns
Printing
-
Setting Print Areas Repeating Print Heading Headers/Footers
Charting
-
Creating a default Column Chart Changing the Chart type Customising chart colours and fonts
Sparklines
-
What is a Sparkline? Creating Sparklines Changing Sparkline type Customising the Sparkline