Excel & Access: From A to Z for Work

Master Microsoft Excel and Access: Manage complex databases with hundred or millions of records

What you'll learn
Learn the two programs, Excel and Access, from beginner to advanced.
Knowing the most common mistakes that can occur at work in the use of the two programs, which prevent the accomplishment of the tasks
Having advanced skills about the two programs in managing databases
Make some tasks at work to be automatically performed
Development of analytical thinking, which helps in the use of programs
Presenting the data in a way that is as easy as possible to view
Requirements
No experience with the two programs is required, being a course that starts from beginner to advanced
The course it's for both those who have no experience at all with the two programs, but who want to learn because they are needed at work, but also for those with experience, who want to learn different more difficult cases that may occur during the tasks.
Microsoft Excel and Microsoft Access on Windows are needed. The programs on macOS can be a little bit different
Description
The course contain 2 parts:

Chapters 1-15: Microsoft Excel

Chapters 16-20: Microsoft Access

In the first part, about Excel, I will teach you all about Excel, from the simplest things, like how to create a table and how to save the file, to more difficult things, which will help you automate your work to accomplish tasks in a much easier way. I will use my 10 years of experience in this field of work, to teach you the most common mistakes that can be encountered when using Excel, and how to solve those problems.

At the end of this part you will know to:

1. Differentiate between Excel files

2. Create a table and edit it

3. Use base functions like Sum, Average, Count, IF, SumIF, SumIFS and much more, but also more difficult functions like Offset, Vlookup, Hlookup, Index & Match, DGet

4. Use the filter and sort data

5. Use Conditional Formatting

6. Use Data Validation and create different scenarios for the data

7. Use the statistical part of Excel, to apply ANOVA, Regression and other statistical tests

8. Create all the charts and to make a Dashboard

9. Protect the sheet and Workbook

10. Print

11. Use Macros and VBA: web scrapping, break the password of the Excel, automate repetitive tasks and more

12. Create UserForm

In the second part, about Access, I will cover all the Query and you will learn how to manage large database with millions of records, and how to obtain data according to requirements. This time too, you will see the common mistakes that can appear and how to solve them.

At the end of this part you will know:

1. How to create a table and edit the fields

2. How to apply restrictions for certain fields, according to preferences

3. How to import data from different programs in Access and Export data

4. How to filter data and sort them

5. How to use default Query and extracting data according to preferences, using Queries: Select, Make Table, Append, Update, CrossTab, Delete

6. How to create a Form and a Report

7. How to use scripts in module to manage data after the preferences

This course will take you from beginner level and will offer you solid knowledge about Excel and Access, which will help you achieve all the goals of managing databases. So this course it's for beginners who want to learn the two programs, but also for those who know the basics of the two programs, but want to improve their knowledge about them and to see different cases that can be encountered in a workplace.

I will be here to help you, if you have any questions or any other ambiguity about anything. Good Luck!

Credits: upklyak, pikisuperstar, slidesgo, Photoroyalty, pikisuperstar (Freepik)

Music: bensound

Who this course is for:
Both those who have no experience at all with the two programs, but who want to learn because they are needed at work, but also for those with experience, who want to learn different more difficult cases that may occur during the tasks.