Excel for Project Management Diploma – CPD Accredited

Excel for Project Management Diploma – CPD Accredited

£149.00

Short Description

SKU: EXPRODIP Categories: ,

Description

This Excel for Project Management Diploma is ideal for people looking to work on Projects. It gives the ideal mix of skills to deliver analytical and reporting work in Project Management. Microsoft Office Courses is a specialist trainer for Microsoft Office Training. We have partnered with Project Management training companies, in order to deliver a Project focused Excel Course. We have used our expertise and technical expertise to develop an online Project focused Excel Training Course.

Excel for Project Management Diploma Objectives

This particular course provides the skills, knowledge and confidence to work in a Project role using Excel. People preparing for interviews should consider this course, as it will prepare you for any possible Excel assessment in the recruitment process.

Excel Training Format

In order to pass the course, an assessment must be taken at the end of the course. The training is delivered online, using a virtual tutor. The virtual tutor instructs, corrects and provides examples, to simulate having a personal IT trainer. This is a very effective and up-to-date method of delivering interactive online training.

This will provide you with a CPD Accredited Certification.

Course Content

The course syllabus focuses on the most commonly required Excel tasks in Project jobs.

Here is an outline of the course:

  • Creating Business Charts; explain your data visually. Creating quality Management tools and information
  • Sparklines and advanced charts
  • Working with multiple views, multiple worksheets and freeze panes
  • Formulas, absolute references
  • Formats and Tables
  • Conditional formats
  • Pivot Tables and Pivot Charts
  • Advanced Functions; Lookup functions, Array Formulas, Date Calculation, Time Calculations, Nested Functions, IF statements, Financial Functions
  • Data Sort and Filters
  • Solver, Goal Seeks, Scenarios, Detecting errors, audit of your spreadsheet and Templates
  • Macros
  • Double Entry Data Tables

Diploma Options

If you prefer to learn face-to-face, we can offer this course in a classroom or virtual classroom environment. Please contact us to discuss our Bespoke Training Courses.

Diploma Benefits

  • Achieve CPD Certification in Excel for Project Management
  • An accredited qualification that will boost your CV and enhance your job options
  • Learn all the Excel skills needed to succeed in Projects
  • Gain confidence in using Excel in the workplace
  • A greater level of efficiency in the workplace

Title

Go to Top