Product Details

1of 3

Data Analysis In Excel

Sort & Analyze Excel Data More Effectively in Under 3 Hours

Our world runs on data, and knowing how to make sense of it all is becoming a vital skill. Get the essential know-how you need to analyze information more effectively in this streamlined course. From PivotTables and conditional formatting to lookup formulas and beyond, this training will get you crunching numbers faster and lay the foundation for a promising analytics future in under three hours.

Access 11 modules & 2.5 hours of content 24/7

Learn how to clean up data for analysis & break it down w/ PivotTables and Charts

Look up information faster using VLOOKUP, HLOOKUP & INDEX-MATCH

Discover how to create a basic interactive dashboard

Refine your training w/ 10 downloadable exercises

Instructor

Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Important Details

Length of time users can access this course: lifetime

Access options: desktop

Certification of completion included

Redemption deadline: redeem your code within 30 days of purchase

Experience level required: beginner

Requirements

Internet required

Access

Lifetime

Content

6 hours

Microsoft PivotTable Training

Harness the Power of Excel's Most Useful Analytics Tool

Widely considered Excel's most powerful tool, PivotTable allows you to automatically sort data from one table and present it in another, making for extremely efficient insights. Its learning curve can be steep for beginners, but you'll come to use it like a pro as you learn how to filter, sort, and present mounds of information in a much more focused way.

Access 39 modules & 6 hours of content 24/7

Understand PivotTable's primary uses & applications

Learn how to identify the worst & best data sets

Discover how to filter, sort and group Pivot Table data to boost efficiency

Instructor

Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Important Details

Length of time users can access this course: lifetime

Access options: desktop

Certification of completion included

Redemption deadline: redeem your code within 30 days of purchase

Experience level required: intermediate

CPD UK-accredited

Requirements

Internet required

Access

Lifetime

Content

4 hours

Basic Microsoft Excel

Get up to Speed with the Excel Essentials in 4 Hours

The workforce is going digital, and understanding a program as ubiquitous as Microsoft Excel is going to be essential in the future. For those who haven't dipped their toes in Excel yet, this training offers the perfect introduction by covering the business-relevant areas of Microsoft Excel. You'll explore the essentials of navigating the Excel interface, saving time with shortcuts, and more, so you can manipulate data, automate tasks, and better manage information.

Access 22 modules & 4 hours of content 24/7

Learn how to navigate the Excel interface & customize it

Create better spreadsheets w/ basic mathematical functions

Foster basic data analytics skills through sorting & filtering

Work more efficiently w/ keyboard shortcuts & quick editing tools

Instructor

Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).