Advanced Excel & Power Point Course

Advanced PowerPoint & Excel Training


The course is designed to demystify some of the most complex business relevant areas of Microsoft Excel. The course is supported with videos and loads of practice exercises and participants will be able to use the most hard to grasp Excel functions in no time. The course covers what you need to know in business and finance rather than what Excel can do. The course covers:

  • Using advanced graphs and presentation techniques to maximise impact
  • How macros and VBA automate your spreadsheets and increase interactivity
  • How superpower functions can solve complex problems
  • Using PivotTables and PowerPivots to turn raw data into clear information that supports key decisions

Section 1: Efficiency and Risk

  • Templates
  • Increasing Efficiency and Reducing Risk
  • Data Validation

Section 2: Advanced Techniques

  • Functions with Superpowers
  • Array Formulae
  • Tables
  • Advanced Range Names
  • What If Analysis
  • Problem Solving

Section 3: Excel Interactivity

  • Form Controls
  • Visual Basic and Macros

Section 4: Spreadsheet Impact

  • Conditional Formatting
  • Charts that Inspire
  • Sparklines
  • Graphics Tricks and Techniques

Section 5: Turning Data into Decisions

  • Advanced Uses of PivotTables
  • PowerPivot
  • Reporting with PowerPivot

Section 6: Course Plenary

  • Plenary

Course duration: 4 –days


The course provides participants with the knowledge and skills required to make beautiful, impressive, effective slides with PowerPoint.
The course will teach attendees how to put together outstanding PowerPoint presentations. Rather than try to teach you everything, we have ruthlessly stripped out all business non-essentials from our syllabus. The result is our highly innovative and impactful PowerPoint course.

Section 1: Foundation

  • The PowerPoint 2016 Interface
  • Getting Started
  • Terminology and Overview
  • Templates and Slide Masters
  • Principles of Slide Design
  • Principles to guide good, clean design and formatting of slides.
  • Making your slides clearer.
  • Creating professional-looking slides with real impact
  • Result within 3 weeks after the exam

Section 2: Creating professional-looking slides with real impact

  • SmartArt
  • Drawing Shapes and Lines
  • Text Boxes
  • Aligning Objects
  • Tips and Shortcuts

Section 3:Administration and Efficiency

  • Printing and Other Output
  • Customising PowerPoin
  • Housekeeping

Section 4: Communicating Analysis

  • Graphs & Charts - How
  • Graphs & Charts - When and Why
  • Making a Presentation Flow
  • Slide-type Toolkit

Section 5: Making an Impact

  • Incorporating Images
  • Transitions and Animation
  • Presenting Your Slides>
  • What Not To Do

The course is appropriate for all category of worker (entry level, mid-level and senior level management staff / employee) who work in any sector

Course fee per participants: N95,000<