Advanced Excel for Businesses

Excel

 

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In this course, learners solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. Upon completing this course, learners can design sophisticated spreadsheets, including professional dashboards, and perform complex calculations using advanced Excel features and techniques.

Objectives

  • Use formulas and functions to perform calculations on data.
  • Automate choices and data lookups using functions.
  • Create charts and tables that effectively summarize raw data.
  • Create Excel Pivot Table and Macros
  • Build Professional Dashboards

Outline

  • Introduction
  • Working with Excel’s Conditional Functions
  • Excel Vlookup Function
  • Visualizing Data Using Charts
  • Creating a Personal Finance Budget
  • Excel PivotTables
  • Using Excel Macros
  • Creating Dynamic Charts
  • Building Professional Dashboards
  • Import SQL Database Data into Excel

Software Tool

Microsoft Excel

Mode of Training

A live virtual class is delivered by a facilitator applying a learner-centred training session, in real time via Web conferencing and audio. It has all the content of a traditional classroom course plus interactive enhancements such as live chat, videoconferences, white boarding and simulations. It also incorporates hands-on labs and demonstrations. Real world examples and scenarios are used with Excel Practice files and tailored to the learners’ experience.

Resources:

  • Training Manual
  • Recorded Video Session for Participants
  • Assignments
GET IN TOUCH

Training Location Details:

4th Floor, Victoria House,
Chelmsford CM1 1JR

info@leanicontechnology.co.uk

    Translate »