This sitemap has a list of all the tutorials available on this site.
Excel Functions
Excel Pivot Table
- Creating a Pivot Table
- Preparing Source Data in Pivot Tables
- Filter Data in Pivot Tables
- Group Dates in Pivot Tables
- Group Numbers in Pivot Tables
- Apply Conditional Formatting in Pivot Tables
- Slicers in Pivot Tables
- Calculated Fields in Pivot Table
- Refresh Pivot Table
- Delete Pivot Table in Excel
- Pivot Cache
- Replace Blank Cells with Zero in Pivot Tables
- Count Distinct Values in Pivot Table
Excel Charting
- Copy Chart Formatting
- Multi-Category Charts in Excel
- Handle Data Gaps in Excel Charts
- Creating Dynamic Chart Titles
- Histogram Chart
- Bell Curve
- Pareto Chart
- Gantt Chart
- Sales Funnel Chart
- Bullet Chart
- Dynamic Charting – Highlight Data Points in Excel with a Click of a Button
- Waffle Chart
- Color Negative Chart Data Labels in Red with a downward arrow
- Spice Up Excel Chart Data Labels – Show Positive/Negative Trend Arrows
- How to Spot Data Point in Excel Scatter Chart
- Dynamic Chart Range
- Milestone Chart
- Dynamic Target Line in Column Chart
- Dynamic Excel Chart with Series Selection Check-box
- Sparklines
- Step Chart
- Actual Vs Target Chart
- Stacked Bar Chart
- Combination Chart
- Heat Map
- Thermometer Chart/Graph
- Area Chart in Excel.
- Add Trendline in Excel Charts.
- 10 Advanced Excel Charts
- How to Add Secondary Axis in a Chart in Excel
- Creating a Pie Chart in Excel
Excel VBA
- Recording a Macro
- Working with Cells and Ranges
- Working with Worksheets
- Working with Workbooks
- VBA Events
- VBA Loops
- IF Then Else VBA
- For Next Loop VBA
- Excel VBA Select Case
- User Defined Function (UDF) Excel
- Excel VBA MsgBox
- Excel VBA Error Handling
- VBA FileSystemObject (FSO) in Excel.
- How to Run a Macro in Excel
- Understanding Excel VBA Data Types.
- Creating an Excel Add-in
- Personal Macro Workbook
- VBA Instr Function
- VBA Split Function
- VBA TRIM Function.
- VBA LCase Function.
- VBA UCase Function.
- VBA Dir Function.
- Combine Multiple Excel Files into One Excel Workbook
- Filter Cells that have Duplicate Text Strings
- Excel VBA Macro Examples
- Create Summary Worksheet with Hyperlinks using VBA
- Select Every Third Row
- Excel VBA Autofilter.
Excel Power Query
- Get a List of File Names from Folders & Sub-folders (using Power Query)
- How to Unpivot Data in Excel using Power Query (aka Get & Transform)
- Combine Data from Multiple Workbooks in Excel (using Power Query)
- Combine Data From Multiple Worksheets into a Single Worksheet in Excel
- Merge Tables in Excel Using Power Query.
Excel Tips
- Custom Number Formatting
- Copy a Worksheet
- Create Custom Sorting Criteria
- Insert New Cells
- Fill Handle
- Increase Tab Numbering as You Create a Cop
- Unhide Columns
- Print Comments
- Send Worksheet as Email Attachment
- Enter Data in Specific Order
- Transpose Data
- Format Numbers as Text
- Data Validation
- Data Formatting
- Move Rows and Columns
- Data Filter
- Insert Line Break
- Watch Window
- Quick Access Toolbar Options
- Insert Watermark
- Insert Page Numbers
- Formula Debugging
- Formatting Shortcuts
- Insert Cent Symbol
- Highlight Negative Numbers in Red
- Excel Table
- Freeze Panes
- Calculate Percentages
- Find Merged Cells
- Calculate CAGR
- Keyboard Mouse Tricks
- Working with Gridlines
- Camera Tool
- Insert Picture in Comment
- Subscript and Superscript formatting
- Symbols in Drop Down Lists
- Inserting Degree Symbol
- Inserting Delta Symbol in Excel.
- Lock Formulas
- Track Changes
- Spell Check
- Input Message
- Use Autocorrect to complete Abbreviations
- Copy Paste Formulas
- Paste Special Shortcuts
- Show Formulas instead of Values
- Remove Leading Trailing and Double Spaces
- Use IFERROR with VLOOKUP to Get Rid of #N/A Errors
- Lookup and Return Entire Row or Column
- Avoid Nested IF by using VLOOKUP
- Lock Cells in Excel
- Multiple Criteria in CountIF
- Count Cells that Contain Text
- Count Unique Values
- Volatile Formulas
- Convert Formulas to Values
- Extract a Substring
- Extract Usernames from Email Ids
- Convert Text to Numbers
- Find and Remove Duplicates
- Convert Date to Text
- Generate Random Numbers
- Generate Unique Random Numbers
- Analyze Each Character in a String
- Enable Dependent Data Entry
- Standard Deviation
- Weighted Average
- Intersect Operator
- How to Merge Cells
- Start a new line in a cell
- Find External Links
- Get Unique Items from a List
- Radio Button
- Autoformat
- Hide Worksheets
- Highlight Blank Cells
- Text to Column
- Insert Multiple Rows
- Highlight Every Other Row
- Split Multiple lines
- Ways to Number Rows in Excel
- Round to Nearest 5 or 10
- Remove Hyperlinks
- Get a List of File Names from a Folder
- Holiday Calendar
- Combine Cells
- Quickly Select Excel Range or Cells
- Select Blank Cells
- Select Visible Cells
- Split Cells
- Create Subcategory in a drop-down list
- To Do List Template
- Wildcard Characters
- Advanced Filter
- Select 500 rows at one go
- Get Developer Tab in the ribbon
- Absolute, Relative and Mixed Cell references
- Find Hyperlinks
- Convert Excel to PDF
- Embed PDF file
- Leave Tracker
- Add Leading Zeroes
- Delete Blank Rows
- Game of Thrones Dashboard
- Insert Picture into Cell
- Avoid Duplication in Serial Numbers
- Embed Youtube Video
- One Variable Data Table
- Two-Variable Data Table
- Scenario Manager
- Goal Seek
- Dynamic Excel Filter
- Filter Bold Font Formatting
- Sort Data in Alphabetical Order
- Shared Expense Calculator
- Calendar To Do List template
- Kpi Dashboard in Excel
- Task Prioritization Matrix Template
- Count Colored Cells
- EPL Visualization in an Excel Dashboard
- Strikethrough Format in Cells
- Conditional Data Entry
- Matrix Falling Numbers in Excel
- Drop Down List
- Vacation Itinerary and Packing List template
- Get the list of comments in the worksheet
- Vlookup with multiple criteria
- Case Sensitive Vlookup
- Harvey Balls
- Random Group Generator Template
- Call Center Performance Dashboard
- Rank Within Groups
- Search and Highlight Using Conditional Formatting
- Excel Formula Crossword
- Create Dynamic Hyperlinks
- Conditional Formatting
- Find the closest match
- Highlight Part of Map using Drop Down
- Creating Multiple Drop-down Lists in Excel without Repetition
- Extract Data based on a drop-down list selection
- Send Email Using Hyperlink
- Compound Interest Calculator
- Calendar Template
- Highlight Active Row and Column
- Lookup Second Value
- Get Numeric or Text Part of a String Using VBA
- Dependent Drop Down List
- Generate Military Alphabet Code
- Scroll Bar
- Dynamic Labels in a Scroll Bar
- Dynamic Search Using Conditional Formatting
- Stopwatch in Excel
- Set Print Area in Excel
- Multiple Lookup Value in a Single Cell
- Excel Drop Down List with Search Suggestion
- Concatenate Excel Ranges
- Solver
- Find and Replace
- Multiply Using Paste Special
- Fill Numbers without dragging
- Picture Lookup
- Excel Data Sorting
- Data Formatting
- Calculate Age in Excel
- 20 Keyboard Shortcuts
- Format Painter
- Mouse Double Click tricks
- Excel Option Hacks
- Crete groups in Quick Access Toolbar
- Text to Speech
- Find the Last Occurrence of a Lookup Value a List
- Get the Last Number using VLOOKUP
- Find a Characters Last Position
- Sort Data with VBA
- Sort Worksheets in Excel (in alphabetical order).
- Multiple Level Sorting
- Select Multiple Items in a Drop Down List
- Excel Timesheet
- Invoice Generator Template
- Flash Fill
- Clean Data in Excel
- Insert Checkbox in Excel
- Checkmark in Excel.
- Calculate Word Count
- Insert Date and Time Stamp
- Insert Bullet Points
- Data Entry Tips
- Excel Data Entry Form.
- 24 Excel Tricks
- Named Ranges
- Adjust the Maximum value of Scroll Bar
- Handling Slow Excel
- Vlookup Vs Index Match
- Excel Interview Questions
- Convert PDF to Excel
- Calculate Number of Days between two dates
- Compare Two Columns in Excel.
- Highlight Rows based on cell value.
- 8 Ways to Reduce Excel File Size.
- Recover Unsaved Excel Files.
- Index Match
- Excel Hyperlinks
- Sort By Color in Excel.
- Automatically Open Specific Excel File on Startup
Useful Excel Resources
- Excel Keyboard Shortcuts
- Creating an Excel Dashboard
- Best Excel Books
- Free Excel Templates
- Free Online Excel Training (Basic to Advanced) – 12+ Hours