Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

Microsoft Excel 2010 Course Beginners/ Intermediate Training

Learn to Invoke the Power of Microsoft Excel in easy to follow stages
Rating: 4.3 out of 54.3 (2,312 ratings)
69,212 students
Created by Infinite Skills
Last updated 1/2017
English
English
30-Day Money-Back Guarantee

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

16 sections • 126 lectures • 9h 16m total length

  • Working Files - Download These First
    00:01
  • Preview06:16
  • Preview05:09
  • Preview02:25
  • Preview03:53
  • Preview02:52
  • Preview03:46
  • 0107 Using The Files Included With This Course
    00:33

  • Preview01:36
  • Preview02:25
  • 0203 Saving In Other Formats
    03:04
  • 0204 Open A Existing Workbook
    01:45
  • 0205 Navigating An Excel Workbook
    05:17

  • Preview03:00
  • Preview03:47
  • Preview04:03
  • Preview02:08
  • Preview06: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
  • Preview05:34

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 1001 Creating A Workbook From A Template
    03:35
  • 1002 Creating Your Own Custom Template
    06:16

Instructor

Infinite Skills
High Quality Training
Infinite Skills
  • 4.3 Instructor Rating
  • 118,298 Reviews
  • 1,238,566 Students
  • 327 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.