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 Mindfulness Personal Transformation 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 Online Business 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
Business Business Analytics & Intelligence Excel Analytics

Excel from Beginner to Pro

The Essential Guide to Sharpening your Excel Skills
Rating: 4.2 out of 54.2 (26 ratings)
114 students
Created by Mariam Adeyemi
Last updated 8/2020
English
30-Day Money-Back Guarantee

What you'll learn

  • At the end of this course, students will learn how to work with:
  • Basic Functions of Excel
  • Pivot Tables & Dashboards
  • Charts and Graphs
  • Excel Formulas
  • Frequently Used keyboard Shortcuts for Excel
  • Business Accounting with Excel
  • The LookUp Function
  • SUMIF
  • Forecasting in Excel
  • Regression Analysis
  • Optimization Analysis
  • What-If Analysis
  • Financial Analysis

Requirements

  • Download any version of Excel between 2010 and 2016 on your computer

Description

Data is an integral part of every business today, whether small, medium or large. That is why the demand for skilled professionals in this field is increasing exponentially. Having Microsoft Excel knowledge today is like having the master key to the engine room of a business. 


"Excel from Beginner to Pro" takes you from the scratch to a professional level even if you've never used Excel before.

At the end of this course, you'll be able to use the Excel software to analyze your dataset like a professional and be ready to challenge the status quo.

If you take this course, you'll able to

  • Use Excel Formulas to work on your dataset

  • To analyze data using the Pivot Tables

  • Apply the Excel functions on your day to day task

  • Run and Interpret Regression Analysis

  • Forecast and grow your business

  • Build charts and graphs with your dataset

  • Build Dashboard and be ready to present your report to the Management

  • Build a Financial Model and run assumptions




Who this course is for:

  • Beginners who want to learn Excel to work smarter
  • Young professionals and Business owners

Course content

16 sections • 48 lectures • 2h 43m total length

  • Preview01:17
  • Introduction to Excel
    01:00

  • Preview09:48
  • Quiz 1
    3 questions
  • Frequently Used Keyboard Shortcuts for Excel
    05:16
  • Quiz 2
    5 questions

  • Cell References
    09:44
  • Quiz 3
    4 questions
  • Cell Reference Practice Test
    3 questions

  • Excel Formulas
    10:18
  • Quiz 4
    5 questions
  • Excel Formulas Assignment
    8 questions

  • Introduction to Conditional Formatting
    04:23
  • Conditional Formatting with Formulas
    02:11
  • Conditional Formatting with Color Scales
    00:43
  • Conditional Formatting with Icon sets
    02:24

  • Pivot Tables
    06:33
  • Quiz 5
    3 questions
  • Assignment
    4 questions

  • Charts and Graphs
    05:39
  • Quiz 6
    5 questions

  • Introduction to Real life Example
    00:33
  • Formatting the Data Set
    01:10
  • Building the Pivot Table from the Data Set
    00:56
  • Building the Pivot Bar Chart
    01:07
  • The Map Chart
    01:46
  • The Doughnut Chart
    01:29
  • The Line Chart
    00:57
  • The Water fall Chart
    02:03
  • Aggregating the chart to build the Dashboard
    03:34
  • Adding Slicers to the dashboard
    01:55
  • The dashboard is ready!
    00:19

  • VLOOKUP and SumIF
    06:45
  • The IF Statement
    05:42
  • Quiz 7
    5 questions

  • Introduction to Forecasting
    01:44
  • Real Life Scenario
    06:26

Instructor

Mariam Adeyemi
Business Analyst
Mariam Adeyemi
  • 4.3 Instructor Rating
  • 30 Reviews
  • 124 Students
  • 2 Courses

Mariam Adeyemi is a certified Business Analyst and Author. She is an IBM certified Data Scientist with over 12 years local and International corporate experience in Sales, Marketing, Finance, Research and Information Technology. She earned her Masters Degree in Business Analytics from Texas A&M University-Commerce and got her Bachelors Degree in Communications. She’s written three books currently listed on Amazon.

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