Chat with us, powered by LiveChat
  • LOGIN
  • No products in the cart.

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

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

4 STUDENTS ENROLLED

Overview

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.

Highlights of the Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course:

  • Enjoy free entrance to Microsoft Excel Complete Course online course
  • High-quality study notes or materials
  • Simple and step-by-step instructions will make your learning easier, quicker, and more enjoyable
  • Dramatically boost your MS Excel skills and confidence
  • Comfortable Premises with the latest technology
  • Learn practical tips and techniques from an industry expert
  • Gain hands-on experience in training
  • Achieve your goals and transform your career by learning from an industry expert
  • Earn a CPD endorsed certification on successful completion
  • No hidden fees or exam charges
  • Ask any questions and get responses from a professional

Enrol in a Microsoft Excel Complete Course online course absolutely FREE! So, what are you thinking about!! Start learning today.

Description

Please note: Once you get the online access you have to secure your classroom spot by paying a fee of £159.

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.

Benefits of studying Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course:

  • 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

Course Objectives:

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

Who is this course for?

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.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Requirements

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.

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

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.

Career path

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

Course Curriculum

Book Your Place
Book Your Place – Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course 00:00:00
Getting Started with Microsoft Office Excel 2016
Navigate the Excel User Interface 00:28:00
Use Excel Commands 00:10:00
Create and Save a Basic Workbook 00:19:00
Enter Cell Data 00:12:00
Use Excel Help 00:05:00
Performing Calculations
Create Worksheet Formulas 00:15:00
Insert Functions 00:17:00
Reuse Formulas and Functions 00:17:00
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00
Search for and Replace Data 00:09:00
Use Proofing and Research Tools 00:07:00
Formatting a Worksheet
Apply Text Formats 00:17:00
Apply Number Format 00:08:00
Align Cell Contents 00:09:00
Apply Styles and Themes 00:12:00
Apply Basic Conditional Formatting 00:11:00
Create and Use Templates 00:07:00
Printing Workbooks
Preview and Print a Workbook 00:10:00
Set Up the Page Layout 00:08:00
Configure Headers and Footers 00:07:00
Managing Workbooks
Manage Worksheets 00:05:00
Manage Workbook and Worksheet Views 00:07:00
Manage Workbook Properties 00:05:00
Working with Functions
Work with Ranges 00:18:00
Use Specialized Functions 00:11:00
Work with Logical Functions 00:23:00
Work with Date & Time Functions 00:08:00
Work with Text Functions 00:11:00
Working with Lists
Sort Data 00:10:00
Filter Data 00:10:00
Query Data with Database Functions 00:09:00
Outline and Subtotal Data 00:09:00
Analyzing Data
Welcome to the Course FREE 00:03:00
Apply Intermediate Conditional Formatting 00:07:00
Apply Advanced Conditional Formatting 00:05:00
Visualizing Data with Charts
Create Charts 00:13:00
Modify and Format Charts 00:12:00
Use Advanced Chart Features 00:12:00
Using PivotTables and PivotCharts
Create a PivotTable 00:13:00
Analyze PivotTable Data 00:12:00
Present Data with PivotCharts 00:07:00
Filter Data by Using Timelines and Slicers 00:11:00
Working with Multiple Worksheets and Workbooks
Use Links and External References 00:12:00
Use 3-D References 00:06:00
Consolidate Data 00:05:00
Using Lookup Functions and Formula Auditing
Use Lookup Functions 00:12:00
Trace Cells 00:09:00
Watch and Evaluate Formulas 00:08:00
Sharing and Protecting Workbooks
Collaborate on a Workbook 00:19:00
Protect Worksheets and Workbooks 00:08:00
Automating Workbook Functionality
Apply Data Validation 00:13:00
Search for Invalid Data and Formulas with Errors 00:04:00
Work with Macros 00:18:00
Creating Sparklines and Mapping Data
Create Sparklines 00:07:00
MapData 00:07:00
Forecasting Data
Determine Potential Outcomes Using Data Tables 00:08:00
Determine Potential Outcomes Using Scenarios 00:09:00
Use the Goal Seek Feature 00:04:00
Forecasting Data Trends 00:05:00
Mock Exam
Mock Exam – Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course 00:20:00
Final Exam
Final Exam – Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course 00:20:00

Course Reviews

4.7

4.7
8 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE

COPYRIGHT © 2018 One Education