Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
Intro Excel BeginnerPreview
|Section 1: Getting started with Excel 2010|
|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.|
|In this video you'll learn how to use the Excel Application Window, and how it is configured.|
|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.|
|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.|
|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 1
Introduction to Help
|The Help Function|
|In this video you'll learn how to zoom out of, or in to your documents, or move them.|
|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.|
"First mark it, then take action”. You're sure to have heard this remark before. Marking table elements.
|In this video you'll learn the main things about the General Pane.|
|In this video you'll learn how to save documents.|
Best Practices Pane + auto recovery
|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.|
|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.|
|In this video you'll learn how to create and open workbooks.|
|In this video you'll learn how to save and close your workbooks.|
|In this video you'll learn how to set the save options in Excel 2010.|
Summary Save Options
|Section 2: Basic Table Editing|
Performing Calculations in an Excel Worksheet - OverviewPreview
|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.|
|One of the most-used Excel functions is the Sum function. In this video you'll learn how to use the Sum function.|
|Excel offers a variety of different functions. In this video you'll learn how to use the functions average, minimum and Maximum.|
|Differentiate between numbers and other content. In this video you'll learn how to use the Count function.|
|In this video you'll learn how to use the Round function.|
|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.|
|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.|
|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 2
|Section 3: Modifying a Worksheet|
Introduction to Basic Table EditingPreview
|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.|
|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.|
|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.|
|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.|
|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.
|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.
|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
|Save your results by printing out all important data. In this video you'll learn how to print your worksheets.|
|In this video you'll learn how to switch between worksheets.|
|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.|
|Learn to navigate, not just within a worksheet, but between different worksheets. In this video you'll learn how to switch between open Windows.|
|Section 4: Modifying the Appearance of a Worksheet|
Introduction to Basis Cell FormattingPreview
|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.|
|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.|
|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
|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.|
|Left, right, or centered? In this video you'll learn how to align the cell Content.|
|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.|
|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 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.
|The percentage format demands particular attention. In this video you'll learn how to work with percentages.|
|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.|
|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 4
|Section 5: More Functions|
|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.|
|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.|
|In Excel you can nest several functions with one another. In this video you'll learn how to set up a Nested IF function.|
|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.|
|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.|
|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.|
|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.|
|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.|
|Section 6: Printing Excel Workbooks|
Introduction to PrintingPreview
|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.|
|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.|
|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.|
|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 Command
|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.|
|In this video you'll learn how to work with the print preview in Excel 2010.|
|Section 7: Outtakes|
|Meet your fun, serious, professional, and did I say "FUN" Microsoft Office 2010 trainer. She's an expert and a blast!|
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.