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 |
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) |
|
|
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) |
|
|
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) |
|
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 |
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 |
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 |
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 |
Excel - PivotTables
Learn to create and analyze PivotTable data.
(Prerequisites: Excel Level 1) |
|
|
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
| |
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
| |
Excel 2016 - Data Analysis with PivotTables
Learn to create and analyze PivotTable data.
(Prerequisites: Excel Level 1) |
|
|
1 Day
$495
DT2C
| |
Data Analysis using Excel 2016 - Level 1 - Report Builders
This is the first course in TLG Learning’s exclusive Data Analysis using Excel 2016 series. This course lays the foundation for Power BI Report Builder using Excel. Report Builders will learn everything they need to create highly effective PivotTable and PivotChart reports using data sources that are created using Excel. 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 level 1, PivotTable & Pivot Chart skills; plus a basic understanding of database concepts is useful, but not required.) |
|
|
1 Day
$495
DT2C
| |
Power BI Tools in Excel 2016 - Level 2
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: Data Analysis using Excel 2016 -Level 1 - Report Builders) |
|
|
1 Day
$595
TT2J
| |
Data Model Design using Excel 2016 - Level 3
This is the third course in TLG Learning’s custom Power BI using Excel 2016 training series. What makes Power BI such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed for Report Builders who are ready to create custom data models for themselves and for other Excel 2016 Report Users.
(Prerequisites: Power BI Tools in Excel 2016 - Level 2) |
|
|
2 Days
$1190
TT2J
| |
Introduction to DAX for Excel 2016 Users - Level 4
This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations.
(Prerequisites: Data Model Design using Excel 2016 - Level 3) |
|
|
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
| |
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
| |
Excel 2013 - PivotTables
Learn to create and analyze PivotTable data.
(Prerequisites: Excel Level 1) |
|
|
1 Day
$495
DT2C
| |
Data Analysis using Excel 2013 - Level 1 - Report Builders
This is the first course in TLG Learning’s exclusive Data Analysis using Excel 2013 series. This course lays the foundation for Power BI Report Builder using Excel. Report Builders will learn everything they need to create highly effective PivotTable and PivotChart reports using data sources that are created using Excel. 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 level 1, PivotTable & Pivot Chart skills; plus a basic understanding of database concepts is useful, but not required.) |
|
|
1 Day
$495
DT2C
| |
Power BI Tools in Excel 2013 - Level 2
This is the second course in TLG Learning’s exclusive Power BI using Excel 2013 series. This course builds on the foundation set in the Data Analysis using Excel 2013 Report Builders. In this course, students learn how to use the Power View, Power Map, and Power Query add-ins.
(Prerequisites: Data Analysis using Excel 2013 - Level 1 - Report Builders) |
|
|
1 Day
$595
TT2J
| |
Data Model Design using Excel 2013 - Level 3
This is the third course in TLG Learning’s custom Power BI using Excel 2013 training series. What makes Power BI such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. This course is designed for Report Builders who are ready to create custom data models for themselves and for other Excel 2013 Report Users.
(Prerequisites: Power BI Tools in Excel 2013 - Level 2) |
|
|
2 Days
$1190
TT2J
| |
Introduction to DAX for Excel 2013 Users - Level 4
This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations.
(Prerequisites: Data Model Design using Excel 2013 - Level 3) |
|
55049 - PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
|
| Overview | Course Outline | |
|
2 Days
$1395
TT2K
| |
55049 - PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts
This course concentrates on PowerPivot and Power View in Excel 2013. Learn how to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 2013.
(Prerequisites: Excel 2007 or later, understanding of PivotTables) |
|
Course | Length/Cost | Location(s) | | Register Now | Time |
|
|
1 Day
$295
DT2B
| |
Office 2016 New Features
Learn the new and enhanced features that are common across all applications in Office 2016, modify documents using Microsoft Word 2016, enhance worksheet data using Microsoft Excel 2016, augment a presentation using Microsoft PowerPoint 2016, create a database using Microsoft Access 2016, utilize mail, calendars, contacts, and tasks in Microsoft Outlook 2016. Office 2016 is also Office 365.
(Prerequisites: Experienced Office users who have worked with either Microsoft Office 2007 or 2010 and who have upgraded to Microsoft Office 2016.) |
|
|