Excel: Intermediate

Excel: Intermediate

from 145.00
Date:
Delivery Method:
Module:
Quantity:
Purchase Now

GSA Checkout → GSA

Course ID: A1200b

Duration: 1 Day | 2 Modules (9:00 am - 4:00 pm PST)

Location: In-Person (San Francisco) or Live Online | Click here to schedule private course.

 

Overview:

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.

+ Who Should Attend

Anyone who manages, creates or edits large spreadsheets of data and would like to efficiently analyze, summarize, and visualize data. Knowledge of Excel Introduction preferred.

+ Course Outline

Module 3: List/Table Essentials & Charting

  • Overview Of List Design
  • Formatting Lists As Tables
  • Using The Flash Fill Option
  • Single And Multi-Level Sorting
  • Removing Duplicates From A List Or Table
  • Filtering Records In A List Or Table
  • Search By Filter
  • Inserting Automatic Subtotals In A List
  • Using The Quick Analysis Tools
  • Inserting Data Charts
  • Recommended Charts
  • Formatting And Editing Chart Elements
  • Adding/Removing Data From A Chart
  • Creating Custom Chart Templates
  • Printing Charts
  • Changing Table And Chart Formatting Through Themes
  • Inserting Sparkline

  Module 4:  Pivot Tables, Protecting & Linking Data

  • Creating Pivot Tables From Lists Or Tables
  • 2016 Pivot Table Enhancements
  • Filtering Pivot Tables
  • Multi-Select Slicers & Timeline Slicers
  • Working With Pivot Charts
  • Data Validation Rules
  • Applying Built In Conditional Formatting
  • Creating Custom Conditional Formats
  • Comments
  • Linking Data
  • Cell, Sheet, And File Protection

+ Prerequisites

There are no prerequisites for this course.

+ Certifications

N/A

+ More Excel Courses