Microsoft Access and Microsoft Excel Mastery Bundle 2016

Microsoft Access and Microsoft Excel Mastery Bundle 2016

**This course includes practice exercises and LIFETIME access**

If you need to manipulate large buckets of data and turn them into meaningful business decisions, then this 4-course bundle showing you how to use both Access and Excel to an advanced level is for you.

We start with the basics in each program before moving onto more complex functionality such as importing data into Excel from an Access database.

Access 2016 Beginners

What you'll learn:

• What’s new in Access 2016

• How to add records, and save and delete data.

• Using Access to set-up a database (desktop or web).

• To explore the Ribbon interface and how to work with touch devices.

• Create and work with forms and sub-forms.

• Sorting data in MS Access and running queries in Access.

• How Macros work in Access 2016 and how to use them.

• How to import data from external sources.

  
  

Access 2016 Advanced

What you'll learn:

• How to effectively link to other data sources outside of Access

• How to split a database by splitting the frontend and backend.

• Dive into options for packaging your application for distribution.

• Learn to create, update and maintain macros.

• Explore the use of Visual Basic for Applications (VBA).

• Learn the advanced options for forms and queries

Excel 2016 Beginners

What you'll learn:

• How to get started with workbooks whether using a mouse or touch device.

• The new and improved features in Excel 2016.

• How to create sophisticated charts and graphs using custom visuals or templates.

• How to personalize your use of Excel 2016.

• To use autofill and flash fill to enter data quickly.

• How to apply themes and cell styles.

• Practical methods in which you can backup and recover your Excel spreadsheets.

• How to format dates and numbers

Excel 2016 Advanced

What you'll learn:

• Advanced charting and graphing in Excel

• How to use detailed formatting tools

• Lookup and advanced lookup functions

• Financial functions including calculating interest and depreciation

• Statistical functions

• Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.

• How to create awesome visualizations using sparklines and data bars

• Mastery of PivotTables and Pivot Charts

• Scenario Manager, Goal Seek and Solver

• Advanced charts such as Surface, Radar, Bubble and Stock Charts

This bundle includes:

1. 4 courses covering Excel & Access 2016

2. 36 hours of video tutorials

3. Over 240 individual video lectures

4. Exercise files to practice what you learned

5. Demo files used by the trainer

6. Certificate of completion

Here’s what our students are saying…

“I took this class as a requirement for a new job. I have never touched access before and I was able to pick it up very quickly with this video. The course flowed very nicely and started with the very basic information first before moving on to more complicated tasks. The instructor was very easy to understand and everything was presented at great pace. Since learning how to use access with this class, I have been to create my own database to practice my skills and learn new ones. I would recommend this class to anyone who would like to get a great understanding of access.”
- Greg Wehner

“Time and money well invested! I have been learning by trial and error by myself watching youtube clip. Nevertheless, I never had the impression that I mastered Access or even its basic fundamentals. One day you start to doubt that you may not have the right approach at all. A moment has come to take a break and put the time to learn things well. With this course I feel that I master the basics, but also all the little details very useful that simplifies life. We also learn several tips and tricks to start a project well and avoid getting bogged down later. Above all, I learned a lot of things that I never doubted possible. The instructor is easy to understand and easy to listen to. I devoured the sections without seeing the time pass. In short it is a very complete course and pleasant to follow. I recommend.”
- Gabriel Beaulieu

“Brilliant. Enjoyed it immensely. Learned everything I needed to know.”
- Brenda Bell

Did you know?

Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!

In this 4-course bundle we combine the power of Excel and Access to help you conquer databases and spreadsheets

Url: View Details

What you will learn

• Sorting information and running queries
• Creating tables and relationships
• Navigating the Access 2016 interface

Rating: 4.3

Level: All Levels

Duration: 43 hours

Instructor: Simon Sez IT