Data Master Bundle

Microsoft Excel:

• 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

Advanced Microsoft Excel:

• Use advanced graphs in minutes instead of wasting hours trying to figure them out
• Increase interactivity by automating your spreadsheets with macros and VBA
• Solve complex problems with superpower functions
• Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.
• And more!

Advanced Microsoft Excel is available in versions: 2007 PC, 2010 PC, 2013 PC, 2016 PC

Data Science:

• How to use your analytical skills to manipulate large data sets
• To develop business acumen, so findings are applicable in the real world
• To master statistics, to separate vital signals from irrelevant noise
• To grasp the basics R programming language and advanced Excel techniques

To understand the core elements of data science, allowing you to solve real business problems

Business Analysis:

• How to turn buckets of data into sound business decisions
• Financial modelling theory
• Essential Excel analysis techniques such as Dynamic Ranges, and Advanced Charts
• How to effectively and clearly present your findings to relevant stakeholders
• Different forecasting techniques, including Moving Averages and Regression

Microsoft Access:

• 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

Advanced Microsoft Access:

• How to effectively link to other data sources.
• How to split a database by splitting the frontend and backend.
• To create and maintain macros.
• The use of Visual Basic for Applications (VBA).
• Advanced options for the use of forms.
• Packaging your application for distribution.

Advanced Microsoft Access is available in versions: 2013 & 2016