wjb logo

Management Courses

Microsoft Excel Training

All three courses are available as a package for £499 + VAT

Become a Microsoft Office Specialist (MOS) by taking the Microsoft Certified Exam for £99 + VAT - Includes practice exams and exam fee. We advise that you take all levels before sitting the exam to increase your chance of passing.

Microsoft Excel 2013/16 combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Delegates will learn the basics of creating, editing, and saving worksheets in our Essentials level class. They will work with formulas and functions to calculate and return values. Delegates will learn to change the appearance of a page, including adding headers and footers, format data and create charts.

Version 2013 and 2016 courses available. Become a formally qualified Microsoft Office Specialist by completing the Advanced Certificate and entering the exam – exam fees will apply – call for details – 01204 282250

Duration

1 day training session

Course Objectives

  • Identify basic worksheet and workbook concepts and terms
  • Enter & Edit data
  • Modify the worksheet
  • Use functions to calculate and return values
  • Format Cells to enhance the appearance of your worksheet
  • Use drawing features and other enhancements
  • Change the page set up to define how the printed worksheet appears

Course Modules

  • Excel Essentials
  • Formatting Text & Printing a Document
  • Managing the Worksheet
  • Formatting the Worksheet
  • Printing the Worksheet/Book

This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts

Version 2013 and 2016 courses available. Become a formally qualified Microsoft Office Specialist by completing the Advanced Certificate and entering the exam – exam fees will apply – call for details – 01204 282250

Duration

1 day training session

Course Objectives

  • Using multiple worksheets, workbooks and workspaces
  • Working with Financial functions
  • Use advanced formatting techniques
  • Using the Auditing Tools to track information
  • Using charts to display financial data
  • Using Macros to automate your work environment
  • Use Templates

Course Modules

  • Using Multiple Worksheets and Workbooks
  • Charting
  • Advanced Functions
  • Advanced Formatting

This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts

Version 2013 and 2016 courses available. Become a formally qualified Microsoft Office Specialist by entering the exam – exam fees will apply – call for details – 01204 282250

Duration

1 day training session

Course Objectives

  • Creating, Maintaining, Filtering and using Subtotals in a List
  • Recording, Assigning and Using Macros
  • Creating and Using UserDefined Functions
  • Performing “What If” Analyses
  • Working with Scenarios
  • Querying a Database
  • Importing and Exporting Files and Data
  • Protecting Data
  • Pivot Tables, Reports and Charts.
  • Other Advanced Business Analysis Tools

Course Modules

  • Working with Lists
  • Working with Macros and User Defined Functions
  • Using Basic Analysis Tools
  • Using Advanced Analysis Tools and External Data
  • Using Business Analysis Tools
Enquire Online

Enquire Now

We aim to respond within 24hrs

By submitting your details, you agree to be added to WJB weekly newsletter and that WJB Ltd may contact you about relevant services and research via email. You can opt out at any time via the unsubscribe messages in the emails you are sent. By providing your email address above you agree to the WJB Ltd Terms and Conditions and the Privacy Policy.