Loading...

Course Overview

Excel 2016 - Advanced

Section 1 - Summarizing Data

  • 3D reference formulas
  • 3D reference functions
  • Subtotals
  • Advanced filters

Section 2 – Functions in Lists

  • SUBTOTAL function
  • Function AutoComplete
  • Change the Function
  • COUNTIF and SUMIF
  • FREQUENCY function
  • Database functions
  • Ranges and formulas
  • DMAX Formula

Section 3 – Lookup Formulas

  • Assign range names
  • Lookup formulas
  • Linked formulas
  • Linking functions
  • Protecting workbooks
  • Security warnings
  • Excel Templates
  • Array formulas

Section 4 – Working with Text

  • Import Wizard
  • CONCATENATE and PARSE
  • TEXTJOIN
  • Transpose
  • TEXT function

Section 5 – Macros

  • Display the Developer tab
  • Recording and running macros
  • Macro-enabled workbooks
  • Testing macros
  • Editing macros
  • Visual Basic Editor
  • Assigning Macros

Section 6 – Office Integration

  • Copying into Word
  • Linking worksheet objects
  • Updating links
  • Edit existing links
  • Embedding worksheet objects
  • Importing from Access
  • Importing from the Internet
  • Access Get External Data command
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .