Are you new to Microsoft Excel? Maybe you feel like you’re missing some skills. Let’s get you emPOWERed using the web-based version of Excel!
Excel 365 Online is Microsoft’s cloud-based, easy-to-use spreadsheet program. By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulas and functions, and making a spreadsheet look professional and presentable.
Microsoft 365 (Online)
This course is intended to help all users get up to speed with Excel 365 Online.
To ensure success, participants should understand the basics of using a computer and be comfortable using the keyboard, mouse, operating system and an internet browser. All participants will be required to have either a personal or business account in Office 365.
Lesson 1: Getting Started with Access
In the first lesson, students will get comfortable opening and creating basic databases, as well as creating simple forms. They will also become familiar with the various objects that make up a database and how to use database templates.
- What Microsoft Access is
- The components that are included in a database
- Create a simple database
- Create a simple form
Lesson 2: Working with Table Data
During this lesson, students will learn various ways to work with table data, how to modify data within a table, as well as how to sort and filter those records. We will also take a look at creating lookup fields to enhance the integrity of your data.
- Work with table data
- Work with records
- Sort and filter records
- Create lookups
Lesson 3: Query a Database
Next, we go over queries and how they can be used to retrieve data from multiple tables (or other queries) in your database. Creating basic queries, as well as adding sorting, grouping, filtering, and calculation components to a query are also covered.
- Join data from different tables in a query
- Sort and filter data in a query
- Perform calculations in a query
Lesson 4: Create Advanced Queries
Then, we go over creating parameter, action, find unmatched and duplicate queries, as well as the various ways that you can summarize data in Access.
- Create parameter queries
- Create action queries
- Create find duplicate and find unmatched queries
- Summarize data
Lesson 5: Generate Reports
In this lesson, students will learn about reports and how they are used to display data in a more readable fashion. They will become comfortable creating basic reports, as well as adding controls to them. Also, changing the theme that a report uses, and preparing a report to be printed are covered.
- Create reports
- Add controls, images, and charts to a report
- Use advanced reporting
Lesson 6: Design a Relational Database
Students will become familiar with the planning processes that must be followed to successfully create a database. The fundamentals of database design with a focus on relational databases, how to create tables, manage fields, and create relationships between fields in various tables are also taught.
- Relational database design
- Create a table
- Modify a table and fields
- Create table relationships
Lesson 7: Joining Tables
There are many ways that you can join tables and their contained data. In this lesson, creating basic query joins, as well as joining tables that do not have a common field are covered. Students will become comfortable working with self-joins, subdatasheets and, also creating basic subqueries using SQL.
- Create query joins
- Work with subdatasheets and subqueries
Lesson 8: Importing and Exporting Data
In the final lesson, the many ways that you can share Access data with other applications and export into a variety of different formats are covered. Exporting data as Excel files and text files, creating a basic mail merge, as well as importing data into Access are also covered.
- Import data into Access
- Export data
- Create a mail merge
Time permitting, this is your chance to ask questions, pose business challenges and work with your instructor in a workshop-style format. This is YOUR time! Make the best of it. (Labs and materials may be shared when available.)