Microsoft Excel Intermediate Training

Microsoft Excel
Intermediate Training

27 September 2023 | Virtual Class

Dynamic DNA is a Microsoft Learning Partner. With the Learning Solutions Competency, we specialize in delivering high-end technical learning solutions to our customers. Earning this Competency identifies members of Microsoft premier commercial training and delivery channel, making it easier to expand the scope of services and market potential.

27 September 2023

Virtual Class

Course Overview - Microsoft Excel Intermediate Training

Learn how to work smarter in Excel, improve your efficiency, and impress with your results. You will learn how to better organise, analyse, and present your day-to-day data using Excel spreadsheets. Create complex formulas, use a range of functions, and develop dynamic charts and reports. We also introduce pivot tables, conditional formatting, defined names, and data validation. The course covers key concepts relevant to the workplace. Take your Excel skills to the next level.

Microsoft Excel Intermediate Learning Outcomes

Modify Excel options
Understand and use formula cell referencing
Use the fill operations available to fill a data series
Create and use defined names in a workbook
Use common worksheet functions
Create more complex formulas and functions
Apply a range of number formatting techniques to worksheet cells
Apply conditional formatting to ranges in a worksheet
Use a variety of data validation techniques
Use data linking to create more efficient workbooks
Use goal seeking to determine the values required to reach a desired result
Work with tables in Microsoft Excel
Understand and create simple PivotTables
Use a range of elements and features to enhance charts