Get in Contact 020 7375 7300|hello@happy.co.uk

Working with Excel

All of our Excel Videos are listed below. We have separated them into categories so that you can browse more easily.

Working Faster & More Accurately

Autofill in excel

Autofill

Software: Excel
Duration: 2:00 minutes

Set up spreadsheets quickly by getting Excel to fill in series of data for you.

faster autosum in Excel

Faster Autosum

Software: Excel
Duration: 1:48 minutes

Make Autosum even faster with this nifty keyboard shortcut.

Advanced Autofill in Excel

Advanced autofill

Software: Excel
Duration: 2.28 minutes

Get more flexibility from Autofill for faster fills the first time.

Keyboard Shortcuts to move around in Excel

Shortcuts for moving around

Software: Excel
Duration: 1:51 minutes

Top short-cuts for even better productivity in large spreadsheets.

Creating Drop Downs Using Data Validation

Dropdowns using Data Validation

Software: Excel
Duration: 1:47 minutes

Speed up data entry and improve the quality of your data.

 Shortcuts for Data Entry

Shortcuts for Data Entry

Software: Excel
Duration: 1:18 minutes

Macros can turn a whole series of steps into a one click action, this clip will show you how to use a macro to tidy up a spreadsheet that you regularly receive.

Working with dates in Excel

Working with Dates

Software: Excel
Duration: 1.57 minutes

Get more functionality from your data by using the correct date formats.

032-Removing Duplicates in Excel

Remove Duplicates

Software: Excel
Duration: 1:43 minutes

Identify duplicates in large sets of data from different sources.

035-Paste Options in Excel

Paste Options in Excel

Software: Excel
Duration: 2:09 minutes
Avoid retyping information and have more control when you copy data into your worksheet.

Finding Invalid Data in Excel

Dada validation to Check data

Software: Excel
Duration: 2:07 minutes
Quickly identify and fix invalid data so all your summaries and reports are accurate.

Controlling Your Workspace

Freeze Panes in Excel

Freeze panes

Software: Excel
Duration: 2.23 minutes

Find out how to keep your headings and labels in sight at all times, even in large spreadsheets.

Working on Excel Sheets Simultaneosly

Working on sheets simultaneously

Software: Excel
Duration: 2.00 minutes

Group worksheets together so that actions you perform on one will appear on all sheets in the group.

Viewing Excel Sheets Side by Side

Viewing sheets side by side

Software: Excel
Duration: 2.15 minutes

See two sheets from the same file side by side and get a better understanding of your data more quickly.

Easy Working with Lists and Databases

Filtering in Excel

Filtering

Software: Excel
Duration: 2.26 minutes

Home in on just the information you are interested in with Excel filters.

Copying filtered lists in Excel

Copying a filtered list in Excel

Software: Excel
Duration: 1:56 minutes

Filter away unwanted data and then preserve the information you need.

structured sorting in excel

Structured sort

Software: Excel
Duration: 02.17 minutes

Sort your list on more than one column to give your data some structure.

Sortiing horizontally in excel

Sorting horizontally in Excel

Software: Excel
Duration: 1.39 minutes

Did you know you can sort horizontally as well as vertically? Watch the clip to find out how.

Subtotals in Excel 2010

Sub-Totals

Software: Excel
Duration: 3.34 minutes

Use subtotals to turn a list into a summary table in a few clicks without the need for any formulas.

 Table Tools in Excel

Table Tools in Excel

Software: Excel
Duration: 2:37 minutes

If you use Excel to store data and you haven’t converted it to a table you should really check this out.

Improve Reporting With Pivot Tables

Grouping dates in a Pivot Table

Grouping dates in a Pivot Table

Software: Excel
Duration: 1.55 minutes

Improve your reporting by grouping dates in a pivot table into months, quarters or years.

Using Pivot Tables to create sub-reports

Using Pivot Tables to create sub-reports

Software: Excel
Duration: 2.09 minutes

Splitting data up into departments, customers, or team members can be time consuming, we’ll show you how to use pivot tables and do it within a few clicks.

