| Course Name |
Hours |
List Price |
Content |
| Data Analysis and Visualization with Microsoft Excel |
14.00 |
$1,395.00 |
|
Description: Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of big data has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, enabling organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage.
Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways.
Microsoft Excel is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-driven visualizations to show insights and trends, as well as create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action.
# of Days:
Setting:
|
| Excel 2019 Charts |
4.00 |
$219.00 |
|
Description: In this course, you will cover the many different types of charts available in Excel, how to modify and redefine chart data, as well as how to move, layout, and style a chart. In addition, you will learn about chart elements and how to add, remove, and format chart elements, as well as how to save a chart template. Finally, you will learn about sparklines, trendlines, error bars, and advanced chart types.
# of Days:
Setting:
|
| Excel 2019 Data Analysis |
7.00 |
$289.00 |
|
Description: In this course, you will cover creating and modifying table elements, adding and deleting records and fields, and using Data forms and Slicers with table data. You will import data from Access and Excel objects as well as text file types. Proper data management will be discussed to determine structure requirements, sorting, filtering, using flash fill, auto filter and advanced filtering features. The database functions will allow the user to extract data from a large list of content with precision based on specific criteria. Finally, the data modeling features will examine how to take spreadsheet data and create one to many relationships which will expand the functionality of a pivot table for a greater understanding of the data.
# of Days:
Setting:
|
| Excel 2019 Data Analysis with Power Pivot |
4.00 |
$219.00 |
|
Description: We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.
# of Days:
Setting:
|
| Excel 2019 Formulas |
6.00 |
$279.00 |
|
Description: In this course, you will cover how to trace formulas, check errors, evaluate formulas, and how to use the Watch Window. You will learn about range names and how to use them in logical functions and lookup functions. You will also learn complex functions, such as SUMIF, AVERAGEIF, and COUNTIF functions. In addition, you will learn about date and time functions, including finding the day of the week and the
week number.
# of Days:
Setting:
|
| Excel 2019 Level 1 |
7.00 |
$279.00 |
|
Description: The Computer Workshop writes their own curriculum for Excel making it easy to customize a class specific to your needs. Many think they are past the basics, but our course has many valuable shortcuts and quick data entry methods built in to give you a good foundation. So even if you have used Excel for a number of years, it is worth taking the Level 1 class. Our course will make ordinary tasks much easier for you to accomplish, and in much less time.
# of Days:
Setting:
|
| Excel 2019 Level 2 |
7.00 |
$289.00 |
|
Description: In this course, you will cover how to work with large worksheets in Microsoft Excel 2019, and use multiple worksheets and workbooks efficiently. You will sort and filter data, use conditional formatting, and create and format tables and charts. You will learn how to protect worksheets and files, as well as referring to data in other workbooks thru 3D formulas. Finally, you will create names, customize a template, and work with comments and graphics.
# of Days:
Setting:
|
| Excel 2019 Level 3 |
7.00 |
$299.00 |
|
Description: In this course, you will cover how to create and work with Macros and VBA Programming, as well as how to add Form Controls and how to assign a Macro to a Form Control. In addition, you will learn about formula auditing, and will learn about common errors, how to correct them, and how to use the Watch Window to see changes in formulas. You will work with creating and modifying hyperlinks, get data from the internet, as well as learn how to save workbooks, worksheets, charts and ranges as web pages. You will create custom styles and learn how to use advanced conditional formatting. Finally you will learn how to create and use a shared workbook, including how to protect, consolidate and resolve editing conflicts in a shared workbook.
# of Days:
Setting:
|
| Excel 2019 Pivot Tables |
4.00 |
$219.00 |
|
Description: In this course you will learn how to create and modify PivotTables and PivotCharts, as well as how to filter and modify fields to format and group data. In addition, you will learn to use the advanced features of PivotTables, such as consolidating multiple workbooks as well as creating and using page fields. Finally, you will learn how to generate PivotTables using imported data from external data sources. This information could be in Access, SQL Tables, the Internet, or other database programs. Understanding how to work with PivotTables and PivotCharts to achieve the results you want is one of the most powerful tools in Excel.
# of Days:
Setting:
|
| Excel 365 Level 1 |
7.00 |
$279.00 |
|
Description: The Computer Workshop writes their own curriculum for Excel making it easy to customize a class specific to your needs. Many think they are past the basics, but our course has many valuable shortcuts and quick data entry methods built in to give you a good foundation. So even if you have used Excel for a number of years, it is worth taking the Level 1 class. Our course will make ordinary tasks much easier for you to accomplish, and in much less time.
# of Days:
Setting:
|
| Excel 365 Level 2 |
7.00 |
$289.00 |
|
Description: In this course, you will cover how to work with large worksheets and workbooks in Microsoft Excel. Create Named cells and ranges which are used in formulas and navigation. Write formulas that refer to other worksheets and workbooks. Create 3D formulas that refer to data in other worksheets and workbooks. You will sort and filter data, use conditional formatting, and create and format tables and charts, and how to use the Quick Analysis tools. Apply protection to the worksheet, workbook, and file itself. You will work with graphics, run the Accessibility Checker and make the file Accessible (508 Compliant), create and work with comments, and finally create a custom template.
# of Days:
Setting:
|
| Excel 365 Level 3 |
7.00 |
$299.00 |
|
Description: In this course, you will cover how to create and work with Macros and VBA Programming, as well as how to add Form Controls and assign a Macro to a Form Control. In addition, you will work with creating and modifying hyperlinks, get data from the internet using the new Power Query tool. You will learn how to use Outlining, Subtotaling, and Consolidation tools. You will also learn not to use the analytical tools of Goal Seek, Data Tables, Scenarios, Solver, and Forecasting.
# of Days:
Setting:
|
| Programming and Data Wrangling with VBA and Excel |
21.00 |
$897.00 |
|
Description: VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users.
Course Objectives:
In this course, you will develop and deploy VBA modules to solve business problems. You will:
Identify general components of VBA and their appropriate use in solving business solutions.
Record VBA macros to automate repetitive tasks.
Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment.
Write VBA code to create a custom worksheet function.
Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
Control how and when macros run.
Develop UserForm objects to create custom dialog boxes and windows.
Use VBA to read and write data from local files and cloud services.
Use VBA to clean and transform data.
Run programs and commands outside of Excel and share VBA projects with other users.
# of Days:
Setting:
|
| Storytelling with Data 2: Renegades in Excel |
7.00 |
$399.00 |
|
Description: Ready to tell more complex stories dealing with dense data? Now that you are familiar with the six essential parts of telling meaningful stories with data, it is time to take that to the next step.
In Storytelling with Data, we explore what it means to harness the highways-of-the-mind to make data driven stories easy to read and understand. Through those six lessons, our conversation will continue in Storytelling with Data 2: Renegades in Excel!?
Take a deeper dive on bulky tables and less-commonly used graphs.?
Explore stories that have multiple endings.
Prepare visuals to tell the story with or without you.
Sprinkle in a dash of dashboarding.?
Above all, are you ready to turn the six lessons on their head to get to the bottom of each case-driven story? Its time to step up your storytelling!
# of Days:
Setting:
|
| Storytelling with Data Using Excel |
7.00 |
$399.00 |
|
Description: The Storytelling with Data course teaches you the fundamentals of data visualization and how to communicate effectively with data. Youll discover the power of storytelling and the way to make data a pivotal point in your story. The lessons in this illuminative text are grounded in theory, but made accessible through numerous real-world examplesready for immediate application to your next graph or presentation.
Storytelling is not an inherent skill, especially when it comes to data visualization, and the tools at our disposal dont make it any easier. This course demonstrates how to go beyond conventional tools to reach the root of your data, and how to use your data to create an engaging, informative, compelling story.
Specifically, youll learn how to:
Understand the importance of context
Determine the appropriate type of graph
Recognize and eliminate the clutter
Direct your audiences attention
Think like a designer when visualizing data
Leverage the power of storytelling to help your message resonate with your audience
# of Days:
Setting:
|