Канал: Anne Walsh

repeat and emojis chart

repeat and emojis chart

IFS function

IFS function

Creating a formula to summarize multiple worksheets

Creating a formula to summarize multiple worksheets

How to view multiple worksheets on the same screen

How to view multiple worksheets on the same screen

Quick Start Course Introduction Video

Quick Start Course Introduction Video

Two methods to quickly update multiiple cells

Two methods to quickly update multiiple cells

combining worksheets - append

combining worksheets - append

combining worksheets - using vstack

combining worksheets - using vstack

combining worksheets - copy and paste

combining worksheets - copy and paste

How to conditionally format a row with two conditions

How to conditionally format a row with two conditions

Using OR with if function in Excel

Using OR with if function in Excel

How to have different page numbering for different sections

How to have different page numbering for different sections

Use conditional formatting to format the entire row

Use conditional formatting to format the entire row

Using Hlookup with match to speed up formula copying

Using Hlookup with match to speed up formula copying

How to use the match function in Excel

How to use the match function in Excel

hlookup - introduction

hlookup - introduction

How to identify and remove duplicate email addresses in Excel

How to identify and remove duplicate email addresses in Excel

How to use xlookup in Excel

How to use xlookup in Excel

How to create expiry status for training records using the IF function

How to create expiry status for training records using the IF function

Colour coding expiry dates for training

Colour coding expiry dates for training

expiry dates calculation ifs functions part two

expiry dates calculation ifs functions part two

Using a vlookup to show expiry dates for courses

Using a vlookup to show expiry dates for courses

Mail merge for letters using word and excel

Mail merge for letters using word and excel

Mail merge for emails using word and Excel

Mail merge for emails using word and Excel

automating your dropdown list with dynamic array functions

automating your dropdown list with dynamic array functions

Creating a dynamic dropdown list that you can easily update in Excel

Creating a dynamic dropdown list that you can easily update in Excel

If function in Excel plus some 80s bands

If function in Excel plus some 80s bands

Pivot table with conditional formatting

Pivot table with conditional formatting

pivot tables - how to create multiple pivot tables from the same data

pivot tables - how to create multiple pivot tables from the same data

How show % in pivot tables with Show Values As

How show % in pivot tables with Show Values As

Group numbers into bins or buckets

Group numbers into bins or buckets

How to group by dates

How to group by dates

How to group by dates and in bins

How to group by dates and in bins

Some of the fundmental patterns in Excel

Some of the fundmental patterns in Excel

How to create a dynamic pivot table and chart with slicer and timeline

How to create a dynamic pivot table and chart with slicer and timeline

How to do your first pivot table from scratch

How to do your first pivot table from scratch

how to use Vlookup and tables to autopopuilate a sheet

how to use Vlookup and tables to autopopuilate a sheet

how to clean up blank rows and columns in Excel

how to clean up blank rows and columns in Excel

Unpivot columns in Excel Part Three

Unpivot columns in Excel Part Three

Unpivot Part Two

Unpivot Part Two

PQ unpivot part one

PQ unpivot part one

Introduction to vlookup

Introduction to vlookup

how to hide and unhide rows and columns

how to hide and unhide rows and columns

How to only print certain parts in Excel

How to only print certain parts in Excel

How to quickly copy formatting from one cell to another using the Format Painter in Excel

How to quickly copy formatting from one cell to another using the Format Painter in Excel

Printing in Excel

Printing in Excel

creating a chart in Excel

creating a chart in Excel

how to subtract in Excel

how to subtract in Excel

how to multiply in Excel

how to multiply in Excel

fix a row in Excel

fix a row in Excel

fix a column in Excel

fix a column in Excel

fixing a cell in Excel

fixing a cell in Excel

Sorting in Excel

Sorting in Excel

filtering in Excel

filtering in Excel

How to count cells that have anything in them

How to count cells that have anything in them

count function in Excel

count function in Excel

finding the lowest value in Excel

finding the lowest value in Excel

How to calculate average in Excel

How to calculate average in Excel

