| Course | Length/Cost | Location(s) | | Register Now | Time |
|
Course | Length/Cost | Location(s) | | Register Now | Time |
|
|
2 Days
$530
DT2A
| Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-4:00PM |
Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Seattle, WA(ILT) | | | 8:00AM-4:00PM |
Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-4:00PM |
Access - Level 1 & 2
Learn essential skills to design, create, and use an Access database in Microsoft Office, including relational database concepts, planning and creating a database, data entry guidelines, and working with forms, queries, and reports.
(Prerequisites: At least one year experience using Windows 10, 8, or 7) |
|
|
Up to 3 days
$265 per day
DT2A
| Bellevue, WA(MLT) | | | 8:00AM-4:00PM |
Seattle, WA(MLT) | | | 8:00AM-4:00PM |
Bellevue, WA(MLT) | | | 8:00AM-4:00PM |
Seattle, WA(MLT) | | | 8:00AM-4:00PM |
Access 2016 - Mentor-led Training
In Access 2016, the relational database app in Microsoft Office, you can design your own databases or use templates to create databases to share with others, namely coworkers. In this course you will create databases, create tables, build queries, build forms, and build reports. This, combined with what you will learn about relational database structures, will improve your skills with small to medium-sized relational databases.
You may purchase this Mentor-led Training Course per day at the per day price shown above and focus on only the topics you need, or you may purchase the full course content available on this topic (see "Up to" number of days above) with free repeat privileges and post class online video access included.
(Prerequisites: At least one year experience using Windows 10, 8, or 7) |
|
|
2 Days
$530
DT2A
| |
Access 2016 - Level 1 & 2
Learn essential skills to design, create, and use an Access database in Microsoft Office 2016, including relational database concepts, planning and creating a database, data entry guidelines, and working with forms, queries, and reports. Access 2016 is also Access for Office 365.
(Prerequisites: At least one year experience using Windows 10, 8, or 7) |
|
|
Up to 3 days
$265 per day
DT2A
| Bellevue, WA(MLT) | | | 8:00AM-4:00PM |
Seattle, WA(MLT) | | | 8:00AM-4:00PM |
Bellevue, WA(MLT) | | | 8:00AM-4:00PM |
Seattle, WA(MLT) | | | 8:00AM-4:00PM |
Access 2013 - Mentor-led Training
Learn essential skills to design, create, and use an Access database, including relational database concepts and guidelines, planning and creating a database, working with forms, select and advanced queries, and reports. Simplify tasks with automate data entry, create navigation and dialog boxes, and perform database maintenance to ensure reliability using Access in Microsoft Office 2013.
You may purchase this Mentor-led Training Course per day at the per day price shown above and focus on only the topics you need, or you may purchase the full course content available on this topic (see "Up to" number of days above) with free repeat privileges and post class online video access included.
(Prerequisites: At least one year experience using Windows 10, 8, or 7) |
|
|
2 Days
$530
DT2A
| |
Access 2013 - Level 1 & 2
Learn essential skills to design, create, and use an Access database in Microsoft Office 2013, including relational database concepts, planning and creating a database, data entry guidelines, and working with forms, queries, and reports.
(Prerequisites: At least one year experience using Windows 10, 8, or 7) |
|
|
Up to 3 days
$265 per day
DT2A
| Bellevue, WA(MLT) | | | 8:00AM-4:00PM |
Access 2010 - Mentor-led Training
Learn essential skills to design, create, and use an Access database, including relational database concepts and guidelines, planning and creating a database, working with forms, select and advanced queries, and reports. Simplify tasks with macros, automate data entry, create navigation and dialog boxes, and perform database maintenance to ensure reliability using Access in Microsoft Office 2010.
You may purchase this Mentor-led Training Course per day at the per day price shown above and focus on only the topics you need, or you may purchase the full course content available on this topic (see "Up to" number of days above) with free repeat privileges and post class online video access included.
(Prerequisites: At least one year experience using Windows 10, 8, or 7) |
|
Course | Length/Cost | Location(s) | | Register Now | Time |
|
|
1 Day
$265
DT1A
| Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-4:00PM |
Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Seattle, WA(ILT) | | | 8:00AM-4:00PM |
Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-4:00PM |
Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Seattle, WA(ILT) | | | 8:00AM-4:00PM |
Excel - Level 1
Learn the basic functions and features of Excel. Topics include how to use the Help system, navigate worksheets and workbooks, enter and edit text, values, formulas, and pictures. Also learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, printing, and how to manage large workbooks.
(Prerequisites: At least one year experience using Windows 10, 8, or 7) |
|
|
1 Day
$265
DT1A
| Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-4:00PM |
Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Seattle, WA(ILT) | | | 8:00AM-4:00PM |
Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-4:00PM |
Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Seattle, WA(ILT) | | | 8:00AM-4:00PM |
Excel - Level 2
Learn how to use multiple worksheets and workbooks efficiently. Work with more advanced formatting options including styles, themes, and backgrounds. Learn to use advanced formulas, including lookup functions. Create and apply cell names, work with tables, learn basic and advanced charting techniques, including the use of trendlines and sparklines. Finally, learn to work with PivotTables and PivotCharts.
(Prerequisites: Excel Level 1) |
|
|
1 Day
$265
DT1A
| Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Seattle, WA(ILT) | | | 8:00AM-4:00PM |
Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-4:00PM |
Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Seattle, WA(ILT) | | | 8:00AM-4:00PM |
Excel - Level 3
Learn to work with advanced formulas, including logical functions (IF, IFERROR, SUMIF). Also learn about data validation, database functions, and analytical features of Excel (such as Goal Seek and Solver). In addition learn to create outlines and subtotals, audit and protect worksheets, run and record macros, and import and export data.
(Prerequisites: Excel Level 2) |
|
|
½ Day
$175
DT2C
| Anywhere (Live-OLT) | | | 8:00AM-11:30AM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-11:30AM |
Anywhere (Live-OLT) | | | 8:00AM-11:30AM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-11:30AM |
Anywhere (Live-OLT) | | | 8:00AM-11:30AM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-11:30AM |
Excel - PivotTables
Learn to create and analyze PivotTable data.
(Prerequisites: Excel Level 1) |
|
|
Up to 3 days
$265 per day
DT1A
| Bellevue, WA(MLT) | | | 8:00AM-4:00PM |
Seattle, WA(MLT) | | | 8:00AM-4:00PM |
Bellevue, WA(MLT) | | | 8:00AM-4:00PM |
Seattle, WA(MLT) | | | 8:00AM-4:00PM |
Excel 2016 - Mentor-led Training
Learn essential skills to create spreadsheets, perform simple and advanced formula calculations, format, edit and print reports, create charts and graphics, sort and filter data. Also learn to automate common tasks, apply advanced analysis techniques to more complex data and collaborate efficiently using Excel in Microsoft Office 2016.
You may purchase this Mentor-led Training Course per day at the per day price shown above and focus on only the topics you need, or you may purchase the full course content available on this topic (see "Up to" number of days above) with free repeat privileges and post class online video access included.
You may purchase this Mentor-led Training Course per day at the per day price shown above and focus on only the topics you need, or you may purchase the full course content available on this topic (see "Up to" number of days above) with free repeat privileges and post class online video access included.
(Prerequisites: At least one year experience using Windows 10, 8, or 7) |
|
|
1 Day
$265
DT1A
| |
Excel 2016 - Level 1
Learn the basic functions and features of Excel 2016. Topics include how to use the Help system, navigate worksheets and workbooks, enter and edit text, values, formulas, and pictures. Also learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, printing, and how to manage large workbooks. Excel 2016 is also Excel for Office 365.
(Prerequisites: At least one year experience using Windows 10, 8, or 7.) |
|
|
1 Day
$265
DT1A
| Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Seattle, WA(ILT) | | | 8:00AM-4:00PM |
Excel 2016 - Level 2
Learn how to use multiple worksheets and workbooks efficiently. Work with more advanced formatting options including styles, themes, and backgrounds. Learn to use advanced formulas, including lookup functions. Create and apply cell names, work with tables, learn basic and advanced charting techniques, including the use of trendlines and sparklines. Finally, learn to work with PivotTables and PivotCharts. Excel 2016 is also Excel for Office 365.
(Prerequisites: Excel Level 1) |
|
|
1 Day
$265
DT1A
| |
Excel 2016 - Level 3
Learn to work with advanced formulas, including logical functions (IF, IFERROR, SUMIF). Also learn about data validation, database functions, and analytical features of Excel (such as Goal Seek and Solver). In addition learn to create outlines and subtotals, audit and protect worksheets, run and record macros, and import and export data. Excel 2016 is also Excel for Office 365.
(Prerequisites: Excel Level 2) |
|
|
½ Day
$175
DT2C
| Anywhere (Live-OLT) | | | 8:00AM-11:30AM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-11:30AM |
Excel 2016 - Data Analysis with PivotTables
Learn to create and analyze PivotTable data.
(Prerequisites: Excel Level 1) |
|
|
1 Day
$495
DT2C
| Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Seattle, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Bellevue, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Seattle, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Bellevue, WA(ILT) | | | 7:00AM-3:00PM |
Power BI for Excel 2016 - Level 1 - Report Builders
This is the first course in TLG Learning’s exclusive Power BI for Excel 2016 training series. This course lays the foundation for all Power BI for Excel Designers. It is the first of several courses an Advanced Power BI Designer would require. Power BI Report Writers will learn everything they need to create highly effective PivotTable and PivotChart reports using data models created by more advanced Power BI Designers. Topics covered include an overview of the PowerPivot add-in, creating effective and professional reports, creating data driven narratives, effectively applying different chart styles, using data hierarchies, and creating simple custom data calculations.
(Prerequisites: Excel levels 1 & 2, including PivotTable & Pivot Chart skills; plus a basic understanding of database concepts.) |
|
|
1 Day
$495
DT2C
| Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Seattle, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Bellevue, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Seattle, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Bellevue, WA(ILT) | | | 7:00AM-3:00PM |
Power BI for Excel 2016 - Level 2 - Power BI Tools
This is the second course in TLG Learning’s exclusive Power BI for Excel 2016 training series. This course builds on the foundation set in the Power BI for Excel Report Builders course. In this course students will learn how to use the Power View, Power Map, and Power Query add-ins. Power BI Report Writers will learn how to use Power View to create highly effective interactive reports using data models created by more advanced Power BI Designers. Students will also learn how to build 3D geospatial reports using Power Map as well as how to transform and query data sources using Power Query. Topics covered include creating effective and professional reports, effectively applying new visualization techniques using Power View, creating geospatial Power Map tours, using data transformations to prepare for data modeling, and creating simple custom data calculations.
(Prerequisites: Power BI for Excel 2016 - Level 1 - Report Builders) |
|
|
1 Day
$595
TT2J
| Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Bellevue, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Seattle, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Bellevue, WA(ILT) | | | 7:00AM-3:00PM |
Power BI for Excel 2016 - Level 3 - Data Model Designers
This is the third course in TLG Learning’s custom Power BI for Excel 2016 training series. What makes Power BI for Excel such a vast improvement over detailed Excel worksheets is the PowerPivot Data Model, which allows data to be pulled together from multiple tables and multiple databases. This course is designed for Power BI for Excel Designers who are ready to create custom data models for themselves and for other Power BI Designers. Topics covered include database design concepts, how to build both general purpose and customized data models, building data hierarchies, and how to use basic DAX language and functionality to extend the capabilities of data models for in-depth and customized analysis of information.
(Prerequisites: Power BI for Excel 2016 - Level 2 - Power BI Tools) |
|
|
2 Days
$1190
TT2J
| Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Bellevue, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Seattle, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Bellevue, WA(ILT) | | | 7:00AM-3:00PM |
Power BI for Excel 2016 - Level 4 - DAX Functions
This is the fourth course in TLG Learning’s custom Power BI for Excel 2016 training series. This course is built for Power BI for Excel Designers that will be responsible for taking basic PowerPivot data models turning them into powerful business intelligence solutions. This course will introduce you to the DAX language, teaching you basic DAX Functions and syntax preparing you to build customized business intelligence solutions. Specific topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, and working with time intelligence calculations.
(Prerequisites: Power BI for Excel 2016 - Level 3 - Data Model Designers) |
|
|
Power BI for Excel 2016 - Report Builders, Power BI Tools, Data Model Designers, and DAX Functions
|
| Overview | Course Outline | |
|
5 Days
$2775
TT2J
| Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Bellevue, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Seattle, WA(ILT) | | | 7:00AM-3:00PM |
Anywhere (Live-OLT) | | | 7:00AM-3:00PM Pacific Time |
Bellevue, WA(ILT) | | | 7:00AM-3:00PM |
Power BI for Excel 2016 - Report Builders, Power BI Tools, Data Model Designers, and DAX Functions
First day topics covered include an overview of PowerPivot, creating effective and professional reports, creating hierarchies, effectively applying different chart styles, and creating report templates. Second day topics include creating Power Views with Excel, Power Map, and Power Query. Third day topics include database design concepts, how to build both general purpose and customized data models, and how to use basic DAX language and functionality to extend the capabilities of data models for in-depth and customized analysis of information. Fourth and fifth day topics covered in this class include Relational functions, Date functions, Banding, Ranking, advanced Slicer techniques, plus using DAX as a query language for customized analysis.
(Prerequisites: Excel levels 1 & 2, including PivotTable & Pivot Chart skills; plus a basic understanding of database concepts.) |
|
|
Up to 4 days
$265 per day
DT1A
| Bellevue, WA(MLT) | | | 8:00AM-4:00PM |
Seattle, WA(MLT) | | | 8:00AM-4:00PM |
Bellevue, WA(MLT) | | | 8:00AM-4:00PM |
Seattle, WA(MLT) | | | 8:00AM-4:00PM |
Excel 2013 - Mentor-led Training
Learn essential skills to create spreadsheets, perform simple and advanced formula calculations, format, edit and print reports, create charts and graphics, sort and filter data. Also learn to automate common tasks, apply advanced analysis techniques to more complex data and collaborate efficiently using Excel in Microsoft Office 2013.
You may purchase this Mentor-led Training Course per day at the per day price shown above and focus on only the topics you need, or you may purchase the full course content available on this topic (see "Up to" number of days above) with free repeat privileges and post class online video access included.
(Prerequisites: At least one year experience using Windows 10, 8, or 7) |
|
|
1 Day
$265
DT1A
| |
Excel 2013 - Level 1
Learn the basic functions and features of Excel 2013. Topics include how to use the Help system, navigate worksheets and workbooks, enter and edit text, values, formulas, and pictures. Also learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, printing, and how to manage large workbooks.
(Prerequisites: At least one year experience using Windows 10, 8, or 7) |
|
|
1 Day
$265
DT1A
| Anywhere (Live-OLT) | | | 8:00AM-4:00PM Pacific Time |
Seattle, WA(ILT) | | | 8:00AM-4:00PM |
Excel 2013 - Level 2
Learn how to use multiple worksheets and workbooks efficiently. Work with more advanced formatting options including styles, themes, and backgrounds. Learn to use advanced formulas, including lookup functions. Create and apply cell names, work with tables, learn basic and advanced charting techniques, including the use of trendlines and sparklines. Finally, learn to work with PivotTables and PivotCharts.
(Prerequisites: Excel Level 1) |
|
|
1 Day
$265
DT1A
| |
Excel 2013 - Level 3
Learn to work with advanced formulas, including logical functions (IF, IFERROR, SUMIF). Also learn about data validation, database functions, and analytical features of Excel (such as Goal Seek and Solver). In addition learn to create outlines and subtotals, audit and protect worksheets, run and record macros, and import and export data.
(Prerequisites: Excel Level 2) |
|
|
½ Day
$175
DT2C
| Anywhere (Live-OLT) | | | 8:00AM-11:30AM Pacific Time |
Bellevue, WA(ILT) | | | 8:00AM-11:30AM |
Excel 2013 PivotTables
Learn to create and analyze PivotTable data.
(Prerequisites: Excel Level 1) |
|
|