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 AWS Certified Developer - Associate CompTIA Security+
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native 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 Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup 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: Advanced Training

Master Advanced Excel 2010 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training
Rating: 4.4 out of 54.4 (2,390 ratings)
75,435 students
Created by Infinite Skills
Last updated 1/2017
English
English
30-Day Money-Back Guarantee

What you'll learn

  • Learn Advanced Microsoft Excel 2010 from a professional trainer from your own desk.
  • 136 lectures (8.5 hours of content) teaching you lookups, advanced IF statements, Macros, Sparklines, and much more!
  • Suitable advanced Excel 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 Excel course.

This Excel 2010 advanced training course, follows up from the Beginners Excel 2010 course by delving even deeper into the features and functions of this powerful spreadsheet software.

Microsoft Excel 2010 is much more than a quick way to add up numbers. In this online course, you will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF and more. You will learn about performing lookups with HLOOKUP and VLOOKUP. This tutorial also covers Sparklines, and goes in-depth with Pivot Tables and Charts. Finally, you will learn how to create and record your own Macros.

This advanced Excel video course is not for beginners. You should have a firm grasp of the basics before taking this Advanced Excel training course. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the same Excel files the author trains you with.

Course content

17 sections • 135 lectures • 8h 18m total length

  • Working Files - Download These First
    00:01
  • Preview04:57
  • Preview01:41
  • Preview03:36

  • Preview06:02
  • Preview06:45
  • Preview04:09
  • Preview03:17
  • Preview02:47
  • Preview05:04
  • Preview03:52
  • Preview02:34
  • Preview07:17

  • Preview03:43
  • Preview10:03
  • Preview03:01
  • Preview06:37
  • Preview04:51
  • Preview05:45
  • Preview04:14
  • Preview04:28

  • The MATCH Function Explained
    08:14
  • The INDEX Function Syntax
    05:06
  • How To Stop Nonexistent Row Or Column Lookups In INDEX
    02:41
  • The CHOOSE Lookup Function
    02:37

  • Working With TIME
    05:55
  • Rounding To Fractional Values
    03:35
  • MOD For Working Out Remainders
    02:18
  • Generating A Random Number
    02:33
  • Pick A List Item At Random
    03:05
  • Calculating Loan Repayments Using PMT
    02:55
  • Excel - Investment Calculations Using PMT
    02:59
  • Working Out Depreciation
    04:21
  • Working Out Different Parts Of A Loan Calculation
    04:58

  • What Is An Array And An Array Formula
    03:00
  • Creating And Using An Array Formula
    03:29
  • Conditional Evaluation In An Array Formula
    03:42
  • The Very Clever TRANSPOSE Array Function
    03:32

  • LEN And TRIM Two Very Useful Text Functions
    02:44
  • Using LEFT And RIGHT For String Extraction
    03:36
  • FIND And MID Working Together To Extract Parts Of Strings
    04:15
  • Build Strings From Multiple Cells
    03:58
  • Excel - Changing The Case Of Text In Cells
    02:56
  • REPLACE And SUBSTITUTE In Action
    05:12
  • Formatting Numeric Values With A Text String Using TEXT
    05:09
  • Extracting The Values From The Text Functions We Have Used
    03:00

  • Welcome To IS Functions
    02:45
  • Error Checking With ISERR ISERROR ISNA And IFERROR
    08:06
  • The OFFSET Formula Explained
    03:17
  • Dynamic Named Ranges Using The OFFSET Function
    05:48
  • Use The INDIRECT Function To Build Dynamic Formulas
    05:59
  • Dealing With INDIRECT Errors
    01:46
  • Use Formulas To Determine An Excel Filename And Or Sheet Name
    05:43

  • Creating A Sparkline In Excel
    03:06
  • Change The Design Of Sparklines
    03:38
  • Dealing with Empty Cells
    01:57
  • Comparing One Sparkline To Another by Altering Vertical Scale
    02:57
  • Removing Sparklines From A Sheet
    01:35

  • Outlining Explained
    02:35
  • Creating An Outline Automatically
    02:34
  • Creating An Outline Manually
    02:58
  • Manually Removing Data From An Outline
    03:25
  • Removing The Outlining From A Worksheet
    00:55
  • Adjusting A Grouping Created By Automatic Outlining
    03:54

Instructor

Infinite Skills
High Quality Training
Infinite Skills
  • 4.3 Instructor Rating
  • 117,431 Reviews
  • 1,232,076 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.