Microsoft Excel 2010 Course Beginners/ Intermediate Training

Name: Microsoft Excel 2010 Course Beginners/ Intermediate Training
Rating: 4.5 (2387 reviews)

Learn to Invoke the Power of Microsoft Excel in easy to follow stages

Created byInfinite Skills

Last updated 1/2017

English

What you'll learn

Learn Microsoft Excel 2010 from a professional trainer from your own desk.
126 lectures (9.5 hours of content) teaching you from the basic to the advanced of this powerful program
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Visual training method, offering users increased retention and accelerated learning.
Breaks even the most complex applications down into simplistic steps.

Course content

16 sections • 126 lectures • 9h 16m total length

Working Files - Download These First0:01
0101 Overview Of Excel 20106:16
This Excel 2010 Training Course is just one of many courses that are created by InfinteSkills. More titles are visible on the InfiniteSkills Website. Click for More Information
0102 The New File Menu In Excel 20105:09
0103 Exploring The Excel Workbook2:25
0104 What Will I Be Able To Do At The End Of This Course3:53
0105 Customizing The Quick Access Toolbar2:52
0106 Working With The Ribbons3:46
0107 Using The Files Included With This Course0:33

0301 Entering Text And Numbers3:00
0302 Entering Numbers As Text3:47
0303 Inputting Dates And Times4:03
0304 Editing The Contents Of A Cell2:08
0305 Using Copy And Paste6:47
Learn to copy and paste in Excel 2010, using the clipboard and multi clipboard, drag and drop, and shortcuts like Ctrl+C and Ctrl+V with orientation preserved.
0306 The FILL Handle7:05
0307 Using Undo And Redo3:03
0308 Shortcuts For Selecting Cells5:12
0309 Inserting Cells , Columns And Rows5:17
0310 Deleting Cells , Columns And Rows3:21
0311 Changing Column Widths And Row Heights4:06
0312 Hiding And Unhiding A Column Or Row5:09
0313 Searching For Values In A Worksheet 5:34

0401 Formatting And Naming Of Worksheet Tabs3:41
0402 Moving Worksheets Within And Between Workbooks4:49
0403 Copying Worksheets Within Workbooks3:17
Copy sheets within a workbook by dragging with the control key or by right-clicking and choosing create a copy, preserving column widths and formatting for safe duplication.
0404 Inserting And Deleting Worksheets3:33
0405 Viewing More Than One Workbook4:34
0406 Hiding And Unhiding Worksheets2:02

0501 Using The Print Area Command To Control What Excel Prints4:03
0502 Setting Page Margins And Page Orientation3:29
0503 Creating A Header And Footer4:48
0504 Using Page Break View2:55
0505 Setting Print Titles For Large Worksheets3:01
0506 Printing Gridlines Column Row Headings And Other Related Options2:48
0507 Enabling The New Page Layout View3:30
0508 Running The Spell Checker3:23
0509 Print Preview And Printing The Whole Or Part Of The Worksheet4:03

0601 Modifying Typeface , Font Size And Colors6:12
Master font formatting in Excel by changing typeface, font size, and color for selected cells. Apply bold, italic, underline, strike-through, and optional superscript or subscript to emphasize data.
0602 Merging Cells2:45
0603 Applying Number Formats4:04
0604 Aligning Cell Contents2:02
0605 Changing The Text Direction In A Cell3:38
0606 Adding Borders To Cells And Ranges4:43
0607 Applying A Date Format To A Cell Or Range5:15
0608 Use Of The Format Painter4:29
0609 Clearing Cell Contents And : Or Formatting2:50

0701 Getting Started With Basic Math Formula Addition5:23
0702 Getting Started With Basic Math Formula Subtraction3:20
0703 Getting Started With Basic Math Formula Multiplication2:45
0704 Getting Started With Basic Math Formula Division4:22
0705 Getting Started With Basic Math Formula Operand2:36
0706 Order Of Operations With BODMAS3:14
Discover how Excel uses the BODMAS order of operations, prioritizing brackets, then division and multiplication, then addition and subtraction, to evaluate formulas like A1 + A2 times A3.
0707 Introduction To Excel Formulas SUM7:46
0708 Copying Formulas And Functions6:55
0709 Displaying Formulae On A Worksheet2:59
0710 Some Useful Functions For Counting4:06
0711 Some Useful Functions For Averages4:02
0712 Some Useful Functions For Highest And Lowest3:15
0713 Absolute Referencing Requirements5:37
0714 Formulas Across Worksheets7:46
0715 Functions Across Worksheets4:44
0716 3D Referencing6:58
0717 Making Use Of Named Cells And Ranges9:24

Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

In this Microsoft Excel 2010 video course, O'Reilly Media introduces you to the latest version of Microsoft's standard spreadsheet application.

In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel 2010 starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. A chapter on how to connect to Microsoft Web Apps is also covered. The course also shows how to use your own SkyDrive to store and share your Microsoft Excel Projects. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel 2010.

By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment.

Microsoft Excel 2010 Course Beginners/ Intermediate Training

What you'll learn

Explore related topics

Course content

Getting Started8 lectures • 25min

Working With An Excel Worksheet5 lectures • 14min

Selecting and Entering Data13 lectures • 59min

Developing A Workbook6 lectures • 22min

Printing and Page Setup9 lectures • 32min

Workbook Formatting9 lectures • 36min

Carrying Out Calculations17 lectures • 1hr 25min

Advanced Formatting4 lectures • 19min

Security4 lectures • 17min

Using Templates2 lectures • 10min

Description