This one-day course provides delegates with a brief review of Excel basics and
introduces them to more features, functions, and data handling techniques
within Excel 2016. It is designed for those computer users who use
spreadsheets on a regular day to day basis.
Pre-requisites
Delegates should have either attended the Excel Introduction course or have
similar experience gained in the workplace.
Course outline
This course provides delegates with a brief review of Excel basics and
introduces them to more features, functions, and data handling techniques
within Excel 2016. It is designed for those computer users who use
spreadsheets on a regular day to day basis.
These course objectives familiarise delegates with the topics to be covered and provide a means for them to evaluate their learning. Upon successful completion of this course delegates will be able to: –
These course objectives familiarise delegates with the topics to be covered and provide a means for them to evaluate their learning. Upon successful completion of this course delegates will be able to: –
- Finding Your Way Around the Excel 2016 Interface
- Use relative, mixed & absolute cell references
- Manage & navigate worksheets in a workbook
- Sort & filter information held in tables
- Create & use custom cell formats
- Use conditional formatting to highlight results
- Use logical, mathematical, statistical, date/time & text functions
- Use Named cell ranges in formulas
- Customise charts & control chart options
Contents
- Backstage View & the Office 2016 Ribbon
- Using Absolute & Relative Addresses
- Managing Worksheets
- Using Custom Cell Formats
- Using the Format Painter
- Using Conditional Formatting
- Add Data Bars, Colour Scales & Icon Sets to cells
- Using Sparklines to add minicharts
- Hiding/Unhiding Rows & Columns
- Clearing Cell Contents and Formats
- Jumping to a Cell
- Sorting Data
- Filtering Information
- Format cells as Excel 2016 Tables
- Finding and Replacing Data
- Linking Worksheets & Workbooks
- Defining Names for Ranges
- What are Functions?
- Using Math and Trigonometric Functions
- Using Statistical Functions
- Using Logical Functions
- Using Date and Time Functions
- Using Text Functions
- Customising a Chart
- Modifying Chart Options
- Adding New Data
- Changing Chart Type
- Changing Chart Location
- Adding Trendlines
- Working with more than one Axis
- Freeze headings when scrolling a Worksheet
- Using Comments
- Keyboard shortcuts and error codes
Duration:
9.30am to 4.30pm (plus 1 day self learning)
Location:
Delivered online via Zoom/MS Teams
Already completed this workshop?
Dates Available:
To be confirmed