Excel Crash Course: Dashboards, Data Analysis & Heatmaps

 This is a 100% project-based Microsoft Excel crash course with a special focus on data analysis, designing simple dashboards and creating heatmap visuals and other charts. Maximizing office productivity is a key skill to learn. By working with modern Excel tables and learning how to extract insights from data, you'll achieve a leap in your Excel skills in 3 hours.


Supercharge your Microsoft Excel skills rapidly in this Crash Course!

As a Business Intelligence consultant, I designed the curriculum based on some of the skills needed to get you powering through your daily business needs, and I’ve designed the courses to achieve specific objectives. This course is a hack to develop advanced power-user skills in Microsoft Excel on Office 365 in a very short period of time.

Students will work on two different datasets - Twitter data and fuel prices data - to design dashboards and extract insights using Pivot tables and beautiful heat maps.

In this course you will learn how to:

  1. Explore Microsoft Excel from a data science, data visualisation and data analysis perspective

  2. Design three dashboard systems in Excel - Twitter Activity Heatmap, Advanced Currency Converter, Business Invoicing Dashboard

  3. Work with Excel time intelligence and text functions to extract HOUR of DAY, DAY of WEEK etc

  4. Manipulate pivot tables to design effective and beautiful charts and heatmap visuals

  5. Design and customise pivot charts by adding custom images

  6. Use the Power Query tool to manipulate and mashup data

  7. Use certain tips and tricks to fine-tune your Excel dashboards and visuals to supercharge your data visualisation skills

  8. Test your data analysis skills by working on data retrieved from Twitter API

  9. Learn HOW to maximize office productivity and increase your salary with automation skills

    Why Excel skills matter

    Advanced Microsoft Excel skills can open up a whole myriad of career opportunities in business analysis, product management, data analysis, operations and strategy roles. As a skilled Excel user that is able to extract insights from data, you will be comfortable in working in industries such as finance, consulting, manufacturing, pharmaceutical, analytics or other business roles. Excel is the primary spreadsheet application used in financial modelling and ad-hoc data analysis.

    In this 100% example-based and project-based course, you’ll develop highly marketable business-focused Excel skills in data analysis and data visualisation to help you outperform competing candidates for promotions, job opportunities, and internships. You’ll learn what it means to be the Excel go-to person having an unfair advantage in analytical skills.

  10. Who this course is for:

    • Beginner in Excel interested in data analysis

    • More advanced users looking to learn how to improve office productivity

    • Business students curious about data visualization

    • Business professionals interested in data analysis and modelling

    • Crash course enthusiasts

    • Python developers and coders interested in data analysis and Excel

    • Who this course is for:

      • Beginner in Excel interested in data analysis
      • Business students curious about data visualization
      • business professionals interested in data analysis and modelling
      • crash course beginners
      • python developer interested in data analysis and Excel
      • Business owners
      • Accountants

    • #Excel Crash Course: Dashboards, Data Analysis & Heatmaps
    • Learn core, business-focused Excel skills for data analysis, data visualisation and dashboard modelling in 3 hours
    • 90% #off #discount #coupon link

    • https://www.udemy.com/course/excel-crash-course-dashboards-data-analysis-heatmaps/

Comments

Post a Comment

Popular posts from this blog

Full Stack Java developer - Core Java + JSP Servlets + Hibernate +Spring + Java Web-service/RestFul API + Spring boot.

If you are a learning enthusiast and want to create a quick and efficient web application, and you have some Java knowledge and a little or no knowledge about the Java networking programming, then this course is for you. “Full Stack Java developer Practical Guide" introduces you to Java, JSP, Restful WS, and spring. In this course, you will be able to combine all the ways to connect to the database and learn how to make it in an informative and attractive way. Here, you will learn all the basic concepts, tools, functions, and required topics which usually a Java Developer requires during the web application development process. The course starts with Java, including multi-threading, Lambdas, Collections debugging and introduction to GIT. Then we will move towards JSP and Servlets. Once we are done with JSP and Servlets, we will start exploring Hibernate. An application will be built using JSP and Hibernate as well. Java, JSP, and Servlets are core technologies, now once we ha...
Read more

CCA 175 Exam preparation using Scala & Practice Tests [2021]

  In this course, we will do the following Intro & Setup CCA175 Introduction Free Cluster Setup on Google Cloud Revise Hadoop Commands Apache Spark Revisi on Spark Intro Actions & Transformations (Optional) Spark Dataframe  (Transform, Stage & Store) Working with various file formats- Json, ORC, XML, CSV, Avro, Parquet etc Working with various compressions - Gzip, Bzip2, Lz4, Snappy, deflate etc Working with Strings Working with dates Working with columns in dataframe Dataframe APIS Spark SQL (Data Analysis) Working with Spark SQL Working with Hive Manipulating Strings in SparkSQL/Hive Manipulating dates in SparkSQL/Hive Mathematical Functions Aggregating & Analyzing data using SparkSQL/Hive Joining Datasets Ranking & Windowing in SparkSQL/Hive Real Exam Like Questions 8-10 Real like Exam solutions Practice Exams with Solutions Practice Exam1 (8 questions with a timer) Practice Exam2  (8 questions with a timer) Who this course ...
Read more

Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume

  In this course, you will start by learning what is hadoop distributed file system and most common hadoop commands required to work with   Hadoop File system. Then you will be introduced to  Sqoop Import Understand lifecycle of sqoop command. Use sqoop import command to migrate data from Mysql to HDFS. Use sqoop import command to migrate data from Mysql to Hive. Use various file formats, compressions, file delimeter,where clause and queries while importing the data. Understand split-by and boundary queries. Use incremental mode to migrate the data from Mysql to HDFS. Further, you will learn  Sqoop Export  to migrate data. What is sqoop export Using sqoop export, migrate data from HDFS to Mysql. Using sqoop export, migrate data from Hive to Mysql. Further, you will learn about  Apache Flume Understand Flume Architecture. Using flume, Ingest data from Twitter and save to HDFS. Using flume, Ingest data from netcat and save to HDFS. Using flume, Ingest data fr...
Read more