Give Us A Call +2711 882 8853

Excel 2013 Advanced Course

Quick Look Course Summery: Excel 2013 Advanced Course
  • Next Public Course Date: 05/09/2019

  • Length:1 day

  • Price: 1 Person R ex vat3 Person R 0 ex vat10 Person R 0 ex vat

  • Certification Type: Certificate of Attendence

  • Locations & Venues: Call Centre Training Courses are held in JHB, Cape Town, Durban, Port Elizabeth

Excel 2013 Advanced Course: Introduction

This course follows on from the intermediate course in Excel. It is intended as a more comprehensive course for participants with prior knowledge of Excel.

Excel 2013 Advanced Course :Course Outline

Welcome to the Advanced workshop on Excel 2013, there are three workshops on Excel 2013 of which this is the second; we suggest participants wanting to attend this workshop first attend our workshop on Excel Essentials. In this workshop students will learn how to use the more advanced features of Excel 2013. This is a practical workshop where participants will practice what they learn on computers. As always we include our pre workshop review form. In Excel 2013 there is a new landing screen which makes creating and launching documents easier, the user interface has also been improved and users may now manage data from Skydrive. Some of the workshop objectives are: Using Smart Art and other objects; tracing precedent cells and auditing; creating pivot tables and charts, recording and running macros and grouping and outlining data. Smart Art, shapes and pictures are ways to enhance your worksheet, especially when sharing the information with others, the user wants the information to be clear, concise and understandable, using objects to highlight information or summarise it is both appealing to the eye and easier to understand. Participants will learn about the contextual tabs which become available when objects are added. Auditing introduces concepts that will help participants when creating formulas. They will learn about precedent cells and dependent cells and the relationship between cells. Auditing also explains how to display the formulas in a worksheet. Precedent cells can be traced to track down problems. The function Trace Precedents is useful to see the trail of data relationships. Charts are a visual representation of information and in Excel 2013 there is a new feature: Recommended Charts. Users now have access to a number of customised charts based on the data selected. We will teach participants how to use the chart tools tab and how to change the view of a chart, finally participants will also learn how to resize and move a chart.TIP: Some types of charts are: COLUMN CHARTS - These types of charts allow the viewer to compare values across a few categories. LINE CHART – These charts show trends over time.PIE CHARTS – Show data as portions of a whole. Pivot tables and charts allow users to analyse numeric data in depth. They can be used to summarise data as well. We will also provide examples of real-life Pivot tables and charts and teach participants the Pivot Table tools tab options. Many people shy away from Pivot tables because they seem complex, however Pivot tables are a powerful tool to summarise different aspects of data in an understandable way for the viewer. In module seven we teach participants advanced use of macros, and in module eight we focus on formula error and solving them, following that we teach participants the what if analysis and how to use goal seek. We end off our workshop with transposing data and lastly grouping and outlining data. Advanced Microsoft Excel Training Course will enable the learner to: Understand and use advanced functions such as logical and lookup functions. Consolidate data from multiple workbooks. Protect a Microsoft Excel Workbook & save with a backup Create and modify Pivot Tables and Pivot Charts. Protect workbooks, worksheets & cells within worksheets. Work with calculated fields and summary tools. Analyse multiple data sources with the Power Pivot ad-in. Automate Pivot Tables with macros. Create & Modify Macros. Use advanced functions. Export and import data. Use conditional formatting. Advanced Microsoft Excel Training Course is designed specifically for individuals who work within top management. And key skills learnt include the ability to: Auto Calculate Cell edit Multiple worksheets Understand data entry ranges Calculate across worksheets Worksheet and workbook linking Data Consolidation, Analysis, Management Exporting and Importing Querying external databases Importing Data Importing CSV files Text import wizard Exporting Data Choosing a specific format Exporting to word Pasting data with a link Copying a graph with a link Subtotals and Summarizing Manipulating display of totals Advanced value field settings Advanced data management Validating cell entries Pivot Table Reports and layout Refreshing data Pivot Chart Reports Macros Conditional Formatting & Smart Art Conditional formatting with graphics Smart Art graphic

Excel 2013 Advanced Course: Course Duration

1 day/s

Who should attend: Excel 2013 Advanced Course

This course is intended for intermediate users of Microsoft Excel. **Quote does not include Any Exam Fees (if applicable) IMPORTANT ACTION: Do Not Wait To Improve Your Skills.   Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

Get Free & personalised Training Advice

Enjoy incredible savings the more delegates you send. See for yourself...

BOTi COURSE COST CALCULATOR

Simply Select a date to see cost

 
m banner