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
4.41 (22 reviews)
216
students
42.5 hours
content
Nov 2022
last update
$59.99
regular price
What you will 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
Related Topics
2347050
udemy ID
5/1/2019
course created date
11/20/2019
course indexed date
Bot
course submited by