Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course Private

Course

Online

£ 100 VAT inc.

Description

  • Type

    Course

  • Level

    Beginner

  • Methodology

    Online

  • Class hours

    10h

  • Duration

    1 Year

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

This one-day, hands-on Microsoft Excel Complete Course is fully Accredited by CPD and supports you build a strong foundation in Excel for careers in diverse sectors.

In this Microsoft Excel Complete Course, gain a comprehensive, practical understanding of Excel including tips, tricks, shortcuts, functions and formulas you need to be a power user. You will learn to create spreadsheets and workbooks using Microsoft Office Excel for storing, manipulating and sharing data.

This Microsoft Excel Complete Course is suitable for anyone, from beginners to advanced users, who are already performing professional financial analysis and financial modelling and wanting to learn 2016, 2013, 2010 or 2007, as it comprises all the aspects and differences between the versions.

Get succeed in the workplace through a focus on Microsoft Excel and prep for a wall street career.

In order to earn an accredited certificate, you will attend practical training and get full access to our online student portal, where you will discover a treasure of high-quality learning resources including engaging lessons, tutorial videos and comprehensive manuals.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

By the time you complete this Microsoft Excel Complete Course, you will be able to:

Perform calculations
Modify a worksheet
Format a worksheet
Print workbook contents
Manage large workbooks
Apply keyboard shortcuts
Understand functions and formulas
What’s included?

Refreshments
Course Notes / Material
Certificate of achievement

This Microsoft Excel Complete Course is suitable for learners seeking to gain the necessary skills and knowledge to create, edit, format, and print basic Microsoft Office Excel worksheets.

Being an expert in Excel can unlock the door to many career opportunities such as:

Administrative Assistant
Data Analyst
Accountants
Financial Analyst
Retail Store Manager
Project Manager
Business Analyst
Financial Planner
Investment Banker
Corporate Development Officer

In order to take this Microsoft Excel Complete Course, you should have sound knowledge of using personal computers, including the mouse and keyboard. You should be familiar with the Windows environment and be able to use Windows to manage information on the computer.

Notably, you should be able to start and close programs; navigate to information stored on the computer; handle files and folders; use the internet.

Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Master Microsoft Excel from beginner to expert level
Learn the most common Excel functions used in the Office
Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
Maintain large sets of Excel data in a list or table
Create dynamic reports by mastering one of the most popular tools, PivotTables
Amaze by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
Excel Templates are included allowing for enhanced learning through hands-on activities

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 5 years

Subjects

  • Excel
  • Office IT
  • Microsoft Excel
  • Financial
  • Private
  • Accredited
  • Ms Office
  • Financial Training
  • Microsoft excel training
  • MS Excel
  • Microsoft Office
  • Charts
  • Analyzing Data

Course programme

COURSE CURRICULUM
  • Book Your Place
  • Getting Started with Microsoft Office Excel 2016
  • Performing Calculations
  • Modifying a Worksheet
  • Formatting a Worksheet
  • Printing Workbooks
  • Managing Workbooks
  • Working with Functions
  • Working with Lists
  • Analyzing Data
  • Visualizing Data with Charts
  • Using PivotTables and PivotCharts
  • Working with Multiple Worksheets and Workbooks
  • Using Lookup Functions and Formula Auditing
  • Sharing and Protecting Workbooks
  • Automating Workbook Functionality
  • Creating Sparklines and Mapping Data
  • Forecasting Data
  • Mock Exam
  • Final Exam

Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course Private

£ 100 VAT inc.