Simple Excel Pivot Tables

Simple Pivot Tables

Software: Excel
Duration: 2.56 minutes

Summarise and analyze large data sets easily with pivot tables.

Creating a Pivot Table to Cross Reference Data

Pivot table to cross reference

Software: Excel
Duration: 3.00 minutes

Make more sense of your data easily and quickly with pivot tables.

Getting Your Message Across with Charts

column charts in Excel

Column Charts

Software: Excel
Duration: 2.46 minutes

Make your point with great looking column charts.

Great lookin pie charts

Great Looking Pie Charts

Software: Excel
Duration: 2.08 minutes

Use pie charts to help others quickly understand your data and the message you are trying to communicate.

Tips for shared spreadsheets

Protecting Excel Worksheets

Protecting Excel Worksheets

Software: Excel
Duration: 2.27 minutes

Protect worksheets so that data never gets deleted – great for sheets you share with others.

creating simple range names

Creating simple range name

Software: Excel
Duration: 1.59 minutes

Improve your spreadsheets usability with range names.

Key Functions You Need To Know

Counting Functions in Excel

Counting functions

Software: Excel
Duration: 02.13 minutes

There are several different counting functions in Excel, learn how to pick the right one for the job!

The CountIF function in Excel

The CountIF function in Excel

Software: Excel
Duration: 2.20 minutes

Count cells that contain data that meets certain criteria such as transaction in London.

Vlookup to cross reference data

Vlookup to cross reference data

Software: Excel
Duration: 2.36 minutes

Learn how to use a Vluookup to lookup an item in another list and return some other information such as replacing a grade with an equivalent numerical value

The SumIf Formula

The SumIf Function

Software: Excel
Duration: 1.41 minutes

Total up an amount based on another criteria by typing in the SumIf Function for example total salaries for your department.

 The IF Function

The IF Function

Software: Excel
Duration: 3.04 minutes

An If Function lets you set a rule and decide two different outcomes, im this clip we’ll show you a simple example to get you started.

Fast Formatting For Improved Legibility

conditional formatting

Conditional Formatting

Software: Excel
Duration: 2.11 minutes

Make important data stand out filter out the rest in a few clicks.

Conditional Formatting - Editing Icon Sets

Conditional Formatting – Editing Icon Sets

Software: Excel
Duration: 1:58 minutes

Conditional formatting changes the look of a cell depending on its value, now you’ll be able to set your own rules so it does just what you want.

Working on Large worksheets

etting Ready to Print Larger Spreadsheets

Getting Ready to Print Larger Spreadsheets

Software: Excel
Duration: 2.17 minutes

All the tricks you need to get your spreadsheets fitting onto the fewest numbers of pages.

017-Print Titles in Excel

Print Titles

Software: Excel
Duration: 2:11 minutes

Print heading rows and columns to make reading a printed out worksheet easier.

044-Outlining in Excel

Outline Information

Software: Excel
Duration: 1:49 minutes

Outlining is better than hiding and showing columns but just as easy, find out how to give your spreadsheets some structure

Automating Repetitive Tasks with Macros

 Introduction to Macros

Introduction to Macros

Software: Excel
Duration: 3:23 minutes

Macros are a way of automating repetitive tasks and saving yourself a boring job, this clip will show you the basics.

Using a Macro to format cells

Using a Macro to format cells

Software: Excel
Duration: 3:97 minutes

Macros can be used for all sorts of repetitive tasks, this macro will ensure any custom formats you use a just one click away on your quick access toolbar.

Using a Macro to Tidy and Format Data

Using a Macro to Tidy and Format Data

Software: Excel
Duration: 4:18 minutes

Macros can turn a whole series of steps into a one click action, this clip will show you how to use a macro to tidy up a spreadsheet that you regularly receive.

Easy Calculations Using Formulas

Percentage calculations in excel

Percentage Calculations

Software: Excel
Duration: 2:11 minutes
Calculate what percentage one number is of another and learn how to display the answer properly.