Microsoft Excel Foundations

Book Now

Course Description

In this course you’ll build the skills you need to manage, explore, analyze, and visualize data in Microsoft Excel using real-world projects and datasets.

Curriculum

• Introducing Microsoft Excel
  The Excel Landscape
  The Excel Interphase

• Spreadsheet Fundamentals
  Data Types in Excel
  Dates in Excel
  Number Formatting
  Data Validation
  Checkboxes & Dropdown Lists
  Removing Duplicates
  Conditional Formatting
  Filtering Data
  Sorting Data

• Formulas & Functions
  Types of Functions
  Basic Math Functions
  Fixed & Relative References
  IF & Nested IF Functions
  AND/OR Operators
  Vlookup & Xlookup Functions
  Date & Time Functions
  Basic Text Functions

• Data Analysis with Pivot Tables

  Creating a Pivot Table
  Modifying Pivot Table Views
  Summarize Values by Options
  Show Values as Calculations
  Sorting & Filtering
  Slicers & Timelines
  Calculated Fields
  Refreshing Pivot Table Data

• Data Visualization with Charts & Graphs
  Why Visualize Data?
  Creating a Basic Chart
  Choosing the Right Chart Type
  Line & Area Charts
  Bar & Column Charts
  Combo Charts
  Pie & Donut Charts
  Histograms
  Maps