Excel Tutorial - Excel Everest

What’s inside Excel Everest? Tutorial Contents Part 1

ResourcesExcel Everest

Excel Everest, the fun and interactive Microsoft Excel tutorial, has a lot of bells, whistles, and knick-knacks mixed into its tabs. One of the first things we wanted to do is expose the full contents of Excel Everest and show you what’s really under the hood. At the beginning of each of the main topics, Excel Everest answers the question “Why is this important?”. In this series of blog posts, you’ll find an overall index as well as these “Why” paragraphs taken right out of the tutorial.…why is this important?

THE ESSENTIAL EXCEL BASICS

Cells and cell properties

  • Number types
  • Move and autofill cells
  • Absolute vs. relative references

The power of paste special

  • Paste options
  • Transpose function

Basic to advance formatting

  • Colors and borders
  • Text options
  • Formatting tables
  • Conditional formatting

Sorting and auto-filters

  • Sorting
  • Auto-filters

Text to columns and find and replace

  • Text to columns
  • Find and replace
  • Combing these functions

Manipulating rows and columns

  • Adding, moving, and deleting rows
  • Hiding and resizing
  • Grouping

The drawing toolbar

  • Grouping, ordering, and selecting objects
  • Shapes, pictures, and object properties

PLAYING WITH FORMULAS

The critical business formulas

  • Vlookup
  • IF statements

Basic math formulas

  • Sum, count, average
  • Percentile, percent rank
  • Rand & randbetween

Text formulas

  • Quotes and ampersand
  • Right, left, and trim

Statistical formulas

  • Average, median, mode, max, min, correl, and stdev

ANSWERING QUESTIONS ABOUT NUMBERS

The basics that your boss will ask for

  • Pivot tables
  • Basic charting
  • Chart formatting

TIPS AND TRICKS

Business tricks you'll love

  • Making an email list
  • Working with multiple tabs
  • The F5 key
  • Getting ride of duplicates
  • Basic macros
  • Printing from Excel

The joy of keyboard shortcuts

  • Tab/enter & navigation
  • Paste special
  • Ctrl-Y and F4