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 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
Business Business Analytics & Intelligence Excel

Mastering MS Excel - From Beginner to Advanced and Beyond

Become proficient in Excel quickly and easily by mastering real-business-world solutions. Updated August, 2020.
Rating: 4.6 out of 54.6 (5 ratings)
17 students
Created by Vivian Pyle
Last updated 10/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn or refresh creating worksheets complete with formatting, formulas and basic functions
  • Advanced functions such as if function, lookup functions, text functions and more
  • Work with datasets and tables
  • Adding subtotals and grouping
  • Charts and Pivot Tables and Pivot Charts
  • Conditional formatting
  • Custom number formats
  • Data validation
  • How to easily remove duplicate data
  • How to password protect a whole worksheet and part of a worksheet
  • Using Range Names
  • More topics coming soon!

Requirements

  • Basic computer knowledge.

Description

UPDATED AUGUST 2020

Proficiency in Excel is one of the key skills to landing a good-paying job, according to a recent labor-market analysis by Burning Glass Technologies. ~Monster

According to the Wall Street Journal, high proficiency in software like Microsoft Excel is increasingly helping people land jobs. And jobs that require digital skills such as Excel also pay approximately 13% more than those that don't.

⭐⭐⭐⭐⭐⭐

Are you ready to increase your pay and become more sought after in today’s job market?

Are you ready to be proficient in Excel and stop wasting time and money searching for the best solution to your Excel project or question?

Are you ready to land that good-paying job?

⭐⭐⭐⭐⭐⭐

There is so much information out there. It can be confusing trying to figure out which Excel solution is the best. Or, what skills are needed in today’s job market. So I’ve made it easy for you.

I’ve collected the most common Excel questions and problems my students and clients have faced in various professional settings in the last 20+ years. I’ve added in my own experience using Excel in corporate and military environments and as a consultant. I’ve put this all together in a course that will show you how to use Excel with real-world examples and exercises..

This course is designed to teach you MS Excel from the ground up, either as a refresher or as a newbie, all the way through to the advanced topics which will make you a pro. All the lessons are taught in an easy, stress-free way with step-by-step instructions. When you are done with this course you will be able to look at a problem and come up with an Excel solution.

⭐⭐⭐⭐⭐⭐

I have over 20+ years of experience using and teaching Excel and helping large companies save time and money by using Excel more efficiently. I have shown thousands of students and clients how to not only use Excel but use it efficiently thus saving themselves and their companies time and money. I am certified to teach MS Excel at the Expert level and I know what solutions employers are looking for.

⭐⭐⭐⭐⭐⭐

Benefits

  • These practical, real-world lessons will help you understand Excel’s full capabilities.

  • You’ll not only know HOW to do something; you’ll also understand the WHY behind the tasks.

  • You'll learn how to use Excel for quick and painless problem solving.

  • You’ll spend less time searching for answers because you will have a solid understanding of the way Excel works.

  • You will learn sought after skills your dream employers are looking for

  • You will increase your skill set to impress the boss and become the go-to person for Excel in the office.

  • You’ll get more done in less time in Excel. Say ‘hello’ to massive productivity in the office.

  • Your confidence in using Excel will soar and you will be super-marketable.

What’s included:

  • Solid foundation to build upon (great for beginners or as a refresher for the more seasoned Excel users)

  • Learn or refresh how to create a worksheet complete with formatting, formulas and functions

  • Learn to use the most popular functions in Excel, including if functions, lookup functions, text and data and time functions

  • Learn how to create professional looking pie charts, bar charts, column charts and more

  • Learn how to create datasets and tables and sort and filter your data

  • Learn how to create pivot tables and charts for a quick analysis

  • Follow along step-by-step instructions, demos and lessons

And some bonuses, too!

  • Downloadable follow-along demo files (BONUS!)

  • Downloadable PDF’s (BONUS!)

  • Quizzes (BONUS!)

  • Future updates and topics (I am constantly adding new topics)

  • 30-day money back guarantee

Who this course is for:

  • This course is perfect for a first-time beginner who needs to learn much more than just the basics. No more wondering what you should learn first.

  • This course is also helpful for the Excel user who is ready to expand their skills in areas such as using advanced functions; creating charts, graphs and tables; creating pivot tables and charts and more. No more trying to guess which task to use in certain situations.

  • This course is helpful for increasing personal productivity, efficiency at work or even developing skills to obtain a better job. Increase your confidence in using Excel.

  • People who want to learn Excel at their own pace and pick and choose which skills they want to work on and when. No more wasting time going through lessons you don’t need.

This course is NOT for:

  • This course would not be useful for an Excel user who has already reached the advanced level.

What others have said about my courses:

