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 CompTIA Security+ Amazon AWS 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 Personal Transformation Mindfulness 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 Freelancing Online Business 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 2013 Advanced. Online Excel Training Course

Master Advanced Excel 2013 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training
Rating: 4.5 out of 54.5 (3,278 ratings)
43,431 students
Created by Infinite Skills
Last updated 1/2017
English
English
30-Day Money-Back Guarantee

What you'll learn

  • To take your basic Excel skills to the next level
  • To gain a solid understanding of the more powerful features and functions in Excel
  • To be able to use Microsoft Excel in a commercial environment

Requirements

  • Microsoft Excel 2013, Windows 8, 7, Vista or XP

Description

Learn the expert features and functions in Microsoft Excel 2013, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel 2013 suite

Whilst in this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we’ll quickly move onto more advanced-level topics including:

  • IF statements
  • VLOOKUP and HLOOKUP
  • Sparklines
  • Pivot Tables and Charts
  • Macro Operations

The Ability to Master Excel

By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer.

With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.

Content and Overview

Suitable for beginners with Microsoft Excel (as we’ll cover the basics early on) but also for those who wish to cover the advanced topics in Excel. Through the course of 128 lectures and 10+ hours of content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment.

Complete with working files and code samples, you’ll be able to follow along with the author throughout the lessons, and will receive a verifiable certificate of completion upon finishing the course.

Who this course is for:

  • Users with a basic knowledge of Excel
  • Users who have completed our Beginners / Intermediate Excel title

Course content

19 sections • 128 lectures • 9h 52m total length

  • Working Files - Download These First
    00:01
  • Preview03:57
  • 0102 Using The Included Files
    01:17
  • 0103 New For 2013: Its All In The Cloud
    04:03
  • Preview04:13

  • Preview03:39
  • 0202 AVERAGE, MODE, MEAN, And MEDIAN
    04:04
  • Preview06:30
  • 0204 COUNTIF For Selective Counting
    03:18
  • 0205 AVERAGEIF For The Mean Of Selected Cells
    03:29
  • 0206 Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
    07:06
  • 0207 Area And Volume Calculations
    04:09

  • 0301 IF Syntax And Uses
    07:55
  • Preview07:26
  • 0303 Use Of The AND Operator Within An IF
    06:29
  • 0304 Use Of The OR Operator Within An IF
    04:03
  • Preview04:28
  • 0306 Display Cell Formulas In Another Cell
    04:11

  • Preview04:51
  • 0402 VLOOKUP In Live Action
    06:53
  • 0403 HLOOKUP: Variation On A Theme
    04:42
  • 0404 Using A Near Match In The Lookup
    03:44
  • Preview04:55
  • 0406 Managing The Lookup Table
    05:03
  • 0407 Lookups Nested Within Lookups
    06:29

  • 0501 Creating A Sparkline
    04:58
  • 0502 Altering The Design Of Sparklines
    04:26
  • 0503 Dealing With Empty Cells
    02:24
  • 0504 Comparing Sparklines Within A Sparkline Group
    04:18
  • 0505 Removing Sparklines From A Worksheet
    02:14

  • 0601 Working With Time In Excel
    10:20
  • 0602 Calculations Using Time
    03:58
  • 0603 Useful Time And Date Functions
    04:45
  • 0604 Rounding Decimal Places
    04:32
  • 0605 MOD And INT Functions And Uses
    04:42
  • 0606 Generate And Use A Random Number
    05:36
  • 0607 Loan And Investment Calculations
    05:58
  • 0608 Loan Calculation Elements And Functions
    04:04

  • 0701 Create An Outline Automatically
    03:47
  • 0702 Adding An Outline Manually
    03:22
  • 0703 Editing And Removing Outlining
    06:39

  • 0801 Setting Up A Set Of Scenarios
    06:59
  • 0802 Displaying And Editing The Different Scenarios
    03:12
  • 0803 How To Work Out Which Scenario You Are Displaying
    04:06
  • 0804 Merging And Deleting Scenarios
    03:41
  • 0805 Producing A Summary Of Scenarios
    03:52

  • 0901 Custom Views Explained
    03:03
  • 0902 Use Of Outlining To Help Setup Custom Views
    03:56
  • 0903 Editing And Deleting Custom Views
    04:25
  • 0904 Add Quick Access To Custom Views
    03:30

  • 1001 LEFT And RIGHT: Text Manipulation
    04:28
  • 1002 LEN And TRIM: String Extractions
    06:34
  • 1003 FIND And MID: Text Functions Working Together
    06:53
  • 1004 CONCATENATE: Building Strings From Multiple Cells
    05:23
  • 1005 Changing Case Functions
    04:03
  • 1006 REPLACE And SUBSTITUTE: Two More String Manipulation Functions
    04:42
  • 1007 Use Of CHAR Function For More Obscure Characters
    06:12
  • 1008 Formatting Numeric And Date Values Using TEXT
    05:01
  • 1009 Keeping The Values Created By String Manipulation
    03:21

Instructor

Infinite Skills
High Quality Training
Infinite Skills
  • 4.3 Instructor Rating
  • 118,462 Reviews
  • 1,239,886 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.