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 AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation 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

Excel in Microsoft Excel 2: Intermediate to Expert advanced

Get Expert certified! Levels 6-10 for Microsoft Excel 2010, 2013, 2016 and Excel 2019. Covers 77-728, 77-427 & 77-428.
Bestseller
Rating: 4.4 out of 54.4 (188 ratings)
1,069 students
Created by Phillip Burton
Last updated 10/2020
English
English
30-Day Money-Back Guarantee

What you'll learn

  • Manage workbooks and workbook review
  • Create and manage PivotTables
  • Present data visually, using PivotCharts and advanced charts
  • Perform data analysis and business intelligence
  • Troubleshoot formulas
  • Manage and reference defined names and custom workbook elements
  • And learn lots of formulas, including VLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT

Requirements

  • Before beginning, you need to use Microsoft Excel to an intermediate standard.
  • This includes Conditional Formatting, Tables, filtering, sorting and creating charts
  • If you have taken the course "Excel in Microsoft Excel - Beginner to Specialist certificate", or taken a Microsoft Office Specialist exam in Excel, then you will have the relevant prerequisites.

Description

This course series has been recorded on Excel 2016 and Excel 2010, but the content also covers Excel 2013 and 2019.

Building on the skills learnt in "Excel in Microsoft Excel 1", here's levels 6-10. By the end of this course, you will have the skills needed for the official Microsoft Excel Expert exam. How would that look on your resume?

Reviews

"Well thought out and explained in a way which makes it easy to learn & understand." - Arnold Schwartz

"This course is very well structured and the teachers knowledge is very good. His teaching style is capturing and he is very structured. The small tests after each section is great, and even greater is that he takes time to show his thoughts on how is should have been done, not just leaving one to wonder if it was right or not. The resources used in this course is also very suitable. Highly recommend this one" - Daniel Sandberg

------------

Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 10?

In this course, learn how to:

Manage workbook options and settings

  • Manage Excel workbooks,

  • Manage workbook review,

  • Apply workbook settings, properties and data options, and

  • Apply logical and statistical functions

Create advanced charts and Excel tables

  • Create and manage PivotTables,

  • Advanced formatting,

  • Create and manage PivotCharts,

  • Create advanced charts,

  • Apply advanced date and time functions

Preparing for advanced formulas

  • Troubleshoot Excel formulas,

  • Manage and reference defined names,

  • Prepare a workbook for internationalisation and accessibility,

  • Array fornulas.

Automation and advanced formulas

  • Perform data analysis and business intelligence in Excel.

  • Visual Basic for Applications (VBA) macros and form controls.

  • Create and modify custom workbook elements

  • Look up data by using functions (VLOOKUP, HLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT). translated into 15 different languages.

This course teaches all the skills that Microsoft want you to know for the Expert exams. Specifically, they are the skills required to undertake the Microsoft Certificate 77-851 (for Excel 2007 Expert), 77-888 (for Excel 2010 Expert), 77-427 and 77-428 (for Excel 2013 Expert) and 77-728 (for Excel 2016 Expert) and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about 8 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

  • you want to learn more about Microsoft Excel, or

  • you want to learn the Excel skills you need to become a certified Microsoft Office Specialist Expert.

Regardless whether you have Excel 2007, Excel 2010, Excel 2013, Excel 2016 or Excel 365, this course will help you get to an advanced level, and maybe even want you to get more!

Who this course is for:

  • This is for you if you want to develop your Excel skills to an Expert level.
  • This is also for you if you want to take the Microsoft Office Specialist Expert Exams.
  • This may not be for you if you are not already at least at an Intermediate level (already done levels 1-5 or equivalent).

Course content

19 sections • 151 lectures • 11h 2m total length

  • Preview01:45
  • Welcome to Udemy
    00:35
  • Preview02:00
  • Preview10:24

  • Save a workbook as a template
    04:55
  • Modifying custom templates
    03:57
  • Copy styles from template to template
    03:19
  • Using a formula to refer to another spreadsheet
    05:52
  • Reference data in another workbook
    03:15
  • Refresh and edit workbook links
    07:15
  • Reference data by using structured references
    05:08
  • Practice Activity Number 1
    00:27
  • Answers to Practice Activity 1
    04:12

  • Restrict editing by protecting a spreadsheet
    04:28
  • Lock and unlock cells
    06:07
  • Lock and unlock objects and hide formulas
    03:02
  • Hiding Formulas
    02:32
  • Protect Workbook
    03:49
  • Sharing Workbooks
    04:36
  • Track Changes
    05:46
  • Preview06:37
  • Encrypt a workbook with a password
    04:14
  • Importing and exporting XML data
    05:56
  • Practice Activity Number 2
    00:23
  • Answers to Practice Activity 2
    03:27

  • Perform logical operations by using the NOT function
    03:53
  • Perform logical operations by using AND and OR
    05:09
  • Perform logical operations by using nested functions
    09:49
  • Perform statistical operations by using COUNTIFS
    06:03
  • Preview05:08
  • Using FREQUENCY
    02:03
  • Trapping errors with IFERROR and ISERROR
    02:43
  • Practice Activity Number 3
    00:44
  • Answers to Practice Activity 3
    04:52

  • Creating our first PivotTable
    07:12
  • PivotTable Options
    07:59
  • Filtering Data, including using Slicers
    05:01
  • Group PivotTable data
    04:57
  • Reference data by using GETPIVOTDATA, and add and utilise calculated fields
    06:26
  • Practice Activity Number 4
    00:17
  • Answers to Practice Activity 4
    03:14

  • Formatting number values
    03:58
  • Custom Formatting - number formatting
    11:45
  • Custom Formatting - dates and text
    09:06
  • Custom Formatting - sections and colors
    08:26
  • Create and manage custom conditional formatting rules
    07:29
  • Create conditional formatting rules that use formulas
    09:17
  • Practice Activity Number 5
    00:22
  • Answers to Practice Activity 5
    03:20

  • Create PivotCharts
    02:34
  • Manipulate options in and apply styles to existing PivotCharts
    02:54
  • Create dual-axis charts
    05:37
  • Add trendlines to charts
    06:36
  • Save a chart as a template and create custom chart templates
    03:07
  • View chart animations
    04:18
  • Practice Activity Number 6
    00:24
  • Answers to Practice Activity 6
    03:56

  • Reference the date and time by using the NOW and TODAY functions
    04:50
  • Extract dates and times
    04:36
  • Serialise numbers by using date and time functions
    05:15
  • Financial functions
    05:58
  • Practice Activity Number 7
    00:17
  • Answers to Practice Activity 7
    01:26

  • Trace precedence and dependence
    05:42
  • Monitor cells and formulas by using the Watch Window
    03:26
  • Checking for errors
    04:37
  • Enable iterative calculations and setting iterative calculation options
    04:17
  • Perform what-if analysis by using Goal Seek
    06:51
  • Enabling or disabling automatic workbook calculation
    06:21
  • Practice Activity Number 8
    00:22
  • Answers to Practice Activity 8
    02:52

  • Display data in multiple international formats
    11:34
  • Apply international currency formats
    03:19
  • Manage multiple options for +Body and +Heading fonts
    03:54
  • Modify worksheets for use with accessibility tools
    04:43
  • Practice Activity Number 9
    00:10
  • Answers to Practice Activity 9
    01:28

Instructor

Phillip Burton
Best Selling Instructor - over 250,000 students so far
Phillip Burton
  • 4.5 Instructor Rating
  • 41,805 Reviews
  • 293,939 Students
  • 46 Courses

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.

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