Excel Crash Course
Data analysis is a powerful skill that helps you make better decisions any In business. Excel is a powerful tool that has become instrumental in business processes worldwide regardless of the industry. It has made analyzing stocks or issuers, budgeting, or organizing much easier with.
The Excel Crash Course is designed to teach learners to make meaningful reports such as Heatmaps, Business invoice reports, and create and manipulate pivot tables. You will be able to make very useful sets of data that are going to help make better managerial decisions for your organizations. Such skills are highly sought after by employers. It can give you the extra edge you need to land yourself your dream job.
The course has been designed from the point of view of a Business Intelligence consultant. The curriculum is based on the skills needed to power through your daily business needs and achieves 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.
Highlights of the Excel Crash Course
- Explore the use of Microsoft Excel from a data science, data visualisation and data analysis perspective
- Learn to design three dashboard systems in Excel such as Activity Heatmap, Advanced Currency Converter, Business Invoicing Dashboard
- Figure out how to work with Excel time intelligence and text functions to extract hour of the day, day of week etc
- Find out how to Manipulate pivot tables to design effective and beautiful charts and heatmap visuals
- Create your own custom design pivot charts by adding custom images
- Learn the use of Power Query tool to manipulate and mashup data
- Use certain tips and tricks to fine-tune your Excel dashboards and visuals to supercharge your data visualisation skills
- Expand your data analysis skills by working on data retrieved from Twitter API
- Explore to maximize office productivity and increase your salary with automation skills
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
How is the course assessed?
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
Why study this course
Whether you’re new to the market or looking to enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Excel Crash Course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
|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|