Microsoft Excel 2010 Course Beginners/ Intermediate Training

Learn to Invoke the Power of Microsoft Excel in easy to follow stages
  • Lectures 127
  • Video 10 Hours
  • Skill level all level
  • Languages English , captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

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.

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

What am I going to get from this course?

  • Over 127 lectures and 9.5 hours of content!
  • 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.

Curriculum

Section 1: Getting Started
Working Files - Download These First
Text
06: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

Text
Instructions on how to obtain your Certificate of Completion for this Infinite Skills course. All Users of this course are eligible for a Certificate of Completion. Each certificate is issued with a unique number which allows verification that the user has undertaken the course listed. In order to o…
0102 The New File Menu In Excel 2010
Preview
05:09
0103 Exploring The Excel Workbook
Preview
02:25
0104 What Will I Be Able To Do At The End Of This Course
Preview
03:53
0105 Customizing The Quick Access Toolbar
Preview
02:52
0106 Working With The Ribbons
Preview
03:46
0107 Using The Files Included With This Course
00:33
Section 2: Working With An Excel Worksheet
0201 Creating A New Workbook
Preview
01:36
0202 Saving A Workbook
Preview
02:25
0203 Saving In Other Formats
03:04
0204 Open A Existing Workbook
01:45
0205 Navigating An Excel Workbook
05:17
Section 3: Selecting and Entering Data
0301 Entering Text And Numbers
Preview
03:00
0302 Entering Numbers As Text
Preview
03:47
0303 Inputting Dates And Times
Preview
04:03
0304 Editing The Contents Of A Cell
Preview
02:08
0305 Using Copy And Paste
Preview
06:47
0306 The FILL Handle
07:05
0307 Using Undo And Redo
03:03
0308 Shortcuts For Selecting Cells
05:12
0309 Inserting Cells , Columns And Rows
05:17
0310 Deleting Cells , Columns And Rows
03:21
0311 Changing Column Widths And Row Heights
04:06
0312 Hiding And Unhiding A Column Or Row
05:09
0313 Searching For Values In A Worksheet
Preview
05:34
Section 4: Developing A Workbook
0401 Formatting And Naming Of Worksheet Tabs
03:41
0402 Moving Worksheets Within And Between Workbooks
04:49
0403 Copying Worksheets Within Workbooks
03:17
0404 Inserting And Deleting Worksheets
03:33
0405 Viewing More Than One Workbook
04:34
0406 Hiding And Unhiding Worksheets
02:02
Section 5: Printing and Page Setup
0501 Using The Print Area Command To Control What Excel Prints
04:03
0502 Setting Page Margins And Page Orientation
03:29
0503 Creating A Header And Footer
04:48
0504 Using Page Break View
02:55
0505 Setting Print Titles For Large Worksheets
03:01
0506 Printing Gridlines Column Row Headings And Other Related Options
02:48
0507 Enabling The New Page Layout View
03:30
0508 Running The Spell Checker
03:23
0509 Print Preview And Printing The Whole Or Part Of The Worksheet
04:03
Section 6: Workbook Formatting
0601 Modifying Typeface , Font Size And Colors
06:12
0602 Merging Cells
02:45
0603 Applying Number Formats
04:04
0604 Aligning Cell Contents
02:02
0605 Changing The Text Direction In A Cell
03:38
0606 Adding Borders To Cells And Ranges
04:43
0607 Applying A Date Format To A Cell Or Range
05:15
0608 Use Of The Format Painter
04:29
0609 Clearing Cell Contents And : Or Formatting
02:50
Section 7: Carrying Out Calculations
0701 Getting Started With Basic Math Formula Addition
05:23
0702 Getting Started With Basic Math Formula Subtraction
03:20
0703 Getting Started With Basic Math Formula Multiplication
02:45
0704 Getting Started With Basic Math Formula Division
04:22
0705 Getting Started With Basic Math Formula Operand
02:36
0706 Order Of Operations With BODMAS
03:14
0707 Introduction To Excel Formulas SUM
07:46
0708 Copying Formulas And Functions
06:55
0709 Displaying Formulae On A Worksheet
02:59
0710 Some Useful Functions For Counting
04:06
0711 Some Useful Functions For Averages
04:02
0712 Some Useful Functions For Highest And Lowest
03:15
0713 Absolute Referencing Requirements
05:37
0714 Formulas Across Worksheets
07:46
0715 Functions Across Worksheets
04:44
0716 3D Referencing
06:58
0717 Making Use Of Named Cells And Ranges
09:24
Section 8: Advanced Formatting
0801 Enhancing Worksheets Using Themes
02:40
0802 Working With Comments
04:45
0803 Creating Your Own Auto Fill List
05:45
0804 Turning Your Data Into A Table For Formatting
05:32
Section 9: Security
0901 Using Protection On A Worksheet
03:35
0902 Protecting Part Of A Worksheet To Facilitate Data Entry
03:59
0903 Controlling Access To Cell Ranges By Password And Or User Accounts
05:17
0904 Saving A Workbook With Password Protection
03:46
Section 10: Using Templates
1001 Creating A Workbook From A Template
03:35
1002 Creating Your Own Custom Template
06:16
Section 11: Graphics Objects
1101 Inserting And Modifying Clipart
07:37
1102 Using Smart Art Graphics
08:11
1103 Adding Drawn Shapes To A Worksheet
04:48
1104 Inserting An External Picture
03:01
1105 Adding A Background Image To A Worksheet
02:57
1106 Formatting Graphic Objects
05:02
1107 Controlling Stacking Order And Alignment Of Multiple Graphics Objects
06:15
1108 Grouping Graphic Objects
03:29
1109 Accessing Formula Results In A Callout Bubble
05:10
Section 12: Using Excel As A Database
1201 Fixing Rows And Columns On Screen
02:51
1202 Fixing Rows And Columns For Print
01:58
1203 Sorting Data In A Worksheet
06:09
1204 Filtering Data In A Worksheet
07:29
1205 Removing Duplicates In An Excel Database
02:36
1206 Adding And Using Subtotals In An Excel Database
07:58
1207 Splitting One Column Of Data Into More Columns
06:38
1208 Splitting The Screen To View Different Parts Of The Same Worksheet
04:28
1209 Linking To Data On A Webpage
08:24
Section 13: Using Charts in Excel
1301 Creating A Chart The Long Way
05:00
1302 Creating A Chart The Quick Way
02:28
1303 Changing A Chart From A Sheet Object To A Sheet
02:57
1304 Modifying Your Chart Type
06:30

