Excel Essentials 3 Course Bundle
CPD Accredited - The Leading Global Excel Training Platform
Excel with Business
Summary
Overview
Analyse and present data quickly and easily using Excel and Pivot Tables.
This bundle aims to teach you the basic skills you need to analyse data effectively and efficiently in just 12 hours.
CPD
Course media
Description
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.
From Pivot Tables and Conditional Formatting to Lookup Formulas and beyond, this bundle 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.
Why Pivot Tables?
Excel can feel daunting – in particular, the infamous PivotTable™ function, which is widely spoken about and little understood. In the simplest terms, it allows you to automatically sort data from one table and present it in another, the pivot table.
But pivot tables can be far more sophisticated than that, and thanks to their flexibility and analytical clout are widely considered Excel’s most powerful tool.
What you get with this Excel Essentials 3 Course Bundle:
- 15 brand new demo videos with professional voiceovers
- 72 modules with text, that is relevant and easy to understand
- Multiple videos, practice exercises and test questions to aid your learning
- 10 downloadable exercises
- Quiz questions during modules
- Specific objectives and condensed accelerators
The courses this bundle will cover:
Data Analysis in Excel:
- 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
Microsoft PivotTables:
- The primary uses of pivot tables
- How to identify the best and worst datasets
- To filter, sort and group PivotTable™ data to maximise its usefulness
- How to present your data clearly using PivotCharts and Conditional Formatting
Basic Microsoft Excel:
- Data entry
- Text and number formats
- Basic mathematical functions (SUM, AVERAGE)
- Editing skills, including Flash Fill
- Basic data analysis skills through sorting and filtering.
- Printing spreadsheets
Version: Excel 2013 used in examples but applicable to all PC Excel versions
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.
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).
Requirements
Basic Microsoft Excel: Excel 2013 used in examples but applicable to all PC Excel versions
Questions and answers
hi Once purchased. Do you keep the course bundle or does it expire?
Answer:Good afternoon, Thanks for your question! Once you purchase a course or bundle for our content from Reed, you will be sent a voucher code and instructions on how to redeem what you have paid for in addition to creating an account. Access to the courses last twelve months from the date that you redeem your voucher. Kind regards, James M
This was helpful.Can you use excel in chrombook? I don't have a Windows or a mac
Answer:Good morning! Thank you for contacting us, The course is 100% online and although we recommend completing on a computer, it is available on any device as long as you have a good internet connection. Let us know if you have further questions so we may assist. Happy learning!
This was helpful.Hi The info re V-Look up is a little vague. Will the course teach me to use this functionality. Thanks Mark
Answer:In this course you will learn: To automate tasks and operations that you perform frequently. How to define and manage variables, set up subroutines, and create functions. How to use input boxes and message boxes to interact with end users. Practical methods for using macro errors to improve your VBA code. About the PivotTable object and basic approaches to utilizing it. To create cross-functional flowcharts. Let us know if you have further questions. Thank you.
This was helpful.
Reviews
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.