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
Matching Items: Pick a region namefrom a drop down list, and Excel formulas show all the employee names from the selected region. No macros!
Pivot Tables: Build 2 pivot tables on one Excel sheet, from the same source data. Then add a Slicer to quickly filter both pivot tables
Excel Newsletter: Read the latest issue - Pivot table trick, multi-criteria lookup, and more. Don't miss the next issue - sign up to get it by email.
Also see: Previous News || Excel Events || RSS || Excel Humour || Debra D Blog
- 30 Functions in 30 Days
- Add-ins, Installing
- Add Number to Multiple Cells
- Addresses, Split
- Advent Calendars, Excel
- AlexJ - Sample Workbooks
- Annual Cost Calculator
- Audit Formulas
- AutoFill Examples
- Backup Tool, Free
- Backup Tool, Pro
- 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
A
B
- 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
- Custom Views
- 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
- 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
- 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
- Gantt Charts
- GetPivotData
- GetPivotData Reports
- Gift Ideas for Excel Users
- Golf Scores Template
- Golf Tee Off Times
- Govier, Roger - Sample Files
- Holiday Planner
- HTML Code, Create
- Hyperlinks, Add, Remove
- IFRAME Code, Create
- Keyboard Shortcuts, Interactive List
- Last Row, Excel VBA
- 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
C
D
E
F
G
H
I
K
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
- 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
- OFFSET
Function
- Order Form
- 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
- PowerPivot for Excel Virtual Lab
- Power BI Resources
- PowerPivot from Identical Files
- Power Query Combine Tables
- Preview Picture - 2016 and later
- Preview Picture - 2010 and earlier
- Print One Page Wide
- Print Headings All Pages
- Programming -- see VBA
- Project Management Templates
- Quick Access
Toolbar, Customize
- 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
- 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
- Table, Excel Named
- Table, Excel, Slicers
- Table, Macro to Copy Items
- Tables, Data, What If Analysis
- Text Box, ActiveX
- Toolbar -- Macros
- Toolbar -- Navigate Sheets
- Topics Index
- Trailing Minus Signs
- 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
- UserForms for Data Entry Course
- 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
- 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
M
N
O
P
Q
R
S
T
U
V
W-Z
Note: Some Excel tutorial links are to Contextures Blog and Contextures Pivot Table blog.
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.
Last updated: July 31, 2020 2:41 PM
Contextures RSS Feed