Excel Teacher

Free Training Online - How to Do Stuff In Microsoft Excel

Excel Teacher site navigationSkip to content
  • Home
  • Using ExcelGeneral tips, discussion, and insight on how to get the most from the Excel interface and main features
    • Files and Data Management
    • Ribbons and QAT
    • Formatting
    • Viewing
    • Shortcuts
    • Status Bar
    • Developer
    • Backstage
  • Functions
    • Basic Arithmetic
    • The LogicalsLogical formulae – if, is, not
    • Text
    • Lookups and References
    • Date and Time
    • Advanced Maths
    • Financial
    • Other Advanced Functions
  • Charts & Graphs
    • Standard
    • Advanced
    • Custom Charts
  • Pivot TablesThe All Powerful Pivot Table
  • VBA
    • How To
    • Recording Macros
    • Code Library
    • Add-Ins
  • Information
    • About Us
    • Comments and Moderation
    • Links
Search
  • Excel Teacher Facebook Page
  • Excel Teacher Twitter Feed
  • Excel Teacher Youtube Channel
  • Excel Teacher RSS Feed

Tag: xl

INDEX, MATCH, and INDEX(MATCH)

VLOOKUP (Pronounced V Lookup, not vloo-kup, in case you were wondering) is…

Continue reading "INDEX, MATCH, and INDEX(MATCH)"…
15 Jan 2016

Excel Shortcut Ctrl + Enter. Very Helpful

Today, I’m going to show you one of the most handy shortcuts…

Continue reading "Excel Shortcut Ctrl + Enter. Very Helpful"…
28 Nov 2015
GETPIVOTDATA error example

Wrap If Error Macro

So as promised, here’s the code to wrap formulae in an IFERROR…

Continue reading "Wrap If Error Macro"…
9 Nov 2015 Comments: 0
1 2 »
© 2021 Excel Teacher. Back to top ↑
  • Excel Teacher Facebook Page
  • Excel Teacher Twitter Feed
  • Excel Teacher Youtube Channel
  • Excel Teacher RSS Feed