Excel Tips and Tutorials
An extensive collection of easy-to-follow Excel tutorials, with videos, free workbooks
and step-by-step instructions.
A B
C D E F
G H I J
K L M N
O P Q R
S T U V
W X Y Z
Conditional Format | Pivot
Table Index | VLOOKUP | COUNT
| SUM
What's New
Contextures Blog: How to make country flags in Excel 365, with 1 formula instead of 48672! June 30, 2022
Compare Lists: Compare two Excel lists, to find new items in second list, and add them to first list. June 20, 2022
Pivot Table Blog: Quick and easy steps to make a clustered stacked pivot chart in #Excel. Video and sample file. June 8, 2022
Debra D Blog: Use bookmarks and shortcut keys for quick navigation in Notepad++ file. June 6, 2022
Also see: Pivot Table Blog || RSS || Debra D Blog || Previous News
D
- Dashboard, Excel
- Dashboard Course Review
- Dashboard
Tips
- Data
Bars - Conditional Formatting
- Data Entry
- Tips Videos
- Data Entry - Fill Blank Cells
- Data Entry - Numbers Don't Add
Up
- Data Entry - Increase by Set Amount
- Data Entry Form, Update
- Data Entry Form, Worksheet
- Data Entry Videos
- Data, Sample (Interactive)
- Data
Tables for What If Analysis
- Date Functions
- Date Picker
- Date Range, Sum or Count
- Dates and Times, FAQs
- Dates, Easter
- Dates, Fix Format
- Dates, Nth Weekday in Month
- Dates, Split Dates and Times
- Delete
Rows Macro
- Dependent ComboBoxes
on UserForm
- Distance, Calculating
- Drop Down List in Cell - Basics
- Drop Down List - Top Items
- Duplicates, Prevent
- Duplicates, Remove from a List
- Duplicates, Remove, Number Problem
- Dynamic Ranges, Naming
Macro
S
- Sample Data (for testing)
- Sample Workbooks
- Scenarios
-- Create and Show
- Scroll
Bar, Date Range
- Scroll
Bar, Worksheet
- Seating Plan, Guest Tables
- Setup Tips, Excel
- Sheet List Popup
- Shortcuts, Keyboard - Interactive List
- Shortcuts, Mouse Double-Click
- SendKeys
- Slicers, Excel Table
- Slicers,
Pivot Table
- Slicers,
Updating VBA
- Sort a List
- Sort Data -- Programming
- Split Dates and Times
- Status Bar Tips
- Subtotals
- Sum - functions and examples
- Support Article, Excel
- Survey Form
Note: Some Excel tutorial links are to Contextures
Blog and Contextures Pivot
Table blog.
Popular Tutorials
Select
Multiple Items from Drop Down
Excel Cluster Stack Chart
VLOOKUP
Function
Excel Count
Functions
Conditional
Format Examples
Create
a Pivot Table
My Blogs
Contextures
Blog
Pivot Tables Blog
Debra's
Blog
Spreadsheet
Day