finding the highest value in Excel

finding the highest value in Excel

Adding up numbers in Excel

Adding up numbers in Excel

PowerBI One file - changing the data source

PowerBI One file - changing the data source

PowerBI - One File - Part One - star schema - separating out the data into different tables

PowerBI - One File - Part One - star schema - separating out the data into different tables

PowerBi - One file - creating a dynamic calendar table

PowerBi - One file - creating a dynamic calendar table

Dashboard Bikes Part Eight - Adding More Data

Dashboard Bikes Part Eight - Adding More Data

Dashboard Bikes Part Seven - Adding a Dynamic Chart

Dashboard Bikes Part Seven - Adding a Dynamic Chart

Dashboard Bikes Part Six - Adding Conditional Icons

Dashboard Bikes Part Six - Adding Conditional Icons

Dashboard Bikes Part Five - Showing YOY Change

Dashboard Bikes Part Five - Showing YOY Change

Dashboard Bikes Part Four - Pulling in the Data from the Pivot Table

Dashboard Bikes Part Four - Pulling in the Data from the Pivot Table

Dashboard Bikes Part Three - Creating a Text Box Slicer Using a Dropdown Box

Dashboard Bikes Part Three - Creating a Text Box Slicer Using a Dropdown Box

Dashboard Bikes Part Two - Creating Two Pivot Tables and Slicer

Dashboard Bikes Part Two - Creating Two Pivot Tables and Slicer

Dashboard Bikes Part One Prepping the Data

Dashboard Bikes Part One Prepping the Data

Sumifs Reference Cell 2

Sumifs Reference Cell 2

Sumifs Introduction

Sumifs Introduction

Sumifs Calculations

Sumifs Calculations

Countifs Demo

Countifs Demo

How to show current and overdue dates

How to show current and overdue dates

Mastering Power BI Report Design: Enhancing User Experience & Impact for Effective Decision Making

Mastering Power BI Report Design: Enhancing User Experience & Impact for Effective Decision Making

Using the If function with conditional formatting to see what is current and overdue

Using the If function with conditional formatting to see what is current and overdue

course type analysis - counting number of unique applicants

course type analysis - counting number of unique applicants

Case study training course analysis - YOY change

Case study training course analysis - YOY change

Case study training course analysis - by Amount spent

Case study training course analysis - by Amount spent

Course type analysis - summary by department

Course type analysis - summary by department

Course type analysis - Summary by course type - video 1

Course type analysis - Summary by course type - video 1

Linking files in Excel

Linking files in Excel

Check for duplicates across worksheets - using append

Check for duplicates across worksheets - using append

How to use removed unwanted spaces with Power Query - AKA Trim

How to use removed unwanted spaces with Power Query - AKA Trim

MKO Excel Group One 5-10-2022 - Session Two - Conditional Formatting

MKO Excel Group One 5-10-2022 - Session Two - Conditional Formatting

Aggregate function in Excel

Aggregate function in Excel

Calculate the top three values in a list of scores

Calculate the top three values in a list of scores

Live with Anne Walsh

Live with Anne Walsh

KPI Video Four - Part four - adding YTD numbers and charts

KPI Video Four - Part four - adding YTD numbers and charts

kpi video five - part two - adding gender charts

kpi video five - part two - adding gender charts

KPI Part Five - Starting the dashboard

KPI Part Five - Starting the dashboard

KPI Dashboard - Part Four – Putting together our annual stats

KPI Dashboard - Part Four – Putting together our annual stats

KPI Dashboard - Part three - preparing monthly stats

KPI Dashboard - Part three - preparing monthly stats

KPI Dashboard Video Three - Monthly stats preparation

KPI Dashboard Video Three - Monthly stats preparation

KPI Dashboard - Video Two - formulas for data entry

KPI Dashboard - Video Two - formulas for data entry

KPI Dashboard - Video Two - formulas for data entry

KPI Dashboard - Video Two - formulas for data entry

KPI Dashboard - Video One - setting the scene

KPI Dashboard - Video One - setting the scene

