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
Corporate Services

Microsoft Excel Intermediate Training

Download the Course Content and Enrolment Form Below

Get In touch

If you any questions regarding the Excel Course, Get in touch!

Contact Us

This field is for validation purposes and should be left unchanged.


Dynamic DNA offers a comprehensive selection of IT and Business courses. Enroll today and take the first step towards a brighter future.