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
Functions: Combine two functions to do an Excel VLOOKUP to the left, without changing your table layout
Pivot Table Styles: Make a quick list of a workbook's pivot tables & styles, with colour samples. Get the Excel file with macros and buttons to test
Excel Newsletter: Read the latest issue - Quickly close all files, VLOOKUP trick, and more. Don't miss the next issue - sign up to get it by email.
Also see: Previous News || Excel Events || Excel RSS || Weekly Excel Humour
- 30 Functions in 30 Days
- Add-ins, Installing
- Add Number to Multiple Cells
- Addresses, Split
- AlexJ - Sample Workbooks
- Annual Cost Calculator
- Audit Formulas
- 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
- 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 Functions
- Dashboard, Excel
- Dashboard Course Review
- Dashboard Tips
- Dashboard Tools Add-in
- 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
- Excel Dates Fix Format
- Easter Dates, Calculate
- 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
- Excel Add-ins List, Free
- Excel Book List (Interactive)
- Excel Events
- Excel FAQs
- Excel Support Articles
- Excel Tools Add-in
- FastExcel V3 Review
- Filters - Advanced AutoFilter
- Find and Replace
- Fiscal Year - Calculate
- Fiscal Year - Pivot Table
- Flash Fill, Reverse Names
- Form, Create a UserForm
- Form, Print Selected Items
- Form, Survey
- Form, Worksheet Data Entry
- Form, Data Entry and Update
- Form Control Buttons
- Formatting Tips
- GetPivotData
- GetPivotData Reports
- Gift Ideas for Excel Users
- Golf Scores Template
- 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
- 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,
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 Meal
- Podcasts, Excel
Roundup
- PowerPivot for
Excel Virtual Lab
- Power BI
Resources
- PowerPivot
from Identical Files
- Power
Query Combine Tables
- 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
- Sheet List Popup
- Shortcuts, Keyboard - Interactive List
- Shortcuts, Mouse Double-Click
- SendKeys
- 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, 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 Dependent
ComboBoxes
- UserForm ComboBox VBA
- UserForms for Data Entry Course
- Waterfall Charts
- Weekly
Meal Planner
- Weight Loss Tracker
- What's
New in Excel - archive
- What If Analysis, Data Tables
- Workbook
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: November 15, 2018 9:34 AM
Contextures RSS Feed