Everything on TrumpExcel in one place, sorted by topic. If you’re after something specific, type it in the box below.
Excel Functions
Go to the Excel Functions hub →A guide for each Excel function, with examples.
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- CELL
- CHAR
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CHISQ.TEST
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COMBIN
- COMBINA
- COMPLEX
- CONCAT
- CONCATENATE
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONVERT
- CORREL
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVARIANCE.P
- COVARIANCE.S
- CSC
- CSCH
- CUBEMEMBER
- CUBERANKEDMEMBER
- CUBESET
- CUBESETCOUNT
- CUBEVALUE
- CUMIPMT
- CUMPRINC
- IF
- IFERROR
- IFNA
- IFS
- IMABS
- IMAGE
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG2
- IMLOG10
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
- INDEX
- INDIRECT
- INFO
- INT
- INTERCEPT
- INTRATE
- IPMT
- IRR
- ISBLANK
- ISERROR
- ISFORMULA
- IS functions
- ISNA
- ISNONTEXT
- ISNUMBER
- ISO.CEILING
- ISOMITTED
- ISOWEEKNUM
- ISPMT
- ISREF
- ISTEXT
Function comparisons and guides
Power Query
Go to the Power Query hub →Clean and reshape your data with Power Query, plus a guide for each M function.
Power Query tutorials
- 5 Easy Ways to Calculate Running Total in Excel (Cumulative Sum)
- Calculate Date Difference in Power Query
- Combine CSV Files When Column Headers Don’t Match
- Combine Data from Multiple Workbooks in Excel (using Power Query)
- Combine Data From Multiple Worksheets into a Single Worksheet in Excel
- Create All Possible Combinations from Lists in Excel
- Fill Down Blank Cells Until the Next Value in Excel (3 Easy Ways)
- Get a List of File Names from Folders & Sub-folders (using Power Query)
- Get Today’s Date in Power Query (Easy Formula)
- How to Combine First and Last Name in Excel (5 Easy Ways)
- How to Get Month Name from Date in Excel (4 Easy Ways)
- How to Undo in Power Query?
- How to Unpivot Data in Excel using Power Query (aka Get & Transform)
- Merge Tables in Excel Using Power Query
- Power Query Functions
- Power Query Keyboard Shortcuts
- Repeat Rows N Times in Excel
Power Query M functions
Charts
Go to the Charts hub →Step-by-step guides for everyday and advanced Excel charts.
- 10 Advanced Excel Charts that You Can Use In Your Day-to-day Work
- A Step-by-step Guide on Creating a BULLET Chart in Excel
- Calculate Area Under Curve in Excel (2 Easy Ways)
- Call Center Performance Dashboard in Excel [FREE Download]
- Color Negative Chart Data Labels in Red with a downward arrow
- Conditional Formatting to Create 100% Stacked Bar Chart in Excel
- Create Dynamic Target Line in Excel Bar Charts
- Creating Actual vs Target Chart in Excel (2 Examples)
- Creating a Pareto Chart in Excel (Static & Dynamic)
- Dynamic Charting – Highlight Data Points in Excel with a Click of a Button
- Dynamic Excel Chart with Series Selection Check-box
- Excel Charting Tips & Tutorials (Resource Guides + Videos)
- Excel Sparklines – A Complete Guide with Examples
- How to Add a Secondary Axis in Excel Charts (Easy Guide)
- How to Add a TrendLine in Excel Charts (Step-by-Step Guide)
- How to Add Axis Titles in Charts in Excel?
- How to Add Error Bars in Excel (Horizontal/Vertical/Custom)
- How to Create a Dynamic Chart Range in Excel
- How to Create a Gantt Chart in Excel – Batman Style
- How to Create a Heat Map in Excel
- How to Create an Area Chart in Excel (explained with Examples)
- How to Create a Sales Funnel Chart in Excel
- How to Create a Thermometer Chart in Excel
- How to Create a Timeline / Milestone Chart in Excel + Free Template Inside
- How to Create a Waterfall Chart in Excel
- How to Create Combination Charts in Excel – Step-by-Step Tutorial
- How to Create Dynamic Chart Titles in Excel
- How to Create Multi-category Charts in Excel
- How to Find Slope in Excel? Using Formula and Chart
- How to Handle Data Gaps in Excel Charts (Examples)
- How to Make a Bell Curve in Excel (Step-by-step Guide)
- How to Make a Histogram in Excel (Step-by-Step Guide)
- How to Make a PIE Chart in Excel (Easy Step-by-Step Guide)
- How to Make a Scatter Plot in Excel (XY Chart)
- How to Move Chart to New Sheet in Excel? 2 Easy Ways!
- How to Quickly Copy Chart (Graph) Format in Excel
- How to Quickly Create a Waffle Chart in Excel
- How to Save Excel Charts as Images (save as PNG, JPG, BMP)
- How to Spot Data Point in Excel Scatter Chart
- KPI Dashboard in Excel [Part 1 of 3] – Dynamic Scatter Chart
- KPI Dashboard in Excel [Part 2 of 3] – Dynamic Interpretation from Scatter Chart
- KPI Dashboard in Excel [Part 3 of 3] – Extract List of Companies from the Scatter Chart
- Show Trend Arrows in Excel Chart Data Labels
- Step Chart in Excel – A Step by Step Tutorial
Templates
Go to the Templates hub →Free Excel templates you can download and use right away.
- Calendar Integrated with a To Do List Template in Excel
- Eisenhower Matrix Template in Excel (Free Download)
- Excel Holiday Calendar Template (FREE Download)
- Excel Timesheet Calculator Template [FREE DOWNLOAD]
- Excel To Do List Template – 4 Examples (FREE Download)
- Free Excel Leave Tracker Template
- FREE Excel Templates Combo – Vacation Itinerary Planner + Packing List Template + Expense Calculator Template
- [FREE Invoice Generator Template] Save Excel Invoice as PDF
- FREE Monthly & Yearly Excel Calendar Template
- Loan Amortization Schedule in Excel (Free Template)
- Random Group Generator Template [FREE Download]
- Shared Expense Calculator – Download Free Excel Template
Free online tools for everyday spreadsheet jobs.
Calculators
Go to the Calculators hub →Free online calculators you can use without opening Excel.
Excel Tips
Formulas, Pivot Tables, shortcuts, quick fixes and time savers for everyday Excel work.
- #REF! Error in Excel – How to Fix the Reference Error!
- 3 Easy Ways to Clip Text in Excel
- 3 Easy Ways to Insert Cent Symbol in Excel
- 3 Quick Ways to Select Visible Cells in Excel
- 3D References in Excel
- 5 Easy Ways to Type/Insert Degree Symbol in Excel (Shortcut + Examples)
- 5 Powerful Excel Formatting Shortcuts That Will Transform Your Data
- 5 Time Saving Excel Features You Must Use [INFOGRAPHIC]
- 5 Ways to Insert New Columns in Excel (including Shortcut & VBA)
- 6 Easy Ways to Insert the Delta Symbol (Δ) in Excel
- 7 Easy Ways to Select Multiple Cells in Excel
- 7 Quick & Easy Ways to Number Rows in Excel
- 8 Ways to Reduce Excel File Size (that actually work)
- 10 Excel Data Entry Tips You Can’t Afford to Miss
- 10 Excel Pivot Table Keyboard Shortcuts
- 10 Super Neat Ways to Clean Data in Excel Spreadsheets
- 10 Tricks to Fix Slow Excel Spreadsheets (Speed-up Excel)
- 13 Best Excel Books to Level Up Your Skills
- 20 Advanced Excel Functions and Formulas (for Excel Pros)
- 20 Excel Keyboard Shortcuts that will Impress Your Boss
- 24 Excel Tricks to Make You Sail through Day-to-day work
- 100+ Excel Interview Questions & Answers
- 200+ Excel Keyboard Shortcuts (Windows & Mac)
- Absolute, Relative, and Mixed Cell References in Excel
- Add Comments Within Excel Formulas
- Add or Subtract Percentage From a Number in Excel (Formula)
- Add Sheet Name to Header or Footer in Excel
- Add Total Values for Stacked Bar Charts in Excel
- Analyze Each Character in Excel using the Triad of Indirect(), Row() & Mid()
- An Introduction to Data Validation in Excel
- An Introduction to Excel Data Filter Options
- Apply Conditional Formatting Based on Another Column in Excel
- Arrow Keys not Working in Excel (Not Moving Cells)
- AutoFit Columns and Rows in Excel to Fit Text Automatically
- Automatically Sort Data in Alphabetical Order using Formula
- AutoSum in Excel (Shortcut)
- Avoid Nested IF Function in Excel…VLOOKUP to Rescue
- Best Fonts for Excel
- Boost Your Productivity with Excel Mouse Double Click Tricks
- Bulk Create Folders (and Subfolders) Using Excel List
- Calculate Chi-Square in Excel
- Calculate Confidence Interval in Excel
- Calculate Fiscal Year from Date in Excel (Formulas)
- Calculate Interquartile Range (IQR) in Excel
- Calculate MEDIAN IF in Excel
- Calculate Number of Months Between Two Dates in Excel (Easy Formulas)
- Calculate P-value in Excel
- Calculate Quarter from Date in Excel (Easy Formula)
- Calculate the Coefficient of Variation (CV) in Excel
- Calculate Time in Excel (Time Difference, Hours Worked, Add/ Subtract)
- Calculating Moving Average in Excel [Simple, Weighted, & Exponential]
- Calculating Weighted Average in Excel (Using Formulas)
- Change Negative Number to Positive in Excel [Remove Negative Sign]
- Change Pivot Table to Tabular Form
- Change the Default Font in Excel
- Check IF a Date is Between Two Given Dates in Excel (Easy Formulas)
- Check IF Cell Contains Partial Text in Excel (Formulas)
- Check your EQ (Excel Quotient) – Formula Crossword
- Combine Date and Time in Excel (3 Easy Ways)
- Compatibility Mode in Excel: What It Is and How to Turn It Off
- Conditional Formatting Not Working in Excel
- Connect Slicer to Multiple Pivot Tables in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel – Explained with Examples
- Convert Days to Months in Excel
- Convert Month Name to Number in Excel
- Convert Number to Words in Excel
- Convert Scientific Notation to Number or Text in Excel
- Convert Text to Numbers in Excel
- Convert Time to Decimal Number in Excel (Hours, Minutes, Seconds)
- Copy and Paste Multiple Cells in Excel (Adjacent & Non-Adjacent)
- Copy Visible Cells Only in Excel
- Count Between Two Numbers in Excel (COUNTIF / COUNTIFS)
- Count Cells Less than a Value in Excel (COUNTIF Less Than)
- Count Cells That Are Not Blank in Excel
- Count Characters in a Cell (or Range of Cells) Using Formulas in Excel
- Count Distinct Values in Excel Pivot Table (Easy Step-by-Step Guide)
- Count Unique Values in Excel Using COUNTIF Function
- Create Barcodes in Excel (Free Barcode Generator)
- Create Data Validation List from Excel Table as Source
- Create Dynamic Hyperlinks in Excel
- Create Groups in Quick Access Toolbar in Excel
- Creating An Excel Dashboard (Explained with Examples & Templates)
- Creating Multiple Drop-down Lists in Excel without Repetition
- CSV vs XLSX – Key Differences (and When to Use Each)
- Data Analysis [Part 1 of 5] – One Variable Data Table in Excel
- Data Analysis [Part 2 of 5] – Two Variable Data Table in Excel
- Data Analysis [Part 3 of 5] – Scenario Manager in Excel
- Data Analysis [Part 4 of 5] – Goal Seek in Excel
- Data Analysis [Part 5 of 5] – Using Solver in Excel
- Delete Blank Columns in Excel (3 Easy Ways + VBA)
- Delete Rows Based on a Cell Value (or Condition) in Excel
- Display Main and Subcategory in Drop Down List in Excel
- Drop Down Lists To Show Numbers Between Two Specified Numbers
- Dynamic Arrays in Excel
- Dynamic Excel Filter Search Box – Extract Data as you Type
- Enable Dark Mode in Microsoft Excel
- Enable Data Entry in a Cell in Excel only if a Dependent Cell is Filled
- Excel Advanced Filter – A Complete Guide with Examples
- Excel AutoCorrect: A Complete Guide + Time Saving Examples
- Excel AutoFormat – A One Click Data Formatting Trick
- Excel Conditional Formatting Based on Another Cell
- Excel Custom Number Formatting Tricks
- Excel Formulas Not Working (Not Calculating)
- Excel Freeze Panes: Use it to Lock Row/Column Headers
- Excel MVP Award!! Thrilled to Share the Good News with You All
- Excel Not Responding? How to Fix It
- Excel Paste Special Shortcuts That Will Save You Tons of Time
- Excel Quick Access Toolbar – 5 Options You Should Consider Adding
- Excel Quick Analysis Tool – How to Best Use it?
- Excel Sample Data Download (15 Free Datasets)
- Excel Sheet Tabs Not Showing? How to Get Them Back
- Excel Showing Formula Instead of Result
- Excel Skills (Basic, Intermediate, and Advanced)
- Excel Table vs Range: Key Differences and When to Use Each
- Excel Text to Speech (Speak Cells)
- Excel Wildcard Characters – What are these and How to Best Use it
- Extract Data From PDF to Excel with this Converter (FREE TRIAL)
- Extract Last Name in Excel
- Extract Usernames from Email Ids in Excel [2 Methods]
- Filter By Color in Excel
- Find and Remove Duplicates in Excel
- Find Position of the Last Occurrence of a Character in a String in Excel
- Find the Closest Match in Excel (using Formulas)
- Find the Last Occurrence of a Lookup Value a List in Excel
- Find the Second Largest Value in Excel
- Format Numbers as Text in a Drop Down List in Excel
- Format Numbers to Show in Millions in Excel
- Formula vs Function in Excel – What’s the Difference?
- Free Excel VBA Course
- FREE Online Excel Training (12+ Hours) | Learn Excel (Basic/Advanced)
- Free Power Query Course
- Get Day Name from Date in Excel (Easy Formulas)
- Get End of Year Date in Excel (Easy Formula)
- Give your Data a Makeover!! Learn All about Excel Data Formatting
- Growing Annuity Formula in Excel
- Highlight an Entire Row Based on Cell Value in Excel (Conditional Formatting)
- Highlight Cells With Formulas in Excel
- Highlight Dates Before Today in Excel
- Highlight EVERY Other ROW in Excel (using Conditional Formatting)
- How to Add and Use an Excel Pivot Table Calculated Field
- How to Add Bullet Points in Excel (Shortcut + 7 More Ways)
- How to Add Decimal Places in Excel (Automatically)
- How to Add Months to Date in Excel (Easy Formula)
- How to Add or Subtract Days to a Date in Excel (Shortcut + Formula)
- How to Add Parentheses Around Text in Excel
- How to Add Plus Sign Before Numbers in Excel
- How to Add Week to Date in Excel?
- How to Add Years to Date in Excel?
- How to Apply Conditional Formatting in a Pivot Table in Excel
- How to Apply Formula to Entire Column in Excel (8 Easy Ways)
- How to Autofill Only Weekday Dates in Excel (Formula)
- How to Automatically Open Specific Excel File on Startup
- How to Calculate Age in Excel using Formulas + FREE Calculator Template
- How to Calculate and Format Percentages in Excel
- How to Calculate Average Annual Growth Rate (AAGR) in Excel
- How to Calculate Compound Annual Growth Rate (CAGR) in Excel
- How to Calculate Compound Interest in Excel + FREE Calculator
- How to Calculate Correlation Coefficient in Excel (2 Easy Ways)
- How to Calculate Number of Weeks Between Two Dates in Excel
- How to Calculate Percentage Change in Excel (Increase and Decrease)
- How to Calculate PERCENTILE in Excel (Formula)
- How to Calculate Ratios in Excel?
- How to Calculate Square Root in Excel (Using Easy Formulas)
- How to Calculate Standard Deviation in Excel
- How to Calculate Standard Error in Excel
- How to Calculate the Number of Days Between Two Dates in Excel
- How to Calculate Variance in Excel (Sample vs Population)
- How to Calculate Years of Service in Excel (Easy Formulas)
- How to Change Case in Excel (Uppercase, Lowercase, Proper Case)
- How to Change Date Format In Excel?
- How to Change Page Orientation in Excel?
- How to Change Row Height in Excel (5 Easy Ways)
- How to Change the Color of the Sheet Tab in Excel (Easy Steps)
- How to Combine Cells in Excel
- How to Combine Duplicate Rows and Sum the Values in Excel
- How to Combine Two Columns in Excel (with Space/Comma)
- How to Compare Dates in Excel (Greater/Less Than, Mismatches)
- How to Compare Text in Excel (Easy Formulas)
- How to Compare Two Columns in Excel (for matches & differences)
- How to Compare Two Excel Sheets (for Differences)
- How to Concatenate a Range in Excel (With or Without a Separator)
- How To Convert Date To Serial Number In Excel?
- How to Convert Formulas to Values in Excel
- How to Convert Fraction to Decimal in Excel
- How to Convert Inches to MM, CM, or Feet in Excel? Easy Formula
- How to Convert Minutes to Hundredths in Excel
- How to Convert Numbers to Text in Excel
- How to Convert Seconds to Minutes in Excel (Easy Formula)
- How to Convert Serial Numbers to Dates in Excel
- How to Convert Text to Date in Excel (8 Easy Ways)
- How to Copy and Paste Column in Excel?
- How to Copy and Paste Formulas in Excel without Changing Cell References
- How to Copy Column Widths in Excel (Shortcut)
- How to Copy Conditional Formatting to Another Cell in Excel
- How to Copy Excel Table to MS Word (4 Easy Ways)
- How to Count Cells that Contain Text Strings
- How to Count Filtered Rows in Excel?
- How to Create a Data Entry Form in Excel
- How to Create a Dependent Drop Down List in Excel
- How to Create a Drop Down Filter in Excel (Extract Data Based on Selection)
- How to Create a Drop Down List in Excel (Step-by-Step Guide)
- How to Create a Scroll Bar in Excel – Step by Step Tutorial
- How to Create Custom List in Excel (Easy Step-by-Step Guide)
- How to Create Dynamic Labels in Excel Scroll Bar
- How to Create Excel Table?
- How to Create Named Ranges in Excel
- How to Create QR Codes in Excel (QR Code Generator)
- How to Customize the Ribbon in Excel (Step-by-Step)
- How to Cut a Cell Value in Excel (Keyboard Shortcuts)
- How to Delete All Hidden Rows and Columns in Excel
- How to Delete a Pivot Table in Excel (Easy Step-by-Step Guide)
- How to Delete Rows in Excel (Single or Multiple)?
- How to Describe Excel Skills in a Resume?
- How to Deselect Cells in Excel?
- How to Display Numbers as Fractions (Write Fractions in Excel)
- How to do a Multiple Level Data Sorting in Excel
- How to do a Picture Lookup in Excel – A Step-by-step Guide
- How to Do Sensitivity Analysis in Excel
- How to Edit Cells in Excel? (Shortcuts)
- How to Embed a PDF File in an Excel Worksheet
- How to Embed Youtube Video in Excel Worksheet
- How to Enable and Use Track Changes in Excel
- How to Enable Conditional Data Entry in Excel using Data Validation
- How to Enable Macros in Excel? Everything You Must Know!
- How to Extract a Substring in Excel (Using TEXT Formulas)
- How to Extract the First Word from a Text String in Excel (3 Easy Ways)
- How to Filter Data in a Pivot Table in Excel
- How to Filter Strikethrough in Excel
- How to Find Circular Reference in Excel (Quick and Easy)
- How to Find External Links and References in Excel
- How to Find Merged Cells in Excel (and then get rid of it)
- How to Find Outliers in Excel (and how to handle these)
- How to Find Range in Excel (Easy Formulas)
- How to Find the Version of Excel You Have?
- How to Fix #NUM! Error in Excel
- How to Fix #VALUE Error in Excel?
- How to Fix Excel Functions That Won’t Spill (EOMONTH, EDATE, WORKDAY)
- How to Fix the #SPILL! Error in Excel
- How to Fix “All Merged Cells Need To Be The Same Size” in Excel
- How to Fix “We Found a Problem With Some Content” in Excel
- How to Forecast in Excel (Formulas & Forecast Sheet)
- How to Format Phone Numbers in Excel?
- How to Freeze Multiple Columns in Excel?
- How to Generate Random Numbers in Excel
- How to Generate Unique Random Numbers in Excel (No Duplicates)
- How to Get Descriptive Statistics in Excel? (Quick and Easy)
- How to Get Rid of #DIV/0! Error in Excel? Easy Formulas!
- How to Get the Excel Developer Tab Show Up in the Ribbon
- How to Get the First Day of the Month in Excel (Easy Formulas)
- How to Get the Number of Days in a Month in Excel?
- How to Get the Sheet Name in Excel? Easy Formula
- How to Get the Word Count in Excel (Using Simple Formulas)
- How to Give Duplicate Values the Same Serial Number in Excel
- How to Group and Collapse Rows in Excel
- How to Group Columns in Excel?
- How to Group Dates in Pivot Tables in Excel (Years, Months, Weeks)
- How to Group Numbers in Pivot Table in Excel
- How to Group Worksheets in Excel (Step-by-Step)
- How to Hide Formulas in Excel (and Only Display the Value)
- How to Hide or Show Formula Bar in Excel?
- How to Highlight Weekend Dates in Excel?
- How to Import XML File into Excel | Convert XML to Excel
- How to Indent in Excel (3 Easy Ways + Keyboard Shortcut)
- How to Insert/Draw a Line in Excel (Straight Line, Arrows, Connectors)
- How to Insert a Checkbox in Excel (New In-Cell Checkboxes)
- How to Insert a Check Mark (Tick ✓) Symbol in Excel
- How to Insert and Use a Radio Button (Option Button) in Excel
- How to Insert a Picture in Excel Comment
- How to Insert Arrows in Excel (Symbols, Shapes, and Icons)
- How to Insert a Watermark in Excel (a Step-by-step Guide)
- How to Insert Line Break in Excel (Quick and Easy)
- How to Insert Multiple Rows in Excel
- How to Insert New Worksheet in Excel (Easy Shortcuts)
- How to Insert Page Breaks in Excel (& Remove, Delete Page Breaks)
- How to Insert Page Numbers in Excel Worksheets
- How to Insert Picture Into a Cell in Excel (a Step-by-Step Tutorial)
- How to Insert Symbols in Excel
- How to Lock Cells in Excel
- How to Lock Formulas in Excel (a Step-by-Step Guide)
- How to Lock Row Height & Column Width in Excel (Easy Trick)
- How to Make All Cells the Same Size in Excel
- How to Make an Interactive Calendar in Excel? (FREE Template)
- How to Make a Pivot Table in Excel (Easy Step-by-Step)
- How to Make a Yes/No Drop-Down in Excel? (Easy Ways)
- How to Make Cells Bigger in Excel?
- How to Make Negative Numbers Show Up in Red in Excel
- How to make VLOOKUP Case Sensitive
- How to Mark an Excel Workbook as Final?
- How to Merge Cells in Excel Without Losing Data
- How to Move Rows and Columns in Excel
- How to Multiply a Column by a Number in Excel
- How to Multiply in Excel Using Paste Special
- How to Name a Table in Excel
- How to Open Excel in Safe Mode?
- How to Password Protect an Excel File (Open, Edit, and Sheets)
- How to Print Comments in Excel (Step-by-Step Guide)
- How to Print Excel Sheet on One Page (Fit to One Page)
- How to Print the Top Row on Every Page in Excel (Repeat Row/Column Headers)
- How to Quickly Fill Numbers in Cells without Dragging
- How to Quickly Find Hyperlinks in Excel (using Find and Replace)
- How to Quickly Insert New Cells in Excel
- How to Quickly Select a Far-off Excel Cell or Range
- How to Quickly Unhide COLUMNS in Excel (A Simple Guide)
- How to Rank within Groups in Excel
- How to Recover Unsaved Excel Files [All Options + Precautions]
- How to Reference Another Sheet or Workbook in Excel (with Examples)
- How to Refresh Pivot Table in Excel (Manually + Auto-Refresh with VBA)
- How to Remove (Disable) Add-Ins in Excel?
- How to Remove Cell Formatting in Excel (from All, Blank, Specific Cells)
- How to Remove Comma in Excel (from Text and Numbers)
- How to Remove Conditional Formatting in Excel (Shortcut + VBA)
- How to Remove Dashes (-) in Excel?
- How to Remove Dotted Lines in Excel (5 Easy Fixes)
- How to Remove Drop-Down List in Excel? Easy Steps!
- How to Remove Header and Footer in Excel
- How to Remove Leading Zeros in Excel (6 Easy Ways)
- How to Remove Password from Excel (File, Workbook, and Sheet)
- How to Remove Table Formatting in Excel?
- How to Remove Time from Date/Timestamp in Excel (6 Easy Ways)
- How to Replace Blank Cells with Zeros in Excel Pivot Tables
- How to Return Cell Address Instead of Value in Excel (Easy Formula)
- How to Rotate Text in Cells in Excel (Easy Steps)
- How to Round to the Nearest Integer or Multiple of 0.5 / 5 / 10 in Excel
- How to See Version History in Excel (& Restore an Older Version)
- How to Select Blank Cells in Excel
- How to Select Entire Column (or Row) in Excel (Shortcut)
- How to Select Non-adjacent Cells in Excel?
- How to Send a Single Excel Worksheet as Email Attachment
- How to Set the Print Area in Excel Worksheets
- How to Shift Cells Down in Excel
- How to Show or Hide the Ribbon in Excel? (with Shortcuts)
- How to Show Pivot Table Fields List? (Get Pivot Table Menu Back)
- How to Show Ruler in Excel?
- How to Shuffle a List of Items/Names in Excel? 2 Easy Formulas!
- How to Sort By Color in Excel (in less than 10 seconds)
- How to Sort by Length in Excel? Easy Formulas!
- How to Sort by the Last Name in Excel (Easy Guide)
- How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)
- How to Split a Cell Diagonally in Excel (Insert Diagonal Line)
- How to Split Cells in Excel (separate into multiple columns)
- How to Split Multiple Lines in a Cell into a Separate Cells / Columns
- How to Split Screen in Excel (Compare Side-by-Side)
- How to Square a Number in Excel
- How to Start a New Line in Excel Cell (Keyboard Shortcut + Formula)
- How to Stop Excel from Changing Numbers to Dates Automatically
- How to Stop Excel from Rounding Numbers (Decimals/Fractions)
- How To Subtract In Excel (Subtract Cells, Column, Dates/Time)
- How to Sum a Column in Excel (5 Really Easy Ways)
- How to Sum Across Multiple Sheets in Excel? (3D SUM Formula)
- How to Sum Only Positive or Negative Numbers in Excel (Easy Formula)
- How to SUM Values Between Two Dates (using SUMIFS formula)
- How to Swap Cells in Excel?
- How to Transpose Data in Excel
- How to Turn OFF Scroll Lock in Excel?
- How to Turn On AutoSave in Excel (An Easy Guide)
- How to Underline in Excel?
- How to Undo Sort in Excel (Revert to Original)
- How to Unhide Rows in Excel (3 Easy Ways + Shortcut)
- How to Unmerge Cells in Excel (3 Easy Ways + Shortcut)
- How to use Fill Handle in Excel
- How to Use Flash Fill in Excel (2013, 2016, 2019, and Excel 365)
- How to Use IF Function with OR in Excel
- How to Use IF with AND in Excel to Check Multiple Conditions
- How to Use Multiple Criteria in Excel COUNTIF and COUNTIFS Function
- How to Use VLOOKUP with Multiple Criteria
- How to Use XLOOKUP with Multiple Criteria in Excel
- How to Wrap Text in Excel (with shortcut, One Click, and a Formula)
- How to Write Scientific Notation in Excel?
- How to Write Vertically in Excel
- How to Zoom-in and Zoom-Out in Excel (Shortcuts)
- Hyperlinks in Excel (A Complete Guide + Examples)
- Identify Errors Using Excel Formula Debugging (2 Methods)
- Improve your Spreadsheet Experience with these Excel Options
- Increase Excel Tab Numbering as You Create a Copy
- INDEX & MATCH Functions Combo in Excel (10 Easy Examples)
- INDEX MATCH with Multiple Criteria in Excel
- Insert Alpha Symbol (α) in Excel
- Insert Approximate (Almost Equal To) Symbol in Excel
- Insert Copyright Symbol in Excel
- Insert Diameter Symbol (Dia) in Excel
- Insert Infinity Symbol in Excel
- Insert Less Than Or Equal To Symbol in Excel
- Insert Omega Symbol in Excel
- Insert Pi Symbol (π) in Excel
- Insert Registered Trademark Symbol in Excel
- Insert Sigma Symbol in Excel (Σ or σ)
- Insert X-Bar Symbol in Excel (Average / Mean)
- Keyboard & Mouse Tricks that will Reinvent the Way You Excel
- Lookup and Return Values in an Entire Row/Column in Excel
- Lookup the Second, the Third, or the Nth Value in Excel
- Microsoft Excel Won’t Open? How to Fix It (9 Solutions)
- Move Pivot Table to Different Worksheet or Workbook (Easy Steps)
- Name Box in Excel
- NAME Error in Excel (#NAME?) – What Causes it and How to Fix it!
- Paste into Filtered Column (Skipping Hidden Cells) in Excel
- Pivot Cache in Excel – What Is It and How to Best Use It
- Pivot Table Limitations in Excel
- Pivot Table Tips & Tutorials (Resource Guides + Videos)
- Power Query vs DAX: Which One Should You Use (and When)?
- Power Query vs Power Pivot vs Power BI
- Preparing Source Data For Pivot Table
- Prevent Duplicate Entries in Excel
- Quickly Enter Data in Excel in a Specific Order in Non-Contiguous Cells
- [Quick Tip] How to Apply Superscript and Subscript Format in Excel
- [Quick Tip] How to Copy a Worksheet in Excel
- [Reader’s Question] How to Increase Size of Harvey Balls in Excel
- Remove Asterisk (*) in Excel
- Remove Blank Rows in Excel Using a Formula
- Remove Characters From Left in Excel (Easy Formulas)
- Remove Duplicates Within a Cell in Excel
- Remove Extra Spaces in Excel (Leading, Trailing, Double Spaces)
- Remove Formulas (but Keep Data) in Excel
- Remove Last Character in Excel
- Remove Parentheses in Excel
- Repeat Last Action in Excel (Shortcuts)
- Return to Normal View in Excel
- Round to the Nearest 1000 in Excel
- Row vs Column in Excel – What’s the Difference?
- Save As Shortcuts in Excel (Quick and Easy)
- Search and Highlight Data Using Conditional Formatting
- Select Every Other Column in Excel
- Select Every Other Row in Excel
- Select Till End of Data in a Column in Excel (Shortcuts)
- Send Email From Excel Using Hyperlink Function + BONUS Email Generator Tool
- Separate First and Last Name in Excel (Split Names Using Formulas)
- Show Formulas in Excel Instead of the Values
- Show Negative Numbers in Parentheses (Brackets) in Excel (Easy Ways)
- Show Symbols in Drop Down Lists in Excel
- Sort Dates By Month in Excel
- Sort Pivot Table in Excel
- Spell Check in Excel – Where is it and How to Use it?
- Split Text into Multiple Rows in Excel
- Status Bar in Excel
- Strikethrough Text in Excel – Keyboard Shortcut and Examples
- SUM Based on Partial Text Match in Excel (SUMIF)
- SUMIF vs SUMIFS in Excel: What’s the Difference?
- Text to Columns in Excel – 7 Examples
- Transpose Multiple Rows into One Column
- Trump Excel Turns One Year Old Today
- Unprotect Excel Sheets Without Password
- Use Excel Watch Window to Keep a Tab on Important Cells and Formulas
- Use Format Painter in Excel to Quickly Copy Formatting
- Use IFERROR with VLOOKUP to Get Rid of #N/A Errors
- Use Input Message in Excel to Display Message when a Cell is Selected
- Use VLookup to Get the Last Number in a List in Excel
- Using A1 or R1C1 Reference Notation in Excel (& How to Change These)
- Using Conditional Formatting in Excel (The Ultimate Guide + Examples)
- Using Find and Replace in Excel
- Using Slicers in Excel Pivot Table – A Beginner’s Guide
- VLOOKUP Not Working? (10 Common Fixes)
- VLOOKUP Vs. INDEX/MATCH – Which One is Better? (Answered)
- Volatile Formulas Detected in Excel – Keep Your Distance
- What is Excel Camera Tool and How to Use It?
- What is Intersect Operator in Excel and How to Use it
- Working with Gridlines in Excel: How to Add, Remove, Change, and Print Gridlines
- XLS vs XLSX – Key Differences
Macros and VBA code to automate the repetitive stuff in Excel.
- 24 Useful Excel Macro Examples for VBA Beginners
- Activate Sheet Using VBA in Excel (Worksheet.Activate)
- Adjust Scroll Bar Maximum Value based on a Cell Value in Excel
- Best Shortcuts to Fill Color in Excel (Basic & Advanced)
- Celebrating 2000 Subscribers with Excel Tips, Freebies and Giveaways
- Check IF Sheet Exists Using VBA in Excel
- Check If Workbook Is Open Using VBA
- Clear Sheet Using VBA in Excel
- Comments in Excel VBA (Add, Remove, Block Commenting)
- Count Rows Using VBA in Excel
- Count Sheets in Excel (using VBA)
- Create New Sheet Using VBA in Excel (Sheets.Add)
- Creating a Searchable Drop Down list in Excel – Step by Step Guide
- Creating a User Defined Function (UDF) in Excel VBA [Ultimate Guide]
- Delete Blank Rows in Excel (5 Easy Ways)
- Delete Sheet in Excel Using VBA
- Excel Dashboard: Premier League Season 2014-15 Visualized
- Excel Personal Macro Workbook | Save & Use Macros in All Workbooks
- Excel VBA Autofilter: A Complete Guide with Examples
- Excel VBA Error Handling – All You Need to Know!
- Excel VBA Events – An Easy (and Complete) Guide
- Excel VBA Immediate Window – 5 Awesome Ways to Use it!
- Excel VBA InStr Function – Explained with Examples
- Excel VBA Loops: For Next, Do While, Do Until, For Each (with Examples)
- Excel VBA MsgBox [Message Box] – All You Need to Know!
- Excel VBA Select Case Statement – Explained with Examples
- Excel VBA Split Function – Explained with Examples
- Excel VBA TRIM Function (explained with Examples)
- Extract Numbers from a String in Excel (Using Formulas or VBA)
- Extract URL from Hyperlinks in Excel
- For Next Loop in Excel VBA – A Beginner’s Guide with Examples
- Game of Thrones Dashboard – Visualizations in Excel
- Get a List of All the Comments in a Worksheet in Excel
- Get the List of File Names from a Folder in Excel (with and without VBA)
- Hide or Unhide Sheets Using VBA
- Hide Zero Values in Excel | Make Cells Blank If the Value is 0
- Highlight Active Row and Column in Excel (VBA)
- Highlight Part of a Map based on Drop Down Selection
- How to Add Leading Zeros in Excel (5 Easy Ways)
- How to Assign a Macro to a Button in Excel (Easy Guide)
- How to Capitalize First Letter of a Text String in Excel (using Formula & VBA)
- How to Combine Multiple Excel Files into One Excel Workbook
- How to Convert Excel to PDF Using VBA
- How to Count Colored Cells in Excel?
- How to Create and Use an Excel Add-in
- How to Create a Stopwatch in Excel (Basic + ToastMasters Style)
- How to Delete Entire Row in Excel Using VBA (Examples)
- How to Delete Every Other Row in Excel (or Every Nth Row)
- How to Delete Named Range in Excel? 2 Easy Ways!
- How to Delete Sheets in Excel (Shortcuts)
- How to Filter Cells that have Duplicate Text Strings (Words) in it
- How to Filter Cells with Bold Font Formatting in Excel (An Easy Guide)
- How to Flip Data in Excel (Reverse Order of Rows or Columns)
- How to Hide a Worksheet in Excel (that can not be unhidden)
- How to Highlight Blank Cells in Excel
- How to Insert / Delete Comments in Excel (including Shortcuts)
- How to Make Multiple Selections in a Drop Down List in Excel
- How to Open Excel Files Using VBA (Examples)
- How to Print Multiple Sheets (or All Sheets) in Excel in One Go
- How to Quickly Insert Date and Timestamp in Excel
- How to Quickly Remove Hyperlinks from a Worksheet in Excel
- How to Record a Macro in Excel – A Step by Step Guide
- How to Remove Line Breaks in Excel (3 Easy Ways)
- How to Remove Macros From an Excel Workbook (3 Easy Ways)
- How To Remove Text Before Or After a Specific Character In Excel
- How to Rename a Sheet in Excel (4 Easy Ways + Shortcut)
- How to Run a Macro in Excel?
- How to Select Every Third Row in Excel (or select every Nth Row)
- How to Sort Data in Excel using VBA (Range/Columns)
- How to Sort Worksheets in Excel using VBA (alphabetically)
- How to Sum by Color in Excel (4 Methods, Formula & VBA)
- How to Switch Between Sheets in Excel (Shortcut + 7 More Ways)
- How to Switch First and Last Name in Excel with Comma?
- How to Unhide Sheets in Excel (All In One Go)
- If Then Else Statement in Excel VBA (explained with examples)
- Insert a Blank Row after Every Row in Excel (or Every Nth Row)
- Lookup and Return Multiple Values in One Cell in Excel (Formula & VBA)
- Make VBA Code Pause or Delay (Using Sleep / Wait Commands)
- Matrix Falling Numbers Effect in Excel using VBA
- Protect and Unprotect Sheet Using VBA
- Quickly Create Summary Worksheet with Hyperlinks in Excel
- Quickly Generate Military Alphabet Code for a Word in Excel
- [Quick Tip] How to Select 500 cells/rows in Excel (with a single click)
- Remove Duplicate Values in Excel Using VBA
- Remove First Character from String in Excel
- Remove Password from VBA Project in Excel
- Rename Files Using VBA
- Rename Sheet Using VBA in Excel
- Separate Text and Numbers in Excel (4 Easy Ways)
- Split Each Excel Sheet Into Separate Files (Manual + VBA)
- Understanding Excel VBA Data Types (Variables and Constants)
- Using Active Cell in VBA in Excel (Examples)
- Using VBA FileSystemObject (FSO) in Excel
- Using VLOOKUP in VBA
- Using Workbook Object in Excel VBA (Open, Close, Save, Set)
- VBA Check IF Cell is Empty (ISEMPTY Function)
- VBA Copy Sheet to New/Existing Workbook
- VBA DIR Function – An Easy Explanation with Examples
- VBA Exit Sub Statement
- VBA LCASE Function – Convert Text to Lower Case in Excel
- VBA Run Time Error 9 (Subscript Out of Range)
- VBA UCASE Function – Convert Text to Upper Case in Excel
- Visual Basic Editor – How to Open and Use it in Excel
- Working with Cells and Ranges in Excel VBA (Select, Copy, Move, Edit)
- Working with Worksheets using Excel VBA (Explained with Examples)
