[PDF] Microsoft Excel Advanced Course Outline - Cantura PDF ExcelAdvanced

Microsoft Excel Advanced Course Outline Duration: 1 Day Benefit: This course is designed for those who wish to understand how to analyse and present their

[PDF] Excel advanced

Course description and objectives The course is aimed to analyze the main advanced features of Excel, including complex functions, what-if analysis, pivot

[PDF] ADVANCED EXCEL TRAINING - Corporate Staffing Services

Course Content LEVEL I Advanced Excel Shortcuts ✓ Extensive Types of charts and their specific uses- Trend line and advanced charts ✓ Modifying and

[PDF] Advanced Excel Course - M Training

Introduction Microsoft Excel is probably one of the most For private courses the course content can be adapted to suit your requirements Please contact us to

[PDF] Adv Excel SYLLABUS

Adv Excel SYLLABUS Advanced Excel Course - Overview of the Basics of Excel ➢ Customizing common options in Excel ➢ Absolute and relative cells

[PDF] COURSE OUTLINE: 20740B: Microsoft Excel 2016 Advanced Page

Course Name Microsoft Excel 2016 Advanced Course Duration 2 Days Course Structure Instructor-Led Course Overview Clearly, you use Excel a lot in your

features of Excel that intermediate and advanced spreadsheet modelers use to make their work more Fill down (a selected column of cells with the content of the first cell) Fill to the right (a on all projects in this class WWW

[PDF] Course Syllabus Excel, Finance, & Investing - Noble Desktop

Course Outline C O U R S E S Y L L A B U S Excel, Finance, Investing Summer Course Learn Microsoft Excel, finance, and stock market investing in

[PDF] Excel Training outline

Microsoft Excel Training - Course Topic Selections The Basics Creating a New Workbook Navigating in Excel Moving the Cell Pointer Using Excel Menus

Microsoft Excel Advanced Course Outline

Duration: 1 Day

Benefit: This course is designed for those who wish to understand how to analyse and present their data more efficiently as well as automate common tasks.

Objectives: On completion of this course, attendees will be able to create a variety of

functions, present their data using PivotTables, analyse workbooks and data and record macros. Pre-requisites: Attendees should have attended our Excel Intermediate course or have equivalent knowledge. Version: Training is available on all versions of Excel.

Review of Excel Skills

Constructing formulae

Using functions

Absolute and relative cell referencing

Naming ranges

Automating Worksheets

Creating and editing templates

Using data validation

Applying workbook & cell protection

Further Functions

Nested IF functions

Using AND OR operators

Lookup and Reference functions

Text functions

Math and Trig functions

Financial functions

Summarising Worksheets

Group and outline a worksheet

Hiding and displaying outlines

Pivot Tables

Creating and modifying Pivot Tables

Refreshing the data

Grouping data within a Pivot Table

Data Management

Using worksheet auditing tools

Tracing dependent and precedent cells

Checking for errors & highlighting

invalid data

Macros

Recording simple Macros

Running and editing Macros

Assigning Macros to the keyboard,

toolbar buttons and menus

If time permits:

Analysis Tools

Using the Goalseek tool

Creating Data Tables

Cantura Limited 60 London Road St Albans Hertfordshire AL1 1NG t: 01727 798111 f: 01727 798112 w: www.cantura.com e: info@cantura.com your complete IT partnerquotesdbs_dbs14.pdfusesText_20

[PDF] [PDF] Microsoft Excel Advanced Course Outline - Cantura

Microsoft Excel Advanced Course Outline

Duration: 1 Day

Review of Excel Skills

 Constructing formulae

 Using functions

 Absolute and relative cell referencing

 Naming ranges

Automating Worksheets

 Creating and editing templates

 Using data validation

 Applying workbook & cell protection

Further Functions

 Nested IF functions

 Using AND OR operators

 Lookup and Reference functions

 Text functions

 Math and Trig functions

 Financial functions