Sitemap

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
• Pivot Cache
• Replace Blank Cells with Zero in Pivot Tables

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
• User Defined Function (UDF) Excel
• How to Run a Macro in Excel
• Creating an Excel Add-in
• Personal Macro Workbook
• VBA Instr Function
• VBA Split 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

• 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
• 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