Already confident and want to advance your knowledge? Have a look at our Advanced Microsoft Data Analysis Bundle here.
Microsoft Data Analysis Bundle
$276.00 for 1 year
Are you ready to raise your earning potential?
Microsoft still reigns supreme in the world of data analysis. Knowing how to use these tools to extract meaningful business decisions from data could be the difference between business or career success and failure.
If you’re ready to solve complex problems using Excel, take control of your database using Microsoft Access, create compelling visualizations and reports of your data using Microsoft Power BI and automate data tasks with VBA, this four-course bundle is for you!
What you get with this Microsoft Data Analysis Bundle:
- 4 skills based, practical business courses to help accelerate your career.
- 350+ modules of training, covering the most business-relevant areas of Microsoft Excel and Business Management.
- Tailored learning. If you have some knowledge, you can use the filter to show only what you most need to learn.
- Multiple videos, practice exercises and test questions to aid your learning.
- Knowledge to understand the data that drives your business.
The courses this bundle will cover:
- How Excel works, how to navigate and design a spreadsheet
- The most popular formulas including IF, VLOOKUP, COUNT, SUM, SUMIF
- To use PivotTables, Pivot Charts and Basic Macros
- To create beautiful looking graphs and charts
- Formatting, including; conditional, cell and number formatting
- How to print what you want
Microsoft Excel is available in versions: 2003 PC, 2007 PC, 2010 PC, 2016 PC, 2013 PC, 2011 MAC, 2016 MAC
- 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.
- What variables are, and how they relate to functions versus methods and subroutines.
- To create cross-functional flowcharts
- How to set-up a database—on your desktop, or on the web.
- How to add records, and save and delete data.
- To explore the Ribbon interface and how to work with touch devices.
- To use table templates to create forms and add custom elements.
- To sort data and run queries.
- Macros and how they work.
- How to import data from external sources.
Microsoft Access is available in versions: 2013 & 2016
- How to use the Query Editor to transform and morph data into the right format for your reporting purposes.
- How to perform complex data modelling operations using relationships, calculated columns, measures, and DAX expressions.
- How to share dashboards and reports, with colleagues, business partners and potential clients.
- How to use Power BI’s sophisticated security features to control the exact content your audience can view.
- How to use Power BI Desktop, Service and Mobile Apps
- How to connect with a variety of data sources
More about us:
- We have nearly a million students
- Our training is personal. Use the filter to show you which parts of the course to skip.
- Our platform is award-winning and always improving. We work with our authors to ensure our courses are up to date.
- All of our courses are certificated on completion – most of our Business Courses are also CPD Accredited.
If you are not 100% happy with your EwB Microsoft Data Analysis Bundle, you have 30 days to exchange or refund.
