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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee

Forever yours.
Lifetime access

Learn on the go.
Desktop, iOS and Android

Get rewarded.
Certificate of completion

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

Infinite Skills , High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Join the biggest student community

7,000,000

Hours of video content

26,000,000

Course Enrollments

7,100,000

Students

Reviews

Average Rating
4.5
Details
  1. 5 Stars
    529
  2. 4 Stars
    186
  3. 3 Stars
    34
  4. 2 Stars
    8
  5. 1 Stars
    23
    • Robert S. Savesky

    Very Good Course

    I have used Excel for years but I needed to lean about the many newer capabilities. I found this course very helpful and interesting. The instructor provides a good summary at the end of each lesson. I would recommend the course.

    • Nick Poulter-Jones

    Really good course

    This is a very clear and useful introduction to Microsoft excel. I will definitely be trying out the advanced course as well.

    • Andrew Millward

    Great Course!

    • Ulrike Schreiner

    excellent teaching

    easy to follow, divided by task, makes it easy to review/look up specific tasks

    • Kevork Zenopyan

    Very Nice

    Very Nice!

Show more reviews
Ready to start learning?
Preview this course