Advanced Excel

By SGS Education Categories: Excel
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Enhance a basic excel worksheet using Pivot Tables and Charts, advanced functions like SUMIF, as well as use lookups.

What Will You Learn?

  • Review Basics
  • Subtotal Functions
  • Range names and Filter date
  • Pivot Tables
  • Selected Functions
  • SUBTOTAL
  • SUMIF
  • ROUND function
  • VLOOKUP & HLOOKUP

Course Content

Topic 1: Review Basics

  • Downloading from Account Reconciliation
    00:00
  • The Excel environment
    00:00
  • The Sparkline
    00:00
  • The Trend line
    00:00

Topic 2: Subtotal Functions

Lesson 3: Range names and Filter date

Lesson 4: Pivot Tables

Lesson 5: Selected Functions

Student Ratings & Reviews

No Review Yet
No Review Yet

Join Our Community

Enter your email address to register to our newsletter subscription delivered on regular basis!
×