DFW Excel Experts

Get to know Microsoft Excel in this one-day introductory course. People with no Excel knowledge, as well as self-taught users, can benefit from this class. Specific course topics include an Excel overview, initializing, saving, utilizing, and sharing workbooks, creating and modifying cells, dealing with multiple worksheets, using formulas and functions, and publishing spreadsheets.

This one-day intermediate Microsoft Excel course focuses on using formulas and functions to more effectively manage data. This class opens a world of possibilities for self-taught users and those with basic Excel skills. Specific course topics include tables, range names, date, time, and other functions, and Flash Fill.

Effectively analyze and present data with the skills you learn in this one-day Microsoft Excel intermediate course. Participants learn how to use existing Excel tools to take their data management skills to the next level. Specific course topics include validating data, using conditional formulas, working with advanced charts, and mastering PivotTables, PivotCharts, and associated calculations.

Effectively leverage Power Query to find, link, and manipulate different data sources in this one-day advanced Microsoft Excel class. People who have intermediate Excel skills but have never used Power Query usually benefit from this course. Specific class topics include an overview of Power Suite, data loading mechanisms, data transformation, manipulating queries and columns, and using M language and functions.

Fully utilize Microsoft Excel’s Power Pivot function in this advanced one-day course. These skills are essential for people who need to quickly analyze considerable amounts of data and make enterprise-level decisions. Specific course topics include a Power Suite overview, data modeling techniques, learning DAX (Data Analysis Expression), such as creating a Power Pivot table and creating explicit and implicit measures, and using some other popular DAX functions.

This one-day Microsoft Excel advanced course gives participants the skills they need to effectively present business data. Course curriculum includes an overview of the most widely-used dashboard techniques. Specific course topics include surveying dashboard design principles, importing data, and using PivotCharts with Slicers and Interactive Charts Dashboard designs. PivotCharts help users break down complex data, and Interactive Charts allow users to build a unique combination of graphs, charts, and other presentation tools.

Add an Interactive Charts Dashboard to your Microsoft Excel repertoire in this one-day advanced course. Interactive Charts Dashboards allow users to customize the interface to suit their needs and preferences. Specific course topics include principles of dashboard design, working with different patterns, and creating Operating Revenue and Customer Satisfaction dashboards.

Dive into advanced calculations and other sophisticated Microsoft Excel functions in this one-day advanced course. Participants with an intermediate understanding of Excel usually benefit most from this course. Specific topics include understanding and using functions like logic, reference, lookup, time/date, text, and auditing, as well as working with different Excel arrays.

Add VBA macro programming to your long list of Microsoft Excel skills in this three-day advanced course. After participants learn some VIsual Basic for Applications programming basics, the curriculum moves quickly to skills application in a group project setting. Specific topics include a VBA overview, including VBA terminology, workbooks, data types, worksheets, user-defined procedures and functions, loops, names, decision structures, data manipulation, file and information management, and form customization.