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
Interactive Filter: Interactive dynamic filter for Excel 365 table. Change filter settings with drop down lists, no macros. Nov 25, 2021
Contextures Blog: How to fix an Excel table that doesn't expand automatically for new data. Nov 25, 2021
Cluster Stack Pivot Chart: See how to create a Cluster Stack Pivot Chart from a pivot table. Use named Excel table or see how to unpivot data with Power Query. Sept 27, 2021
Excel Newsletter: Read the latest issue - List every 3rd item, make a flexible formula, and more. Nov 16, 2021
Also see: Previous News || RSS || Debra D Blog
- 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
- 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
- Contextures Blog
- 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 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 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-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
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
- PeltierTech - Charting Site Index
- 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
P
- 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
R
- 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
- Split Dates and Times
- 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, Create
- UserForm with ComboBoxes
- UserForm with Help Pages
- UserForm Dependent ComboBoxes
- UserForm ComboBox VBA
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: November 25, 2021 3:51 PM