Acumen IT Training, Inc.

MICROSOFT EXCEL 2016 ADVANCED

COURSE DESCRIPTION

This course provides the participant to use the spreadsheet application to produce what are deemed to be advanced spreadsheet outputs. The participant shall be able to operate effectively at more than intermediate level of competence and be able to sort, query and link data. The participant shall be able to use functions such as those associated with logical, statistical or mathematical operations. Furthermore, the participant will be able to use available analysis and audit tools and to run and record simple macros.

COURSE OUTLINE

Module 1. Using Auditing Tools and Range Names

  • Jumping to a Named Range
  • Assigning Names
  • Using Range Names in Formulas
  • Creating Range Names from Headings
  • Applying Range Names
  • Deleting Range Names
  • Using Range Names in 3-D Formulas
  • Displaying/Removing Dependent Arrows
  • Displaying/Removing Precedent Arrows
  • Showing Formulas
  • Labs

 

Module 2. Exporting and Importing Data

  • Importing Data from Text Files
  • Changing External Data Range Properties
  • Removing the Query Definition
  • Creating a Hyperlink
  • Editing a Hyperlink
  • Labs
Please contact us for the full course outline, schedules and for booking a private class.
;