|
- Excel Basic
-
Fee: $155.00
Dates: 6/15/2023 - 6/15/2023
Times: 8:30 AM - 5:00 PM
Days: Th
Sessions: 1
Building: F/PC Bldg 3
Room: 217
Instructor: Heather Severino
Students will learn how to use the Help system and navigate worksheets and workbooks. They will enter and edit text, values, formulas and pictures, and save workbooks in various formats. Students move and copy data, learn about absolute and relative references, and work with ranges, rows and columns. This course covers simple functions, basic formatting techniques and printing. Finally, students create and modify charts and manage large workbooks.
This course meets at our Flagler/Palm Coast Campus.
|
|
|
|
- Excel Intermediate
-
Fee: $155.00
Dates: 7/12/2023 - 7/12/2023
Times: 8:30 AM - 5:00 PM
Days: W
Sessions: 1
Building: F/PC Bldg 3
Room: 217
Instructor: Heather Severino
Students learn how to use multiple worksheets and workbooks efficiently, and start working with more advanced formatting options including styles, themes and backgrounds. They create outlines and subtotals, create and apply cell names and work with tables. Students save workbooks as Web pages, insert and edit hyperlinks and share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, students learn to work with PivotTables and PivotCharts.
This course meets on our Flagler/Palm Coast Campus.
|
|
|
|
- Excel Advanced
-
Fee: $155.00
Dates: 7/26/2023 - 7/26/2023
Times: 8:30 AM - 5:00 PM
Days: W
Sessions: 1
Building: F/PC Bldg 3
Room: 217
Instructor: Heather Severino
Students work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students learn about data validation and database functions such as DSUM. They import and export data, and query external databases. Finally, students learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.
This course meets at our Flagler/Palm Coast Campus.
|
|
|
|
- PowerPoint Basic
-
Fee: $155.00
Dates: 7/11/2023 - 7/11/2023
Times: 8:30 AM - 5:00 PM
Days: Tu
Sessions: 1
Building: F/PC Bldg 3
Room: 217
Instructor: Heather Severino
This course provides the foundational understanding of PowerPoint that is necessary to create and develop engaging multimedia presentations. You will develop a presentation, perform advanced text editing operations, add graphical elements, format graphical elements and prepare to deliver your presentation.
This course meets at our Flagler/Palm Coast Campus.
|
|
|
|
Introduction to Microsoft Access 2019/Office 365
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Access 2019/Office 365
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Advanced Microsoft Excel 2016
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Advanced Microsoft Excel 2016
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Advanced Microsoft Excel 2019/Office 365
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Advanced Microsoft Excel 2019/Office 365
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Access 2016
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Access 2016
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Outlook 2019/Office 365
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Outlook 2019/Office 365
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft PowerPoint 2016
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft PowerPoint 2016
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft PowerPoint 2019/Office 365
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft PowerPoint 2019/Office 365
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Word 2016
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Word 2016
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Word 2019/Office 365
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Word 2019/Office 365
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Excel 2016
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Excel 2016
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Excel 2019/Office 365
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Excel 2019/Office 365
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Project 2019/Office 365
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Project 2019/Office 365
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Access 2016
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Access 2016
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Access 2019/Office 365
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Access 2019/Office 365
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Word 2016
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Word 2016
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Word 2019/Office 365
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Word 2019/Office 365
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Excel 2016
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Excel 2016
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Excel 2019/Office 365
Fee: $129.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Excel 2019/Office 365
Fee: $129.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Microsoft Excel - Pivot Tables
Fee: $115.00
Dates: 6/14/2023 - 8/5/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Microsoft Excel - Pivot Tables
Fee: $115.00
Dates: 7/12/2023 - 9/2/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to SharePoint 2019
Fee: $79.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Master VLOOKUP in Microsoft Excel
Fee: $79.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Outlook 2019/Office 365 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Excel 2016 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Word 2016 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Excel 2016 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Microsoft Excel - Pivot Tables (Self-Paced Tutorial)
Fee: $115.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Access 2019/Office 365 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Advanced Microsoft Excel 2019/Office 365 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft PowerPoint 2019/Office 365 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Word 2019/Office 365 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Excel 2019/Office 365 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Project 2019/Office 365 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Access 2019/Office 365 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Word 2019/Office 365 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Excel 2019/Office 365 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Word 2016 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Advanced Microsoft Excel 2016 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft Access 2016 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Introduction to Microsoft PowerPoint 2016 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
Intermediate Microsoft Access 2016 (Self-Paced Tutorial)
Fee: $129.00
Dates: 5/1/2023 - 7/31/2023
Delivery Method: Online
This course is offered through our partners at ed2go. These courses are fun, fast, convenient, easy to use, and led by an expert instructor. Courses run for six weeks and you have 24/7 access to two lessons each week. Each lesson is accompanied by a short, multiple-choice quiz, and some lessons include hands-on assignments.
You will receive an e-mail with course access information upon completion of your enrollment.
Important: All online courses through the Center for Business & Industry are non-credit courses. For college credit programs and courses please visit www.DaytonaState.edu.
|
|
|
- Introduction to Microsoft Access 2019/Office 365
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
This hands-on course will teach beginners how to use Microsoft Access 2019 to build a database and customize the way data is stored. Virtually every industry can benefit from the use of Microsoft Access to organize, store, and document their essential information. Data ranging from inventory and customer information to orders details and vendors can be effectively organized with Microsoft's longstanding software. If you work with databases of any kind, learning how to use Access 2019 will add a valuable skill set to your professional profile.
This course will teach you one of the most useful skills for both job seekers and those looking for promotion. If you know how to use Microsoft Excel, learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management. Requirements:
Hardware Requirements:
- This course can be taken on either a PC, Mac, or Chromebook.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Access 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Build, edit, and maintain databases in Microsoft Access 2019 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job. Getting to Know Access 2019In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database. Controlling Your Access Table FieldsIt's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that require allow only certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-frees. Creating Tables and RelationshipsYou'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database. Building Powerful FormsIn this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and which allows you to select one or more tables' fields to include. You'll also learn how to change the form layout. Adding Versatility to FormsIn this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table. Interviewing Your DatabaseUsing queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. By following the instructions step by step, you'll first become familiar with the process, and then you'll get to create a query on your own! Taking Queries to the Next LevelA query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database. Multi-Table Query ControlIn this lesson, you'll learn to plan, build, and use queries that pull data from more than one table at a time. This gives you more power over your data and allows you to build a great foundation for truly customized reports. Reporting on Your TablesReports are easy to create and to customize. In this lesson, you'll build a simple report using the Report Wizard. Then you'll change the report's appearance, using layout view and design view. These skills provide the foundation to create and design any report you may need on any data in your database. Creating Query-Based ReportsIn this lesson, you'll create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. This makes truly customized reporting possible—and quite simple. Mastering Report DesignIn this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data. Automating Your Database With MacrosBuilding macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click. What you will learn
- Planning and building a database consisting of multiple tables
- Creating logical relationships between database tables
- Designing effective and powerful data entry forms
- Building efficient and useful queries to find and organize records
- Generation of professional-looking reports
How you will benefit
- You will be able to build and customize Access databases
- Existing Access databases will make more sense
- Gain knowledge to take a stronger role in the database maintenance
- Design professional-looking forms and reports
Laurie Ulrich
Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.
|
|
|
- Advanced Microsoft Excel 2016
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Master advanced features and functions of Microsoft Excel 2016, including data analysis tools, data tables and databases, PivotTables, custom controls, importing external data, and conditional formatting. Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed Microsoft Excel training, you'll see how to truly maximize this program's functions and capabilities. After all, most organizations rely heavily on Excel to consolidate, analyze, and report data and want their employees to be proficient in this important program. This Excel training class gives you the skills you need to impress your current or future employer—and its online format means you can take this class from anywhere, at any time.
With exercises, quizzes, and all the latest information, the best online Excel training is right here in this course. The lessons will simplify some of those tricky Excel concepts that might seem hard to grasp, so you can discover how Excel 2016 table tools actually take the complexity out of spreadsheet creation and management. When you've completed this course, you'll be able to accomplish just about everything Microsoft Excel has to offer in displaying, analyzing, reporting, and tracking data—and you'll understand it so well, you'll even be able to share your newfound skills with your friends and colleagues. Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
- PC: Windows 8 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Office Home and Student 2016 (not included in enrollment).
- Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Develop essential skills in Microsoft Excel 2016 to better consolidate, analyze, and report on data. This course provides expert instruction and hands-on exercises that will help you easily master analysis tools, PivotTables, conditional formatting, and other advanced features. Customizing ExcelIn this course, you'll explore Microsoft Excel's sometimes-overlooked and advanced features. You'll learn how to use data analysis tools and techniques to improve your decision making and practice generating accurate data more quickly. By the end of this course, you'll be well prepared to contribute more value to your organization with your advanced understanding of Excel. To kick things off, you'll spend this first lesson learning how you can modify Excel to streamline processes and make your work easier. You'll use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior, set up your Quick Access Toolbar, and take a look at the status bar and its customizable features. Mastering these processes will lay the foundation for your exploration of advanced topics throughout the course. Table ManagementIn this lesson, you'll explore some great table management features in Excel, learn how to use data forms with Excel databases, and look at a few alternative database techniques. You'll be glad to know that working with tables has become much easier in this latest version of Excel. Now, instead of applying filters, total rows, and formats separately, you can perform these actions through a single user interface. You'll also learn how data forms provide a more user-friendly method for adding, deleting, and editing records in a table, and practice using a data form to search for and view records that match specific criteria. The lesson will wrap things up with a brief look at some of the practical applications for data forms. Data ValidationIn this lesson, you'll tackle data validation techniques—your first line of defense against incorrect or missing data and the logical next step after data forms. You'll practice using whole number, decimal, date, time, list, and other forms of validation. After that, you'll explore the possibilities of custom validation, which allows you to apply validation to a cell or range of cells based on a formula you create. The possibilities for using it are limitless! You'll also learn how to create input messages and error alerts to guide the user's data entry, how to keep track of validation rules, and how to apply a custom validation rule to other cells so that you don't have to create it all over again. Custom ControlsIn the first three lessons, you learned what you might call intro-level advanced Excel topics, and now it's time to head into more complex territory. So in this lesson, you'll start working with custom controls—graphical objects that help facilitate data input and are sure to impress users. You'll start by getting your Ribbon set up to work with custom controls and then walk through some practice exercises. You'll learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes. You'll also master the process of creating a dynamic list box, which allows you to control the values in one list box based on the values chosen by your user in a separate custom control. Conditional FormattingIn this lesson, you'll discover how to use conditional formatting (and not just creating validation based on cell values!). You'll do a quick review of that process, just as a refresher, but after that you're going to focus on formula conditional formatting. You'll work through nine different practice exercises that explore row conditional formatting and then learn how the formula works after each exercise. You'll see how to use conditional formatting to hide errors, to highlight records based on multiple criteria, to track and alert you about due dates, to find the differences between two lists, to shade every other row, and more. You'll especially enjoy learning how to set up a scorecard, which will show you problem areas in red, possible problems in yellow, and everything running smoothly in green. Consolidating and OutliningIn this lesson, you'll learn how to use Excel's consolidation function to efficiently summarize data from multiple sources. A lot of people do this the hard way, but with Excel's automatic consolidation feature, you'll no longer need to develop a web of formula links to multiple sources. Goodbye, potential for human error! You'll begin with an exercise on consolidating data within the same workbook, and after that, you'll practice consolidating using an advanced technique with category labels and wildcards. Next, there will be a practice exercise on consolidating from multiple workbooks. You'll also learn how to use automatic and manual outlining to view or hide different levels or sections of your information. Excel Functions and NestingExcel's functions are too numerous to completely cover in one lesson, so this lesson will just focus on a few important ones spanning four categories: Logical, Database, Math & Trig, and Lookup & Reference. You'll start the lesson with an overview of functions, take a look at the Insert Function dialog box, and then practice working with the IF function, nesting functions, the DSUM function, and the VLOOKUP function—all of which will come in handy when you need to perform a quick, thorough analysis of your data. Import External DataIn this lesson, you'll find out all about importing external data. You'll begin with a practice exercise to get you comfortable with importing data from another Excel file, during which you'll see how to use the built-in Query Editor, which used to be an optional add-in known as Power Query. You'll test two methods for refreshing the target area for the imported data and find out how to edit any type of query. After that, you'll do an import from an external database that combines two database tables into a single import. Finally, you'll learn how to perform a web query, which—you guessed it—allows you to import data from the Internet. The web query feature is another fantastic feature in Excel. Data TablesIt's time to look at data tables, which let you compare the outcomes of different versions of the same formula without slogging through the process of calculating each of them. Data tables are very powerful what-if analysis tools that are great for analyzing potential outcomes of personal or business financial decisions. In this lesson, you'll learn how to use two types of data tables: a one-variable data table (which lets you substitute just one variable into the formula calculation) and the two-variable data table (which allows you to change multiple aspects of the formula). What-If Analysis ToolsIn this lesson, you'll explore three more of Excel's what-if analysis tools: Goal Seek, Scenario Manager, and Solver. You'll find out how to use Goal Seek to solve formulas backward—for example, you might want to do this if you knew the result you wanted but needed to determine how to change a single input cell in order to get that desired result. After that, you'll practice using Scenario Manager to create and save different input values and their results as scenarios (great for working on budgets). Finally, you'll put Excel's Solver to work to discover the optimal solution to models that have multiple variables and constraints. Advanced PivotTablesIn this lesson, you'll discover how to use PivotTables, which are excellent for summarizing massive amounts of data and viewing different cuts of the information quickly. There are two methods for creating PivotTables, and you'll practice using both. You'll also learn how to edit a PivotTable, how to filter the table to create individual reports, how to format a PivotTable to make it reader-friendly, how to insert a Timeline, and how to create and use calculated fields and items. After this, you'll create a PivotChart based on the data fields in your PivotTable. You may not be quite done with the course, but after mastering PivotTables and PivotCharts, you'll certainly be able to count yourself an advanced Excel user. Analysis ToolPak, Advanced Filter, Array Formulas, and More!The final lesson begins with a look at the functions available in the Analysis ToolPak, including two popular choices: the Moving Average and Sampling tools. You'll complete an exercise using advanced filters, and then look at some Excel tips and tricks. You'll find out how to work with the View Side by Side tool and how to use the Watch Window to keep tabs on your data when you're updating a workbook. The lesson wraps things up with practice exercises using array formulas and the AutoSum Tool. When you're done with this lesson—and the course—you'll want to pass along the techniques you've learned to friends and colleagues who are still wrestling with Excel! What you will learn
- Behind-the-scenes controls to make you more efficient.
- How to use data validation and formula conditional formatting.
- How to use functions, created nested functions, import data from multiple sources, and create different types of data tables.
- All about Goal Seek, Scenario Manager, Solver, PivotTables, PivotCharts, and the Analysis ToolPak add-in.
How you will benefit
- Become more valuable to your organization and stay ahead of your competition by learning advanced Excel techniques.
- Become more efficient in your ability to display, analyze, and report on important company data.
- Build a foundation for learning even more about Excel, or move on to other Microsoft Office programs, such as our Microsoft Word 2016 Series.
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
|
|
|
- Advanced Microsoft Excel 2019/Office 365
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
In this hands-on course, you will learn Microsoft Excel 2019's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables. Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information and other important data. Your company is probably no exception. If you work with data of any kind, learning Excel's advanced functions to taking on greater responsibilities in your organization.
This course will help you master many features in Microsoft Excel 2019 that most users don't know exist. You will learn the secret to using formula-based conditional formatting as a creative solution to common issues. You will also learn how to leverage Excel's Power Query tool to import and transform data from about any data source. By the time you finish this course, you will have mastered Microsoft Excel 2019 and will be able to better serve your company's data management needs. Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs or Chromebooks.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
- Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. In this hands-on course, you will learn Microsoft Excel 2019's advanced functions and often-overlooked features, including data analysis tools, data tables and databases, custom controls, and PivotTables. Customizing ExcelTo kick things off, your first lesson explores different ways you can modify Excel to streamline processes and make your work easier. You will use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior and set up your Quick Access Toolbar. Table ManagementThis lesson explores Excel's table management features, using data forms with Excel databases, and alternative database techniques. You'll be glad to know that formatting and working with tables has become much easier in this latest version of Excel. Data ValidationIn this lesson, you will tackle data validation techniques—your first line of defense against incorrect or missing data and the logical next step after data forms. You will practice using whole number, decimal, date, time, list, and other forms of validation. Custom ControlsThis lesson will introduce you to custom controls—graphical objects that help facilitate data input and are sure to impress users. You will learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes. Conditional FormattingThis lesson will teach you how to use conditional formatting. You will learn how to use conditional formatting to hide errors, to highlight records based on multiple criteria, to track and alert you about due dates, to find the differences between two lists, to shade every other row, and more. Consolidating and OutliningIn this lesson, you will learn how to use Excel's consolidation function to efficiently summarize data from multiple sources. Many Excel users do this the hard way, but with Excel's automatic consolidation feature, you will no longer need to develop a web of formula links to multiple sources. Excel Functions and NestingExcel's functions are too numerous to cover in just one lesson, so this lesson focuses on a few important ones spanning four categories: Logical, Database, Math & Trig, and Lookup & Reference. Import External DataThis lesson focuses on importing external data. You will learn how to use the built-in Query Editor using Excel's powerful Power Query tool and import external database that combines two database tables into a single import. Data TablesData tables are very powerful what-if analysis tools that are great for analyzing potential outcomes of personal or business financial decisions. In this lesson, you will learn how to use two different types of data tables. What-If Analysis ToolsThis lesson explores three more of Excel's what-if analysis tools: Goal Seek, Scenario Manager, and Solver. Advanced PivotTablesIn this lesson, you will discover how to use PivotTables, which are excellent for summarizing massive amounts of data and viewing different cuts of the information quickly. There are two methods for creating PivotTables, and you will practice using both. Analysis ToolPak, Advanced Filter, Array Formulas, and More!Your final lesson with a look at the functions available in the Analysis ToolPak, including Moving Average and Sampling tools. You will learn how to use the View Side by Side tool and how to use the Watch Window to keep tabs on your data when you're updating a workbook. What you will learn
- The power of what-if analysis tools like data tables, Scenario Manager, Solver, and Goal Seek
- To build creative formulas with conditional formatting to solve common problems
- To import and transform external data from multiple external sources
- To combine multiple Access tables into a single table using Power Query
How you will benefit
- Master Excel 2019 and become a more productive member of your organization
- Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting
- Learn to use the power of Microsoft Excel 2019 to save time, money and frustration
- Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
|
|
|
- Introduction to Microsoft Access 2016
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Learn to build, edit, and maintain a database in Microsoft Access 2016, complete with tables, reports, forms, macros, and queries to give you fast access to all your important information. Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records.
Through easy-to-follow, step-by-step instructions, this course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage. Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- PC: Windows 8 or later.
- Mac: macOS 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Access 2016 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Build, edit, and maintain databases in Microsoft Access 2016 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course provides you with the skills to create an effective database for any type of information at home or on the job. Getting to Know Access 2016In this lesson, you'll find out what Access is and how individuals, businesses, and organizations use it to store information. You'll begin to build an Access database, including all the components that turn a list of records into reports, forms, and queries. You'll start by opening the application and creating a new database. Controlling Your Access Table FieldsIt's time to lay down the law! In this lesson, you'll impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers. You'll also set up rules that only allow certain kinds of data in certain fields. With just a few minutes of work, you can make data entry simpler, clearer, and practically error-free. Creating Tables and RelationshipsIn this lesson, you'll create additional tables for the class database, customize them along the way, and then build relationships between them. This all paves the way for later database features, such as reports, queries, and forms that draw from multiple tables in the database. Building Powerful FormsIn this lesson, you'll use forms for data entry and for viewing records in your tables. You'll meet the Form Wizard, which makes form building fast and easy and allows you to select one or more tables' fields to include. You'll also determine the form layout. Adding Versatility to FormsIn this lesson, you'll add buttons and controls to forms. You'll also adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table. Interviewing Your DatabaseUsing queries to sort, filter, and search your database is one of the most important skills you'll master in this course. In this lesson, you'll create queries that search for specific data. You'll also customize how Access displays that data. You'll follow instructions step by step so you gain confidence with the process, and then you'll get to create a query on your own! Taking Queries to the Next LevelA query that puts specific records in order or finds all the records that have a general piece of information in common is, well, pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see. In this lesson, you'll create queries that give you true power to search your database. Multi-Table Query ControlIn this lesson, you will learn to plan, build, and use queries that pull data from multiple tables simultaneously. This gives you more power over your data and allows you to build the foundation for truly customized reports. Reporting on Your TablesReports are easy to create and customize. In this lesson, you will build a simple report using the Report Wizard. Then you will change the report's appearance, using layout view and design view. These skills are foundational to creating and designing reports for any data in your database. Creating Query-Based ReportsIn this lesson, you will create reports that are based on the results of queries you create to sort and filter your database. Because queries can combine data from multiple tables, filter for specific data, and sort the results, your report reflects just the data that meet the query's criteria. Mastering Report DesignIn this lesson, you'll plan and create a completely customized report, using a specialized query that controls which data the report includes. You'll add fields that perform calculations on your data. You'll customize your report's layout, too, using design view's many tools for controlling the structure and appearance of your data. Automating Your Database With MacrosBuilding macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click. What you will learn
- Learn to build and customize tables to store data
- Learn how you can use relational databases to build forms, generate reports, and search for data with queries across thousands of records in hundreds of tables
- Discover how to use macros to automate repetitive tasks and increase your efficiency
- Develop not only strong Access skills, but a solid understanding of good database design concepts
How you will benefit
- Understand how to organize and assemble an effective database for any kind of information you need to store, document, and manage
- Gain confidence in your use of Microsoft Access
- Become more productive and efficient in organizing, managing, and reporting on data both personally and professionally
Laurie Ulrich
Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.
|
|
|
- Introduction to Microsoft Outlook 2019/Office 365
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Are you overloaded with emails, meetings, and to-do lists? Make use of Microsoft Outlook 2019 functions, and you will rapidly increase your efficiency and productivity. Whether for personal use or work, everyone needs to stay organized. In today's world, being organized means tracking email messages and appointments, storing names and contact information of important people, and creating to-do lists to help you complete various types of projects for yourself or your job.
Many people rely on Microsoft Outlook 2019, a unique tool to help you manage email, appointments, tasks, and contacts in a single program. In this course, you'll learn how to use Microsoft Outlook 2019 for Windows.
You will learn to save, sort, organize, and read email messages. Set appointments along with reminders, so you'll never miss an important date! Store and search through names of important people and their contact information, and create task lists to help you make progress on different projects. By the end of the course, you'll master how to effectively navigate Outlook's four main features: Mail, Appointments, People, and Tasks.
Besides learning how to create email messages, appointments, task lists, and contact information, you'll also learn how to search and find information and sort and organize data. Whether you need to manage your personal life or your professional world, the step-by-step lessons in this course will help you master Outlook for use at home or work. Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs and Chromebooks are not compatible.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
- Microsoft Office Outlook 2019 (not included in enrollment)
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. This Microsoft Outlook training class introduces the 2019 interface and will get you up and running quickly, working effectively with messages, calendars, and contacts. Getting Started with Outlook 2019In this lesson, you'll get acquainted with Outlook. You'll go over the basics of what Outlook can do and how you can use it to save time and keep yourself organized. You'll also get familiar with Outlook's user interface to help you feel comfortable using the program. After you finish this lesson, you'll be ready to start using Outlook and switching between its different functions (Mail, Calendar, People, and Tasks). Reading Email MessagesThis lesson will help you make sense of all your email messages without forcing you to scroll through a long list of messages. You'll learn how to display, sort, and organize email messages. Since email is the most popular way to communicate with people anywhere globally, learning how to read and organize email in Outlook could be the feature you'll use most often. Finding and Grouping MessagesReceiving email is always fun, but finding ways to search through all your email messages to find what you need can spell the difference between using email as a powerful communication tool or getting lost in the daily flood of email messages. In this lesson, you'll learn how to search, tag, and select email messages and move them to a folder. You will also explore strategies for labeling and organizing email messages. Creating Email MessagesBy receiving email messages and responding to them or simply writing new email messages all your own, you can turn your email account into a two-way communication medium to reach out to people anywhere around the world. In this lesson, you'll learn different ways to create and reply to messages. You will also identify ways to edit and send email messages. Formatting Email MessagesIn this lesson, you'll learn how to format text in your email messages to make your messages more appealing and readable. Formatting text doesn't just mean improving cosmetic appearances but can also mean displaying text in an organized fashion, so it's easier to read. You will identify ways to improve email messages through the use of different fonts, colors, and styles, as well as the use of spelling and grammar checks. You'll also learn how to use bulleted and numbered lists to ensure your emails are easy to read and understand. Editing Email MessagesThis lesson is all about polishing your text, so everything is correct. After all, your words may be powerful, but if there are typos or grammatical mistakes, your email message can look less valid and legitimate. In this lesson, you'll learn different ways to proofread and edit email messages. You'll explore the search and replace feature, learn how to create hyperlinks for email and website addresses, learn how to use the signature feature, and explore different styles for your email messages. Sending Attachments to Email MessagesSending email messages with file attachments lets you communicate with others using more than just what you can type. You can share a spreadsheet for others to edit, send someone an interesting PDF file to read, or give someone a short video of yourself wishing him a happy birthday. In this lesson, you'll learn how to add files such as word processor documents, spreadsheets, databases, or presentations along with video and audio files to your email messages. You'll also learn how to add images to email messages and edit these using word wrapping and other methods. Dealing with Wanted and Unwanted EmailIn this lesson, you'll learn how to deal with both wanted and unwanted email messages so you can focus your time on having fun and being productive. You'll learn how to delete and retrieve email messages, as well as how to archive them. Most of your email messages will likely be those you want to receive, but too many of them can make it difficult to find what you need, so you will also learn the benefits of creating rules for sorting emails so you can deal with junk email messages easier. Storing Contact InformationOutlook offers a way to store names and contact information in a database. Not only can this database grow as large as necessary, but no matter how big it gets, Outlook still makes it easy for you to search and find the information you need quickly and accurately. In this lesson, you'll learn all about using Outlook to store contact information of the people most important to you for business and personal use. You'll learn how to create and keep contacts, sharing and search contacts, and group and sort contacts. Using the Outlook CalendarEveryone needs to meet people or be at a certain place at a specific time. For busier people, your scheduled appointments may become so numerous and varied that keeping track of your time can be cumbersome. In this lesson, you'll learn all about using Outlook's calendar feature to create and store appointments. You'll identify the different ways to view and use the calendar. You'll also explore setting and viewing appointments, as well as managing, editing, and sharing these appointments. Creating Task ListsIn this lesson, you'll learn all about using Outlook to create tasks that can help you stay focused on achieving the goals you want to achieve. Outlook makes it easy to create and store your list of tasks that you can view whenever you use Outlook. In this lesson, you'll learn how to create a task list, tag and add details to a task, and manage your tasks. Outlook's task list is just one more tool to help you keep your life organized and focused. Taking Notes and Customizing OutlookOnce you learn how to use Outlook's note-taking feature, you can learn different keystroke shortcuts and how to customize Outlook further to serve your particular needs better. In this lesson, you'll identify ways to create and modify notes. You'll also identify keystroke shortcuts and how to use these. Along with this, you'll learn different ways to customize Outlook's user interface and change Outlook's settings. You'll also have a chance to reflect on Outlook's various features you find most valuable and then decide how you plan to customize Outlook to make it easier for you. What you will learn
- Understand the basics of the Outlook 2019 interface and how to navigate the program
- Create a standard Mail view to work from and learn the basics of sending and receiving email
- Get to know everything you need to know about Outlook's contacts, Contacts views, Contact Groups, and Address Books
- Learn how to link Outlook to social media sites, and find out how information from People can appear throughout Outlook
- Learn how to work with one or more Outlook Calendars and the associated items: appointments, meetings, and events.
- Learn how to work with Outlook tasks and to-dos
- Learn how to customize Outlook
How you will benefit
- Harness the full power of Outlook 2019 so you can be more productive
- Learn to better communicate and keep track of all your responsibilities
Wallace Wang
Wallace Wang is the author of over 40 computer books, including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghostwritten several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
|
|
|
- Introduction to Microsoft PowerPoint 2016
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-looking presentations using slide and layout masters that make global changes in a snap. Take your PowerPoint presentations from ordinary to extraordinary! In these lessons, you'll learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.
You'll see how to plan a presentation for your audience, format it with themes and color, and use the slide master and layout master to make global changes. You'll embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt, and learn to add multimedia effects to create animated presentations and more. If you want to become a PowerPoint pro, this is the course for you! Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
- PC: Windows 8 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Office Home and Student 2016 or a subscription to Office 365 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Take your presentations from "so-so" to sensation with PowerPoint. This course will help you discover how to use Microsoft PowerPoint 2016 to create professional-quality slide presentations that grab attention from start to finish and make your message memorable. The PowerPoint 2016 InterfaceCome explore the basic features of Microsoft PowerPoint 2016! You'll learn about the Ribbon, which replaces the menu and toolbars so common in other programs written for the Windows operating system. You'll find out how to plan a presentation and start the PowerPoint program and practice working with different views, task panes, tabs, and templates. Creating PresentationsNow that you know the basics of PowerPoint, it's time to create a presentation from scratch. You'll start by choosing a theme for the presentation and create slides with a variety of slide layouts. You'll find out about the Live Preview feature and learn how to save a file so that you can find it later. You'll also create and edit slides in the slide pane and in Outline view. Finally, the lesson will go over the ways to put on a slide show. Creating and Editing Tables and Opening and Saving FilesIncluding tables in your presentation lets you present a lot of information in a little space. So in this lesson, you'll add, revise, and format tables. You'll also learn multiple ways to open a presentation. Then, the lesson will teach you how to preserve different versions of your work by saving with different filenames. Creating and Printing Error-Free PresentationsThis lesson will cover two topics: printing and proofreading. You'll learn to print your presentation as slides, handouts, an outline, and notes pages. This versatility will really help you connect with audience members! To make sure your printed presentation is as close to perfect as it can be, you'll explore the Spelling, AutoCorrect, and Thesaurus features, along with the new Smart Lookup feature. Working With Saved and Online ImagesYou're going to switch gears in this lesson and work with images instead of text, which you'll probably enjoy. You'll see how to embellish your slides with media clips, which could include illustrations, clip art, and photographs. You'll even learn how to download an image from a website and insert the image on a slide. WordArt, Shapes, and SmartArtYou're going to work with WordArt, Shapes, and SmartArt Graphics in this lesson, which is very exciting. It's fun to transform text into colorful WordArt objects and to draw and fill shapes with color and special effects. You'll learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics. Creating and Editing a ChartIn this lesson, you'll create and edit a chart slide to illustrate statistical data. You'll find this lesson easy if you like working with numbers! If you don't enjoy math, that's okay—the lesson will walk you through everything you need to know and do to create a chart slide. It will also show you how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons. Making Global Changes to a PresentationMaking the same changes to dozens of PowerPoint slides is boring and time-consuming. In this lesson, you'll look at global changes you can make to your slides, handouts, and notes. For example, if you want to increase or decrease the font size on all the slides in a presentation, just make the change on the slide master. You'll also make global changes when you modify your presentation's theme colors or background. Creating LinksIn this lesson, you'll work with hyperlinks and action buttons. You'll enliven your presentation as you learn to create links from text or objects to other slides, presentations, documents, and web pages. You can even add sounds and 3D effects! Applying Animation to Slides, Text, and ObjectsHave you seen a presentation where text, images, or entire slides fly in from the top or push up from the bottom? That's animation. In this lesson, you'll learn about slide transitions, the options on the Transition tab, and you'll apply animation to text and objects on slides and the slide or layout master with the options on the Animations tab. You'll then find out how to add sound effects, such as chimes and whooshes, to slide transitions. Perhaps most important, you'll also learn how to avoid overdoing these effects! Applying Advanced Animation Effects to Text and ObjectsYou already know how to apply animation to your slides as they transition. Now it's time to apply advanced animation effects to text and objects on slides and slide and layout masters. With the animation commands and the Animation Pane, you'll add and reorder animated text and objects on slides. You'll also add an audio clip to your presentation. Sharing and Saving Your Presentations, Including OneDrive and Office OnlineNow that you know so much about creating PowerPoint presentations, you'll focus on different ways to save and share them. You'll see how easy it is to export your presentation as a PDF file, so it'll be accessible on computers that don't have PowerPoint 2016. You'll learn to open, edit, and share your presentation online with a Windows OneDrive account and PowerPoint Online and how to turn your presentation into a video. What you will learn
- Learn how to plan a presentation for your audience
- Understand how to format it with themes and color and use the slide master and layout master to make global changes
- Explore how to embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt
- Learn to add multimedia effects to create animated presentations
- Explore the options on the PowerPoint Ribbon, including the new Online Pictures command, File menu options, and Backstage View
- Learn how to print slides, handouts, and even an outline
- Discover the best view for creating and editing your slides and running your presentations
How you will benefit
- Master PowerPoint skills that will help you produce better presentations
- Become an integral team member at your company with professional presentation design skills
- Gain skills that will transfer to any organization and will look great on your résumé
Kathy Van Pelt
Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.
|
|
|
- Introduction to Microsoft PowerPoint 2019/Office 365
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
As technology transforms business practices, Microsoft PowerPoint remains one of the most commonly used tools for presentations. This course is perfect for beginners wanting to learn how to effectively use Microsoft PowerPoint 2019 to create professional presentations. This in-depth course introduces PowerPoint's functions and will teach you how to plan and create professional-quality presentations. You will learn how to catch your audience's attention with PowerPoint's visual features like photo album. As you become acquainted to Office 365, you will learn how to utilize OneDrive and PowerPoint Online's cross-functionality—saving, editing, and sharing your presentations online.
This course is perfect for beginners looking to learn how to use the latest PowerPoint software. You will have the opportunity to create a custom presentation with content specific to your needs. By completion, you will be able to create captivating presentations and contribute to your company's business processes. Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft PowerPoint 2019 (desktop version) available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Make presentations go from "so-so" to sensation with PowerPoint. This course will help you learn to use Microsoft PowerPoint 2019/Office 365 to create professional-quality slide presentations that grab attention and make your message memorable from start to finish. The PowerPoint 2019 InterfaceThis lesson explores the basic features of Microsoft PowerPoint 2019. You'll explore the Ribbon and learn how to start the PowerPoint program and plan a presentation. You'll also practice working with different views, task panes, tabs, and templates. Creating PresentationsNow that you know the basics of PowerPoint, it's time to create a presentation from scratch. You'll start by choosing a theme for a presentation and create slides with a variety of slide layouts. You'll explore the Live Preview feature and learn how to save a file for future use. You'll also create and edit slides in Slide pane and Outline view. Finally, you'll explore ways to play a slide show. Working With Files and Creating and Editing TablesIncluding tables in your presentation lets you present a lot of information in a compact space. In this lesson you'll add, revise and format tables. You'll also explore multiple ways to open a presentation. Then, you'll learn how to preserve different versions of your work by saving with new file names. Creating Professional PresentationsThis lesson covers two topics: proofreading and printing. You'll explore the Spelling, AutoCorrect, Thesaurus and Smart Lookup feature. You'll learn to print your presentation as slides, an outline, handouts and notes pages. This versatility really helps you connect with audience members! Working With the Images GroupThis lesson switches gears and works with images instead of text. You'll learn how to embellish your slides with media images, including online pictures, Icons, 3D models and photographs. You'll also learn how to download an image from a website and insert the image on a slide. WordArt and the Illustrations GroupThis lesson includes instructions for using WordArt, Shapes, Icons, 3D Models and SmartArt Graphics. You'll then learn how to transform text into colorful WordArt objects and add Icons and 3D Models. You'll also practice drawing and filling shapes with color and special effects. Finally, you'll learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics. All About ChartsIn this lesson, you'll create a chart to illustrate statistical data. You'll explore chart components and learn how to add and edit specific chart elements. You'll discover how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons. Making Global Changes to a PresentationMaking duplicate changes to dozens of PowerPoint slides is boring and time-consuming. This lesson focuses on making global changes to slides, handouts, and notes. You'll also make global changes to modify your presentation's background or theme colors. Creating LinksIn this lesson, you'll work with hyperlinks and action buttons. Enliven your presentation as you create links from text or objects to other slides, presentations, documents, and web pages. You can add sounds and 3D effects if desired. Also introduced in this lesson is the Zoom feature which sets up presenter-driven links between slides in a presentation. Applying Animation to Slides, Text, and ObjectsThis lesson explores slide transitions and the Transition tab options. You'll apply animation to text and slide objects and use the Animations tab to add animation to slide or layout masters. You'll also find out how to add sound effects, such as a chime or coin sound, to slide transitions. Adding Advanced Animation Effects to Text and ObjectsUsing the Animation Pane, you'll add and reorder animated text and objects on slides. You'll discover how to apply advanced animation effects to text and objects on slides, and slide and layout masters. You'll also add an audio clip to your presentation. Sharing and Saving Your PresentationsIn this lesson, you'll focus on different ways to save and share a presentation. You'll practice converting a presentation into a PDF file, so it's accessible on computers without PowerPoint 2019. You'll learn to open, edit, and share your presentation online with PowerPoint Online and a Windows OneDrive account. Last, you'll learn how to transform your presentation into a video. What you will learn
- Planning and presentation skills
- Formatting a presentation with themes and colors, and use slide and layout masters
- How to utilize text and objects, including Icons, 3D Models, WordArt and SmartArt
- Explore the options on the PowerPoint Ribbon, including the Online Pictures command, File menu options, and Backstage View
- Learn how to print slides, handouts, notes and an outline
- Discover the best views for creating and editing slides, and running a presentation
How you will benefit
- Master PowerPoint skills that help you produce better presentations
- Become an integral company team member with professional presentation design skills
- Gain skills that transfer to any organization and look great on your résumé
Tracy Loffer
Tracy Loffer holds a master's degree in Education in Curriculum and Instruction. She has been involved in education for twenty years, as a music educator and technology trainer. She has also worked in the private sector as a trainer of domestic and international technology franchisees as well as a writer and developmental editor of educational technology materials.
|
|
|
- Introduction to Microsoft Word 2016
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Learn to use the basic features of Word 2016 (now available through Office 365) to type, edit, format, spell check, and print professional-looking documents, letters, and reports. One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016, now available through Office 365. In this course, you will gain the foundational skills you need to make the most of this powerful program.
Through hands-on instructions, you will learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously; and format your text. You will also see how to save, retrieve, copy, organize, and print your documents.
You will learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.
By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You will also explore the program's thesaurus feature, which can help you find exactly the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, you will be able to use Word confidently at home or on the job. Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
- PC: Windows 8 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Word 2016 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Microsoft Word is used in nearly every modern workplace. In this course, you will master all the basics of this powerful word-processing program, including how to type and edit text, and how to format, spell check, and print documents. You will also learn dozens of different ways to modify the appearance and content of your documents and how to catch errors with Word's spell and grammar checker. After completing the course, you will be able to use Word confidently at home or on the job. Getting StartedIn this introductory lesson, you will learn how to use the different parts of Word 2016's user interface, how to look at your document from different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs. Typing and NavigationThe whole purpose of Word is to let you create and edit text. This lesson introduces the basics of moving the insertion point and deleting text. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word. File ManagementIn this lesson, you will learn how to save the documents you create in Word. You will also learn how to rename, copy, and even delete any files you have created, so you will always be in complete control of all the files you create. Editing TextAfter you've typed some text in a Word document, you may need to edit that text. This lesson focuses on editing text. The easiest way to edit text is to delete it, but a more sophisticated way to edit text is to copy text and paste a duplicate of that text in another location. Working With Multiple DocumentsMost people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This lesson will teach you how to open, switch between, and view multiple documents. Text Formatting and AlignmentOnce you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change text size and alignment, and even modify fonts. PrintingMost people use Word to print letters and reports. In this lesson, you will learn about the different ways you can print a document, such as portrait orientation or landscape orientation. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents. Margins, Tabs, and Page NumberingBy knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you will also learn how to add page numbers to the top or bottom of a page to keep track of page order. Paragraph FormattingWord provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and number lists, so you can display short bits of information in a visual manner. Language ToolsFor important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document. Customizing WordWith Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard. Making a Word Document Pretty and OrganizedFinally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible. What you will learn
- Learn the fundamentals of one of the most crucial software applications in the modern workplace
- Acquire the skills and learn the tools you will need to adjust margins, spacing, layout, and design of any Word document
- Learn how to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
- Explore the many ways to modify the appearance of your documents in order to suit your individual needs
How you will benefit
- Gain the confidence you need to make the most of this indispensable software application
- Learn how to make the perfect layout for useful documents of any occasion - resumes, invitations, letters, articles, training materials, and much more
- Save time and avoid frustration by familiarizing yourself with the wide variety of tools at your disposal in Word 2016
- Become more proficient and efficient at one of the most widely used software programs in history
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
|
|
|
- Introduction to Microsoft Word 2019/Office 365
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Learn how the foundational skills needed to utilize Microsoft Word 2019. This course will teach you how to create professional-looking letters, reports, and documents. Across all industries, the ability to create documents in a word processor is essential in day-to-day functions. From writing reports to Knowing how to use Microsoft Word, the most widely-used word processing program, adds an important skill set to your professional profile.
This course will introduce you to the 2019 version of Microsoft Word. You will learn the basics of Word 2019 needed to write and edit text and to create, format, and organize documents. By the time you're done with these hands-on activities, you will be able to use Word confidently at home or on the job. Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs and Chromebooks are not compatible.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
- Microsoft Word 2019 (desktop version) available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Learn to create professional-looking letters, reports, and documents using Microsoft Word 2019. This hands-on course will help you master the basic features of this powerful word-processing program to type, edit, and format text, and spell check and print documents like a pro. Getting StartedIn this introductory lesson, you'll learn how to use the different parts of Word 2019's user interface, how to look at your document in different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs. Typing and NavigationThe whole purpose of Word is to let you create and edit text, so in this lesson, you'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word. File ManagementIn this lesson, you're going to learn how to save the documents you create in Word. You'll learn how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so that you'll always be in complete control of all the files you create. Editing TextAfter you've typed some text in a Word document, you may need to edit that text. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word. Working With Multiple DocumentsMost people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word. Text Formatting and AlignmentOnce you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing. PrintingMost people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word. Margins, Tabs, and Page NumberingMost of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document. Paragraph FormattingWord can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and numbered lists, so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs. Language ToolsIt's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature, so you can see exactly what and who changed the document. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word. Customizing WordWord can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard. Making a Word Document Pretty and OrganizedWriting involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible. What you will learn
- Fundamentals of one of the most crucial software applications in the modern workplace
- Skills and tools needed to adjust margins, spacing, layout, and design of any Word document
- How to work on multiple projects at once and become faster and more efficient in a variety of Microsoft Word tasks
- Techniques for modifying the appearance of your documents in order to suit your needs
How you will benefit
- Gain the confidence needed to make the most of this indispensable software application
- Learn how to make the perfect layout for useful documents of any occasion - resumes, invitations, letters, articles, training materials, and much more
- Save time and avoid frustration by familiarizing yourself with the wide variety of tools at your disposal in Word 2019
- Become more proficient with one of the most widely used software programs in history
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
|
|
|
- Introduction to Microsoft Excel 2016
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Discover how to create worksheets, workbooks, charts, and graphs quickly and efficiently in Microsoft Excel 2016, now available through Office 365. If you work with numbers, you need to master Microsoft Excel 2016! This hands-on course will teach you dozens of shortcuts and tricks for setting up fully-formatted worksheets quickly and efficiently. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.
In addition, you will get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. You will also learn Excel 2016 features, including Quick Analysis, Flash Fill, and new charting capabilities.
This is not a tutorial, but an in-depth class. By the time you're done, you will be using this vital Office 2016 application like a pro. Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
- PC: Windows 8 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Office Home and Student 2016 (not included in enrollment).
- Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Learn to quickly and efficiently use Microsoft Excel 2016 and discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro. Excel BasicsThis lesson will help you develop a solid understanding of the Excel interface. You will become fluent in the secret language spoken only by Excel users and discover the best way to correct any mistake you made in Excel. Creating a WorksheetIn this lesson, you will learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully-formatted. Time-SaversThis lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. You will also spend some time working with the Quick Analysis and Flash Fill tools, introduced in Excel 2016. Relative, Absolute, Mixed, and Circular ReferencesDo you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. This lesson focuses on writing formulas that can help ease through some rather sticky scenarios. Three Dimensional WorkbooksWith enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Sorting, Subtotaling, and FilteringNo Excel course would be complete without a lesson on Excel's data-crunching capabilities. In this lesson, you will not only learn how to build a database in Excel, but how to subtotal, sort, and filter. Charting BasicsThis lesson introduces the various charts available in Excel. You will build your first graph in this lesson, and you will learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart. Advanced Charting TechniquesThis lesson explores everything from bar charts and line charts to more prosaic graphs like the pie chart, the bubble chart, and 3D charts. You will find out how to personalize your charts and discover the best ways to print or otherwise display the truly impressive charts that you will be creating. Intro to Excel's Statistical FunctionsExcel includes many powerful functions that can automatically perform complicated tasks for you. This lesson introduces helpful ways to put these functions to work. You will find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics. Financial FunctionsThis lesson provides an in-depth look at Excel's financial functions. By the time this lesson is over, you will be able to figure out how much money you will have when you retire, when your kids reach college, or just before your next vacation. Worksheet AutomationThis lesson introduces automation. You will discover how to move your most frequently used commands from their present locations to a much more convenient place: the toolbar. You will also learn how macros can be used to reduce just about any complex task to a single keystroke. Mastering Excel's IF FunctionIn your final lesson, you will learn how to teach Excel to make and act on certain decisions. You will learn how to utilize a function that allows Excel to make comparisons and use that comparison as the basis for important decisions. What you will learn
- Learn shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently
- Discover how to quickly and automatically calculate statistics, loan payments, future value, and more
- Learn how to best sort and analyze date, create charts and graphs, and automate often repeated tasks
How you will benefit
- Learn to use Excel 2016 and become a more productive member of your organization
- Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting
- Learn to use the power of Microsoft Excel 2016 to save time, money and frustration
- Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
|
|
|
- Introduction to Microsoft Excel 2019/Office 365
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
If you work with data of any kind, knowing how to create a spreadsheet is key to effectively managing and organizing information. This course will introduce you to Microsoft Excel 2019 and teach you how to use this powerful software. Do you manage large sets of numbers, names, dates, or other pieces of information? If so, then you need to create worksheets to manage, store, organize, and even analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel.
If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool. Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs or Chromebooks.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
- Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Learn to quickly and efficiently use Microsoft Excel 2019 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro. Excel BasicsIn this lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas. Creating a WorksheetIn this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted. Time-SaversThis lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. You'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro. Relative, Absolute, Mixed, and Circular ReferencesDo you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. In this lesson, you'll learn to write sophisticated formulas that can help ease you through some rather sticky scenarios. Three-Dimensional WorkbooksWith enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. In this lesson, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks. Sorting, Subtotaling, and FilteringNo Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter. Charting BasicsIn this lesson, you'll explore the exciting world of charts. You'll build your first graph and learn how easy it is to adjust the chart type, labels, titles, colors, and other aspects of your chart. Advanced Charting TechniquesIn this lesson, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating. Intro to Excel's Statistical FunctionsExcel includes many powerful functions that can automatically perform some very complicated tasks for you. In this lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers. Financial FunctionsYou'll continue your exploration of Excel functions with an in-depth look at Excel's handy financial functions. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time. Worksheet AutomationIn this lesson, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke. Mastering Excel's IF FunctionYou'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions. What you will learn
- How to create worksheets, charts, and graphs
- Methods for sorting and analyzing automating often repeated tasks
- How to parse data with Flash Fill
- Important keyboard shortcuts
How you will benefit
- Knowing how to use Excel 2019 will make you a more productive member of your organization
- Gain indispensable skills that will be useful for numbers-based reporting
- Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
|
|
|
- Introduction to Microsoft Project 2019/Office 365
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Discover how to effectively plan and implement projects using the world's most popular project management software, Microsoft Project 2019. Microsoft Project is a staple for project management and remains the most widely-used project management software across all industries. If you manage projects in your organization, learning how to use this longstanding resource is key to successfully and effectively seeing your projects through to completion.
In this course, you will discover how to effectively plan, implement, and control projects using Microsoft Project 2019. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress and revising your project plan, Microsoft Project can help you organize all your project's details.
Armed with this information, you will avoid stalling or overloading your schedule. If you encounter trouble, you will know how to best utilize Project 2019 to get your project back on track. Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Project 2019 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track. Overview of Microsoft ProjectMicrosoft Project can help you manage your project's schedule, costs, and scope in a way that you've never dreamed of. Too often, Project users never use this powerful tool to its fullest potential. In this lesson, you'll discover how to improve your project by adopting a formal management approach. You'll get a quick overview of Project Management, and then you'll learn the basics of Microsoft Project, including a summary of the Gantt Chart view and ways to create and enter project tasks. Creating a Solid FoundationIf you're looking for ways to keep organized, you'll see just how to do that in this lesson! You'll go through the steps to create a project schedule in no time flat. Once you create and enter tasks in Project's Gantt Chart view, you'll set a schedule by using a calendar and assigning lead times. Then, you'll need to create task dependencies, sometimes known as links. You'll see how to perform these activities and, in the process, you'll become comfortable using Project's many dialog boxes. Before you know it, you'll be creating schedules for all your projects with little effort. Creating and Managing ResourcesYou won't get too far with your project without adding resources. While tasks create the backbone of your project, you'll also need people, equipment, and materials to bring your project to life. In this lesson, you'll find out how to apply two types of Project resources—work resources, and material resources. You'll look at two more dialog boxes—Resource Information and Assign Resources—and you'll learn how to analyze resources by using the Resource Sheet and Resource Usage views. Defining and Assigning CostsNo matter what project you work on, the bottom line is always important. So, get ready to add the final piece to your basic project schedule—costs. You'll start things off by looking through a brief overview of cost accounting, exploring fixed, variable, relevant, and accrued costs. After this review, you'll learn how to assign costs by using the Resource Sheet. You'll even discover how to assign different costs for the same resource and analyze the overall costs for your project by using the Cost Table. Project Templates, Security, and ConstraintsSuccessful project managers are known for their efficiency and for safeguarding private information. Microsoft Project provides two excellent methods to help you in these areas: project templates and project security. You'll find out how to use some of the many templates Project has to offer, including the Residential Construction template and the New Product template. You'll also learn how to protect your project information with backups, passwords, and write protection. Then you'll discover how to put Project's task constraints to good use. Working With Views and Managing InformationIn this lesson, you'll discover how easy it is to modify your basic schedules and work with project data. You'll look at the various Project views, such as the Calendar, Leveling Gantt, and the Network Diagram. If you don't like the default colors or fonts in your schedule or table, you'll be well-prepared to make changes. You'll even learn how and why you might want to create a combination view; add notes to your project; or sort, filter, and group data. Fine-Tuning Your Project PlanMany projects experience schedule compression when management or clients ask that the project be completed sooner and for less. In this lesson, you'll discover how to improve your schedule's performance. You'll explore the Project Statistics dialog box, and you'll learn how to determine the ideal starting point in terms of planned costs and completion dates. You'll see how to change task dependencies to speed up your project and also find out how to split tasks to add more lead time. You'll also learn how to create recurring tasks and attach notes to your project's taskbars. Baselines and TrackingBefore you implement your project, you need to create a baseline. This will help you track actual results against what you originally set out to accomplish. Microsoft Project makes it possible to set up a baseline with a few mouse clicks. You'll learn how to create a baseline and then see a variety of ways, including using the Tracking toolbar, to record your actual project results. Managing VariancesHere's where things really start to come together! You'll learn how to compare actual results to your baseline by using the Gantt Chart and reviewing a table. You'll discover how useful status identifiers and progress lines can be to quickly gain information about your project's position. You'll also begin using the Tracking Gantt and filters to automatically identify slipping tasks. You'll also take a stroll through the basics of variance analysis by discussing the Start and Finish Date, Resources, and Work Variance Tables. Closing Your ProjectNo project is complete until it's officially closed. In this final lesson, you'll find out how to close your project and use the Organizer to help you customize and copy views for future projects. Printing ViewsNow that you're using reports to share project information, you'll occasionally need to print various views and tables. In this lesson, you'll delve into printing Microsoft Project documents. You'll be a master at creating different views of your project with the Page Setup dialog box, and you'll clearly understand the mechanics of the Print dialog box and the Print Preview. Using and Creating ReportsOnce your project gets rolling, outsiders will probably want to know how things are going. It can be a real time drain answering each request individually. When others request information from you, Microsoft Project offers the perfect solution: Reports. You'll go over a representative sample of the standard reports as well as discuss how to modify and create new reports in this lesson. By the time you finish, you'll be well acquainted with Project's reporting capabilities and also know how to create Visual Reports as Project automatically exports data to Microsoft Excel and Visio. What you will learn
- Effective planning, implementation, and control projects using Microsoft Project
- How to enhance your project in the areas of efficiency and security
- The importance of setting a project baseline and tracking actual results
- Generate several standard project reports and a wide variety of visual project reports
How you will benefit
- Know how to the use of the world's most popular project management software
- Gain transferable skills
- Replace informal project plans with plans based on logic and structures reflective
Tony Swaim
Tony Swaim has helped many clients, colleagues, and students reach their professional and personal goals. He has been an online instructor since 1998 and has taught at colleges and universities across the United States since 1981. His focus areas are project management, Six Sigma, and supply chain management. Tony manages a successful consulting firm, and his industry experience includes 20 years of supply chain management. He earned a Doctorate in Business Administration from Kennesaw State University and holds professional certifications in six disciplines, including the Project Management Professional (PMP)® certification from the Project Management Institute (PMI)® and Certified Six Sigma Black Belt (CSSBB)® from the American Society for Quality (ASQ)®.
|
|
|
- Intermediate Microsoft Access 2016
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Master more advanced techniques for this powerful database program, including importing Excel spreadsheets as tables, creating query calculations to crunch numbers, and using Visual Basic to automate common tasks. Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.
From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. Finally, you'll build a navigation form to make it easy for your users to find their way around your database. By the time you've completed the course, you'll have a fully functional database that tracks customer and order information. Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
- PC: Windows 8 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Access 2016 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Develop a fully functional database that tracks customer and order information in this hands-on Microsoft Access 2016 course. Learn advanced techniques for presenting data, automating common tasks, and building navigation while you create a database project from scratch. Reviewing Terms and Importing DataIn this lesson, you'll review Access key concepts and terminology. You'll also learn how to share data between Access and other applications. The objects you import in this lesson will be the basis of a project that you'll work on for the rest of the course. Key Fields and Action QueriesIn this lesson, you'll learn how to set up key fields in tables and use action queries to quickly and easily manipulate multiple-table records with one command. Relationships of the Database KindWhat are table relationships, and what does referential integrity mean? It's time to find out how and why to use these features. Creating and Modifying FormsForms are the user-friendly gateway to Access table data. In this lesson, you'll learn how to create and modify forms and make them easy to use. Subforms and the Tab ControlIn this lesson, you'll learn how to add a subform to a main form without the wizard, and you'll use the Tab control to arrange form data. QueriesYou've already learned to put data into your database in an efficient way. In this lesson, you'll learn about query joins and data functions. These tools will help you get timely, high-quality data out of your database, so you see all the data you want and none of the data you don't want. Query CalculationsSuppose your boss tells you, "I want a list of the customers who placed the most orders and a separate list of the customers who spent the most overall." How can you find these answers quickly and accurately? Access comes to your rescue again! In this lesson, you'll explore Access functions, crunch numbers with the best of them, and even design a mathematical formula of your own. Don't worry if math makes you nervous, because this lesson will walk you through every step! Summary QueriesIn this lesson, you'll build powerful, fast summary queries that total, count, or average the values in a set of records. You'll also discover the power of the crosstab query, which can not only summarize data but also rearrange it so that it becomes easier to understand. Finally, you'll add query parameters that allow you to change a query's criteria without altering its design. Building Reports That Pinpoint Key InformationIn this lesson, you'll use the Report Wizard to build a basic report. You'll then fine-tune what you've built and learn some tips and tricks that were developed while building thousands of Access reports. Finally, you'll learn about a fantastic tool—conditional formatting, which allows you to visually identify key report data. With a few clicks, your report will change from a mass of numbers to a map of trends and changes that affect your business. Run Reports From a Custom Dialog BoxJust about every time you run a report, you'll want to limit the data it displays. You might want to see only a certain customer or a particular month and year. In this lesson, you'll build a dialog box that allows the user to run reports based on custom-built criteria. Using Visual Basic to Automate the Reports Dialog BoxVisual Basic is a powerful programming language that allows database developers to automate simple and complex tasks. In this lesson, you'll learn a little bit about Visual Basic, using it to make the reports dialog box you built earlier fully functional. Putting It All TogetherIf you're creating a database for others, you must make it easy to use—and as you may remember, Access can look intimidating to a newbie! In this lesson, you'll build a navigation form that directs users to the forms and reports they need. You'll also set up a database for shared use and modify the startup options. What you will learn
- Use action queries to manage table data quickly and efficiently
- Learn to set table relationships to maintain data integrity
- Learn how to make forms easier to use
- Understand query joins, and learn how to use date functions
- Learn to build a report dialog box to dynamically run database reports based on criteria the user selects
- Explore how to use Visual Basic to add custom commands to the report dialog box
- Learn how to prepare a database for use by others
How you will benefit
- Master more of this powerful database program's advanced techniques
- Learn to build an entire database project from scratch
- Design a fully functional database that tracks customer and order information
Ken Cook
Ken Cook has managed his own successful computer consulting business since 1990. He began as a trainer, instructing numerous users on a variety of software packages, specializing in Microsoft Office. Currently, his main focus is creating expert Microsoft Office solutions, Microsoft Access database solutions, and Microsoft SQL Server solutions for Fortune 500 and small business clients. He is also co-author of four "Access for Dummies" books.
|
|
|
- Intermediate Microsoft Access 2019/Office 365
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
If you use Microsoft Access, this course will help you manage databases more efficiently by advancing your skill set through hands-on lessons. Microsoft Access is one of the most widely used information management systems. This course will teach you advanced techniques in this powerful database program, including importing Excel spreadsheets as tables, creating query calculations to crunch numbers, and using Visual Basic to automate common tasks. From building reports to using conditional formatting, this course will teach you how to best present your data with Access 2019. Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs are not compatible.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Access 2019: Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Develop a fully functional database in this hands-on Microsoft Access 2019 course. Master advanced techniques for presenting data, automating common tasks, and building navigation as you work to create a database project from scratch. Reviewing Terms and Importing DataIn this lesson, you'll review Access key concepts and terminology. You'll also learn how to share data between Access and other applications. The objects you import in this lesson will be the basis of a project that you'll work on for the rest of the course. Key Fields and Action QueriesYou'll learn how to set up key fields in tables, plus you'll use action queries to quickly and easily manipulate multiple-table records with one command. Relationships of the Database KindWhat are table relationships, and what does referential integrity mean? It's time to find out how and why to use these features. Creating and Modifying FormsForms are the user-friendly gateway to Access table data. In this lesson, you'll learn how to create and modify forms and make them easy to use. Subforms and the Tab ControlIn this lesson, you'll learn how to add a subform to a main form without the wizard, and you'll use the Tab control to arrange form data. QueriesYou've already learned to put data into your database in an efficient way. In this lesson, you'll learn about query joins and data functions. These tools will help you get timely, high-quality data out of your database, so you see all the data you want and none of the data you don't want. Query CalculationsSuppose your boss tells you, "I want a list of the customers who placed the most orders and a separate list of the customers who spent the most overall." How can you find these answers quickly and accurately? Access comes to your rescue again! In this lesson, you'll explore Access functions, crunch numbers with the best of them, and even design a mathematical formula of your own. Summary QueriesIn this lesson, you'll build powerful, fast summary queries that total, count, or average the values in a set of records. You'll also discover the power of the crosstab query, which can not only summarize data but also rearrange it so that it becomes easier to understand. Finally, you'll add query parameters that allow you to change a query's criteria without altering its design. Building Reports That Pinpoint Key InformationIn this lesson, you'll use the Report Wizard to build a basic report. You'll then fine-tune what you've built and learn some tips and tricks about building Access reports. Finally, you'll learn about a fantastic tool—conditional formatting, which allows you to visually identify key report data. With a few clicks, your report will change from a mass of numbers to a map of trends and changes that affect your business. Run Reports from a Custom Dialog BoxJust about every time you run a report, you'll want to limit the data it displays. You might want to see only a certain customer or a particular month and year. In this lesson, you'll build a dialog box that allows the user to run reports based on custom-built criteria. Using Visual Basic to Automate the Reports Dialog BoxVisual Basic is a powerful programming language that allows database developers to automate simple and complex tasks. In this lesson, you'll learn a little bit about Visual Basic, using it to make the reports dialog box you built earlier fully functional. Putting It All TogetherIf you're creating a database for others, you must make it easy to use—and as you may remember, Access can look intimidating to a newbie! In this lesson, you'll build a navigation form that directs users to the forms and reports they need. You'll also set up a database for shared use and modify the startup options. What you will learn
- Import table data from external sources
- Use action queries to update table data quickly and efficiently
- Set table relationships to maintain data integrity
- Make forms easier to use
- Understand query joins, and common functions
- Build a report dialog box to dynamically run database reports based on user selected criteria
- Use Visual Basic to run reports from the report dialog box
- Prepare a database for use by others
How you will benefit
- Build your own database from scratch
- Improve the efficiency of your existing databases
- Build a fully functional database that tracks customer and order information
- Create an automated dialog box that runs reports with the click of a button and filters those reports to specific user selected criteria
Ken Cook
Ken Cook has managed his own successful computer consulting business since 1990. He began as a trainer, instructing numerous users on a variety of software packages, specializing in Microsoft Office. Currently, his main focus is creating expert Microsoft Office solutions, Microsoft Access database solutions, and Microsoft SQL Server solutions for Fortune 500 and small business clients. He is also co-author of four "Access for Dummies" books.
|
|
|
- Intermediate Microsoft Word 2016
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Learn how to use the more advanced features of Microsoft Word 2016 (now available through Office 365) including how to add graphics, use templates, and merge data. Go beyond the basics of word processing and master the more advanced features of Microsoft Word 2016 (now available through Office 365). In this course, you'll learn how to automate Word 2016 using shortcuts to help you write more while typing less. From signs, newsletters, and greeting cards to long documents, you'll learn how to create whatever you need—quickly and with professional-looking results.
You'll also learn how to create and organize text in tables, mix graphics and text together to turn Word into a simple desktop publishing program, and merge spreadsheet and database data to create mailing labels and form letters. Along the way, you'll go through lots of examples and exercises so you can see how Word's advanced features work; but more importantly, you'll see how you can use these advanced features at home and on the job. By the end of this course, you'll know how to use Word more effectively and take advantage of its many features so that you can get your work done quicker and easier than you ever thought possible. Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
- PC: Windows 8 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Word 2016 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Master the advanced features of Microsoft Word 2016 and create truly professional looking documents. This hands-on course will help you learn how to create an index, build a list of figures, design a table of contents, do desktop publishing, perform a mail merge, and use timesaving shortcuts. Shortcuts and Time-Savers in Word 2016Humanity has come a long way since the days of the typewriter. What used to take hours can now be done in seconds with Microsoft Word 2016. And the less time you spend typing, the more time you can spend being creative and having fun. In this lesson, you'll learn shortcuts in Word that can help you create documents faster and more accurately than ever before. Not only will these shortcuts save you time, but they'll help you create letters and reports more easily than you might have thought possible. Text and Paragraph Formatting MethodsWhat you write is half of communication. The other half is getting people to read what you write. One way to make your writing more appealing is to make it look presentable with formatting. Of course, formatting text is easy, but applying different types of formatting over and over again can get tedious. That's why, in this lesson, you'll learn a fast and easy way to format chunks of text quickly and consistently using something called styles. You'll find out what a style is, how to apply it, and more important, how to create and save your own styles to use in any document. By the end of this lesson, you'll be able to make any document look presentable with just the click of your mouse. TemplatesIf you've ever baked cookies, or even just watched someone else do it, you know how difficult it can be to make all the cookies in a batch look exactly alike. Some turn out big, some small, some gooey, and some burned! However, if you use a cookie cutter, you can make identically shaped cookies every time. That's the same principle you'll learn in this lesson; instead of using a cookie cutter, though, you'll use something called a template. A template stores the formatting of a document so that you can apply it to another document. Templates let you format entire documents as easily as formatting a single word. Word offers lots of convenient templates stored right on your computer or available over the Internet, and you'll also find out how you can create your own. Graphics: Part 1They say a picture is worth a thousand words, so what better way to spice up your documents than by adding pictures? In this lesson, you'll learn how to add your own digital photographs to a document so that you can show everyone your vacation pictures, family holidays, or just interesting sights you've captured with your own camera. In addition to adding your own photos, you can also add clip art from Word's massive library of free graphics. And you'll find out how to resize, rotate, and style your pictures, as well as wrap your document text around them. By the end of this lesson, you'll see why Word documents are about much more than words! Graphics: Part 2, and ColumnsDigital photographs and clip art are just the beginning of what you can do with graphics in Word. In this lesson, you'll discover how to add a variety of informational graphics, including charts, graphs, and WordArt, which allow you to display text as a graphic image. Not only will you learn how to add these graphics, but you'll also find out how to edit them when your data changes. You'll finish off the lesson by seeing how Word allows you to format documents with multiple columns—a handy skill for creating newsletters and publications! Sections and NotesDo you often create long documents? If so, you'll appreciate this lesson, which shows you how to divide a large document into parts called sections. Sections allow you to format part of a document a certain way without that formatting affecting the rest of your text. For example, you may want headers and footers to appear on some pages but not others. Sections make this easy! You'll also spend some time inserting footnotes and endnotes in a document. If you need to write research papers or other academic content, Word makes it a snap to add and format these previously pesky notes! TablesIf you've ever seen a spreadsheet, you know how rows and columns let you organize numbers and text on the screen. Well, tables do the same thing in Word. In this lesson, you'll see how to create tables of all different sizes right in a Word document! The lesson will cover how to modify tables, too. And don't think Excel users get to have all the fun—you can even enter formulas to perform calculations in your tables, sort them, and style them for a customized look. Your data has never looked so appealing! Envelopes and Odd-Size PagesYou probably print most of your documents on standard letter-size paper. While this is great for ordinary letters or business reports, sometimes you may want to get creative with your paper sizes. But then there's the trouble of printing. In this lesson, you'll see how you can define the dimensions of the paper you're using, so Word will print everything correctly. You'll also learn how to print names and addresses directly on envelopes of any size. After this lesson, you won't feel confined to boring 8 1/2 x 11-inch paper anymore! Desktop Publishing: Part 1As you've probably already figured out, Word can do more than write letters. It also functions as a simple desktop publishing program for creating greeting cards, calendars, or newsletters. In this lesson, you'll find out how text boxes are the key to simple desktop publishing and see how other elements come into play in customized documents. Along the way, you'll look at business cards and greeting cards to get a feel for how desktop publishing works. If you've always wanted to create a document that combines text and graphics in an artistic or visually appealing way, you'll find out how to do that and much more. Desktop Publishing: Part 2With the basics down, it's time to take your desktop publishing skills to the next level. In this lesson, you'll discover the magic of linked text boxes that give you the power to move your text anywhere you want on the page and keep it flowing. You'll see how to create, position, resize, and group text boxes so you have total control over your text. Merging Data with DocumentsHave you ever received one of those "personalized" letters from a company in the mail? You can be sure that nobody typed the entire sales letter from scratch. Instead, the company used a form letter and something called mail merging. In this lesson, you'll learn how to store long lists of names and addresses that you can use over and over again in a form letter. Just create a document once, leave blanks for inserting information such as names and addresses, and let Word personalize each letter for you. Now you, too, can create personalized letters for business or personal use, such as sending out holiday greetings to family members and friends. Final TouchesLook in most books, and you'll find the table of contents at the beginning and an index in the back. Often, these are the last components added to a document, since they need to have accurate titles and page numbers. But Word takes a lot of the tedious work out of creating these components. In this final lesson, you'll see how you can use Styles to make creating the table of contents a snap, and then explore how to tag index terms so Word knows what page they're on, even if they move later. Word can also help you keep track of any figures, such as charts, illustrations, or graphs, in your document. By letting Word worry about the details, you can create an accurate table of contents, index, or list of figures with very little extra effort on your part. These finishing touches will make your most important documents shine! What you will learn
- Learn how shortcut keys, macros, and the AutoCorrect feature can save you time
- Discover fast ways to format text in a document
- Find out how to insert graphic images, including clip art and photos, into your documents
- Add charts, SmartArt, and WordArt to a document, and divide any document into columns
- Practice dividing a long document into sections and using footnotes and endnotes
- Get acquainted with some of Word's desktop publishing features, such as using text boxes, layering, and aligning objects
- Learn how to link text boxes, and position them in a document to create brochures and newsletters
- Use mail merging to quickly and easily personalize form documents
How you will benefit
- Master the more advanced features of Microsoft Word
- Learn how to use Word more effectively and take advantage of all its many features so you can get your work done more quickly and more easily
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
|
|
|
- Intermediate Microsoft Word 2019/Office 365
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Use Microsoft Word 2019 more efficiently by mastering its more advanced features. This hands-on course will teach you how to create an index, build a list of figures, design a table of contents, perform a mail merge, and use timesaving shortcuts to develop professional documents. If you create business documents like letters, brochures, or newsletters, you know that their quality is representative of your organization. To create professional-quality documents efficiently and effectively, you have to use advanced word processing functions. This online course will teach you how to use Microsoft Word 2019, the newest version of Microsoft's widely-used word processing software.
Through hands-on lessons and modules, you will learn how to use a number of shortcuts and time-saving techniques to create complex documents. By the end of the course, you will know how to create and organize tables, manipulate graphics, and merge spreadsheets, amongst other functions, to turn Word into a simple desktop publishing tool. Requirements:
Hardware Requirements:
- This course must be taken on a PC. Macs and Chromebooks are not compatible.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
- Microsoft Word 2019 (desktop version) available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
- Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Use Microsoft Word 2019 more efficiently by mastering its more advanced features. This hands-on course will teach you how to create an index, build a list of figures, design a table of contents, perform a mail merge, and use timesaving shortcuts to develop professional documents. Timesavers in Word 2019Things have come a long way since the days of the typewriter. What used to take hours can now be done in seconds with Microsoft Word 2019. And the less time you spend typing, the more time you can spend being creative and having fun. In this lesson, you'll learn shortcuts in Word that can help you create documents faster and more accurately than ever before. Not only will these shortcuts save you time, but they'll help you create letters and reports more easily than you might have thought possible. Methods to Streamline Text FormattingWhat you write is half of communication. The other half is getting people to read what you write. One way to make your writing more appealing is to make it look presentable with formatting. Of course, formatting text is easy, but applying different types of formatting over and over again can get tedious. In this lesson, you'll learn a fast and easy way to format chunks of text quickly and consistently using something called styles. You'll find out what a style is, how to apply it, and—more important—how to create and save your own styles to use in any document. By the end of this lesson, you'll be able to make any document look presentable with just the click of your mouse. Working with TemplatesA template stores the formatting of a document so that you can apply it to another document. Templates let you format entire documents as easily as formatting a single word. Word offers lots of convenient templates stored right on your computer or available over the Internet. In this lesson, you'll learn about how to search and use Word templates, and you'll also discover how you can create your own. Adding Graphics to Your Word DocumentsThey say a picture is worth a thousand words, so what better way to spice up your documents than by adding pictures? In this lesson, you'll learn how to add your own digital photographs to a document so that you can show everyone your vacation pictures, family holidays, or just interesting sights you've captured with your own camera. In addition to adding your own photos, you can also add clip art from Word's massive library of free graphics. And you'll find out how to resize, rotate, and style your pictures, as well as wrap your document text around them. By the end of this lesson, you'll see why Word documents are about much more than words! Creating Text-Based Graphics in WordDigital photographs and clip art are just the beginning of what you can do with graphics in Word. In this lesson, you'll discover how to add a variety of informational graphics, including charts, graphs, and WordArt, which allows you to display text as a graphic image. Not only will you learn how to add these graphics, but you'll also find out how to edit them when your data changes. You'll finish off the lesson by seeing how Word allows you to format documents with multiple columns—a handy skill for creating newsletters and publications! Organizing Your Text with Columns and SectionsDo you often create long documents? If so, you'll appreciate this lesson, which shows you how to divide a large document into parts called sections. Sections allow you to format part of a document a certain way without that formatting affecting the rest of your text. For example, you may want headers and footers to appear on some pages but not others. Sections make this easy! You'll also spend some time inserting footnotes and end-notes in a document. If you need to write research papers or other academic content, Word makes it a snap to add and format these previously pesky notes! Creating Tables in WordIf you've ever seen a spreadsheet, you know how rows and columns let you organize numbers and text on the screen. Well, tables do the same thing in Word. In this lesson, you'll see how to create tables of all different sizes right in a Word document! You'll cover how to modify tables, too. And don't think Excel users get to have all the fun—you can even enter formulas to perform calculations in your tables, sort them, and style them for a customized look. Your data has never looked so appealing! Creating Stationary in WordYou probably print most of your documents on standard letter-size paper. While this is great for ordinary letters or business reports, sometimes you may want to get creative with your paper sizes. But then there's the trouble of printing. In this lesson, you'll see how you can define the dimensions of the paper you're using, so Word will print everything correctly. You'll also learn how to print names and addresses directly on envelopes of any size. After this lesson, you won't feel confined to boring 8 1/2 x 11-inch paper anymore! Creating Business Stationary in WordAs you've probably already figured out, Word can do more than write letters. It can also function as a simple desktop publishing program for creating greeting cards, calendars, or newsletters. In this lesson, you'll find out how text boxes are the key to simple desktop publishing, and you'll see how other elements come into play in customized documents. Along the way, you'll look at business cards and greeting cards to get a feel for how desktop publishing works. If you've always wanted to create a document that combines text and graphics in an artistic or visually appealing way, you'll find out how to do that and much more. Desktop PublishingWith the basics down, it's time to take your desktop publishing skills to the next level. In this lesson, you'll discover the magic of linked text boxes that give you the power to move your text anywhere you want on the page and keep it flowing. You'll see how to create, position, resize, and group text boxes so that you have total control over your text. Merging Data with DocumentsHave you ever received one of those "personalized" letters from a company in the mail? You can be sure that nobody typed the entire sales letter from scratch. Instead, the company used a form letter and something called mail merging. In this lesson, you'll learn how to store long lists of names and addresses that you can reuse in a form letter. Just create a document once, leave blanks for inserting information such as names and addresses, and let Word personalize each letter for you. Now, you too can create personalized letters for business or personal use, such as sending out holiday greetings to family members and friends. Creating Summative Lists of What's in Your DocumentLook in most books, and you'll find a table of contents at the beginning and an index in the back. Often, these are the last components added to a document, since they need to have accurate titles and page numbers. Thankfully, Word takes a lot of the tedious work out of creating these components. In this final lesson, you'll see how you can use Styles to make creating a table of contents a snap, and you'll explore how to tag index terms so that Word knows what page they're on, even if they move later. Word can also help you keep track of any figures, such as charts, illustrations, or graphs, in your document. By letting Word worry about the details, you can create an accurate table of contents, index, or list of figures with very little extra effort on your part. These finishing touches will make your most important documents shine! What you will learn
- Functions and features of Microsoft Word 2019
- Shortcuts and time-saving techniques including macros, keystroke shortcuts, and templates
- Finding, inserting, and modifying graphic images
- Creating and merging data and text for labels, letters, and other professional documents
How you will benefit
- Utilizing Microsoft Word 2019 as a basic desktop publishing tool adds value to your professional profile.
- By learning more advanced features of this popular software, you can contribute to your organization more effectively.
Wallace Wang
Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghost written several books about investing in real estate, day trading stocks, and becoming an entrepreneur. Some of his past jobs have included teaching computer science courses at the University of Zimbabwe, performing stand-up comedy, and appearing on a weekly radio show.
|
|
|
- Intermediate Microsoft Excel 2016
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Take your Microsoft Excel 2016 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions. In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire. Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs.
Software Requirements:
- PC: Windows 8 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Office Home and Student 2016 (not included in enrollment).
- Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Harness the power of Excel and become a master user of this powerful program. This hands-on course will provide skills using charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2016 functions. Excel Charts and GraphsIn your first lesson, you will discover why Excel 2016 is such a powerful charting tool. To you, a workbook's numbers might tell an interesting story; to others, that story may not be obvious. You will learn how to choose the right chart for your story and then how to create, format, and edit your chart. More Excel ChartsThis lesson continues exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they may not be well-known, these options can add tremendous value to your worksheets in the right situations. AutoFilter and SortingWorking with data in Excel can be quite easy when you know about the tools that are available in a table format. One of these great tools is the Auto Filter command. This lesson will teach you how to use Auto Filter to limit your table information to just the records you want. Goal SeekingLearn how to use Solver to solve a complex problem based on the criteria and constraints that you provide it. You'll also explore in detail how to create all three types of Sparklines, as well as formatting options for each and gain the skills to create dashboard-like mini charts sure to make you the envy of your office. PivotTablesFind out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Then, receive a quick overview of all the categories of functions and the different methods you can use to create them. Advanced PivotTablesJust like charting, Excel's PivotTables are too big a topic to fit into one lesson. This lesson takes a tour through some of Excel's more advanced techniques, like the PivotTable filtering tool Slicer. You will also learn how a PivotTable can serve as your source for the PivotChart. SolverHave you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you will learn how to use Solver to solve a complex problem based on criteria and constraints. SparklinesThere's nothing more exciting than learning how to master a new feature in Excel. This lesson focuses on creating three types of Sparklines, as well as formatting options for each. By the end of the lesson, you will have the skills to create dashboard-style mini charts. MacrosIn this lesson, you will find out how to use macros to turn repetitive and often time-consuming tasks into automated Excel functions. You will also learn how to record a macro that performs a task in seconds with the click of a button. Introduction to FunctionsIf you have used Excel for a while, you know there are hundreds of functions at your disposal. The last three lessons of this course will cover how and why you would use these functions. This lesson introduces creating various functions with the Text category. Math/Trig FunctionsNext to learning how to create macros, most students want to learn as much as they can about Excel functions. This lesson covers on more complex functions of the "Math & Trig" category, focusing on the SUMIF and COUNTIF functions in particular. VLOOKUP, INDEX, and MATCH FunctionsSince functions are such an integral part of using Excel, your final lesson will cover advanced features. In this lesson, you will learn how to use the VLOOKUP, INDEX, and MATCH functions. What you will learn
- Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016
- Learn to create useful and eye-catching charts
- Discover how to manipulate data with the push of a button
- Add the time-saving functions of advanced Excel users to your repertoire
How you will benefit
- Take your Excel 2016 skills to an expert level and become a more productive member of your organization
- Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting
- Learn to fully harness the power of Microsoft Excel 2016 and use all of its capabilities to save time and money
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
|
|
|
- Intermediate Microsoft Excel 2019/Office 365
-
Fee: $129.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
If you use Microsoft Excel, this intermediate course will bring your Excel skills to the next level. You will learn how to use a number of powerful features in the 2019 version of Microsoft's longstanding Excel software. Many businesses rely on spreadsheets to manage budgets, schedules, and tracking. Microsoft Excel is considered the industry standard for spreadsheets. If you use Excel regularly and want to learn more advanced functions in this powerful software, this course is for you.
You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other intermediate functions to your professional skill set. In addition, you will learn to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. Requirements:
Hardware Requirements:
- This course must be taken on a PC. It is not suitable for Macs or Chromebooks.
Software Requirements:
- PC: Windows 10 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
- Microsoft Excel 2019 (desktop version), available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Master new skills and harness the power of Excel to become a power user. This hands-on course provides in-depth knowledge of charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2019 functions. Excel Charts and GraphsIn this first lesson, you'll discover why Excel is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. So, in this lesson, you'll find out how to choose the right chart for telling your story and then how to create, format, and edit your chart to help others clearly visualize that story. More Excel ChartsWith so many great charting features and enhancements in Excel 2019, there's no way you could study them all in a single lesson. So, in this lesson, you'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well-known, these options can add tremendous value to your worksheets in the right situations. The lesson will walk you through a few of them step-by-step so that you can see the value for yourself. AutoFilter and SortingWorking with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In this lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that? Goal SeekingNormally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want, but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. You'll go through multiple examples, exploring several ways to apply this great feature. Pivot TablesYou'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you'll know what to expect. There's no greater what-if analysis tool to summarize, reorganize, and report data. When you practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss! Advanced PivotTablesJust like charting, Excel's PivotTables are too big a topic to fit into one lesson. So, in this lesson, you'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then, you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart. Last, you'll become an expert in using the Excel PivotTable filtering tool called Slicer. SolverHave you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you'll learn how to use Solver to solve a complex problem based on the criteria and constraints you provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off. SparklinesThere's nothing more exciting than learning how to master a useful and eye-catching feature in Excel. In this lesson, you'll explore in detail how to create all three types of Sparklines, as well as formatting options for each. By the end of the lesson, you'll have the skills to create dashboard-like mini charts sure to make you the envy of your office. If you enjoy creating charts, you'll really enjoy this lesson. MacrosThis topic is a student favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you? Introduction to FunctionsIf you've used Excel for a while, you know there are hundreds of functions at your disposal. You'll spend the last three lessons of this course going over exactly how and why you'd use them. The lesson will begin by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, you'll ease into creating various functions using some from the Text category. Math/Trig FunctionsIn addition to learning how to create macros, most students want to learn as much as they can about Excel functions. In this lesson, you'll dig a little deeper into using some of the slightly more complex functions in the Math & Trig category. Specifically, you'll look at two popular choices, the SUMIF and COUNTIF functions, and discuss how to use one of the more complex functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat! VLOOKUP, INDEX, and MATCH FunctionsSince functions are such an important and integral part of using Excel, you'll spend the final lesson going over a few more of them. You'll learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short-changed, because this lesson will add to the complexity. You'll also use the INDEX and MATCH functions to do something just short of amazing. This is another lesson you won't want to miss! What you will learn
- Charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2019
- How to manipulate data
- Intermediate level Excel functions
How you will benefit
- Become a more productive member of your organization
- Build an indispensable skill set
- Learn to fully harness the power of Microsoft Excel 2019
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
|
|
|
- Microsoft Excel - Pivot Tables
-
Fee: $115.00
Dates: 5/17/2023 - 7/8/2023
REGISTRATION FOR THIS CLASS IS CLOSED. This class is already in session.
Master all the features of Excel pivot tables, including little-known options and settings, layouts, calculated fields, multi-level subtotals, Pivot Charts, Timelines, and Slicers. Wouldn't it be great to learn how to effectively use all the advanced Excel pivot table features? In this practical and information-packed course, you will learn how to maximize this program's functions and capabilities.
Most organizations rely heavily on Microsoft Excel pivot tables to analyze and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.
This course will teach you how to utilize the numerous pivot tables to develop useful analysis models and reports within your company. Impress your coworkers by learning how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers. You will discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items. You will learn how to use Excel's Table function to efficiently manage changes to the pivot table's source data in order to avoid making mistakes when data is added or deleted. Requirements:
Hardware Requirements:
- This course can be taken on either a PC or Mac.
Software Requirements:
- PC: Windows 8 or later.
- Mac: macOS 10.6 or later.
- Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
- Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Office 2016 (not included in enrollment).
- The "Starter", "Web App", and "Office Mac Home" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
- Adobe Acrobat Reader.
- Software must be installed and fully operational before the course begins.
Other:
- Email capabilities and access to a personal email account.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online. Maximize your investment in Microsoft Excel by mastering its pivot table features. In this practical hands-on course, you will discover how to use different layout, subtotaling, and filtering options and discover a variety of advanced techniques for pivot tables, including Pivot Charts, Timelines, and Slicers. You will also master data analysis by learning how to quickly and easily summarize your data. Pivot Table ConceptsIn your first lesson, you will develop a solid understanding of the requirements to use pivot tables. This lesson introduces the foundational elements needed to understand and get the most out of pivot tables. Creating a Pivot TableNot all data is created equal. In this lesson, you will learn what's required to make sure your data is organized well enough to be used in a pivot table. You will discover a very common issue that occurs when the source data changes and you how to easily eliminate that issue. Pivot Table Analyze and Design TabsWorking efficiently with pivot tables requires knowing where to find the proper pivot table feature without searching high and low for it. Most pivot table features reside on one of the two pivot table Ribbon tabs. This lesson introduces the different features that are grouped and what each one provides. Pivot Table Formatting Inside and OutLearn to group ordinary pivot table fields, which will create new fields that you can use within the pivot table or as a Slicer. In addition, you'll learn how to expand and collapse fields to help in summarizing the pivot table data. Then learn how to locate data anomalies in large data sets and the proper use of report filters which can assist in any data investigation as well as a great tool for creating multiple reports from a single pivot table report. Pivot Table Options and Field SettingsMost users may not know that there are certain options and settings that provide little-known but extremely useful features. Most of these features are accessed through the pivot table Ribbon tabs, but some are not. In this lesson, you will learn how to use some of the more obscure settings in the Pivot Table Options and Field Settings dialog boxes. Value Field SettingsSimilar to the Field Settings, the Values section of a pivot table report has unique settings and summarization options. For most people, simply summing or counting the data within the Values section is enough. But once you learn how to use these lesser-known settings, you will go from an average pivot table user to an expert. Grouping Pivot Table FieldsA pivot table is ideal for analyzing and summarizing data. By default, the table does an excellent job at summarizing the data within the various fields, but there is a way to summarize the data even further. This lesson will show you how to group ordinary pivot table fields, which will create new fields that you can use within the pivot table or as a Slicer. In addition, you will learn how to expand and collapse fields to help in summarizing the pivot table data. Data-Integrity Checks and Report FiltersA pivot table is a great way to locate data anomalies in large data sets that would otherwise be hard to find scanning through the source table. In addition, the proper use of report filters can assist in any data investigation, as well as providing a great tool to create multiple reports from a single pivot table report. You will learn all about these tools in this lesson. Cloning a Pivot Table and the Wonderful World of SlicersPivot tables are extremely useful and flexible for data analysis and reporting. It's easy to add, remove, or simply move fields to create different-looking reports from the same source data. This lesson focuses on creating different versions of reports and the different techniques needed to do so. Calculated Fields and ItemsPivot tables are great for analyzing and reporting information, but they're limited in their functionality when your source data is missing needed information. Or, perhaps the information isn't needed in the source data and is only needed for analysis for a short time. This lesson will demonstrate how to use Excel's Calculated Items and Fields feature to create items that are missing from the source data. Working With Slicers and Pivot ChartsYour pivot table isn't complete without a Slicer and pivot chart. In order to create an effective dashboard, you'll need a pivot table and a pivot chart controlled by multiple Slicers. This lesson focuses on creating and managing Slicers and Pivot Charts. Timelines and Dashboard DevelopmentIn the final lesson, you will learn about the many interactive tools and techniques available to make pivot tables and pivot charts fun to use. Similar to a Slicer, Excel offers a tool called Timelines. Timelines are available when a field available in your pivot table or chart is a date. Within a dashboard, using the Timeline feature can be useful and eye catching to the users. What you will learn
- Learn how to work with the numerous pivot table options and system settings
- Become skilled in developing useful analysis models and reports
- Learn how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers
- Discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items
- Learn how to efficiently manage changes to the pivot table's source data in order to avoid making mistakes when data is added or deleted
How you will benefit
- Learn advanced techniques and become more valuable to your organization
- Become more confident in your ability to report accurate data efficiently using Microsoft Excel
- Open the door to new career opportunities in data analysis and reporting
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
|
|
|