Course Name |
Hours |
List Price |
Content |
10994 - Data Analysis Fundamentals using Excel |
14.00 |
$1,159.00 |
|
Description: The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
Audience Profile
This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.
# of Days:
Setting:
|
20345-1 - Administering Microsoft Exchange Server 2016 |
35.00 |
$2,899.00 |
|
Description: This 5-day instructor-led course teaches IT professionals how to administer and support Exchange Server 2016. Students will learn how to install Exchange Server 2016, and how to configure and manage an Exchange Server environment. The course covers how to manage mail recipients and public folders, including how to perform bulk operations using Exchange Management Shell. Students also will learn how to manage client connectivity, message transport and hygiene, how to implement and manage highly available Exchange Server deployments, and how to implement back up and disaster recovery solutions. The course also teaches students how to maintain and monitor an Exchange Server 2016 deployment. In addition, students will learn how to administer Exchange Online in an Office 365 deployment.
Audience Profile
This course is primarily intended for people aspiring to become enterprise-level messaging administrators for Exchange Server 2016. IT generalists and help-desk professionals who want to learn about Exchange Server 2016 might also take this course. Students taking this course are expected to have at least two years of experience working in the IT fieldtypically in the areas of Windows Server administration, network administration, help desk, or system administration. They are not expected to have experience with previous Exchange Server versions.
The secondary audience for this course includes IT professionals who take this course as preparation material for exam 70-345: Designing and Deploying Microsoft Exchange Server 2016, or as part of the requirement for the MCSE: Microsoft Exchange Server 2016 certification.
# of Days:
Setting:
|
20345-2 - Designing and Deploying Microsoft Exchange Server 2016 |
35.00 |
$2,899.00 |
|
Description: This course provides experienced Exchange Server administrators with the knowledge to design and implement an Exchange Server 2016 messaging environment. Students will learn how to design and configure advanced components in an Exchange Server 2016 deployment such as site resiliency, advanced security, compliance, archiving, and discovery solutions. In addition, students will learn about coexistence with other Exchange organizations or Exchange Online, and migration from previous versions of Exchange Server. The course will provide guidelines, best practices, and considerations that will help students optimize their Exchange Server deployment.
Audience profile
This course is intended for IT professionals who are experienced messaging administrators, messaging architects, or consultants. This course is designed for professionals in an enterprise environment who are responsible for designing and deploying Exchange Server 2016 solutions, including environments that contain previous versions of Exchange Server or Exchange Online. Students are expected to have experience with Exchange Server 2016 or previous versions of Exchange Server.
This course is also intended as preparation material for IT professionals who are looking to take the 70-345: Designing and Deploying Microsoft Exchange Server 2016 exam as part of the requirement for the MCSE: Microsoft Exchange Server 2016 certification.
# of Days:
Setting:
|
20779 - Analyzing Data with Excel |
21.00 |
$1,739.00 |
|
Description: The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
Audience Profile
This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.
The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.
# of Days:
Setting:
|
Excel 2016 Charts |
4.00 |
$219.00 |
|
Description: In this course, you will cover how to create a chart sheet, create an embedded chart, format a chart, create a pie chart, create a 3D Column Chart, create a picture chart, create a combination chart, add new data create a user-defined chart type.
# of Days:
Setting:
|
Excel 2016 Dashboards |
7.00 |
$299.00 |
|
Description: In this Microsoft Excel 2016 Dashboards course students will give you the skills to use Excel 2016 Dashboards at an advanced level. Microsoft Excel 2016 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 2016 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 2016 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.
Upon successful completion of this course, you will be able to use Power Pivot along with Excel 2016 to analyze data from a variety of sources. You will be able to do the following:
Get started with Power Pivot.
Visualize Power Pivot data.
Work with advanced functionality in Power Pivot.
# of Days:
Setting:
|
Excel 2016 Formulas |
6.00 |
$279.00 |
|
Description: In this course, you will cover how to: build a formula, use function formulas, work with range names in a formula, use Logical and Lookup function formulas, use Financial function formulas, use the Concatenate function formula, work with the Date, Proper, Upper and Lower function formulas, create a function formulas from scratch work with data tables.
# of Days:
Setting:
|
Excel 2016 Level 1 for Windows |
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 create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.
You will:
? Get started with Microsoft Office Excel 2016.
? Perform calculations.
? Modify a worksheet.
? Format a worksheet.
? Print workbooks.
? Manage workbooks.
Prepares you for the Microsoft Office Specialist exam for Excel 2016 and the Excel 2016 Expert Exam.
# of Days:
Setting:
|
Excel 2016 Level 2 for Windows |
7.00 |
$289.00 |
|
Description: In this course, you will cover how to work with large worksheets in Microsoft Excel 2016, 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 clipart.
# of Days:
Setting:
|
Excel 2016 Level 3 for Windows |
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 2016 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 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 |
0.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 shot 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 PivotTables |
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 2019 VBA Programming |
7.00 |
$299.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 so they can be performed faster, more consistently, and with less effort than performing them manually. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks. You will learn how to use the macro recorder effectively, as well as how to write your own VBA code from scratch. You will use tools built into Excel to explore and learn VBAs capabilities and to optimize and debug your code.
At Course Completion:
After competing this course, student will be able to:
Identify general components of VBA and their appropriate use in solving business solutions.
Record VBA macros to automate repetitive tasks.
Write VBA code to create VBA subroutines and functions.
Use various programming elements to solve problems through code, including variables, objects, conditional statements, and loops.
Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
# 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:
|