Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Excel 2010 for Beginners

Name: Microsoft Excel 2010 for Beginners
Rating: 4.5 (24 reviews)

Master Excel basics in this easy to follow, step-by-step course.

Created bySONIC Performance Support - E-Learning Experts

Last updated 4/2015

English

What you'll 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!

Course content

8 sections • 77 lectures • 9h 28m total length

Intro Excel Beginner0:40

Introduction0:35
Join a Microsoft Excel 2010 training seminar led by Jennifer to explore new features and review familiar tools from earlier versions. Follow along through the series of training videos.
Open and Close Excel5:24
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.
The Excel Application Window6:03
In this video you'll learn how to use the Excel Application Window, and how it is configured.
Zoom In and Out4:31
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.
The Ribbon5:32
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.
The Quick Access Toolbar9:21
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.
Summary Section 11:35
Excel Templates8:12
Introduction to Help0:25
Discover how to use Excel 2010's built-in help to solve common problems and answer questions, guiding beginners to navigate formulas and features with confidence.
The Help Function8:59
The Help Function
Summary Help1:28
Access Excel help by clicking the question mark or using a key, then search topics via the search box or the table of contents.
Expand, Minimize and Move Windows5:11
In this video you'll learn how to zoom out of, or in to your documents, or move them.
Navigating the Worksheet6:02
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.
Select Elements of a Table11:59
"First mark it, then take action”. You're sure to have heard this remark before. Marking table elements.
The General Pane12:53
In this video you'll learn the main things about the General Pane.
The Save Pane13:33
In this video you'll learn how to save documents.
Best Practices Pane + auto recovery1:52
Explore the best practices pane and auto recovery in Excel 2010, start by changing one or two options to undo easily, and add author name for search and 97-2003 compatibility.
Input Numbers, Dates and Text into Cells6:16
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.
Save in a Different File Type10:08
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.
Create and Open Workbooks7:13
In this video you'll learn how to create and open workbooks.
Save and Close Workbooks9:05
In this video you'll learn how to save and close your workbooks.
Save Options12:29
In this video you'll learn how to set the save options in Excel 2010.
Summary Save Options2:10
Master Excel basics by navigating worksheets, using the name box to jump to cells, learning data types and alignment, and using save or save as, plus copying or moving sheets.

Performing Calculations in an Excel Worksheet - Overview0:19
Create Formulas in a Worksheet12:11
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.
The Sum Function17:12
One of the most-used Excel functions is the Sum function. In this video you'll learn how to use the Sum function.
The Average, Minimum and Maximum Function8:47
Excel offers a variety of different functions. In this video you'll learn how to use the functions average, minimum and Maximum.
The Count Function8:21
Differentiate between numbers and other content. In this video you'll learn how to use the Count function.
The Round Function10:07
In this video you'll learn how to use the Round function.
Change and Delete Cell Contents8:19
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.
Relative References8:46
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.
Absolute References13:16
Excel differentiates mainly between relative and absolute cell references. In this video you'll learn how to use absolute cell references in formulas.
Summary Section 23:43
Master Excel calculations by building formulas with cell references, understanding order of operations, and using the round function to ensure true values; copy formulas with relative and absolute references.

Introduction to Basic Table Editing0:32
Learn to input data and navigate a workbook, select columns, rows, or cells, save and print workbooks, and add, copy, and move worksheets in Excel.
The Undo and Redo Commands5:12
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.
Quick Access to Cells8:33
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.
Find and Replace Cells9:38
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.
Add and Delete New Worksheets6:10
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.
Column Width and Row Height10:58
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.
Insert and Delete Columns, Rows and Cells9:30
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.
Show and Hide Colums and Rows5:26
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.
Print Worksheets8:23
Save your results by printing out all important data. In this video you'll learn how to print your worksheets.
Switching between Worksheets9:45
In this video you'll learn how to switch between worksheets.
Copy, Move and Rename Worksheets9:44
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.
Switch between Open Windows3:50
Learn to navigate, not just within a worksheet, but between different worksheets. In this video you'll learn how to switch between open Windows.

Introduction to Basis Cell Formatting1:14
Font Size and Type4:02
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.
Bold, Italic and Underline5:10
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.
Format Painter5:12
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...
Cell Borders13:01
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 Color6:23
Alignment Options3:54
Left, right, or centered? In this video you'll learn how to align the cell Content.
Line Break4:48
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.
The Merge Feature5:45
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.
Decimals7:40
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.
Percent6:56
The percentage format demands particular attention. In this video you'll learn how to work with percentages.
Insert and Format Time and Date11:42
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.
Apply Cell Styles11:21
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.
Summary Section 42:30

The Function Wizard10:36
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 IF Function11:59
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 Nested IF Function11:37
In Excel you can nest several functions with one another. In this video you'll learn how to set up a Nested IF function.
VLOOKUP and HLOOKUP18:34
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.
Standard Error Message8:20
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.
Formula Auditing12:01
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.
Simple Time Calculation9:05
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.
Work with Date and Time Functions12:25
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.

Introduction to Printing0:27
Page Margins6:07
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 Breaks8:36
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.
Headers and Footers10:23
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.
Page Orientation8:44
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.
The Print Titles Command5:06
Repeat header rows and left columns on every printed page by using print titles in page setup, selecting rows to repeat at top and columns to repeat at left.
Scaling Options6:26
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.
Print Preview5:14
In this video you'll learn how to work with the print preview in Excel 2010.

Requirements

None

Description

COURSE DESCRIPTION

Excel is one of the most used office programs. However, users without training support usually only use 10% of the functionality of Excel. Excel allows you to organize, analyze, update, and present your data to make better decisions based on those analyses. This course will provide you with basic knowledge and skills that you can build upon with further training to eventually become an Excel expert.

Understand the concept of Excel and learn basic Excel skills. Discover what Excel is most useful for. In this fundamentals course, you will learn to create error-free spreadsheets and master initial calculations.

METHOD

Your trainers guide you through the various concepts and functions in an easy-to-understand, step-by-step manner. If necessary, you can pause videos or even rewind and watch them again. Beyond the training videos, there are plenty of helpful handouts, practice materials, and quizzes for you to make sure you get the most out of this training.

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.

THIS COURSE IS SUITABLE FOR YOU, IF

• you are an Excel beginner

• you wish to gain foundational understanding of Excel

• you need to create and work with electronic spreadsheets

PREREQUISITES

• To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and access websites using a web browser.

COURSE OBJECTIVES

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

You will:

• Perform calculations

• Modify worksheets

• Format worksheets

• Print workbooks

• Manage workbooks

Who this course is for:

Everyone who works with computers

Microsoft Excel 2010 for Beginners

What you'll learn

Explore related topics

Course content

Intro Excel Beginner1 lecture • 1min

Getting started with Excel 201023 lectures • 2hr 31min

Basic Table Editing10 lectures • 1hr 31min

Modifying a Worksheet12 lectures • 1hr 28min

Modifying the Appearance of a Worksheet14 lectures • 1hr 30min

More Functions8 lectures • 1hr 35min

Printing Excel Workbooks8 lectures • 51min

Outtakes1 lecture • 3min

Requirements

Description

Who this course is for: