Learn Microsoft Excel 2010
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
29 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Microsoft Excel 2010 to your Wishlist.

Add to Wishlist

Learn Microsoft Excel 2010

Get to grips with Excel - create spreadsheets that work! Learn what you want when you want.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
29 students enrolled
Created by Shelley Fishel
Last updated 8/2013
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3.5 hours on-demand video
  • 1 Article
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create spreadsheets
  • Use formulae to add, subtract, multiply and divide
  • Use Absolute Cell References
  • Create charts
  • Use Subtotals
  • Create a Pivot Table
  • Format your data
  • Use Conditional Formatting to show data that matches a criteria
View Curriculum
  • You must be able to use a keyboard and a mouse.
  • A full working copy of Excel 2010 is required so that you can work along with me.

This course will take you through Microsoft Excel 2010 from starting the program and using the Ribbon to creating Pivot Tables and summarising your data.

You will be able to create spreadsheets and workbooks that add up. Use more complex functions such as If Statements and present your data in a visually pleasing way.

You can take the course in the order it is set out or jump in and learn the lessons you need when you need them.

This course will have you presenting professional looking worksheets and summarising your data efficiently.

Who is the target audience?
  • Anyone who uses Excel in their day to day work and wants to speed up how they do things
  • If you want more confidence using Excel 2010 then this course is for you.
Compare to Other Excel Courses
Curriculum For This Course
55 Lectures
2 Lectures 04:39

Demonstration Files - Download these to work alongside me
Getting Started
10 Lectures 28:26
Before working with Microsoft Excel 2010 you will need to open the program. This short tutorial shows you how to do just that.
Starting Excel

Find your way around the Excel screen - see where things are.
The Excel Window

Get to grips with the Ribbon and see how it works.

The Ribbon

The Quick Access Toolbar allows you to add your favourite icons to a handy toolbar which is always in view.

The Quick Access Toolbar

Find out how the Alt Key helps with keyboard shortcuts.

The Alt Key

In Excel 2010 you can customise the Ribbon to add your own favourite icons where you want them or even create your own Ribbon.

Customise the Ribbon

Create your own Ribbon with the icons you use most often. All your favourite tools in one place.

Create your own Ribbon

The Backstage menu is where you will find information about the current file, new documents, printing and Excel Options.

The Backstage Menu

Here you will find how to customise Excel and control how it works.

Excel Options

Complete the exercise to check your understanding and make sure that you can do everything you have learned so far.

Down load the pdf and follow the instructions.

Exercise - Customise your screen
1 page

Take the quiz to check your understanding. Good Luck!

Getting Started
4 questions
Editing in Excel
17 Lectures 57:44

Learn how to add text and numbers to your spreadsheets.

Preview 03:29

See how to format Numbers in Excel.

Number formats

Learn about selecting different parts of your spreadsheet.

Selecting text and the Mouse

See how to format text entries in Excel 2010.

Formatting text

Learn about Number Formats in Excel and why they are important.

Formatting Numbers

Sometimes you may wish to centre your heading accross several cells. See how to merge cells and centre the text across them all.

Merge Centre and Resize Columns

Complete the exercise to check your understanding of what you have learned. This exercise will enable you to practice formatting your spreadsheet.

Exercise - Formatting
2 pages

Format Painter allows you to copy formatting from one location to another.

Format Painter

Learn how to insert columns and rows into your spreadsheet.

Insert Columns and Rows

Copy or move information from one place in your spreadsheet to anohter.

Cut Copy and Paste

Learn about moving around your spreadsheet.

Preview 02:15

There are different views of worksheets in Excel. Find out the differences and when to use them.

Different Views of your Worksheet

Saving your workbook

Printing in Excel

Learn about saving your work in different formats.

Save in different formats and versions

Send your spreadsheet as an attachment direct from within Excel.

Preview 01:14

Here is another exercise for you to do. This one is all about printing and emailing your spreadsheet. Download the pdf and follow the instructions.

Exercise - Printing
1 page

Take the Quiz to check your understanding and see what you have learned.

Editing in Excel
6 questions
Automatic features
4 Lectures 17:25

Autofill is one of the most useful tools in Excel. Use it to copy content across or down a selection of cells or to create a series of data that increments ; like dates or days of the week.

