Microsoft Access and Microsoft Excel Mastery Bundle 2016

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

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I Learn?

• Sorting information and running queries
• Creating tables and relationships
• Navigating the Access 2016 interface
• Design forms and generate reports
• Learn valuable new skills for complex data projects at work
• Supercharge your database projects
• Discover how to into import data from Excel
• Learn Queries, use validations, how to create and print reports
• How to compact, repair and backup your database
• How to create a linked table
• Discover how to use the Query Wizard
• Learn to use Model Dialog and Macros
• Discover how to effectively link to other data sources.
• Learn how to split a database by splitting the frontend and backend.
• Explore the use of Visual Basic for Applications (VBA).
• Discover advanced options for the use of forms.
• Dive into options for packaging your application for distribution.
• Practice with included Access 2016 exercises files.
• Follow along with the instructor with included instructor demostration files.
• Discover advanced options and tips for building and using queries.
• Follow along as you learn to create and maintain macros.
• Complete database projects at the advanced level.
• Get helpful techniques that allow you to link, report, and package your data quickly.
• Discover new and improved features in Excel 2016.
• How to effectively use Excel 2016 on a touchscreen device.
• How create, save, and open a workbook.
• Learn how to personalize your use of Excel using Excel Options.
• How to use and how to customize the Quick Access Toolbar.
• Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
• The basics of entering and editing data in a workbook.
• Discover how to format dates and numbers.
• Learn practical methods in which you can backup and recover your Excel spreadsheets.
• Effectively use autofill and flashfill so you are more productive.
• Discover the essentials of using fomulas and functions.
• How to rename, insert, move, and reference an Excel 2016 worksheet.
• Discover how to create charts and graphs
• Learn practical methods to sort and filter your data
• How to protect and secure your Excel data
• Working with dates and times
• Averages, percentiles, and LINEST functions
• Calculating depreciation
• Using financial functions to determine payments
• Sparklines and data bars
• How to import and export data to and from Excel
• Create and effectively use pivot tables
• How to use Excel for data analysis
• Discover practical methods for financial & statistical​ Functions

Requirements

• A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases.
• Microsoft Access 2016
• Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer.

Target audience

• Anyone new to Microsoft Access
• Users new to Microsoft Access 2016 and those upgrading from previous software versions
• Anyone new to the data management role
• Anyone who wants to learn data management and Microsoft Access
• Users of earlier versions of Excel looking to update their skills.
• Those new to using Microsoft Excel 2016.
• Users who have a foundation of Microsoft Excel and seeking to take advance there Excel 2016 knowledge.
• If you want to refresh your memory and understanding of Excel.