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

Contextures Blog: Video shows MID formula to reverse first and last names in Excel. See how it works, and see a longer formula too. Apr 15, 2021

Pivot Table Blog: Analyze sales data with Pivot Table Top 10 filters. Change settings on worksheet, macro changes multiple pivot table filters automatically. Apr 7, 2021

Data Validation: Use simple data validation rules to limit budget entry amounts that can be entered in Excel budget plan. Video, written steps, free Excel workbook Mar 23, 2921

Excel Newsletter: Read the latest issue - Hide used items in drop down list, currency symbol switch, and more. Don't miss the next issue - sign up to get it by email. Apr 6, 2021.

Also see: Previous News || RSS || Debra D Blog

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
• 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
• Blank Cells, Fill
• Blog, Contextures
• Blog, Pivot Tables
• Box Plot (Box and Whisker Chart)
• Budget Forecast
• Buttons, Form Control

C

• Calorie Burn Calculator
• Calorie Counter
• Cartesian Join with MS Query
+Charts
    Charting - Jon Peltier's Site Index
    Charts, Box Plot (Box and Whisker)
    Charts, Box Plot Video
    Charts, Cluster Stack Utility
     Chart Error Bars VBA
    Charts, Gantt
    Charts, Interactive
    Charts, Interactive, Totals
    Charts, Line-Column 2 Axes
    Charts, Marimekko
    Charts, Panel
    Charts, Pie
    Charts, Videos
    Charts, Waterfall
• 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)
+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
+Conditional Formatting
     Basics
     Currency
     Data Bars
     Documentation
     Entire Row
     Examples
     Other Sheet
     Pivot Table
• 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 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
    Multi Select Premium FAQ
    Order Form
    Product Name - change to Code
    Time Entry
    Tips and Troubleshooting
    Troubleshooting
    Videos
• 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
• 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

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
+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
    Count cells
    Count Cells With Specific Text
    Count with Column Criteria
    COUNTIF
    Dates
    FORMULATEXT
    FILTER Examples
    HLOOKUP
    HYPERLINK
    IF
    IFERROR
    INDEX
    INDIRECT
    INDIRECT - Compare Sheets
    INFO
    ISFORMULA
    Lookup Functions Compared
    LOOKUP Function
    Lookup - 2 criteria
    MATCH
    MEDIAN
    MIN and MAX
    OFFSET
    PMT
    RAND
    RANK
    Ratio
    REPT
    Rounding
    Running Total
    Running Total Video
    SEARCH
    SHEET and SHEETS
    Spill Function Examples
    SUBTOTAL
    Sum cells
    TEXT
    TEXTJOIN
    TRANSPOSE
    TRIM
    TRIMMEAN
    VLOOKUP
    VLOOKUP Other Workbook

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 Tables
    Pivot Table Index
    Add-in - Pivot Power Premium
    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
    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
    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
• 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

+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, 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.