Microsoft Excel 2010 for Beginners
4.5 (8 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.
47 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Microsoft Excel 2010 for Beginners

Master Excel basics in this easy to follow, step-by-step course.
4.5 (8 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.
47 students enrolled
Last updated 7/2013
English
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Jennifer will teach you Excel 2010 in her step-by-step, fun, serious and professional style. She's an expert and easy to learn from.
  • Training with a human touch right at your desktop!
View Curriculum
Requirements
  • None
Description

In this Microsoft Excel 2010 Training course, you will learn by watching the instructor actually conduct the exercises as she explains step-by-step how to perform these functions. The training starts with the absolute basics of creating your very first worksheet and slowly progresses through learning numerous capabilities of this very powerful program.  The topics range from creating very basic formulas to more advanced functions like table editing, the help function and more. 

As part of this course, you can also download the exercise files that allow you to work alongside the author as she teaches you how to master Microsoft Excel 2010.

Our Microsoft courses help you to prepare for the official Microsoft Office Specialist exam.


Who is the target audience?
  • Everyone who works with computers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 77 Lectures Collapse All 77 Lectures 09:28:59
+
Intro Excel Beginner
1 Lecture 00:40
+
Getting started with Excel 2010
23 Lectures 02:30:56

A correct program start is just as important as the correct exit. In this video you'll learn how to open and close Excel 2010.
Open and Close Excel
05:24

In this video you'll learn how to use the Excel Application Window, and how it is configured.
The Excel Application Window
06:03

The optimum display size of your worksheet is of special importance when working with Excel. In this video you'll learn how to use the zoom in Excel.
Zoom In and Out
04:31

For optimum navigation within a program, you have to know where exactly the commands are stored. In this video you'll learn about the ribbon in Excel 2010.
Preview 05:32

Simply place the most important commands straight onto the Quick Access Toolbar, and save yourself a lot of searching for them. In this video you'll learn how to use the Quick Access Toolbar when working with Excel.
The Quick Access Toolbar
09:21

Summary Section 1
01:35

Excel Templates
08:12

Introduction to Help
00:25

The Help Function
The Help Function
08:59

Summary Help
01:28

In this video you'll learn how to zoom out of, or in to your documents, or move them.
Expand, Minimize and Move Windows
05:11

Excel 2010 has well over 16,000 columns and more than 1,000,000 lines. Safely navigating an Excel worksheet is the key factor of navigation basics. In this video you'll learn how to move around an Excel worksheet.
Navigating the Worksheet
06:02

"First mark it, then take action”. You're sure to have heard this remark before. Marking table elements.
Select Elements of a Table
11:59

In this video you'll learn the main things about the General Pane.
The General Pane
12:53

In this video you'll learn how to save documents.
The Save Pane
13:33

Best Practices Pane + auto recovery
01:52

You have to learn how to enter data correctly in Excel. In this video you'll learn how to enter a number, date and text in an Excel worksheet.
Input Numbers, Dates and Text into Cells
06:16

Excel 2010 offers you a variety of file types you can use for saving your Excel workbooks. In this video you'll learn how to save your Excel workbooks as a different file type.
Save in a Different File Type
10:08

In this video you'll learn how to create and open workbooks.
Create and Open Workbooks
07:13

In this video you'll learn how to save and close your workbooks.
Save and Close Workbooks
09:05

In this video you'll learn how to set the save options in Excel 2010.
Save Options
12:29

Summary Save Options
02:10
+
Basic Table Editing
10 Lectures 01:31:01

Excel is a calculation tool. The correct entry of a formula is especially important for later calculations. In this video you'll learn about the configuration and entry of formulas.
Preview 12:11

One of the most-used Excel functions is the Sum function. In this video you'll learn how to use the Sum function.
Preview 17:12

Excel offers a variety of different functions. In this video you'll learn how to use the functions average, minimum and Maximum.
The Average, Minimum and Maximum Function
08:47

Differentiate between numbers and other content. In this video you'll learn how to use the Count function.
The Count Function
08:21

In this video you'll learn how to use the Round function.
The Round Function
10:07

Especially in the case of existing data, it is important  to be able to change and customize it. In this video you'll learn how to changing and delete cell Content.
Change and Delete Cell Contents
08:19

Every calculation is based on cell references. Excel differentiates mainly between relative and absolute cell references. In this video you'll learn how to use the relative cell references in formulas.
Relative References
08:46

Excel differentiates mainly between relative and absolute cell references. In this video you'll learn how to use absolute cell references in formulas.
Absolute References
13:16

Summary Section 2
03:43
+
Modifying a Worksheet
12 Lectures 01:27:41

In this video you'll learn how to undo your worksteps in Excel. This is especially important if you have made a mistake and want to track the wrong step.
The Undo and Redo Commands
05:12

With the help of the arrow keys in Excel, you can move really quickly from cell to cell. You can also use the mouse to target and select one of the visible cells, for example. But what do you do, though, if the cell you want to get to is really way down or over to the right in a column or row you can't see, e.g. cell “ADE7000”? In this case the so-called name box can help you to move to a target in the worksheet.
Quick Access to Cells
08:33

With large Excel lists it is often difficult to find the required content straightaway. In this video you'll learn how to find cells, and replace them if required.
Find and Replace Cells
09:38

If required, you can add new worksheets in an Excel workbook, or remove sheets no longer needed. In this video you'll learn how to add and/or delete new worksheets.
Add and Delete New Worksheets
06:10

If the content does not fit the prescribed column width or row height,
you can adjust these quite easily. In this video you'll learn how to
change the column width and row height.
Column Width and Row Height
10:58

If you find, when working with Excel, that a column or row is missing or
superfluous, you can insert or remove them. In this video you'll learn
how to insert or delete columns, rows and cells.
Insert and Delete Columns, Rows and Cells
09:30

Frequently, more information is displayed in an Excel worksheet than
actually needed for working with the respective table. In this video,
you'll learn how to show and hide columns and/or rows in an Excel
worksheet.
Show and Hide Colums and Rows
05:26

Save your results by printing out all important data. In this video you'll learn how to print your worksheets.
Print Worksheets
08:23

In this video you'll learn how to switch between worksheets.
Switching between Worksheets
09:45

You can not only copy individual cells or cell content. In Excel you can copy, move and re-use whole worksheets and their content.In this video you'll learn how to copy, move and rename worksheets.
Copy, Move and Rename Worksheets
09:44

Learn to navigate, not just within a worksheet, but between different worksheets. In this video you'll learn how to switch between open Windows.
Switch between Open Windows
03:50
+
Modifying the Appearance of a Worksheet
14 Lectures 01:29:38

A well-formatted table with amatching font size and type expresses a lot about the way you work. In this video you'll learn how to change the font size and type.
Font Size and Type
04:02

Use further formats, such as bold, italic, or undeline, for example. In this video you'll learn how to format the cell content in an especially interesting way.
Bold, Italic and Underline
05:10

You've formatted a cell or cell content, and have forgotten how exactly
you did it, or you know, but it would take a long time because several
formatting steps are necessary. Make use of the possibility of
transferring...
Format Painter
05:12

Emphasize your data by using the cell borders to format the most important cells. In this video you'll learn how to create cell borders.
Cell Borders
13:01


Left, right, or centered? In this video you'll learn how to align the cell Content.
Alignment Options
03:54

If the content doesn't fit into the prescribed column width, it makes sense to write the content on more than one line. In this video you'll learn how to insert a line break.
Line Break
04:48

If you have a main heading covering several columns, it makes sense sometimes to link the cells above. In this video you'll learn how to merge cells.
The Merge Feature
05:45

The number of decimal places determines how precisely you calculate, and
how exact the displayed value will be. In this video you'll learn how
to specify the number of decimal places for a number.
Decimals
07:40

The percentage format demands particular attention. In this video you'll learn how to work with percentages.
Percent
06:56

Date and time is purely a special format that transforms a number into a date and/or a time. In this video you'll learn how to insert and format date and time Information.
Insert and Format Time and Date
11:42

Cell styles can be used as quick styles for quick processing and formatting of the content, and always ensure a uniform layout and appearance of the content. In this video you'll learn how to define the cell styles.
Apply Cell Styles
11:21

Summary Section 4
02:30
+
More Functions
8 Lectures 01:34:37
There are over 300 functions in Excel that you can use for calculating your results. In this video you'll learn how to work with the function wizard.
The Function Wizard
10:36

If your calculating steps depend on certain conditions, you can use the IF function to define these conditions and check whether they are met or not. In this video you'll learn how to use the IF function.
The IF Function
11:59

In Excel you can nest several functions with one another. In this video you'll learn how to  set up a Nested IF function.
The Nested IF Function
11:37

Use the LOOKUP function, for example, to compare two tables with each other. In this video you'll learn how to use the two functions VLOOKUP and HLOOKUP.
VLOOKUP and HLOOKUP
18:34

If a formula is wrong, Excel will display an error message. But what do these error messages mean? In this video you'll learn about the Standard Error Messages in Excel 2010.
Standard Error Message
08:20

Lots of formulars are very complex and refer to several other cells that can be spread across many different worksheets. In this video you'll learn how to use the formula auditing.
Formula Auditing
12:01

Because times in Excel are simply numbers formulated as dates, you can calculate with them without any problems. In this video you'll learn how to carry out simple time calculations.
Simple Time Calculation
09:05

Use the numerous date and time functions in Excel 2010 to work with dates and times. In this video you'll learn how to work with date and time functions.
Work with Date and Time Functions
12:25
+
Printing Excel Workbooks
8 Lectures 51:03

Portrait format, landscape format or customized margins. Select the correct setting for your Excel worksheets. In this video you'll learn how to set the margins.
Page Margins
06:07

The page break preview helps you to recognize in good time whether the content will fit a page or not, and whether the break is in the right place. In this video you'll learn how to work with the page break in Excel.
Page Breaks
08:36

The header can contain very important information, such as the title of the table or the creation date. In this video you'll learn how to work with headers and footers.
Headers and Footers
10:23

Set your pages up and specify what is to be printed, and when. In this video you'll learn how to set up a page.
Page Orientation
08:44

The Print Titles Command
05:06

Zoom settings and file size and/or sheet size are very important when working with Excel 2010. In this video you'll learn how to scale the documents in Excel 2010.
Scaling Options
06:26

In this video you'll learn how to work with the print preview in Excel 2010.
Print Preview
05:14
+
Outtakes
1 Lecture 03:23
Meet your fun, serious, professional, and did I say "FUN" Microsoft Office 2010 trainer. She's an expert and a blast!
Preview 03:23
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.1 Average rating
273 Reviews
4,879 Students
45 Courses

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.