Data Analysis In Excel
Online | Intermediate | 2Hours
Data Analysis In Excel
Data Analysis In Excel
Course Overview
This short course aims to take you from a novice to an expert in under 2 hours!
In a world where we are constantly bombarded with information, making sense of it all can sometimes be difficult and time-consuming. This is particularly true of Excel. Analysing large amounts of data and presenting information that makes sense to your audience is an essential skill for many people.
In this short, ten module course we aim to teach you the basic skills you need to analyse data effectively and efficiently. From Pivot Tables and Conditional Formatting to Lookup Formulas and beyond, ‘Excel Data Analysis’ will set you up with a great foundation upon which to build further skills.
Why Excel matters:
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit.
We also know how difficult it is to find quality instruction that is:
• Easy to follow
• Gets you the results you want
• Teaches you advanced methods that you can quickly put into practice
That’s why we developed our online Excel course.
What you get with this Data Analysis in Excel course:
• 15 brand new demo videos with professional voiceovers
• 11 modules with text, that is relevant and easy to understand
• 10 downloadable exercises
• Quiz questions in every module
• Specific objectives and condensed accelerators
In this course you’ll learn:
• Clean up data ready for analysis
• Create PivotTables and PivotCharts
• Lookup information using VLOOKUP, HLOOKUP and INDEX-MATCH
• Make decisions using IF Statements
• Highlight information using Conditional Formatting and Rules
• Build a basic Interactive Dashboard
More about us:
• We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
• We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
• Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
• Our platform is award-winning and improving all the time.
If you are not 100% happy with your EwB Data Analysis in Excel, you have 30 days to exchange or refund.
About the author:
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).
Syllabus:
Section 1: Basic Skills
▸
Unit 1.1 - Excel Introduction
▸
Unit 1.2 - The Excel Interface
▸
Unit 1.3 - Accessing and Saving Files
▸
Unit 1.4 - Read and Enter Data
Section 2: Efficiency of Use
▸
Unit 2.1 - Keyboard Shortcuts
▸
Unit 2.2 - Editing
Section 3: Data Analysis
▸
Unit 3.1 - Basic Arithmetic
▸
Unit 3.2 - Sorting and Filtering
Section 4: Presentation
▸
Unit 4.1 - Setup and Printing