Excel
Excel Help & Tips
- & Formula – Demonstrating Excel Logic
- Alt Key Shortcuts
- Quick Access Toolbars
- Context Menu
- The Scroll Button
- Navigating Tabs Shortcut
- Using Wingdings
- Brackets & Commas
- Sort Left To Right
- Create VLookUps across multiple columns
- Paste special
- 3D SUM
- Create a Planer in Excel
- Selecting next cells in a different order
- VLookUp with multiple values
- Avoid #REF’s – Precedents & Dependents
- Custom Sort
- How to Sum Odd or Even Numbers
- VLookUp to retrive the 2nd, 3rd, etc. result
- How to sum by fill color
- Scenario Manager
- Index Match, an alternative to Vlookup
- Sum cells by color
- Format dates to show st, nd, rd and th
- Data Validation 1 : Short Simple DropDown List
- Data Validation 2 : List based on range of cells
- Data Validation 3 : Automatically adjust source based on list size
- IF Statements
- SUMIF
- SUMIFS – SUMIF with multiple criteria
- COUNTIF
- COUNTIFS – COUNIF with multiple criteria
- LEFT, LEN, MID & RIGHT
- SUMPRODUCT
- IFERROR & IF ISNA
- How To Autofill Sequential Letters
- How To Get Filename Using Formula
- Using the * wildcard in Formula
- Upper, Lower & Proper
- Offset
- Substitute
Excel Charts
Pivot Tables
Excel VBA Macros
- Introduction
- Setting up Excel for VBA
- Recording A Macro & Challenge Question
- Answer To Challenge
- Understanding Your First Macro
- Change Text In A Cell
- Format Text
- Add Macros to custom toolbar