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+
Photoshop Graphic Design 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 Coaching 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 Retargeting
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
2020-12-08 15:03:25
30-Day Money-Back Guarantee

This course includes:

  • 13 hours on-demand video
  • 2 articles
  • 37 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

The Microsoft Excel Zero to Master Complete Course

Microsoft Excel 2010, 2013, 2016, 2019 and 365 professional Master with Formulas, Charts, Pivot and VBA Macros
New
Rating: 4.5 out of 54.5 (111 ratings)
13,128 students
Created by Manuel Estasio, Stephanie Rocco
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn to use Excel at the highest level, become a professional
  • You will be guided to consolidate your Excel basic Knowledge
  • Look into common and new Excel formulas
  • Manage large amounts of data, make your reports automatic and simplify your work routine
  • Follow the exercises and upgrade your Excel projects
  • Impress your colleagues with advanced formulas and pivot tables
  • Get to learn VBA and create the most significant macros with Excel
  • Follow the constant updates of the course and improve your skills

Requirements

  • No previous knowledge of Microsoft Excel is required
  • The Microsoft Excel software already installed
  • Course recorded with Excel 365, the updates will ALWAYS be provided with the latest version available; the use of the 2010, 2013, 2016, 2019 and following versions is also possible

Description

Stay Focused. Learn for Real!

The Microsoft Excel Zero to Master Complete Course made up of max 15-minute long lessons.

A complete Master, recorded with Excel 365, constantly updated, made up of 5 levels which will make you a new Excel hero: Zero, Base, Intermediate, Advanced and Master.

The schedule provides a project with which you will be able to create and manage - on your own- a hypothetical Company- both as for the commercial part and for the administrative and bureaucratic part- in addition to a VBA project, with which you will create a data entry system, within an Excel file.

Suitable to any type of person, this course does not require any type of ITC know -how, you just need to have a PC to start off the adventure with this fantastic application program.

Every single recorded video was framed in a specific section so that to facilitate the learning, to give you the chance to follow it at your ease and at your own pace distributing the span of every step in the best possible way.

You will find more than 10 exercises helping you test what you’ve learned in the various phases of the course: the structure of every group of lesson was carefully planned to simulate a classroom experience, with the difference that it’s entirely up to you when to stop, easily acknowledging by yourself whether every topic has been fully grasped.

The topics of the lessons are the ones we consider essential to match the best expertise in the software with a perfect learning experience so that to enable you to work with Excel fully exploiting its potentials, at every level.

Every published update will be signposted: we will give you the opportunity to choose the topics to drill down.

Go through the list of the sections to get the idea of the carefulness displayed along this course: nothing is left to chance, everything is put forward in the easiest and in the most practical way and ...don’t forget to follow our personal pages, where we will gradually insert all our courses, to become an absolute expert in the ITC realm!

If you have any questions, you can: check the list provided in this course- in case they have already been posted and answered-, use the Forum or simply ask! Any doubt deserves being resolved to enable you to learn everything without any difficulty.

Who this course is for:

  • Any user without any experience of Microsoft Excel and willing to learn to use it at its best.
  • Any user who has little experience of Microsoft Excel and willing to drill down his/her knowledge.
  • Any expert wanting to improve his /her skills so that to use Excel as a real pro.
  • Any user wanting to achieve statistics and data analysis skills with the best tool around.

Course content

35 sections • 192 lectures • 12h 59m total length

  • Preview00:30
  • Preview03:15
  • Preview01:00
  • Preview04:27

  • Preview01:53
  • Preview02:16
  • Preview01:32
  • Preview01:53
  • Preview01:09

  • Preview02:21
  • Preview04:00
  • Preview02:38

  • Create your first words list
    01:21
  • Create your first numbers list
    00:55
  • Select, copy, paste and cut
    06:06
  • Order, filter and remove duplicates
    06:19
  • Find and replace
    04:32
  • Fonts, text alignment and colors
    06:12
  • Exercise #1 – To do List
    03:34
  • Exercise #1 – SOLUTION
    01:13

  • Structure of elementary Excel formulas
    02:25
  • SUM math function
    04:06
  • UPPER, LOWER and PROPER text functions
    04:10
  • Arithmetical operators and calculation logic
    05:06
  • Basic date and time functions
    01:52
  • Exercise #2 – Name and years
    01:19
  • Exercise #2 – SOLUTION
    01:20

  • Introduction to Excel Basics
    01:33

  • Header and Footer
    04:08
  • Table style formatting
    07:29
  • Excel templates
    05:13
  • Hyperlinks
    03:37
  • Print preview
    03:21
  • Exercise #3 – To do List template
    00:56
  • Exercise #3 – SOLUTION
    01:10

  • Text and special formats
    02:45
  • Maths formats
    03:33
  • Currency formats
    02:36
  • Date and time formats
    03:45
  • Percentage format
    01:54

  • Structure of basic Excel formulas
    01:44
  • COUNTA math function
    02:00
  • AVERAGE math function
    01:20
  • ROUNDUP and ROUNDDOWN math functions
    02:22
  • LEN text function
    02:02
  • CONCATENATE text function
    02:34
  • ROW and COLUMN search functions
    01:28
  • Exercise #4 – Text in five cells
    01:04
  • Exercise #4 – SOLUTION
    00:51

  • Introduction to Excel Intermediate
    01:59

Instructors

Manuel Estasio
Web Developer & Instructor
Manuel Estasio
  • 4.5 Instructor Rating
  • 307 Reviews
  • 14,335 Students
  • 4 Courses

Hi, my name’s Manuel :) I've been a full stack web developer, designer and marketer since 2006 with a computer technology degree.

I had my first computer at 10 years old and I started programming at 13, then I started my ITC education focusing on statistics and web technologies.

I've been working for several international companies since 2006, and in 2019 I established my own company.

Now I am setting up websites, I ‘m supporting some companies in their online growth and I dedicate myself to my greatest desire, to teach others what I am most passionate about.

I want my courses to be clear and useful, without you ever losing concentration: if you find a lesson longer than 10 minutes, I'm sorry, but I couldn't explain it to you in less time.

Stephanie Rocco
Professional Bootcamp Instructor
Stephanie Rocco
  • 4.5 Instructor Rating
  • 111 Reviews
  • 13,128 Students
  • 1 Course

Hi, there!

I’m Stephanie, your new instructor.

I’ve been engaged in teaching for more than 20 years in a classroom environment, dealing with diverse knowledge areas, included statistics and ITC.

Some years ago, I got involved in a new adventure which shifted my focus onto online activities, and I am thrilled to introduce my courses to you.

At the moment, I am co-operating with an ITC company, specialized in Web development and online teaching, which is in charge of creating and updating all the courses available to you.

We will come to terms with Excel, UX, JavaScript, Node, React and much more.

Follow my page to find out what’s new!

If you are looking for solutions for you to upskill in a topic -from A to Z-, you are on the right place, everything is carefully planned to take you to be a professional.

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