⭐⭐⭐⭐⭐ “I wish I had taken this course before I took my first Excel class in college. This course explains all the basics that I had to learn through trial and error. Incredibly helpful information!” ~Paula (Foundations of Excel)

⭐⭐⭐⭐⭐ “I have been using Excel for years and I learned more in one class with Vivian than I did from any other instructor.” ~former student

⭐⭐⭐⭐⭐ “I was able to get the promotion I wanted by taking Foundations of Excel. It was fast and much easier than I thought it would be. Vivian has an easy-to-follow method of teaching and I was able to finish what I needed from the course in a couple of hours.” ~former Foundations of Excel student

⭐⭐⭐⭐⭐ “This is such a clear and concise explanation. Thanks for giving the terms and showing the layout slowly, and demonstrating as you do. You're a gifted teacher Vivian.” ~Peri

⭐⭐⭐⭐⭐ “It has helped me quite a bit and I have learned some shortcuts I didn’t know about.” ~Dolores

⭐⭐⭐⭐⭐ “30 minutes working with Vivian 1:1 saved me hours of work trying to learn on my own.” ~former student and client

⭐⭐⭐⭐⭐ “I find Vivian’s courses easy to understand and follow. I feel much more confident in Excel!” ~Connie

Who this course is for:

  • Individuals wanting to expand their Excel skills
  • Anyone who needs to learn Excel from the ground up
  • Users who have a basic understanding of Excel and who are ready to go deeper into the more advanced topics
  • Anyone who wants to learn Excel at their own pace and/or pick and choose what topics they learn and in what order

Course content

21 sections • 110 lectures • 5h 2m total length

  • Preview01:05
  • Preview01:14
  • Preview00:26

  • Preview05:27
  • Preview10:43
  • Navigating the worksheet
    06:44

  • How to start a new workbook and worksheet
    02:03
  • Entering data into the worksheet
    04:33
  • Selecting data
    05:45
  • Moving and copying data
    04:35
  • Using the autofill handle
    02:48
  • Undo and redo
    01:23
  • Closing and saving workbooks.
    02:54

  • Formulas
    00:19
  • Formula Rules
    01:47
  • Using operators
    03:55
  • Mixed Operators
    04:04

  • Function definition
    01:37
  • Working with ranges
    01:20
  • Anatomy of a function
    01:00
  • Some common functions
    08:59
  • Autosum button
    05:01
  • Basic functions recap exercise
    00:39
  • Common errors and what they mean
    04:06
  • Using functions with formulas
    00:50
  • Copying functions and formulas
    02:53
  • Absolute and relative cell references
    06:17

  • Modify fonts
    06:26
  • Aligning cell contents
    02:49
  • Number formats
    08:06
  • Borders and color
    05:17
  • Resizing columns and rows
    04:35
  • Format painter
    03:01

  • Page layout ribbon
    07:09
  • Page setup dialog box
    03:28
  • Print preview
    02:16
  • Print titles
    07:12

  • Adding additional sheets-setting the default
    03:22
  • Adding and renaming sheets
    01:41
  • Moving and deleting sheets
    01:10
  • Copying sheets-move dialog box
    03:38
  • Add color to tab sheets-quiz
    01:18
  • Excel options
    03:44

  • New downloadable files! Welcome to Advanced Formatting
    00:16
  • NEW!! Advanced Formatting-Built-in Formats
    06:42
  • New downloadable files! Advanced Formatting-Custom Number Formats
    08:49
  • New downloadable files! Advanced Formatting-Styles
    02:55
  • New downloadable files! Advanced Formatting-Slanted Headers
    02:55
  • New downloadable files! Advanced Formatting-Conditional Formatting
    06:48

  • NEW! Charts (Welcome)
    00:20
  • NEW!! Chart Types and Components
    03:32
  • NEW!! Creating Charts
    02:05
  • NEW!! Modifying Charts
    07:35

Instructor

Vivian Pyle
Master Guru and Instructor at Vivian Says Solutions
Vivian Pyle
  • 4.6 Instructor Rating
  • 5 Reviews
  • 17 Students
  • 1 Course

Hi, I’m Vivian with Vivian Says Solutions and I teach Microsoft Excel and Access in easy-to-understand ways so you can save time and money by improving productivity with better, faster and maybe even automated spreadsheets and databases.

I have helped countless companies save hundreds of hours a month (and lots of money!) by teaching their employees to be more efficient using the software or by automating Excel spreadsheets and/or Access databases.

I am a Microsoft Certified Master Office Instructor and have over 20 years experience teaching and using MS Office. I specialize in MS Excel and Access. I have experience using MS Office in different capacities from corporate to military to small business and I bring that experience to the classroom with me.


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