• LOGIN
  • No products in the cart.

Login

Course Curriculum

Course Curriculum

Analysis of Twitter Dataset and Designing Heatmaps
Introduction to the Excel crash course 00:06:00
Understanding the Twitter Dataset 00:05:00
Extracting Other Details for Analysis 00:09:00
Creating Pivot Tables 00:08:00
Applying Conditional Formatting using Color Scales 00:03:00
Adding Slicers to Dashboard 00:02:00
Applying Custom Number Formats 00:03:00
Adding Custom Images to Charts 00:11:00
Interlude – Data Manipulation Challenge 00:02:00
Adding Heatmap Legend 00:02:00
Wrapping Up – Introduction to Open Analytics 00:02:00
Advanced Currency Converter using Dynamic Arrays
Introduction to Modern Excel Tables and Dynamic Arrays 00:11:00
Using Power Query for Data Manipulation 00:08:00
Applying Power Query Data Transformations 00:06:00
Structured Table Referencing 00:12:00
XLOOKUP Function and Pivot Table Calculations 00:05:00
Laundry Service Model and Invoicing Dashboard
Introduction to the Project 00:01:00
Overview of the Laundry Model Project 00:04:00
Understanding the Inputs 00:03:00
Formatting the Input Tables 00:04:00
Duplicate and Combine Tables with Power Query 00:09:00
Rounding Digits in Power Query 00:02:00
Load Specific Tables from Power Query 00:02:00
Feature Extraction and Named Ranges 00:10:00
Combining Elements – Data Validation with Named Ranges 00:08:00
Combining Elements – Understanding the INDIRECT Function 00:02:00
Combining Elements – Dynamic Drop-down Menu with Data Validation 00:04:00
Combining Elements – INDEX and MATCH with Multiple Criteria 00:12:00
Understanding the MATCH Formula with Multiple Criteria 00:06:00
Business Invoice Dashboard Design 00:06:00

Excel Crash Course

4.9( 7 REVIEWS )
799 STUDENTS
$ 249.00
Excel Crash Course
  • Course Highlights

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Excel Crash Course has been specially designed to help learners gain a good command of Excel Crash Course, providing them with a solid foundation of knowledge to become a qualified professional.

Through this Excel Crash Course, you will gain both practical and theoretical understanding of Excel Crash Course that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.

Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.

  • Learning outcome
  • Get a deep understanding of the Excel Crash Course just in hours not years
  • Familiar yourself with the recent development and updates of the relevant industry
  • Know how to use your theoretical and practical knowledge to adapt in any working environment
  • Get help from our expert tutors anytime you need
  • Access to course contents that are designed and prepared by industry professionals
  • Study at your convenient time and from wherever you want
  • Requirements
  • No formal qualifications required, anyone from any academic background can take this course.
  • Access to any internet-enabled smart device.
  • Why should I take this course?
  • 3 hours of on-demand video lectures and downloadable resources.
  • Affordable premium-quality E-learning content, you can learn at your own pace.
  • You will receive a completion certificate upon completing the course.
  • Internationally recognized Accredited Qualification will boost up your resume.
  • You will learn the researched and proven approach adopted by successful salespeople to transform their careers.
  • You will be able to incorporate various practical sales techniques successfully and understand your customers better.

Testimonial

Hear what our happy students want to say

Setup Menus in Admin Panel