Skip to content
Excel at Work Logo
  • Online Live CoursesExpand
    • All Online Live Courses
    • Excel Stage 1
    • Excel Stage 2
    • Excel Stage 3
    • Word Stage 1
    • Word Stage 2
    • PowerPoint Stage 1
  • Self-Guided CoursesExpand
    • All Online Self-Paced Courses
    • Excel 1 Beginners
    • Excel 2 Intermediate
    • Excel 3 Data Analysis & Pivot Table Reporting
    • Excel 1, 2 & 3 Course Bundle
    • Word 1 Beginners
    • Excel & Word Beginners Bundle
    • FAQs
    • Login to Learning
  • Pricing
  • Contact
  • Blog
Search
Excel at Work Logo
Home / Excel Combine, Analyse, Report

Excel Combine, Analyse, Report

Discover posts that introduce the more advanced features of Excel that assist you in referencing and reporting on large data lists.

Become super confident preparing data, creating reports and charts using these fabulous tools.

enter 0 before a number
Excel Combine, Analyse, Report

How to add 0 in front of a Number in Excel

Are you struggling to add 0 in front of a number in Excel, only to see it disappear? This is a common…

Read More How to add 0 in front of a Number in ExcelContinue

How to Remove Space Before and After Text in Excel
Excel Combine, Analyse, Report

How to Remove Space Before and After Text in Excel

Do you need to remove extra spaces in an Excel cell? Extra spaces can appear in your worksheet for many different reasons,…

Read More How to Remove Space Before and After Text in ExcelContinue

Close up of a woman's hands on a mouse and laptop keyboard.
Excel Combine, Analyse, Report

5 Quick And SUPER EASY Ways To CLEAN DATA In EXCEL

Cleaning messy data in Excel is essential for accurate analysis and efficient workflow. Whether you’re dealing with extra spaces, incorrect formatting, or…

Read More 5 Quick And SUPER EASY Ways To CLEAN DATA In EXCELContinue

Excel Filter not working
Excel Combine, Analyse, Report

Excel Filter Not Working? 5 Reasons Why

Excel filter not working? Don’t worry. I’ve got you covered! Filtering is a fantastic tool for analysing data, but it can be…

Read More Excel Filter Not Working? 5 Reasons WhyContinue

finding removing duplicate data Excel
Excel Combine, Analyse, Report

Find and Delete Duplicate Rows in Excel

Unlocking the ability to find and delete duplicate rows in Excel is not just a time-saver; it’s a game-changer. However, it can…

Read More Find and Delete Duplicate Rows in ExcelContinue

vlookup with multiple criteria
Excel Combine, Analyse, Report

How to do a VLOOKUP with multiple criteria in Excel

There are times when you want to return a match for a VLOOKUP based on multiple criteria. For example, we may have customers…

Read More How to do a VLOOKUP with multiple criteria in ExcelContinue

excel remove spaces
Excel Combine, Analyse, Report

Remove spaces in Excel cell before and after text

Need to learn how to quickly remove spaces in Excel? Extra spaces can appear in your worksheet for lots of different reasons…

Read More Remove spaces in Excel cell before and after textContinue

excel change case command
Excel Combine, Analyse, Report

How Change Case in Excel

In this blog we will cover how to change the case of your text in Excel with or without a formula. If…

Read More How Change Case in ExcelContinue

excel trim isn't removing all spaces
Excel Combine, Analyse, Report

Remove spaces Excel TRIM function misses

Want to learn how to remove spaces in Excel that even the TRIM function can’t get rid of? Here are two easy…

Read More Remove spaces Excel TRIM function missesContinue

Word customized style headings navigation pane
Excel Combine, Analyse, Report

Excel – Using VLOOKUP to compare two lists

If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two…

Read More Excel – Using VLOOKUP to compare two listsContinue

Excel Tables Freeze Panes
Excel Combine, Analyse, Report

Excel – How do I merge cells within a range that is formatted as a Table?

Question: When I use Excel “Format as Table” to format a range, the Merge & Center button is greyed out and becomes…

Read More Excel – How do I merge cells within a range that is formatted as a Table?Continue

I Help You get the Most out of Your Microsoft Apps So that You can Save Time and Work Smarter

  • All Live Online Training
  • All Online Self-Paced Courses
  • Pricing
  • Contact
  • Blog
  • About Sharyn
  • Privacy Policy
  • Terms and Conditions

© 2025 Excel at Work

YouTube Facebook Pinterest Instagram
Search
  • Online Live Courses
    • All Online Live Courses
    • Excel Stage 1
    • Excel Stage 2
    • Excel Stage 3
    • Word Stage 1
    • Word Stage 2
    • PowerPoint Stage 1
  • Self-Guided Courses
    • All Online Self-Paced Courses
    • Excel 1 Beginners
    • Excel 2 Intermediate
    • Excel 3 Data Analysis & Pivot Table Reporting
    • Excel 1, 2 & 3 Course Bundle
    • Word 1 Beginners
    • Excel & Word Beginners Bundle
    • FAQs
    • Login to Learning
  • Pricing
  • Contact
  • Blog