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
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

MS Excel - Data Analysis with Pivot Tables & Excel Formulas

Learn to effectively analyze data with Pivot, Functions, VLookup, Dashboard, Filters, Slicers, Pivot Charts, Power View
Rating: 4.1 out of 54.1 (46 ratings)
6,869 students
Created by Institute of Investment Banking
Last updated 12/2018
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn the usage of excel to learn to simplify your work and make it more interesting.
  • Learn to Analyze data to make business decisions,Troubleshooting and enhancing professional workbooks,Analyzing data with functions

Requirements

  • Basic knowledge of using spreadsheets/Excel
  • The course is fit for anyone who has the urge to learn applications of excel
  • No specific education background and work experience required

Description

The course is an online course. It being one of the most interesting usage of excel you might be excited to learn to simplify your work and make it more interesting. The main course objective of this online training is to deliver the knowledge of advanced options in Microsoft excel that a user can apply to its routine tasks without using any coding or intense programming. 

Following is the part of the Power excel training

Analyzing data to make business decisions,Troubleshooting and enhancing professional workbooks,Analyzing data with functions,Optimizing workbook models with “what-if” analysis,Summarizing business information,Formulating decisions from database information,Enhancing excel usage with macros.

Who this course is for:

  • Commerce students
  • Students from the business administration
  • Working professionals who go through the hectic working schedule of same repetitive work every day

Course content

11 sections • 47 lectures • 4h 51m total length

  • Preview02:16
  • Preview01:20

  • Preview04:22
  • Preview06:30
  • Quick Analysis
    Preview01:19
  • Rate Function
    05:17

  • Pivot Tables
    06:29
  • Create Custom Groups in Pivot Table
    07:37
  • Set Conditional Formatting
    05:58
  • Set Conditional Formatting Continues
    06:53

  • Troubleshooting and Enhancing Professional Workbooks
    10:52
  • Troubleshooting and Enhancing Professional Workbooks Continues
    11:10
  • Name Range and Data Set
    08:31
  • Key Performance Indicator (KPI) In Excel
    11:41

  • Analysis Data with Function
    00:44
  • Date Format
    06:13
  • Time Format
    08:13

  • Nested If Statement in Excel
    10:27
  • Count ifs and Sum ifs in Excel
    10:04
  • VLookup In Excel
    02:11

  • Future Value
    04:40
  • Epitomizing What If Analysis
    00:34
  • How to Create Scenario in Excel
    06:06
  • Creating Goal Seek in Excel
    05:22
  • Creating Goal Seek in Excel Continues
    05:22
  • Hw to Use Solver Tool in Excel
    06:33

  • Business Information
    00:46
  • Creating a Dashboard of Sales
    10:52
  • Create hyperlinks for Sales
    06:34
  • Profit and Loss of Sales
    09:53
  • Profit and Loss of Sales Continues
    11:16

  • Formulating the Design From Database Information
    01:17
  • Working with Data Table in Power Excel
    03:54
  • Adding New Coloumn in Data Table
    07:22
  • Using Excel Function in Data Table
    06:29
  • Working With Data Filtering
    06:17
  • Working With Data Filtering Continues
    03:54
  • Data Subtotal Group and Ungroup
    05:21
  • More on Data Subtotal Group and Ungroup
    04:53

  • Data Comparison in Power Excel
    09:04
  • Data Filters and Slicers in Power Excel
    04:57

Instructor

Institute of Investment Banking
Learn Investment Banking the easy way!
Institute of Investment Banking
  • 3.6 Instructor Rating
  • 2,711 Reviews
  • 62,022 Students
  • 38 Courses

Institute of Investment Banking (iiB) offers a comprehensive range of professional Online Courses and Classroom Programs in Finance and Investment Banking. iiB is the Premier Finance Training Provider around the world. iiB has built a strong online platform and caters to self-paced learning, online learning and classroom mode of learning. Our courses are taught by industry experts. Our courses are driven by a constant need to be job relevant and stimulating, taking into consideration the dynamic nature of the Financial Services and Analytics market. Today, iiB is a name trusted by companies, professionals and students across India and all over the world. We empower you with practical knowledge through our courses. With us, you get the intensive experience that will expose you to new challenges, and innovative ideas to perform better in your career. We've been offering our courses for more than a decade and our alumni are already doing a remarkable job across the globe. Our academic excellence goes beyond theoretical knowledge or setting you up to memorize things, our courses are built around applied Finance. We're proud of people who give us their time and commitment. We're looking for people who are ready to level up, who care to up-skill and re-skill with changing time and work demand. One thing we preach is that any learning needs focus, commitment, and consistency. Come and Join our courses and take a leap. 

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