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 Organise, Analyse Data

Excel Organise, Analyse Data

Discover posts that cover the Excel features that save you time.

Perfect if you spend hours formatting and updating data in worksheets.

If you use Excel often but find you seem to be spending way too much time getting the results you require, this category is a good place to hang out.

Quickly Fill Blank Cells With Value Above In Excel
Excel Organise, Analyse Data

Quickly Fill Blank Cells With Value Above In Excel

In this blog, we will explore a simple and efficient method to fill blank cells with the value above in Excel. This…

Read More Quickly Fill Blank Cells With Value Above In ExcelContinue

How To APPLY FILTER In EXCEL- Essential Skill
Excel Organise, Analyse Data

How To APPLY FILTER In EXCEL- Essential Skill

Filtering in Excel is a powerful tool that can help you manage and analyse your data more effectively. Imagine having a magic…

Read More How To APPLY FILTER In EXCEL- Essential SkillContinue

Four people in an office having a meeting
Excel Organise, Analyse Data

How to Apply Multiple Filters to the Same Field in an Excel Pivot Table

Have you ever tried to apply multiple filters to the same field in a Pivot Table, only to find that your first…

Read More How to Apply Multiple Filters to the Same Field in an Excel Pivot TableContinue

Unprotect Excel
Excel Organise, Analyse Data

How to Unprotect Excel Workbook & Excel Worksheet (inc Without Password)

Are you looking to unlock the full potential of your Excel workbook but feel stuck behind a password barrier? You’ve come to…

Read More How to Unprotect Excel Workbook & Excel Worksheet (inc Without Password)Continue

How to Password Protect in Excel Lock Cells to Prevent Edits
Excel Organise, Analyse Data

How to Password Protect in Excel Lock Cells to Prevent Edits

Looking to password protect your Excel sheets? Itโ€™s a smart move to prevent accidental edits or unwanted tweaks to your formulas and…

Read More How to Password Protect in Excel Lock Cells to Prevent EditsContinue

Woman working on computer
Excel Organise, Analyse Data

How the SUMPRODUCT formula in Excel can help you work more efficiently

When it comes to performing calculations and analysis in Excel, numerous functions can save you time and effort, one of which is…

Read More How the SUMPRODUCT formula in Excel can help you work more efficientlyContinue

Excel #DIV/0! error
Excel Organise, Analyse Data

How to Remove #DIV/0 Error in Excel

If you’re an Excel user, you’ve probably encountered the dreaded #DIV/0 error at some point. This error occurs when you attempt to…

Read More How to Remove #DIV/0 Error in ExcelContinue

#N/A Excel
Excel Organise, Analyse Data

Find and break links in Excel

Linking from one worksheet to another is a fantastic way to connect data from one source to another, and a great way…

Read More Find and break links in ExcelContinue

excel count cells with text
Excel Organise, Analyse Data

Excel Count cells with Text (3 easy functions + 9 valuable formula examples)

Are you trying to count cells with text in Excel? Are you wondering why the COUNT function in Excel returns a result…

Read More Excel Count cells with Text (3 easy functions + 9 valuable formula examples)Continue

Average formula in Excel
Excel Organise, Analyse Data

Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function

There are many areas within business reporting where we are looking for the average of a selection of results. A good example…

Read More Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS functionContinue

Freeze column row Excel
Excel Organise, Analyse Data

How to Freeze rows in Excel

Would you like to keep row headings in Excel when you are scrolling so that you can easily identify your columns? What…

Read More How to Freeze rows in ExcelContinue

how to edit drop down list in excel
Excel Organise, Analyse Data

Editing a Drop Down List in Excel

Learn how to edit a drop-down list in Excel. In this blog you will learn how to find, remove and add items…

Read More Editing a Drop Down List in ExcelContinue

Page navigation

1 2 Next PageNext

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