Microsoft Excel 2010 Course Beginners/ Intermediate Training
4.3 (1,581 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
68,032 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2010 Course Beginners/ Intermediate Training to your Wishlist.

Add to Wishlist

Microsoft Excel 2010 Course Beginners/ Intermediate Training

Learn to Invoke the Power of Microsoft Excel in easy to follow stages
4.3 (1,581 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
68,032 students enrolled
Last updated 1/2017
English
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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.
View Curriculum
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.

Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 126 Lectures Collapse All 126 Lectures 09:16:27
+
Getting Started
8 Lectures 24:55
Working Files - Download These First
00:01

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

Preview 06:16






0107 Using The Files Included With This Course
00:33
+
Working With An Excel Worksheet
5 Lectures 14:07


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





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

+
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
6 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
36,099 Reviews
677,491 Students
331 Courses
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.