Duration: 1 day
Attendees: 1 - 10
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.
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
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
Applying Currency, Date, % and Number Formatting Applying Cell colours Adjust Row/Column height and width Add, Delete and Adjust Rows/Columns
Setting Print Areas Repeating Print Heading Headers/Footers
Creating a default Column Chart Changing the Chart type Customising chart colours and fonts
What is a Sparkline? Creating Sparklines Changing Sparkline type Customising the Sparkline