Instructor Biography

O'Reilly Media , High Quality Training

O'Reilly spreads the knowledge of innovators through its technology books, online services, magazines, research, and tech conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, O'Reilly has a long history of advocacy, meme-making, and evangelism.

Reviews

Average Rating
4.5
Details
  1. 5 Stars
    506
  2. 4 Stars
    182
  3. 3 Stars
    32
  4. 2 Stars
    8
  5. 1 Stars
    23
    • Chrissy Boyce

    LOVE THE FORMAT

    This is course is great. You can take notes and it will record the not time so you can go back to the lecture at the exact time to review if needed. I also love that it is broken up into small portions so I can re-visit if needed and work it small bits at a time. The instructor is very good. I never find myself with questions. I do wish there was a way to download all of your notes at once at the end of the course so you dont have to do it after each lecture. That would make this course perfect.

    • Alice Wu

    Awesome class

    This course is straightforward, concise, simple. I like the attachments which are really helpful too. This class has solidated my skills in Excel. Thanks!

    • Varun Gupta

    Useful Course

    The course is really useful and provides good understanding for New Excel Users like me.

    • Thierry

    Great course

    I recommend this course, i use excell a lot but thanks to Guy i've learned a lot of useful tips. You can view the entire course in 2-3 days.

    • Carie Turner

    Clear and complete

    I have been very impressed by this course. The material is well organized and thorough. The instructor speaks clearly and is knowledgeable. He does a quick review of the newly covered concepts at the end of each tutorial. He has a subtle yet witty sense of humour that I certainly appreciate. Kudos to anyone who can make Excel interesting!

Show more reviews

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

5,900,000

Hours of video content

22,000,000

Course enrollment

6,500,000

Students

Ready to start learning?
Preview this course