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
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
30-Day Money-Back Guarantee

This course includes:

  • 3 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Microsoft Excel - Excel from Zero to Hero (2020)

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Office 365 | Everyday Excel
Rating: 4.8 out of 54.8 (46 ratings)
1,659 students
Created by Mozn Akhourshiedah
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn the Microsoft Excel from the beginning
  • Explore and learn the important functions in Microsoft Excel
  • Learn how to analyse data using Excel
  • Learn about PivotTable and use it for analysis
  • Learn how to perform basic calculations
  • Learn Excel by doing using practical examples

Requirements

  • This course starts from zero, there is NO pre-requirements

Description


Hello!

This Microsoft Excel course helps the learners to understand how to work and manage data sets, It focuses on understanding rather memorizing, which leads into great results in a very short time. You will learn many topics: Overview of Excel, Data entry, Creating Charts, PivotTables, Pivot Charts, Formulas, most common functions like Sum(), Average(), VLOOKUP()...etc. In a very short time, you will be able able to say you really know excel. You will become the Excel master in your organisation or Business.


This course will help the learners to improve their skills and be familiar with Microsoft Excel. Now a days, Microsoft Excel is one of the most important and used program world wide.

We are going to start from the very basics, and gradually introduce basic functions, then dive into powerful tools like PivotTables.


What makes me qualified to teach you?

My name is Mozn and I've been a professional instructor for over a decade. Plus I'm the founder of Mezan Institute and the Author of a published book. I break down complex topics into an easy understandable messages, and help learners to absorbe the study material in an easy and engaging way. My courses are continuously receiving 5-star reviews like these from Microsoft Excel from Zero to Hero, 2020:

***** I realise after this quick and easy course that I new few parts of the excel but I am realy greathfull that Iadd few more when soon as I finsh this course. - Diana

***** Simple quick into to excel. Please add some more lectures similar to this :). - Geraldine

***** Yes, a good match, I do this every day, however, manually, but now I understand formulas much better, and it is less time consuming. - Dianne


What is this Excel course about?

In this guide to Microsoft Excel course, you'll not only learn all of the principles of Microsoft Excel, but also how to understand and become a star in your field.

This course will cover Beginners, Intermediate and Advanced levels of Excel, including:

  • Overview of Excel, What is it for and how to use it

  • Entering, editing, formatting data in Excel

  • Formulas and main functions in Excel; Sum, Average, Min, Max...etc.

  • Charts and visualisation

  • The powerful tool of PivotTables

  • Creating and Managing PivotTables

  • And much more! New lectures will be added and updated when possible.


Learn from someone who is currently working in the industry, who knows the most current teaching techniques.

By the end of this course, your confidence as Data analyst using Excel will soar. You'll have a thorough understanding of how to use Excel in a business or personal environment.

Go ahead and click the enroll button, and I'll see you in lesson 1!


I wish you an enjoyable journey with us.

Shukran! Mozn

Who this course is for:

  • Anyone interested in learning Microsoft Excel
  • Anyone need to save time and create automatic and dynamic reports

Course content

6 sections • 36 lectures • 2h 54m total length

  • Preview04:27
  • Excel Toolbars and shortcut menues
    06:49
  • Workbooks and Worksheets
    04:59
  • How to look for Help on Excel - Using Excel Help
    03:46
  • Chapter Quiz
    3 questions

  • Data entry, Editing and AutoFill
    05:53
  • Preview06:10

  • Working with Simple formulas
    08:40
  • Using the SUM() function
    06:39
  • Using the MIN() and MAX() functions
    03:18
  • Using the AVERAGE() finction
    05:06

  • How to Create Charts in Excel
    08:31
  • Chart Types
    11:53
  • Exploring Excel Ideas
    03:43

  • Introduction
    00:50
  • Create your first PivotTable
    11:15
  • Configure your PivotTable
    06:00
  • Create a PivotTable from external data source
    02:16
  • Preview05:47

  • Subtotals and Grand Totals
    04:08
  • Preview04:01
  • Adding more than one data field
    03:06
  • Managing Dates in PivotTables
    03:36
  • Creating Calculated Fields
    04:11
  • Drilling down the data
    04:11
  • Sorting the data
    02:27
  • Filtering the data
    02:55
  • Filter by rules
    04:04
  • Filtering with search
    01:53
  • Filtering using Slicers
    04:48
  • Formatting the slicers
    03:46
  • More on filtering your data
    06:11
  • Clearing and re-applying filters
    02:01
  • Filtering the PivotTable with a Timeline
    04:04
  • Changing the style of the PivotTable
    04:44
  • Changing the Layout of the PivotTable
    04:31
  • Formatting the numbers in the PivotTable
    03:48

Instructor

Mozn Akhourshiedah
Engineer, trainer, Entrepreneur
Mozn Akhourshiedah
  • 4.7 Instructor Rating
  • 113 Reviews
  • 4,641 Students
  • 5 Courses

My passion is helping others growing a skill they are passionate about. I have been teaching and conducting training courses for more than 10 years. I am specialized in Engineering, Language teaching, Coaching, training skills. 

My first Udemy course is Starter's Arabic language course, join me in this highly effective course now!


More about Mozn:

Mozn Shaker is the founder and CEO of Mezan Institute. He received his B.Sc in Mechanical Engineering from the University of Jordan and his master’s degree in International Business and Languages from Sorbonne University, Recently he completed his Data, Economics and Development MicroMasters program from MIT. After his 9th year as a regional manager with international engineering organizations, he founded Mezan Institute; a specialized language institute based in Dubai. During the last few years, Mozn worked with hundreds of students to improve their language, communication and digital skills. Mozn authored and Amazon published his first book in 2019, titled: Arabic language for non-native speakers, part 1.

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