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 | Pivot
Tables Blog
Newsletter Index | Pivot
Table Index | VLOOKUP | COUNT
|
SUM
What's New
Pivot Table Blog: To stop people from selecting (All) in an Excel pivot table filter, use this macro, for normal or OLAP-based pivot tables. Feb 24, 2021
Contextures Blog: In her latest Excel video, Sarah shows how to add and remove line breaks in a worksheet cell, using Excel shortcuts Feb 18, 2021
Excel Newsletter: Read the latest issue - Hyperlinks oddity, line breaks shortcuts, and more. Don't miss the next issue - sign up to get it by email. Feb. 23, 2021.
Also see: Previous News || Excel Events || RSS || Excel Humour || Debra D Blog
C
- Calorie Burn Calculator
- Calorie Counter
- Cartesian
Join with MS Query
- Check Box, Change Formula
- Check
Box, VBA
- Christmas Planner
- Christmas
Tree Scroll Bar
- Code, Copy to a workbook
- Coderre, Ron - Sample Workbooks
- Column headers show numbers
(FAQ)
- Combine Text/Numbers (Concatenate)
- Concatenate
UDF
- Contextures Blog
- Cost Calculator, Annual
- Count Duplicates
- Count Functions
- Count Specific Items
- Count Specific Items in Cell
- Custom Views
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
Popup List
- Data Entry Videos
- Data, Sample (Interactive)
- Data
Tables for What If Analysis
- Data Validation
Premium Kit
- Date Functions
- Date Picker
- Dates and Times, FAQs
- Dates, Easter
- Dates, Fix Format
- Dates, Nth Weekday in Month
- Delete
Rows Macro
- Dependent ComboBoxes
on UserForm
- Distance, Calculating
- Drop Down List in Cell - Basics
- Duplicates
-- Prevent
- Duplicates
-- Remove from a List
- Dynamic Ranges, Naming
Macro
E
- Email from Excel with PDF
- Excel
Add-ins List, Free
- Excel Book List (Interactive)
- Excel Error Values
- Excel Events
- Excel FAQs
- Excel, Key Skills
- Excel Resources
- Excel Resources, Mac
- Excel Resources, Power BI
- Excel Setup Tips
- Excel Support Articles
- Excel
Tools Add-in
F
- FastExcel
Tools Review
- Filters - Advanced AutoFilter
- Filters, Right-Click Macros
- Find
and Replace
- Fiscal Year - Calculate
- Fiscal Year - Pivot Table
- Flash Fill, Reverse Names
- Form Control Buttons
- Forms, Create
a UserForm
- Forms, Data Entry and
Update
- Forms, Print Selected Items
- Forms, Survey
- Forms, Worksheet Data Entry
- Formatting Tips
- Freeze Panes Tips
G
- Gantt Charts
- GetPivotData
- GetPivotData Reports
- Gift Ideas for Excel Users
- Golf Scores Template
- Golf Tee Off Times
- Govier, Roger - Sample Files
H
- Holiday Planner
- Holidays, Excel for the
- HTML Code, Create
- Hyperlinks,
Add, Remove
I
- IFRAME Code, Create
K
- Keyboard Shortcuts, Interactive List
L
- Last Row,
Excel VBA
- Leap Year Calculations
- Line-Column Chart
on 2 Axes
- List
Box, Excel VBA
- Lists - AutoFilter VBA
- Lists, Drop Down in Cell - Basics
- Loan Payment Schedule Template
- Longitude, Latitude
-
Lookup Functions Compared
M
- Macintosh, Excel for Mac Resources
- Macros -- see VBA
- Marimekko Chart
- MATCH Function
- Matching Items, List
- Meal Planner, Holiday
- Meal
Planner, Weekly
- Microsoft
Query, Cartesian Join
- MIN and MAX Functions
N
- Names - Naming
Ranges
- Names - Create Dynamic Ranges VBA
- Names - List with Macros
- Names,
Split/Reverse First and Last
- Names - Use Names in Formulas
- Navigation Command for Sheets
- Navigation - Sheet List Popup
- Navigation Toolbar for Sheets 2003
- Newsletter Index, Contextures
- Numbers Don't Add Up
- Numbers, Increase by Set Amount
O
- OFFSET
Function
- Order Form
P
- Panel Charts
- Paste
Values Mouse Shortcut
- PDF Format,
Macros to Save Sheets As
- PeltierTech - Charting Site Index
- Pivot Power Premium Add-in
- Planner, Chicken Dinner
- Planner, Christmas
- Planner, Holiday Meal
- Planner, Weekly Template
- Planner,
Weekly Meal
- Podcasts, Excel
Roundup
- Power BI
Resources
- Power Pivot for
Excel Virtual Lab
- Power Pivot
from Identical Files
- Power
Query Combine Tables
- PowerPoint Slides from Excel List
- Preview Picture - 2016 and later
- Preview Picture - 2010 and earlier
- Print One Page Wide
- Print Headings All Pages
- Programming -- see VBA
- Project Task Tracker
Q
- Quick Access
Toolbar, Customize
R
- Ranges, Naming
- Replace,
Find and
- Ribbon
-- Custom tabs, Add
- Ribbon
-- Custom tabs, Intro
- Ribbon
-- Custom tabs, Your Macros
- Ribbon -- Sheet Navigation
- Rothstein,
Rick - Excel VBA
- RSS
Feeds, Contextures Site and Blogs
- RSS
Feeds on Worksheet
- Running Totals, Pivot Tables
S
- Sample Data (for testing)
- Sample Workbooks
- Scenarios
-- Create and Show
- Scroll
Bar, Date Range
- Scroll
Bar, Worksheet
- 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
- Subtotals
- Sum - functions and examples
- Support Article, Excel
- Survey Form
T
- Table, Excel Named
- Table, Excel, Slicers
- Table, Macro to Copy Items
- Tables,
Data, What If Analysis
- Text
Box, ActiveX
- Threaded Comment Macros
- Time Values, Pivot Table
- Toolbar --
Macros
- Toolbar -- Navigate Sheets
- Topics Index
- Trailing Minus Signs
U
- Unique
Count, Pivot Table
- Used Range, Reset (FAQ)
- Used Range,
Select
- UserForm,
Create
- UserForm with ComboBoxes
- UserForm with Help Pages
- UserForm Dependent
ComboBoxes
- UserForm ComboBox VBA
V
W-Z
- Waterfall Charts
- Weekly
Meal Planner
- Weekly Planner Template
- Weight Loss Tracker
- What's
New in Excel - archive
- What
If Analysis, Data Tables
- Workbook Backup Tool, Free
- Workbook
Tips
- Workbooks, List and Close
- Worksheet Freeze Panes Tips
- Worksheet List Popup
- Worksheet
Objects
- Worksheet
Tips
- Worksheet
VBA
- Worksheets, Freeze and Zoom Macros
- Worksheets, Hide Based on Tab Colour
- XML Maps for RSS Feed
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
Don't Miss Our Excel Tips
Don't miss my latest Excel tips and videos! Click OK, to get my weekly newsletter with Excel tips, and links to other Excel news and resources.
