Dynamic Web Training

This 1-day introductory Microsoft Excel course will teach those new to Excel how to successfully get up and running with Microsoft’s powerful spreadsheet program. The course explores a range of core Excel concepts, including an overview of the Excel interface, how to create a new workbook, editing data, working with formulas and functions, selecting ranges, copying and pasting data, applying borders to cells, row and column formatting, adjusting pages, printing, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

This 1-day intermediate Microsoft Excel course will teach those with a basic understanding of Excel some intermediate tools and shortcuts to enhance their spreadsheet knowledge and workflow. The course explores a range of Excel concepts, including data filling, formula referencing, defining names, essential functions, conditional formatting, working with worksheets, find and replace, sorting and filtering data, creating charts, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

This 1-day advanced Microsoft Excel course will teach those with a good grasp of Excel some of the advanced tools to elevate their spreadsheet knowledge and workflow capabilities. The course explores a range of advanced Excel concepts, including lookup and text functions, finance functions, complex formulas, goal seek, data linking, data protection, summarizing and subtotaling, grouping, pivot tables, pivot charts, macros, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

This 1-day Power BI for Excel course will teach those with advanced knowledge of Excel how to incorporate some business intelligence elements into their Excel workbooks. The course explores a range of Power BI tools and concepts, including how to link data to Query, accessing data types from Query, transforming data, importing data into PowerPivot, data model relationships, the differences between PowerPivot and Query, the DAX language and DAX measures, text-based calculations and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

This 2-day Excel Visual Basic (VBA) course will teach students how to automate tasks and develop programs using the VBA editor. The course explores a range of VBA programming concepts, including a broad overview of VBA terminology, starting with Excel VBA, understanding procedures, using variables, functions in VBA, using Excel objects, various programming techniques, creating custom forms, error handling, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

This 1-day Power BI Essentials course will teach students how to develop and share dashboards using Microsoft’s dynamic business intelligence software. The course explores a range of Power BI reporting concepts, including a broad overview of business intelligence and data analytics, understanding and getting started with Power BI, importing data, transforming data, an introduction to Power Query, data modeling, an introduction to DAX, data visualization best practices in Power BI, working with filters and slicers, Power BI publisher, and more. Students will also receive a certificate of completion, training manual, 12 months of email support, and the option to take the class again for free.

Move into advanced data analytics and explore the latest Microsoft Power BI features in this intermediate-level, two-day course. Students learn how to perform advanced data manipulations and create advanced analytical models. Through hands-on learning, participants also explore topics like script visualization, report design, data analytics, and dashboard design.

This 1-day Microsoft Word workshop was designed to help individuals new to working with Word learn how to create clean and professional documents. The workshop covers a broad range of beginner Word concepts and tools, including a primer on getting started with Word, how to format text and paragraphs, workflow efficiency tips and tricks, how to manage lists and add tables, and insert graphics, controlling page appearance, and best practices for finalizing and publishing a Word document.

This 1-day intermediate Microsoft Word workshop was designed to help individuals with a firm grasp of Word basics learn some intermediate skills to enhance and create more professional looking documents. The workshop covers a broad range of intermediate Word concepts and tools, including how to organize content with tables and charts, customizing formats using styles and themes, inserting Word Art, using templates to automate document formatting, controlling document flow, document simplification, and using mail merge to quickly create letters, envelopes, and labels.

This 1-day advanced Microsoft Word workshop was designed to help individuals with a strong grasp of Word basics learn some advanced skills to further enhance the look and flow of their documents. The workshop covers a broad range of advanced Word concepts and tools, including how to create and work with master documents, manipulate images, use customer graphic elements, document collaboration, adding references and links to documents, securing a document, using forms, and an overview of automating tasks with macros.