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 Analytics

Learn Advanced Excel: Take the Next Step w/ Microsoft Excel

"Do you know any good Excel jokes? I know SUM." Learn advanced Excel w/a touch of humor, from an experienced instructor.
Rating: 4.7 out of 54.7 (160 ratings)
26,859 students
Created by Steve McDonald, Paul Ray
Last updated 8/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn advanced Charts, Formulas, Shortcuts, Pivot Tables and Visualizations.
  • Build on your existing beginner to intermediate Excel skills.
  • This course uses fun examples, humor, and an experienced instructor to make learning advanced Excel easy and interesting.
  • Get ready for that raise, promotion or new job by supercharging your Excel skills.

Requirements

  • You should have a basic understanding of beginning Excel before starting this course.
  • A willingness to learn and practice as you go to take your Excel skills to a truly advanced level.

Description

Tired of boring old Excel lessons?

Then you'll love Paul Ray's new style of teaching Excel. In this course, you'll learn advanced Microsoft Excel skills in a fun way using examples from a fictitious toy company. The humor might be cheesy, but make no mistake, the advanced Excel tutorials are extra meaty.

This course was specifically designed for students from Steve McDonald's beginning Excel courses to build on your existing skills. It's also perfect for any Excel user with a basic understanding of Excel who is ready to take their career to the next level. You'll learn awesome advanced functions, shortcuts, and data visualizations.

Here's what you'll learn in this course:

  • Advanced keyboard shortcuts

  • Powerful nested functions

  • Advanced table and cell referencing

  • Bad dad jokes

  • Scroll bars, check boxes and combo boxes

  • Conditional formatting

  • Combo charts

  • Pivot Tables

  • Stunning visuals with charts, pivot charts, slicers, timelines, and more

Here is our commitment to you with this advanced Excel course:

  1. You won't be bored

  2. You won't get left behind

  3. You'll love what you're learning

We guarantee you'll love the course! If, for any reason, you don't, within 30 days of your purchase you can get a complete refund. You can keep the skills that you've learned, along with all of your new dad jokes and you've lost nothing. So, what are you waiting for? Jump in and learn some advanced Excel skills today. 


Who this course is for:

  • Anyone with basic Excel skills and is ready to move on to more advanced skills
  • An employee who needs a raise, promotion or new job that requires advanced Excel skills.

Course content

5 sections • 30 lectures • 4h 53m total length

  • Preview01:24

  • Preview11:48
  • Nested Formulas
    11:56
  • Dates
    04:30
  • Quiz 1
    3 questions
  • IFERROR, LEN, TRIM
    07:22
  • Advanced Cell Referencing
    06:10
  • Filtering, View Tab, and Trace Precedents
    09:01
  • Quiz 2
    3 questions
  • Transpose, Paste Special, HLOOKUP
    09:05
  • Macros
    15:31
  • Text to Columns and Flash Fill
    09:10
  • Data Validation
    08:49
  • Quiz 3
    4 questions

  • Sparklines
    06:52
  • Scroll Bars
    12:01
  • Check Boxes
    13:11
  • Combo Boxes
    07:12
  • Quiz 4
    4 questions
  • Option Buttons
    09:21
  • Conditional Formatting
    10:53
  • Advanced Chart Features
    09:43
  • Combo Charts
    14:24
  • Quiz 5
    4 questions

  • Pivot Table Basics
    14:09
  • Sorting and Filtering
    09:49
  • Pivot Table Visuals
    06:26
  • Quiz 6
    3 questions
  • Summarize Values and Advanced Tips
    13:47
  • Show Values As (Part 1)
    06:58
  • Show Values As (Part 2)
    08:56
  • Calculated Fields (Part 1)
    13:45
  • Calculated Fields (Part 2)
    10:39
  • Pivot Charts
    13:15
  • Slicers and Timelines
    10:44
  • Quiz 7
    5 questions

  • Conclusion
    06:46

Instructors

Steve McDonald
Dedicated Instructor Will Help You Excel | 300K+ Students
Steve McDonald
  • 4.5 Instructor Rating
  • 29,006 Reviews
  • 393,145 Students
  • 21 Courses

Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals. 

My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology. There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek. 

I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand.

I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.

I am here to guide you on your way to success. You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction.

I'm always happy to help.  I believe in you, and I'm here to support you in your learning process.

Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy.

Sign up for a course today and I'll help you reach the level of success you deserve. 

I'll see you in there!

Paul Ray
Data Analyst
Paul Ray
  • 4.7 Instructor Rating
  • 160 Reviews
  • 26,859 Students
  • 1 Course

After six years of experience and professionally certified training in analytical tools, I have come to Udemy to pass along some knowledge. My hope is for my students to learn from my mistakes and better themselves by learning from my real-world experience. I have a more practical approach to teaching and have structured the lessons to be applicable in your everyday life.

  • 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.