__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"f3080":{"name":"Main Accent","parent":-1},"f2bba":{"name":"Main Light 10","parent":"f3080"},"trewq":{"name":"Main Light 30","parent":"f3080"},"poiuy":{"name":"Main Light 80","parent":"f3080"},"f83d7":{"name":"Main Light 80","parent":"f3080"},"frty6":{"name":"Main Light 45","parent":"f3080"},"flktr":{"name":"Main Light 80","parent":"f3080"}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"f3080":{"val":"var(--tcb-skin-color-16)"},"f2bba":{"val":"rgba(89, 94, 95, 0.5)","hsl_parent_dependency":{"h":184,"l":0.36,"s":0.03}},"trewq":{"val":"rgba(89, 94, 95, 0.7)","hsl_parent_dependency":{"h":184,"l":0.36,"s":0.03}},"poiuy":{"val":"rgba(89, 94, 95, 0.35)","hsl_parent_dependency":{"h":184,"l":0.36,"s":0.03}},"f83d7":{"val":"rgba(89, 94, 95, 0.4)","hsl_parent_dependency":{"h":184,"l":0.36,"s":0.03}},"frty6":{"val":"rgba(89, 94, 95, 0.2)","hsl_parent_dependency":{"h":184,"l":0.36,"s":0.03}},"flktr":{"val":"rgba(89, 94, 95, 0.8)","hsl_parent_dependency":{"h":184,"l":0.36,"s":0.03}}},"gradients":[]},"original":{"colors":{"f3080":{"val":"rgb(23, 23, 22)","hsl":{"h":60,"s":0.02,"l":0.09}},"f2bba":{"val":"rgba(23, 23, 22, 0.5)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.5}},"trewq":{"val":"rgba(23, 23, 22, 0.7)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.7}},"poiuy":{"val":"rgba(23, 23, 22, 0.35)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.35}},"f83d7":{"val":"rgba(23, 23, 22, 0.4)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.4}},"frty6":{"val":"rgba(23, 23, 22, 0.2)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.2}},"flktr":{"val":"rgba(23, 23, 22, 0.8)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.8}}},"gradients":[]}}]}__CONFIG_colors_palette__
  • Home
  • About
  • Contact
  • Videos
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"3a186":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"3a186":{"val":"var(--tcb-color-3)","hsl":{"h":147,"s":0.5857,"l":0.2745,"a":1}}},"gradients":[]},"original":{"colors":{"3a186":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45,"a":1}}},"gradients":[]}}]}__CONFIG_colors_palette__
sign up for freebies

Logo
  • Online Courses
    • Instructor Led Courses
      • Excel Stage 1 – Essential Skills
      • Excel Stage 2 – Organise & Analyse Data
      • Excel Stage 3 – Combine, Analyse and Report
      • Word Stage 1 – Essentials for Beginners
      • Word Stage 2 – Intermediate
      • Office 365 Essential Skills
      • Teams Engage with Clients
      • Teams Collaborate and Communicate
    • Self Guided Online Courses
    • Online Coaching
    • Pricing
  • Excel
  • Microsoft Word
  • Microsoft 365 Apps

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"3a186":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"3a186":{"val":"var(--tcb-skin-color-2)","hsl":{"h":0,"s":0.01,"l":0.9725,"a":1}}},"gradients":[]},"original":{"colors":{"3a186":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45,"a":1}}},"gradients":[]}}]}__CONFIG_colors_palette__
free email sign up
Excel at Work logo
  • Online Courses
    • Instructor Led Courses
      • Excel Stage 1
      • Excel Stage 2
      • Excel Stage 3
      • Word Stage 1
      • Word Stage 2
      • Microsoft 365 Essential Skills
      • Microsoft Teams Engage with Clients
      • Microsoft Teams Collaborate and Communicate
    • Self Guided Online Courses
    • Online Coaching | Personal training for 1 or 2 people
    • Pricing
  • Excel
  • Microsoft Word
  • Microsoft 365 Apps

excel basics   Â·   filter & sort   Â·   popular functions   Â·   essential formulas   Â·   pivot tables   Â·   word   Â·   teams 

  • You are here: Home
  • Category: 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.

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

Average formula in Excel – AVERAGE, AVERAGEIF, AVERAGEIFS function

Don’t be fooled – Excel Worksheet Protection isn’t bullet-proof

3 quick ways to Unprotect Excel Sheet and Excel Workbook (inc without password)

How to Protect an Excel file with password (3 quick ways to protect your work)

How to Freeze rows in Excel

Editing a Drop Down List in Excel

How to Create Drop Down Menu in Excel (Drop Down List)

Page [tcb_pagination_current_page] of [tcb_pagination_total_pages]

prev

Previous

Next

next

Free Email Bonus

100+ Steps to Becoming Proficient in Excel

Join Free Now!

     Privacy Policy    Terms Of Use 

Excel at Work logo

Copyright 2022, Excel At Work Limited.

All rights reserved.

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"f3080":{"name":"Main Accent","parent":-1},"f2bba":{"name":"Main Light 10","parent":"f3080"},"trewq":{"name":"Main Light 30","parent":"f3080"},"poiuy":{"name":"Main Light 80","parent":"f3080"},"f83d7":{"name":"Main Light 80","parent":"f3080"},"frty6":{"name":"Main Light 45","parent":"f3080"},"flktr":{"name":"Main Light 80","parent":"f3080"}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"f3080":{"val":"rgb(23, 23, 22)"},"f2bba":{"val":"rgba(23, 23, 22, 0.5)","hsl_parent_dependency":{"h":60,"l":0.09,"s":0.02}},"trewq":{"val":"rgba(23, 23, 22, 0.7)","hsl_parent_dependency":{"h":60,"l":0.09,"s":0.02}},"poiuy":{"val":"rgba(23, 23, 22, 0.35)","hsl_parent_dependency":{"h":60,"l":0.09,"s":0.02}},"f83d7":{"val":"rgba(23, 23, 22, 0.4)","hsl_parent_dependency":{"h":60,"l":0.09,"s":0.02}},"frty6":{"val":"rgba(23, 23, 22, 0.2)","hsl_parent_dependency":{"h":60,"l":0.09,"s":0.02}},"flktr":{"val":"rgba(23, 23, 22, 0.8)","hsl_parent_dependency":{"h":60,"l":0.09,"s":0.02}}},"gradients":[]},"original":{"colors":{"f3080":{"val":"rgb(23, 23, 22)","hsl":{"h":60,"s":0.02,"l":0.09}},"f2bba":{"val":"rgba(23, 23, 22, 0.5)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.5}},"trewq":{"val":"rgba(23, 23, 22, 0.7)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.7}},"poiuy":{"val":"rgba(23, 23, 22, 0.35)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.35}},"f83d7":{"val":"rgba(23, 23, 22, 0.4)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.4}},"frty6":{"val":"rgba(23, 23, 22, 0.2)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.2}},"flktr":{"val":"rgba(23, 23, 22, 0.8)","hsl_parent_dependency":{"h":60,"s":0.02,"l":0.09,"a":0.8}}},"gradients":[]}}]}__CONFIG_colors_palette__
>
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are agreeing to our Cookie Policy.OK, I understandPrivacy policy