Hey! Welcome to ExcelChamp.Net.
If you are new here, use these links to navigate easily to your interest area within Excel. We hope that our Best Excel Tips and Tricks, Formulas and shortcuts will speed up your work & save you a lot of time.
We also have a FREE TRAINING ON PIVOT TABLES. NO SIGNUP IS REQUIRED. Simply Click and Start watching videos to master Pivot Tables in Excel.
Our Goal is to Solve Everyday Problems with Excel and Make You Awesome With Excel!
Main Categories of Excel Tips, Tricks & Tutorials
New to Microsoft Excel?
General Excel Tips & Tricks
- Top 25 Amazing Tricks in Excel That Will SkyRocket Your Productivity – STEP BY STEP VIDEO TUTORIAL
- 201 Things To Learn in Microsoft Excel: The Complete List
- Top 10 Time Saving Tips in Using Microsoft Excel
- Do You Use These Features of Microsoft Excel?
- How to Center a Title in Excel
- Microsoft Excel Shortcuts
Data Cleanup & Formatting With Excel
- Displaying Large Numbers in K (thousands) or M (millions) in Excel
- How to Find Duplicates in Excel Quickly
- How To Make a Dropdown List in Microsoft Excel
- How to Replace Blanks With Any Value or Zeros in Excel
- Not Ascending… Custom Sorting in Excel
- Showing The Hidden First Column in Excel
- Removing Grid lines from a Section in Microsoft Excel
- Protect Cells from Any Unauthorized Changes in Excel
- Display the File Name & File Path in Excel (PC & Mac)
- Re-Sorting a List or Table in Excel
- Top 5 Careers Requiring Data Analysis Skills (2021)
How To Use Excel Functions & Formulas
- Lookup Functions of Excel: VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, OFFSET
- Find Age in Years within Microsoft Excel [Video Tutorial]
- Using Date & Time Functions in Excel
- Difference Between 2 Dates, Without the Weekends
- How To Count Cells With a Certain Value in Excel
- Multiple Ways to Count in Excel
- Simple Functions in Excel [Video]
- Viewing the Formula in Another Cell in Excel
- View All Formulas in Excel with a Single Click
Tips For Data Analysis With Excel
- 7 Habits of Highly Effective Data Analysts
- Adding Line Breaks in a CSV File
- Counting Text Columns like Employee Names in Excel
- Combine Multiple Text Columns Into a Single Column
- Extracting Digits from Serial Numbers in Excel
- Extracting Text From Variable Length Strings
- Finding The Second Largest Value in Excel
- Removing Duplicate Values in Excel
- How To Summarize Data in Excel: Top 10 Ways
Excel Pivot Table Tips
- How to Analyze Data using Excel Pivot Tables
- How To Show Values & Percentages in Excel Pivot Tables
- How to Refresh Pivot Table in Excel
- How To Get Running Totals In a Pivot Table
- Creating a New Calculation in an Excel Pivot Table
- Different Grouping For Multiple Pivot Tables
- FREE COURSE ON PIVOT TABLES TO ANALYZE DATA – No Signup is required. Click & Start watching Videos For Free and improve your Pivot Table Skills.
Excel Charting Tips
Excel Training & Resources
Microsoft Power BI
Have any Questions About Excel?
Subscribe to Excel Tips Newsletter
Join the ExcelChamp Newsletter and get new Excel tips & tricks each week in your mailbox.
All the Best!
Vinai Prakash
Founder of ExcelChamp
Click to Join our Annual Event – Excel Crash Course in Just 1 Weekend (Nov 18-19, 2023)