MICROSOFT EXCEL INTERMEDIATE

  • PURPOSE

  • COURSE CONTENT

  • DELIVERY

  • ACCREDITATION

The Intermediate Microsoft Excel course is for those who understand the basics of Excel and are familiar with the Excel screen, formatting and basic formulas.
You will explore basic Vlookups and pivot tables to ensure that you understand the more advanced formulas and functions of MS Excel.

Unit 1: Calculating data with advanced formulas

  1. Applying cell and range names
  2. Naming ranges automatically
  3. Using specialised functions
  4. Fixed referencing

Unit 2: Organising worksheets and table data

  1. Sorting and filtering data
  2. Creating and modifying tables

Unit 3: Presenting data using charts

  1. Creating a chart
  2. Modifying charts
  3. Adding data to charts

Unit 4: Simplistic 

  1. MIN, MAX and Average
  2. COUNT, COUNTA and COUNTBLANK
  3. Rounding

Unit 5: Inserting graphic objects

  1. Inserting graphic objects
  2. Drawing and modifying shapes
  3. Illustrating workflow using SmartArt graphics
  4. Adding a background

Unit 6:C Custom formatting

  1. Custom format numbers, date, etc.

Unit 7: Other functions

  1. Watch window options
  2. Text to columns
  3. Subtotal function
  4. Protection
  5. Setting up calculations
  6. Types of errors
  7. Breaking links
  8. Data validation
  9. Hyperlink 

Unit 8: Dates

  1. Working with dates and time
  2. Dynamic dates and TODAY and NOW functions

Unit 9: Formatting functions

  1. Conditional formatting
  2. Format painter
  3. Paste special

Unit 10: Reporting formula

  1. Pivot tables
  2. Counting using pivot tables and drilling down into detail
  3. Updating a pivot table with new data and adding multiple values
  4. Using calculated fields in pivot tables
  5. Removing or hiding subtotals, grand totals and filling blanks

Unit 11: Google sheet

  1. Google sheets

 

Duration: 1 Day

Delivery: Classroom/Online

 

5 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of all courses.

1 Day Courses: Participants will receive a SpecCon Holdings certificate upon completion of this course.