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
Formulas: See 2 easy ways to copy Excel formulas with table references and avoid the problems that can cause incorrect results
Fiscal Months: Sort dates by fiscal month in an Excel pivot table, with month names included, for clarity
Spreadsheets: Dashboard tips, free spreadsheet courses and more, in this spreadsheet roundup.
Excel Newsletter: Read the latest issue - Show fractions, sort months in a fiscal year, 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
- 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 Resources
- Excel Resources, Mac
- Excel Resources, Power BI
- Excel Setup Tips
- Excel Support Articles
- Excel Tools Add-in
- FastExcel Tools Review
- Filters - Advanced AutoFilter
- 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
- 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
- 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: May 22, 2020 12:48 PM
Contextures RSS Feed