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+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation 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 Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-15 10:57:29
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

Microsoft Excel Functions, Formulas, Analysis, & Dashboards

Microsoft Excel Zero to Advanced. Functions, Formulas, Shortcuts, Data Analysis, & Dashboards - A Practical Course
Rating: 4.4 out of 54.4 (1,923 ratings)
101,698 students
Created by Irfan Sharif
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Basics like cells, rows, and columns
  • Adding/deleting rows and columns
  • Cell formats
  • Basic Mathematical functions
  • Keyboard shortcuts
  • Data cleaning
  • Data analysis
  • Dashboards
  • Learn everything you need to start working on Excel!

Requirements

  • Microsoft Excel 2016, or any other version

Description

If your work requires working with numbers or large amounts of data, Microsoft Excel is your software.


Microsoft Excel is one of the most powerful data management and data analysis tool.

This course enables students to start using Excel in an effective manner. It starts from the very basics and within a few minutes, you will be having a good command over basic excel functions and even some advanced and frequently used features.


About this course:

Designed to teach Microsoft Excel to absolute beginners, this course will take you from scratch to a level where you can effectively store, manage, clean, transform, consolidate, analyze, and visualize data.


Prerequisites:

There is absolutely no prerequisite to start this course. Even 8 years old can take this course to learn Excel.


Who should take this course:

First-time learners, who have no idea about Excel and want to start the right way. This includes:

  1. Students

  2. Professionals, especially those who have to work with numbers.

  3. Daydreamers who wish to bring financial sense to their dreams.

  4. Anyone who wants to learn a better way to manage the numbers and calculations.


Software Requirement:

You should have Microsoft Excel installed on your computer. Any version above Excel 2010 will be okay. I will be using Excel 2016 in this course. If you do not have Excel currently, please download Office 365 free trial from the Microsoft website. Just google Office 365 free trial and it will take you to the page.


Money-Back Guarantee: 

Nothing to lose! If you won't be satisfied with the course, Udemy offers 30 days money-back guarantee!


Introduction to the teacher:

Chartered Accountant | 12 years of work experience | 12 years of teaching experience as visiting faculty | 4000+ in-class students | 100,000+ Udemy students | In love with Excel for 15 years

Who this course is for:

  • Beginner level users of Excel who are looking for a solid foundation
  • Students, business owners, entrepreneurs and professionals
  • Students with Zero knowledge of Excel

Featured review

Deepak Sharma
Deepak Sharma
145 courses
7 reviews
Rating: 5.0 out of 57 months ago
This course proved awesome for me. I learnt a lot of things from this course. The very best thing what I like in this course is the data which provided to exercise in resources. Voice is very clear to understand. Seems to have a vast knowledge of teaching. I will give 10 out of 10 for this course.

Course content

10 sections • 68 lectures • 5h 22m total length

  • Preview07:51
  • Preview05:41
  • Preview03:08
  • Autofill
    01:37
  • Basic Mathamatical functions
    06:10
  • Practice on real data
    09:57

  • Preview03:55
  • Preview06:27
  • Spell check
    03:23
  • Preview05:54
  • Replacing blank cells
    01:53
  • Using proper fonts
    03:14

  • Merging data in cells
    04:27
  • Text to Columns
    06:01
  • Preview05:00
  • Preview03:14
  • Flash Fill
    02:39

  • Vlookup
    13:55
  • Hlookup
    05:30
  • Index and match
    13:46
  • Consolidate
    04:48
  • Append data with Power Query
    05:52

  • Manipulating dates - Date | Month | Year
    04:13
  • Preview03:30
  • Manipulating dates - Day of the week | Week of the year
    04:27
  • Day of the Year
    08:15
  • Quarter of the Year
    05:48
  • Dynamic TODAY | Tomorrow | Yesterday
    01:39
  • Calculating Age
    03:16
  • Adding conditional columns based on IF
    02:05
  • NESTED IF
    02:53
  • IF OR
    04:32
  • IF OR Multiple Column
    03:00
  • IF OR OR OR Practice
    03:32
  • IF AND
    02:56
  • IF AND AND AND Practice
    02:44

  • Freeze Panes
    03:24
  • Filters and advance filters
    06:41
  • Preview07:49
  • Subtotals
    02:26
  • Preview03:42
  • COUNTIFS
    02:37
  • SUMIF
    03:47
  • SUMIFS
    03:10

  • Introduction to Data Analaysis and Data
    04:57
  • Summay by a parameter
    06:02
  • Adding parameters with drill down and drill up
    03:03
  • Breaking down information by Column
    02:54
  • Filtering the data in reports
    02:05
  • Understanding Value Field Settings
    03:42
  • Working with Dates in rows
    04:54
  • Grouping example
    03:16
  • Compiling data on one sheet
    06:52
  • Slicers
    05:31
  • Timeline
    03:27

  • Introduction and first chart
    04:39
  • Exploring the chart options further
    07:09
  • Compiling data on one sheet
    06:38
  • Adding timeline (time slicer) on dashboard
    03:05
  • Adding and adjusting slicers
    04:00
  • Adding trendline charts
    07:33

  • Understanding Relational Data
    08:29
  • Adding Power Pivot to Excel
    01:10
  • Adding data to Data Model
    05:12
  • Data Modelling
    05:36
  • Power Pivot
    04:25

  • Shortcuts Masterclass Part 1
    03:17
  • Shortcuts Masterclass Part 2
    04:05

Instructor

Irfan Sharif
Bestselling Trainer | Chartered Accountant | PwC Alumni
Irfan Sharif
  • 4.4 Instructor Rating
  • 6,094 Reviews
  • 195,950 Students
  • 6 Courses

Experienced finance professional with practical experience of teaching accountancy and finance.  

I am Certified Chartered Accountant (ACCA-UK), with a rich experience of providing finance and accountancy services to large organizations of banking, FMCG and professional services sectors. I have worked as a Consultant at "PwC" and as Finance Manager at a FTSE 100 MNC. Now I am leading Accountancy Service of "Excelsious" where we provide Accountancy and Finance services to small and medium sized entities. 

Throughout my career I have been associated with professional education as a visiting member of faculty at prestigious professional colleges and universities for ACCA, CA and MBA. Over this time, I have helped more than 4000 students successfully achieve their aspirations and professional education goals. I am really excited about the enhanced learning experience of teaching online and sharing my knowledge and expertise with a wider audience. 

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