Coursera Plus Annual is 50% Off — Ends June 17.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CreativeLive

Excel Bootcamp

via CreativeLive

Go to class Write review

Overview

This three-day Excel Bootcamp takes you from complete beginner to advanced user, bundling three one-day courses into a single comprehensive package. You will kick things off with Excel Fundamentals, where you will get comfortable with the essentials: calculations, basic functions, charts, formatt...

Syllabus

  • Interface
  • Rows and Columns
  • Autofill
  • Data Entry
  • Calculations
  • Autosum Functions
  • Text Functions
  • True False
  • Absolute Cell References
  • Multi Input Functions
  • Formatting
  • Conditional Formatting
  • Line Chart
  • Column Chart
  • Trendlines
  • Pie Chart
  • Tables
  • Printing
  • Worksheets
  • Freeze Panes
  • Excel Tricks
  • Tips and Fundamentals
  • Navigation
  • Paste Special
  • Paste Special Values
  • Splitting Text
  • Joining Text
  • Named Ranges
  • Data Validation
  • Remove Duplicates
  • VLOOKUP
  • HLOOKUP
  • Sort and Filter
  • Pivot Tables New
  • Pivot Grouping Timelines
  • Multiple Pivot Tables
  • If Statements
  • And Or
  • COUNTIFS and SUMIFS
  • Combo Charts
  • Advanced Cell Lock
  • Hot Keys
  • Go To Special
  • Date Functions
  • Adv Conditional Formatting
  • Nested IFs
  • If AND OR
  • Goal Seek
  • Data Tables
  • Conditional Sumproduct
  • Pivot Table Variances
  • Pivot Calculations
  • Pivot Charts
  • Match Function
  • Vlookup Match
  • Index Match
  • Index Double Match
  • Windows
  • Working Across Sheets
  • Macros
  • MacrosReport
  • Consolidation

Reviews

4.8 rating at CreativeLive based on 9512 ratings

Start your review of Excel Bootcamp

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.