ESF Intermediate Course on Excel

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: –
  • 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

Book on workshop!

Get SET Academy needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at any time. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, please review our Privacy Policy.

Go to Top