Microsoft Excel 2010 Course Beginners/ Intermediate Training

Learn to Invoke the Power of Microsoft Excel in easy to follow stages
747 reviews
TAUGHT BY
  • Infinite Skills High Quality Training

    InfiniteSkills is a Canadian based company that offers an ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples. The emphasis is on teaching real life skills that are essential in today's commercial environment. All InfiniteSkills courses are taught by experts who have a true passion for teaching.

WHAT'S INSIDE
  • Lifetime access to 127 lectures
  • 9+ hours of high quality content
  • Closed captioning enabled
  • A community of 62300+ students learning together!
  • 2400+ discussions
SHARE

Microsoft Excel 2010 Course Beginners/ Intermediate Training

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

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

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, InfiniteSkills 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.

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

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • SECTION 1:
    Getting Started
  • 1
    Working Files - Download These First
    Text
  • 2
    0101 Overview Of Excel 2010
    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

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

UDEMY BY THE NUMBERS

38,500,000
Hours of video content
8,500,000
Course Enrollments
3,500,000
Students

RATING

  • 503
  • 181
  • 32
  • 8
  • 23
AVERAGE RATING
NUMBER OF RATINGS
747

REVIEWS

  • 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!

  • Eric Wrye
    Needs Exercises/Homework - Otherwise great

    This is a great beginners course on Excel. Each lesson covers just a few basic principles and it's easy to go at your own pace. The one thing that is missing is that at the end of each section, there should be a downloadable Excercise/Homework sheet. I took a similar course that had an Excel Workbook you downloaded at the end of each major section and it had 4-5 assignments to do with the various sheets in the workbook that utilized the skills learned in that section. (The last sheet of the workbook contained "answers" that explained step by step what to do if you couldn't figure it out.) Just watching these lessons and following along is okay, but the real way you learn something is by doing it on your own. This class lacks that important element to really solidify the information.

  • Thomas Calloway
    This course is a fine place to start learning Excel 2010

    Comprehensive course, lots of XL basic/intermediate functions, charting and features, including Sky Drive file management. If you have trouble with a Liverpudlian accent, it may take some getting used to. All lessons are brief and feature closing recaps, so don't panic. Spread over 2-3 days, this course is doable and you can practice what you have learned on accompanying file set. Spreadsheets displayed are small on average laptop screen, so you have to keep clicking to increase to full screen size after each lesson ends....720p is not default HD display range (must reset for each session), which is a bit lame. This course could have used an update to feature SharePoint interfaces, but these lectures were produced in 2010. This course will get you rolling and ready for advanced Excel course, which is the point, of course.

  • C Flower
    Good course

    Course quickly and clearly covers a lot of features. It helped transition me from Excel 2003. Although I use Excel extensively, I still learned new functions and better ways to accomplish tasks.

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion