Office Productivity
Microsoft
Excel
Microsoft Excel 2010 Course Beginners/ Intermediate Training
4.6 (2,249 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
69,149 students enrolled

Microsoft Excel 2010 Course Beginners/ Intermediate Training

Learn to Invoke the Power of Microsoft Excel in easy to follow stages
4.6 (2,249 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
69,149 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
English
Preview this course
Microsoft Excel 2010 Course Beginners/ Intermediate Training
Current price: $31.99 Original price: $49.99 Discount: 36% off
13 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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.
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.

Course content
Expand all 126 lectures 09:16:15
+ – Working With An Excel Worksheet
5 lectures 14:07
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
+ – Selecting and Entering Data
13 lectures 58:32
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
+ – Developing A Workbook
6 lectures 21:56
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
+ – Printing and Page Setup
9 lectures 32:00
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
+ – Workbook Formatting
9 lectures 35:58
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
+ – Carrying Out Calculations
17 lectures 01:25:12
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
+ – Advanced Formatting
4 lectures 18:42
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
+ – Security
4 lectures 16:37
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
+ – Using Templates
2 lectures 09:51
1001 Creating A Workbook From A Template
03:35
1002 Creating Your Own Custom Template
06:16