Course Name |
Hours |
List Price |
Content |
Data Analysis and Visualization with Microsoft Excel |
21.00 |
$1,550.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 2016 Dashboards |
7.00 |
$299.00 |
|
Description: In this Microsoft Excel Dashboards course, students will give you the skills to use Excel Dashboards at an advanced level. Microsoft Excel Dashboards are a reporting mechanism that can deliver Business Intelligence (BI) in graphical form. Dashboards take raw data; allow it to be analyzed and presented in a form that is of most benefit to the end user. Participants in this course must have an Intermediate working knowledge of Excel.
Course Objectives:
- Differentiate between Reports and dashboards
- Discuss the benefits of an Excel dashboard
- Assemble all data needed for a dashboard
- Identify ground rules for creating effective dashboards
- Create dynamic charts
- Create Pivot tables
- Create Pivot Charts
- Modify Pivot tables and charts
- Apply conditional formatting to a dashboard
- Identify and apply Excel functions (IF, CHOOSE and VLOOKUP)
- Design and build a dashboard from raw data to the finished product
# 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: name cells and ranges, use those names in formulas, use Logical and Lookup function formulas, use the IF and IFS formulas, Data Validation, use Match and Indexing formulas, work with Date and Time formulas, and use the formula auditing tools to trouble shoot problems in formulas.
# 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.
Upon successful completion of this course, you will be able to customize the interface to better suit your needs, create lists, efficiently develop Excel worksheets and workbooks, use basic excel function formulas, apply formatting to content, create customize number formats, control how spreadsheets are printed, as well as be able to find and replace content.
You will:
Get started with Microsoft Office Excel 2019
Customize the interface
Perform calculations
Modify a worksheet
Format a worksheet
Print workbooks
Edit contents
# 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:
|
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:
|