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
Data Validation | Pivot Tables | Formulas | Macros | Format | Charts | Filters
What's New
Contextures Blog: Video shows how to use wildcards with criteria for a flexible AVERAGEIF formula in Excel . July 28, 2022
Date Grouping: See how to turn off automatic date grouping for Excel Pivot Tables and AutoFilters. July 18, 2022
Pivot Table Blog: Quickly check sales progress with % Running Total feature in Excel pivot table - 2 videos show the steps. July 6, 2022
Also see: Pivot Table Blog || RSS || Debra D Blog || What's New
- Add-ins, Installing
- Add Number to Multiple Cells
- Addresses, Split
- Advent Calendars, Excel
- AlexJ - Sample Workbooks
- Annual Cost Calculator
- Audit Formulas
- AutoFill Examples
A
- Backup Tool, Free
- Bar over character
- Beyond the Keyboard
- Bingo Cards
- Blank Cells, Fill
- Blog, Contextures
- Blog, Pivot Tables
- Box Plot (Box and Whisker Chart)
- Budget Forecast
- Buttons, Form Control
B
- Calculation Options
- Calorie Burn Calculator
- Calorie Counter
- Cartesian Join with MS Query
- Check Box, Change Formula
- Check Box, VBA
- Check Box, To Do List
- 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
- Compare Cell Values
- Contextures Blog
- Copy & Paste Problems
- Cost Calculator, Annual
- Count Duplicates
- Count Functions
- Count Specific Items
- Count Specific Items in Cell
- Custom Views
C
- 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 Grouping, Turn Off
- 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
D
- Email from Excel with PDF
- Error Cannot Shift Objects
- Excel Add-ins List, Free
- Excel Book List (Interactive)
- Excel Error Values
- Excel Events
- Excel Help - Online Resource List
- Excel FAQs
- Excel, Key Skills
- Excel Resources
- Excel Resources, Mac
- Excel Resources, Power BI
- Excel Setup Tips
- Excel Support Articles
E
- FastExcel Tools Review
- Filters - Advanced AutoFilter
- Filters, Dynamic
- 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
F
- Gantt Charts
- GetPivotData
- GetPivotData Reports
- Gift Ideas for Excel Users
- Golf Scores Template
- Golf Tee Off Times
- Govier, Roger - Sample Files
G
- Last Row, Excel VBA
- Leap Year Calculations
- Line Breaks, Add, Remove
- Line-Column Chart on 2 Axes
- List Box, Excel VBA
- Lists - AutoFilter VBA
- Lists, Compare 2 Lists
- Lists, Drop Down in Cell - Basics
- Loan Payment Schedule Template
- Longitude, Latitude
- Lookup Functions Compared
L
- 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
M
- 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
N
- Panel Charts
- Paste Values Mouse Shortcut
- PDF Format, Macros to Save Sheets As
- 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
- Printing, Pre-Print Diagnostic
- Programming -- see VBA
- Project Task Tracker
P
- Ranges, Naming
- Radio Streaming in Excel
- 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
R
- 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
S
- 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
- To Do List with Check Boxes
- Toolbar -- Macros
- Toolbar -- Navigate Sheets
- Topics Index
- Trailing Minus Signs
T
- Unique Count, Pivot Table
- Used Range, Reset (FAQ)
- Used Range, Select
- UserForm-Basic, Create
- UserForm-Basic: Videos
- UserForm-ComboBoxes
- UserForm ComboBox VBA
- UserForm Dependent ComboBoxes
- UserForm with Help Tabs
U
- 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
W-Z
Note: Some Excel tutorial links are to Contextures Blog and Contextures Pivot Table blog.
Popular Tutorials
Select Multiple Items from Drop Down
My Blogs
Last updated: July 28, 2022 1:34 PM