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 Excel spreadsheet software. 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 page layout, 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 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, using 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 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, PivotTables, PivotCharts, 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 using Power Query, accessing data types in Power Query, transforming data, importing data into Power Pivot, data model relationships, the differences between Power Pivot and Query, DAX functions and 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, using functions in VBA, working with 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 Power BI 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 for Excel, 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 custom visuals and scripting, report design, advanced data analysis, 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, inserting graphics, how to control page appearance, and reviewing 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 WordArt, using templates to automate document formatting, controlling document flow, simplifying documents, 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 custom graphic elements, document collaboration, adding references and hyperlinks to documents, securing a document, using forms, and an overview of automating tasks with macros.