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
$40
Take This Course
  • Lectures 55
  • Contents Video: 3.5 hours
    Other: 8 mins
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2013 English

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

What are the 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.

What am I going to get from this course?

  • 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

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Introduction
Preview
04:34
Demonstration Files - Download these to work alongside me
Article
Section 1: Getting Started
01:51
Before working with Microsoft Excel 2010 you will need to open the program. This short tutorial shows you how to do just that.
02:28
Find your way around the Excel screen - see where things are.
03:09

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

04:20

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

03:33

Find out how the Alt Key helps with keyboard shortcuts.

02:18

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

02:12

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

03:34

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

05:01

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

1 page

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.

4 questions

Take the quiz to check your understanding. Good Luck!

Section 2: Editing in Excel
03:29

Learn how to add text and numbers to your spreadsheets.

03:17

See how to format Numbers in Excel.

04:38

Learn about selecting different parts of your spreadsheet.

04:41

See how to format text entries in Excel 2010.

05:11

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

03:43

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

2 pages

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

02:48

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

03:28

Learn how to insert columns and rows into your spreadsheet.

04:33

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

02:15

Learn about moving around your spreadsheet.

03:42

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

Saving your workbook
03:18
Printing in Excel
05:54
05:33

Learn about saving your work in different formats.

01:14

Send your spreadsheet as an attachment direct from within Excel.

1 page

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.

6 questions

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

Section 3: Automatic features
04:55

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.

03:16

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

06:47

Learn how to add up a column of numbers.

02:27

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

4 questions

Take the Quiz to cosolidate what you have learned.

Section 4: Creating Formulae
05:40

Build a formula from scratch.

07:09

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

05:50

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.

2 pages

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

5 questions

Take the Quiz to consolidate your leearning.

Section 5: Sort and Filter
03:31

Sort your data by a particluar column.

05:36

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

03:38

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.

4 questions

Take the Quiz to consolidate your learning.

Section 6: Format as a Table
06:11

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

02:18

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.

02:22

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.

Section 7: More Formatting Options
07:39

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

09:18

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.

Section 8: Analyse Data
07:07

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

1 page

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

06:27

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

05:15

Add formatting to your Pivot Table.

05:39

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

04:00

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

06:50

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

1 page

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

4 questions

Take the Quiz to consolidate your learning.

Section 9: Conditional Processing
03:29
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.

04:39

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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Shelley Fishel, 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 13 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.

Ready to start learning?
Take This Course