|
Home > Contextures > Ctx Info > Tips and Topics Excel Tips and Tutorials
|
Excel Tutorials A-Z
To find a tutorial name, click one of the the letters below, to go to that section in this page's tutorial list.
Excel Topics
Or click a topic name below, to go to that general topic page, and get started:
- Data Validation | Pivot Tables | Formulas | Macros | Format | Charts | Filters | Data | Structure
What's New
Meal Plan: To get my April 5-11 meal plan in Excel, go to my What's For Supper blog. It has fun food day ideas too, like Deep Dish Pizza Day (April 5th)
Grand Totals: Show Excel pivot table grand totals at the top, with this quick trick. Mar 13, 2025
Excel News March: Excel Pi Day, quick filter trick, and more, in this month's Excel news. Mar 10, 2025
Also see: Pivot Table Blog || RSS || Debra D Blog || What's New
- Add-ins, Installing
- Add Number to Multiple Cells
- ADDRESS Function
- Addresses, Split
- Advent Calendars, Excel
- AGGREGATE Function
- AND Function
- Annual Cost Calculator
- Audit Formulas
- AutoFill Examples
- Average Functions
A
- Backup Tool, Free
- Bar over character
- Beyond the Keyboard
- Bingo Cards
- Bingo, Vision Board
- Blank Cells-Fill
- Blank Cells-Fill-Macros
- Blank Cells, Fix
- Blog, Contextures
- Blog, Pivot Tables
- Box Plot (Box and Whisker Chart)
- Budget Forecast
- Business Growth Challenge
- Buttons, Form Control
B
- Calculation Options
- Calendar, Printable
- Calorie Burn Calculator
- Calorie Counter
- Cartesian Join with MS Query
- CELL Function
- Check Box Formula
- Check Box Macro
- Checkbox Survey
- Check Box To Do List
- CHOOSE Function
- Christmas Planner
- Christmas Tree Scroll Bar
- CODE and CHAR Functions
- Code, Copy to a workbook
- Column heading numbers, Fix
- COLUMNS Function
- Combine or Merge Cells
- Combine Text/Numbers (Concatenate)
- Concatenate UDF
- Compare Cell Values
- Compare Lists - Find New Items
- CONVERT Function
- Contextures Blog
- Copy & Paste Problems
- Copy Numbers Only
- Cost Calculator, Annual
- COUNTIF Function
C
- Dashboard Problems Survey Results
- Dashboard Templates
- Dashboard Tips
- Data Analysis, Hockey Player
- Data Bars - Conditional Formatting
- Data, Sample (Interactive)
- Data Tables for What If Analysis
- Delete Rows Macro
- Dependent ComboBoxes on UserForm
- Distance, Calculating
- Drop Down - from Filtered List
- Drop Down List in Cell - Basics
- Drop Down List - Top Items
- Drop Down List Types
- DSUM Function
- Duplicates, Highlight
- Duplicates, Prevent
- Duplicates, Remove from a List
- Duplicates, Remove, Number Problem
- Dynamic Ranges, Naming Macro
D
- Email from Excel with PDF
- EOMONTH Function
- Error Cannot Shift Objects
- EXACT Function
- Excel Add-ins List, Free
- Excel Book List (Interactive)
- Excel Data for Practice
- Excel Error Values
- Excel Events
- Excel Help - Online Resource List
- Excel FAQs
- Excel Files - List All Folder Files
- Excel Files - Update & Zip (Macro)
- Excel, Key Skills
- Excel Resources
- Excel Resources, Mac
- Excel Resources, Power BI
- Excel Setup Tips
- Excel Support Articles
- Excel Tools-Top Picks
- Excel Topics Index
E
- FastExcel Tools Review
- FILTER Function Basics
- FILTER Function Examples
- FILTER Function Reports
- FILTERXML Function
- Filtered Rows, Count or Sum
- Filters - Advanced AutoFilter
- Filters, Dynamic
- Filters, Right-Click Macros
- FIND Function
- Find and Replace
- Fiscal Year - Calculate
- Fiscal Year - Pivot Table
- Flash Fill, Reverse Names
- Formatting Tips
- FORMULATEXT Function
- Freeze Panes Tips
F
Individual functions are listed alphabetically.
- Games in Excel
- Gantt Charts
- GetPivotData
- GetPivotData Reports
- Golf Scores Template
- Golf Tee Off Times
- Google Sheets, Tips
- Govier, Roger - Sample Files
G
- Hide/Show Questions
- HLOOKUP Function
- Holiday Planner
- Holidays, Excel for the
- HTML Code, Create
- HYPERLINK Function
- Hyperlinks, Add, Remove
- Hyperlinks, Pivot Table
H
- IF Function
- IFERROR Function
- IFRAME Code, Create
- INDEX Function
- INDIRECT Function
- INDIRECT - Compare Sheets
- INFO Function
- Insert Rows, Multiple
- INT, TRUNC Function
- ISFORMULA Function
I
- 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 Function
- Lookup - 2 criteria
- Lookup Functions Compared
- LOWER, UPPER, PROPER Functions
L
- Macintosh, Excel for Mac Resources
- Macros -- see VBA
- Marimekko Chart
- MATCH Function
- Matching Items, List
- Meal Planner, Holiday
- Meal Planner, Weekly
- Menus, Right-Click
- Merge or Combine Cells
- MEDIAN Function
- Microsoft Query, Cartesian Join
- MIN and MAX Functions
- MINIFS MAXIFS Functions
- MODE Function
- MONTH Function
M
- 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
- Page 1 Watermark
- Panel Charts
- Paste, Skip Blanks
- Paste Values Mouse Shortcut
- PDF Format, Macros to Save Sheets As
- PIVOTBY Function
- PMT Function
- 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
- Practice - Excel Data for Practice
- 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
- Radio Streaming in Excel
- RAND Function
- Random, Choose Names
- RANK Function
- RANK Function, Ties
- Ratio Formula
- Replace, Find and
- REPT Function
- Rothstein, Rick - Excel VBA
- Rounding Formulas
- Rows, Alternate Colour
- RSS Feeds, Contextures Site and Blogs
- RSS Feeds on Worksheet
- Running Total / Rolling Total
- Running Totals, Pivot Tables
R
- Sample Workbooks
- Scenarios - Create and Show
- Scroll Bar, Date Range
- Scroll Bar, Worksheet
- SEARCH Function
- Seating Plan, Guest Tables
- SEQUENCE Function
- Setup Tips, Excel
- SHEET and SHEETS Functions
- Sheet List Popup
- Shortcuts, Keyboard - Interactive List
- Shortcuts, Mouse Double-Click
- SendKeys
- Sort a List
- Sort Data - Macro
- Sort Multiple Columns
- Split Address with Formulas
- Split Dates and Times
- Status Bar Tips
- Student Time Tracker
- SUBSTITUTE or REPLACE Functions
- SUBTOTAL Function
- Subtotals
- Sum - Functions / Examples
- Support Article, Excel
- Survey, Checkbox
- Survey Form
S
- Text Box, ActiveX
- Text Box Formatting Tips
- TEXT Function
- TEXTJOIN Function
- TEXTSPLIT Function Examples
- Threaded Comment Macros
- Time Tracker, Excel Projects
- Time Tracker, Student
- Time Values, Pivot Table
- To Do List with Check Boxes
- TODAY Function Examples
- Toolbar - Macros
- Toolbar -- Navigate Sheets
- Trailing Minus Signs
- TRANSPOSE Function
- TRIM Function
- TRIMMEAN Function
T
- Vision Board Bingo
- Waterfall Charts
- Watermark, Page 1
- Weekly Meal Planner
- Weekly Planner Template
- Weight Loss Tracker
- What's New in Excel - archive
- What If Analysis, Data Tables
- WORKDAY Function
- WORKDAY.INTL Function
- XLOOKUP Function Examples
- XML Maps for RSS Feed
W-Z
Note: Some Excel tutorial links are to Contextures Blog and Contextures Pivot Table blog.
Get Monthly Excel Tips!
Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.
Next, when you get my reply, click the Confirm button. I add this step to protect you from spam!
Popular Tutorials
Select Multiple Items from Drop Down
My Blogs
Data Validation | Pivot Tables | Formulas | Macros | Format | Charts | Filters | Data | Structure
Last updated: April 4, 2026 3:28 PM