Copying Xlookup function across - with a table

Copying Xlookup function across - with a table

Can I do a dashboard in 20 minutes

Can I do a dashboard in 20 minutes

Index function with Area option

Index function with Area option

index with two match functions

index with two match functions

use index with two match functions to identify a match

use index with two match functions to identify a match

Colour coding your data automatically in Excel

Colour coding your data automatically in Excel

Use Vlookup to compare two lists and identify what is in one and not in the other

Use Vlookup to compare two lists and identify what is in one and not in the other

When you need to schedule follow ups using working days

When you need to schedule follow ups using working days

Reformatting 0322 to date format

Reformatting 0322 to date format

Recommended pivot table and analyze data

Recommended pivot table and analyze data

03 - Identifying birthdays - flagging them

03 - Identifying birthdays - flagging them

02 - Identifying birthdays - the formula

02 - Identifying birthdays - the formula

01 - identifying birthdays - the setup

01 - identifying birthdays - the setup

convert US dates to UK dates using Power Query

convert US dates to UK dates using Power Query

How to create a funnel chart in Excel

How to create a funnel chart in Excel

how to use a treemap in Excel

how to use a treemap in Excel

Using Match with Vlookup - to match on column names

Using Match with Vlookup - to match on column names

how to load two files for a pivot table without a vlookup

how to load two files for a pivot table without a vlookup

How to use the data model feature

How to use the data model feature

Pivot tables - Show Values As

Pivot tables - Show Values As

When you have a disappointment

When you have a disappointment

receipts - non -profit

receipts - non -profit

Using IF function and IFS function to identify overdue and current records

Using IF function and IFS function to identify overdue and current records

How to clean up text using Excel's Power Query

How to clean up text using Excel's Power Query

unpivot data

unpivot data

04 Pivot tables Show Values As

04 Pivot tables Show Values As

03 Pivot table from scratch with chart and slicer

03 Pivot table from scratch with chart and slicer

02 Pivot Tables - Recommended pivot tables

02 Pivot Tables - Recommended pivot tables

01 - Pivot Tables - Part One - Overview

01 - Pivot Tables - Part One - Overview

Compare spreadsheet Excel tool

Compare spreadsheet Excel tool

Grouping_by_numbers_pivot_table

Grouping_by_numbers_pivot_table

Excel Snacks Conditional Formatting and If function 24 9 2021

Excel Snacks Conditional Formatting and If function 24 9 2021

SimpleAccountingSystem - Part Three - SUMIFS

SimpleAccountingSystem - Part Three - SUMIFS

Excel Snacks Pivot tables 17 9 2021

Excel Snacks Pivot tables 17 9 2021

Excel Snacks - Vlookup - Key Excel superpower 10-9-2021

Excel Snacks - Vlookup - Key Excel superpower 10-9-2021

Payments_Journal_Part_Two

Payments_Journal_Part_Two

Take the Lift v3 8 9 2021

Take the Lift v3 8 9 2021

Payments_Journal_Part_One

Payments_Journal_Part_One

Excel Snack Making Data Entry Easy 3 9 2021

Excel Snack Making Data Entry Easy 3 9 2021

Summarize CSV files

Summarize CSV files

Take the Lift V3 Overview 1 9 2021

Take the Lift V3 Overview 1 9 2021

Summarize CSV files in a folder

Summarize CSV files in a folder

summarize across worksheets

summarize across worksheets

Summarize multiple entries from multiple worksheets

Summarize multiple entries from multiple worksheets

index-match-tutorial

index-match-tutorial

complex_if_training_record_status

complex_if_training_record_status

Tracking_Participation_part_two

Tracking_Participation_part_two

Top three by participation

Top three by participation

Excel Snacks Peek into Power Query

Excel Snacks Peek into Power Query

Excel Snacks printing drop scissors glue and stapler

Excel Snacks printing drop scissors glue and stapler

Examples of If functions exercises

Examples of If functions exercises

Conditional formatting in Excel - Highlight cells rules

Conditional formatting in Excel - Highlight cells rules

