Key Skills > Excel Tips

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

Pivot Table Blog: Show extra subtotals in pivot table, without adding columns. Watch for limitations though!. Jan 25, 2023

Debra D Blog: This Ode to Microsoft Excel, for Robert Burns Day, gives humorous "burns" to other spreadsheets. Jan 25, 2022

Contextures Blog: Can ChatGPT write Excel TEXTJOIN formulas? See my test results. Jan 19, 2023

Combine Text: Combine text and numbers from multiple cells with Excel TEXTJOIN function. 7 examples, basic to advanced Jan 18, 2023

Also see: Pivot Table Blog || RSS || Debra D Blog || What's New

A

• Add-ins, Installing
• Add Number to Multiple Cells
• Addresses, Split
+Advanced Filter
    Advanced Filter Basics
    Advanced Filter Criteria
    Advanced Filter Criteria Slicers
    Advanced Filter Macros
    Filter to Different Sheet
    Filter Unique Items
    Filter with Criteria List
• Advent Calendars, Excel
• AlexJ - Sample Workbooks
• Annual Cost Calculator
• Audit Formulas
• AutoFill Examples
+AutoFilter
    AutoFilter Basics Videos
    AutoFilter, Criteria List Macro
    Programming - Lists  Sheet
    Tips, AutoFilter

B

• 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

C

• Calculation Options
• Calorie Burn Calculator
• Calorie Counter
• Cartesian Join with MS Query
+Charts
    Charts, Box Plot (Box and Whisker)
    Charts, Box Plot Video
    Charts, Cluster Stack
    Charts, Cluster Stack Pivot
     Chart Error Bars VBA
    Charts, Gantt
    Charts, Hidden Data
    Charts, Interactive
    Charts, Interactive, Totals
    Charts, Line-Column 2 Axes
    Charts, Marimekko
    Charts, Panel
    Charts, Pie
    Charts, Target Range
    Charts, Videos
    Charts, Waterfall
• 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)
+Combo Boxes
    Combo Box Lists
    Combo Box Match Required
    UserForm Combo Box Dependent
    UserForm Combo Box Tips
    UserForm Combo Box VBA
    Worksheet Combo Box Tips
+Comments
    Add a Picture
    Comments - Basics Videos
    Comments - Programming
    Comments - Tips
    Threaded Comment Macros
• Concatenate UDF
• Compare Cell Values
+Conditional Formatting
     Overview
     Basics
     Color, Show Selected
     Currency
     Data Bars
     Documentation
     Entire Row
     Examples
     Extra Rules, Fix
     Other Sheet
     Pivot Table
• Contextures Blog
• Copy & Paste Problems
• Cost Calculator, Annual
• Count Duplicates
• Count Functions
• Count Specific Items
• Count Specific Items in Cell
• Custom Views

D

• Dashboard, Excel
• Dashboard Course Review
• Dashboard Problems Survey Results
• Dashboard Tips
• Data Analysis, Hockey Player
• 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
+Data Validation
    _Main Page
    Basics
    Combo box
    Combo box Click
    Combo box Named Range
    Combo box Resources
    Criteria Examples
    Custom Criteria
    Date Rules
    Dependent Drop Down - Setup Choices
    Dependent Drop Down - Basics
    Dependent Drop Down - Basics Video
    Dependent Drop Down - From Dynamic Arrays
    Dependent Drop Down - From Sorted List
    Dependent Drop Down Lists INDEX
    Dependent Drop Downs- Tables
    Dependent Drop Downs- Tables, Dynamic Arrays
    Dependent Drop Downs- Tables/INDIRECT
    Dropdowns Too Wide
    Duplicates, Prevent
    Examples - Custom
    Hide Used Items
    Input Message in Text Box
    List, New Items Add
    List, New Items, Allow
    List, Other Workbook
    Messages
    Multi Select
    Multi Select Listbox
    Order Form
    Product Name - change to Code
    Time Entry
    Tips and Troubleshooting
    Troubleshooting
    Videos
• 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
• Dates, Weekend
• 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

E

• 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

F

