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
English
Current price: $10 Original price: $40 Discount: 75% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 1 Article
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
Requirements
  • 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.
Description

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 55 Lectures Collapse All 55 Lectures 03:38:53
+
Introduction
2 Lectures 04:39

Demonstration Files - Download these to work alongside me
00:05
+
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
01:51

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

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

The Ribbon
03:09

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

The Quick Access Toolbar
04:20

Find out how the Alt Key helps with keyboard shortcuts.

The Alt Key
03:33

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
02:18

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

Create your own Ribbon
02:12

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

The Backstage Menu
03:34

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

Excel Options
05:01

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
03:17

Learn about selecting different parts of your spreadsheet.

Selecting text and the Mouse
04:38

See how to format text entries in Excel 2010.

Formatting text
04:41

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

Formatting Numbers
05:11

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
03:43

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
02:48

Learn how to insert columns and rows into your spreadsheet.

Insert Columns and Rows
03:28

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

Cut Copy and Paste
04:33

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
03:42

Saving your workbook
03:18

Printing in Excel
05:54

Learn about saving your work in different formats.

Save in different formats and versions
05:33

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
04:55

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

Create a custom list
03:16

Learn how to add up a column of numbers.

Automatically add up a column of numbers
06:47

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

Copy a formula using autofill
02:27

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
05:40

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

Average Min Max
07:09

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
05:50

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.

Formula
5 questions
+
Sort and Filter
3 Lectures 12:45

Sort your data by a particluar column.

Sort Data
03:31

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
05:36

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
03:38

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
06:11

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
02:18

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
02:22
+
More Formatting Options
2 Lectures 16:57

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

Borders and Shading
07:39

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
09:18
+
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
07:07

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
06:27

Add formatting to your Pivot Table.

Pivot Table Design
05:15

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
05:39

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

Slicers
04:00

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

Pivot Charts
06:50

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
03:29

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
04:39
About the Instructor
Shelley Fishel
4.4 Average rating
7 Reviews
131 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.