Auto Fill - automatically copy a list

Create your own custom list so that you can save time when typing in headings.

Create a custom list

Learn how to add up a column of numbers.

Automatically add up a column of numbers

See how Autofill helps when copying a formula across a row or down an entire column.

Copy a formula using autofill

Take the Quiz to cosolidate what you have learned.

Automatic Features
4 questions
Creating Formulae
4 Lectures 18:39

Build a formula from scratch.

Create simple formula

Work out the Average value of a list or pick the minimum number of the maximum number with these handy functions.

Average Min Max

Absolute Cell References allow you to fix part of the formula so that you can copy it down a column or across a row. See the video to understand how useful this feature is.

Absolute Cell References - fixing part of your formula

Complete the exercise to check your understanding. A practical example of how to use Absolute Cell References will help you embed the learning.

Exercise - Absolute Cell References
2 pages

Take the Quiz to consolidate your leearning.

5 questions
Sort and Filter
3 Lectures 12:45

Sort your data by a particluar column.

Sort Data

You may wish to sort on more then one column of data and with Excel 2010 you can sort on up to 64 levels!!

Sort on more than one level

When filtering data you can pull out just the information that you want to focus on. Really useful when you have a very large amount of data and need to focus on just one part.

Filter Data

Take the Quiz to consolidate your learning.

Sort and Filter
4 questions
Format as a Table
3 Lectures 10:51

Formatting your data as a table allows you to add really great formatting plus a filter and some totals.

Format as a table

If you have formatted your data as a table and then finished with it, you might want to put the data back to static data. This short video shows you how.

Remove formatting convert to range

Calculated columns allow you to create a formula in one cell and the automatic feature will populate the whole column when you press enter. A real time saver.

Calculated Columns
More Formatting Options
2 Lectures 16:57

Learn how to add borders and shading to jazz up your spread sheets.

Borders and Shading

Use formatting to pick out data that matches a particular criteria. For example, show all cells where the value is greater than a certain amount in Red.

Conditional Formatting & Duplicate values
Analyse Data
8 Lectures 35:18

Subtotals are a great way to find out the total of each group of data in your spreadsheet. My favourite function.

Subtotals - get subtotals of groups of data in a flash

Complete this exercise to practice sorting, filtering and conditional formatting.

Exercise - Sort Filter and Conditional Formatting
1 page

A pivot table allows you to sort and filter your data plus get subtotals too. Simple to create once your data is arranged correctly.

Create a Pivot Table

Add formatting to your Pivot Table.

Pivot Table Design

When you need to add extra data to your Pivot Table you will have to update it. This video tutorial shows you how.

Update a Pivot Table

Slicers allow you to filter a Pivot Table easily and you can have as many slicers as you wish.


A Pivot Chart is like a Pivot Table except you create a chart that can be filtered from drop down menus.

Pivot Charts

Complete this exercise to practice creating Pivot Tables and Pivot Charts.

Exercise - Pivot Tables and Pivot Charts
1 page

Take the Quiz to consolidate your learning.

Analyse Data
4 questions
Conditional Processing
2 Lectures 08:08
An If Statement allows you to ask a question of your data - for example, 

If the coffee sales in Bath are over £500 then have a pay rise otherwise no pay rise. 

You can also do calculations within an IF Statement. 

This lesson shows you how to build a basic IF Statement.

If Statements

A nested If statement allows you to test for several conditions.

Create your first test, and if the formula is true it stops, if it gets a false result it continues to perform a second test and so on.

Nested IF Statements
About the Instructor
Shelley Fishel
3.3 Average rating
22 Reviews
139 Students
3 Courses
MCT helping you become more productive with Microsoft Office

HI I am Shelley Fishel - a qualified Microsoft Certified Trainer and I have been teaching Microsoft Office for more than 18 years now. Through my IT Training Company, The IT Training Surgery myself and a team of dedicated trainers deliver courses to businesses in many sectors.

With several levels of each course on offer and a bespoke offering as well I decided that it was time to put my classroom training on line.

Each course has several hours of video tutorials along with exercises to consolidate the learning. 

I am very excited to bring this training to more people with my main aim, to save you time when working in Microsoft Office.