Excel Snacks Rolling in the worksheets

Excel Snacks Rolling in the worksheets

Excel Snacks If FY Function

Excel Snacks If FY Function

Time-day-workingday-duration

Time-day-workingday-duration

Analysis of time for closed cases

Analysis of time for closed cases

Creating_a_calendar_Final

Creating_a_calendar_Final

How to extract a list of unique entries

How to extract a list of unique entries

How to clean up a bunch of pasted emails

How to clean up a bunch of pasted emails

Excel Snacks - It's a Pivot Table not a pivot

Excel Snacks - It's a Pivot Table not a pivot

Location_allowance

Location_allowance

Excel Snacks Lists, lists my kingdom for a list

Excel Snacks Lists, lists my kingdom for a list

Dashboards-Part Three

Dashboards-Part Three

Creating a Dashboard - Part Two

Creating a Dashboard - Part Two

Creating a Dashboard - Part One

Creating a Dashboard - Part One

Excel snack add a colour pop AKA Conditional Formatting

Excel snack add a colour pop AKA Conditional Formatting

How to keep the top row visible in large data set in Excel

How to keep the top row visible in large data set in Excel

Excel Snack - Charts - 26.02.21

Excel Snack - Charts - 26.02.21

How to use Trim to remove unwanted spaces and Concatenate to put entries together

How to use Trim to remove unwanted spaces and Concatenate to put entries together

Use Recommended Charts to create a chart

Use Recommended Charts to create a chart

Conditional formatting - that excludes text entries

Conditional formatting - that excludes text entries

Creating_a_training_roster_Part_Two_Data_Entry

Creating_a_training_roster_Part_Two_Data_Entry

Creating_a_training_roster_Part_One_Lists

Creating_a_training_roster_Part_One_Lists

Using IFS or Nested IF to find a matching VAT rate

Using IFS or Nested IF to find a matching VAT rate

UseZoomEmailsto_check_attendance

UseZoomEmailsto_check_attendance

02- using plus for numbers and dates

02- using plus for numbers and dates

02- using plus for numbers and dates

02- using plus for numbers and dates

vaccination_timetable

vaccination_timetable

01-Excel-Introduction

01-Excel-Introduction

01-Excel Introduction

01-Excel Introduction

Clean up accounts with Power Query - Part One

Clean up accounts with Power Query - Part One

Clean up accounts data dump using Power Query in Excel

Clean up accounts data dump using Power Query in Excel

Power_Query_Unpivot_Part_Two

Power_Query_Unpivot_Part_Two

Power_Query_Unpivot_Part_One

Power_Query_Unpivot_Part_One

Filter_function_in_Excel

Filter_function_in_Excel

Creating_a_unique_ID_using Excel's text functions and randbetween()

Creating_a_unique_ID_using Excel's text functions and randbetween()

how to copy and paste a hyperlink from an email

how to copy and paste a hyperlink from an email

how to reply and forward an email in Gmail

how to reply and forward an email in Gmail

Renaming and copying and pasting

Renaming and copying and pasting

How to get to Google docs from your Gmail account

How to get to Google docs from your Gmail account

Conditional_formatting_icons

Conditional_formatting_icons

How to convert PDF to Excel in under 5 minutes using Power Query

How to convert PDF to Excel in under 5 minutes using Power Query

Zoom Setting up a poll

Zoom Setting up a poll

Zoom_using_breakout_rooms_in_the_session_Two

Zoom_using_breakout_rooms_in_the_session_Two

Zoom_using_breakout_rooms_in_the_session_One

Zoom_using_breakout_rooms_in_the_session_One

Zoom_turning_on_breakout_room_feature

Zoom_turning_on_breakout_room_feature

Vlookup_with_Match_worldwide_importers

Vlookup_with_Match_worldwide_importers

How to use the MATCH() function in Excel

How to use the MATCH() function in Excel

Adding_up_across_worksheets

Adding_up_across_worksheets

IFS_Tutorial

IFS_Tutorial

view_arrange_all

view_arrange_all