quit

Get in Touch





Get Enquiry

Welcome to CAFE Excel

Let’s Face It…. How Much Time You Spend On Excel or PowerPoint Each Day? 3 Hours?? That’s 15 Hours A Week, 60 Hours A Month? Imagine If You Created A 25% Improvement By Working Smarter, Using Methods You Didn’t Know About? That’s Saving You 15 Hours A Month – 180 Hours A Year, Through Efficient. What Is Your Time Worth?

Microsoft Excel is a spreadsheet program that is used incredibly widely. Having a good understanding of how Excel works is a key skill for any office worker today. Spreadsheets let you store and organise data in a grid of rows and columns. It lets you control and process your data by using formulas and functions. In it’s most simple applications, it can be used to summarise data showing totals, averages and also to very quickly produce graphs and charts. However, it is an extremely powerful and flexible tool and is used in a very wide variety of far more complicated applications. It is used for applications as different as producing full financial models for businesses or groups of businesses and statistically analysing scientific data.

Acuity’sMicrosoft Excel training courses can take you from being a complete beginner, who has never used Microsoft Excel, all the way through to an advanced user who will then be able to make full use of the program’s capabilities. If you wish, you can then go on to learn to program in VBA (visual basic for applications) which will enable you to further automate tasks by building your own macros.

Led by highly experienced Excel trainers with many years of experience our hands-on courses mean that you will leave with practical experience as well as useful tips and tricks.

Class Overview

This Advanced Microsoft Excel 2013 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros

Target Audience: Students who have intermediate skills with Microsoft Excel 2013 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2013 interface.

ms-excel

Class Goals

  • Create pivot tables and charts.
  • Learn to trace precedents and dependents.
  • Convert text and validate and consolidate data.
  • Collaborate with others by protecting worksheets and workbooks.
  • Create, use, edit, and manage macros.
  • Import and export data.
  • its ability to manage complex calculations
  • a comprehensive array of formatting options
  • graphics and charting tools
  • pivot tables - data summarization and visualization tool
  • built-in programming language - VBA (Visual Basic for Applications) to automate complex tasks.