• 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
+Functions and Formulas
    Functions, All, Interactive List
    Functions, FAQs
    Formulas, Auditing
    Formulas, Auditing Macro
    Formulas, Getting Started
    30 Functions in 30 Days
    ADDRESS Function
    Addresses, Split
    AGGREGATE
    AND
    Average
    CELL
    CHOOSE
    CODE and CHAR
    COLUMNS
    Count cells
    Count Cells With Specific Text
    Count with Column Criteria
    COUNTIF
    Dates
    EOMONTH
    EXACT
    FILTER Examples
    FILTER Function Reports
    FILTERXML
    FIND
    FORMULATEXT
    HLOOKUP
    HYPERLINK
    IF
    IFERROR
    INDEX
    INDIRECT
    INDIRECT - Compare Sheets
    INFO
    INT, TRUNC
    ISFORMULA
    Lookup Functions Compared
    LOOKUP Function
    Lookup - 2 criteria
    LOWER, UPPER, PROPER
    MATCH
    MEDIAN
    MIN and MAX
    MODE
    MONTH
    OFFSET
    PMT
    RAND
    RANK
    Ratio
    REPT
    Rounding
    Running Total
    Running Total Video
    SEARCH
    SHEET and SHEETS
    Spill Function Examples
    SUBSTITUTE or REPLACE
    SUBTOTAL
    Sum cells
    TEXT
    TEXTJOIN
    TEXTSPLIT Function Examples
    TODAY Examples
    TRANSPOSE
    TRIM
    TRIMMEAN
    VLOOKUP
    VLOOKUP Other Workbook
    WORKDAY
    WORKDAY.INTL
    XLOOKUP Examples

G

• Games in Excel
• 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 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

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, Skip Blanks
• Paste Values Mouse Shortcut
• PDF Format, Macros to Save Sheets As
+ Pivot Tables
    Pivot Table Index
    Add-in - Pivot Power Free
    Block Features, Data Model
    Calculated Field vs Calculated Item
    Calculated Field
    Calculated Field Count
    Calculated Item
    Charts, Compare Years
    Charts, Data Source
    Clear Old Items
    Conditional Formatting
    Conditional Formatting Weekends
    Count Blanks
    Create
    Custom Calculations
    Custom Style, Copy
    Data Field Layout
    Data Source
    Data Source, Dynamic
    Data Source, Filter
    Differences, Show
    DrillDown (Show Details)
    Error Values, Change
    Errors
    Expand and Collapse
    FAQs
    Field List
    Field Settings
    Fields, Move Quickly
    Fields, Remove with macros
    Fields, Remove (normal or DM)
    Filters, Date
    Filters, Interactive
    Filters, Label
    Filters, Multiple
    Filters, Report Filters
    Filters, Top 10
    Filters, VBA
    Fiscal Year
    Formatting
    Format, Copy
    Format VBA
    GetPivotData
    GetPivotData Reports
    Grand Total at Top
    Grouping Data
    Layout
    List All Pivot Tables
    Macro Topics, Pivot Table
    Multiple Consolidation Ranges
    Multiple Consolidation Ranges Video
    Pivot Cache
    Pivot Options
    Printing
    Printing, Vertical Values
    Protection
    Refresh Pivot Table
    Running Totals
    Select Sections
    Show and Hide Items
    Show Details (DrillDown)
    Show Differences
    Show Values As
    Slicers
    Slicers, Value Groups
    Sorting
    Subtotals
    "Sum of", Remove from Headings
    Summary Functions
    Text Values in Pivot Table
    Top 10 Filters
    Unique Count
    Unique Items
    Unpivot Source Data, Macro
• 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

Q

• Quick Access Toolbar, Customize

R

• 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

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

T

• Table, Excel Named
• Table, Excel, Slicers
• Table, Macro to Copy Items
• Table Name, Show on Worksheet
• 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

U

• Unique Count, Pivot Table
• Used Range, Reset (FAQ)
• Used Range, Select
• UserForm Topics
• UserForms-Basic, Create
• UserForms-Basic: Videos
• UserForms-ComboBoxes
• UserForms ComboBox VBA
• UserForms Dependent ComboBoxes
• UserForms - Search, Add, Edit
• UserForms with Help Tabs

V

+VBA and Macros

    Macros Add to QAT

    Macros Copy to workbook

     Macros FAQs

    Macros, Getting Started

    Macros, Record and Test

    Macros, Sheet Zoom and Freeze

    Macros Toolbar

    VBA SendKeys

    VBA Troubleshooting

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, Add Automatically
• 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

My Blogs

Contextures Blog

Pivot Tables Blog

Debra's Blog

Spreadsheet Day