__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 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.

How to do a VLOOKUP with multiple criteria in Excel

Remove spaces in Excel cell before and after text

How to add 0 in front of a Number in Excel

How Change Case in Excel

Remove spaces Excel TRIM function misses

Excel Tables

Excel – How do I change a Pivot Table back to the classic (version 2003 and earlier) display?

Excel – Using VLOOKUP to compare two lists

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