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, creating, saving, using, and sharing workbooks, entering and formatting data in cells, managing 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 and time functions, and Flash Fill.

Effectively analyze and present data with the skills you learn in this one-day intermediate Microsoft Excel 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 Query, data-loading mechanisms, data transformation, manipulating queries and columns, and using the 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 Pivot overview, data modeling techniques, learning DAX (Data Analysis Expressions), such as creating Power Pivot tables and creating explicit and implicit measures, and using some other popular DAX functions.

This one-day advanced Microsoft Excel 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 dashboard chart 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 design 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 logical, reference, lookup, date/time, text, and auditing, as well as working with Excel arrays.

Add VBA macro programming to your long list of Microsoft Excel skills in this three-day advanced course. After participants learn 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, naming conventions, decision structures, data manipulation, file and information management, and form customization.