Excel 2013 Advanced Course

 

Description

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

<