[PDF] ADVANCED EXCEL TRAINING - Corporate Staffing Services PDF Advance-Excel-Course-Outline.pdf

ADVANCED EXCEL TRAINING Course Types of charts and their specific uses - Trend line and advanced charts ✓ Modifying and Effective interest rates

COST: The course fee is $360 per person (break tea and lunch are provided) For client hosted trainings with participants more than 10, a discount of 15 applies

[PDF] Brochure_ICMAI Advanced Excel Course_181020_Singlecdr

18 oct 2020 · Advanced Business Excel for Finance Professionals he Institute of Substantial discount on the Course fees is available for bulk corporate

[PDF] Advanced Ms-Excel Course for Working Professionals & Corporates

Original Fees: This course also enables the student to utilize, the advance features taught in BASIC Microsoft Excel [must have knowledge of BASIC]

[PDF] Advanced excel training courses online - Squarespace

Advanced excel training courses online a small fee to pay for their services In the Advanced course, we will prepare you to become a power user of Excel

[PDF] SHORT AND PROFESSIONAL COURSES - University of Dar es

Tuition fee Manuals 1 Microcomputer Applications ✓ Introduction to Computers Windows 2007 ✓ MS Word 2007 ✓ MS Excel 2007 ✓ MS Access

[PDF] ADVANCED EXCEL TRAINING - Corporate Staffing Services

ADVANCED EXCEL TRAINING Course Types of charts and their specific uses - Trend line and advanced charts ✓ Modifying and Effective interest rates

[PDF] Office 365 - Advanced Excel 2016 – 24 hrs - Genetic Computer School

19 oct 2019 · Perform Advanced Spreadsheet Functions (ICDL Certification) Course Duration 24 Hours Course Fee Full Fee: $520 Subsidy Nett Fees

[PDF] NIESBUD ANNOUNCES Certificate Training Course on Advance

Anyone with basic Excel skills will benefit, whether you're a self-taught Excel user , or you've taken an introductory Excel course Training Fees Rs 5000/-

[PDF] Advanced Excel Trainingcdr - FORE School of Management

Fee is payable in advance by way of Local Cheque / DD in favor of “FORE This Excel 2016 advanced training course, is much more than a quick way to add

ADVANCED EXCEL TRAINING

Course Content

LEVEL I

Advanced Excel Shortcuts

9 Extensive exercise on excel shortcuts

9 Doing away with the mouse

9 Mastering the shortcut window

Data Presentation with charts

9 Types of charts and their specific uses- Trend line and advanced charts.

9 Modifying and formatting existing charts.

Data Analysis Report with Pivot Tables & Pivot Charts

9 Analyzing and generating reports of large data using PivotTables.

9 Creating PivotTables, editing and updating changes in PivotTable.

9 Using Slicers in Pivot Table

9 Creating Pivot Chart

Sorting And Filtering data

9 Sort data as per value, colour, icons

9 Filter based on Font/Cell colour

9 Turning Auto Filter off

9 Use subtotal features and work with database functions

Understanding References

9 Relative, Absolute & Mixed reference

9 Referencing different workbooks & Merging

9 Consolidating data, linking cells in different work books

9 Utilizing Dynamic Named Ranges for writing formulas and functions

Manipulating Dates

9 Dates formats

9 Extracting Day, Month or Year from a date value

9 Extracting Day, Month or Year from a date value using TEXT Formula

9 Extracting end month from a date value

LEVEL II

Advanced Excel Formulas

Logical Functions

9 Ifs and Nested Ifs Statements

9 AND, OR and NOT Functions

9 Error handling using IFERROR, ISNA and ISERROR

Text Formulas

9 CONCATENATE

9 FIND V/S SEARCH

9 LEFT, RIGHT, MID

9 UPPER, PROPER, LOWER

Lookup Formulas

9 VLOOKUP & HLOOKUP

9 INDEX & MATCH

SUMPRODUCT Function

Data Validations and Protection

9 Specifying a valid range of values for a cell

9 Specifying a list of valid values for a cell

9 Creating Drop down list

9 Managing Themes, creating and use of templates

Financial Analysis and Formulas

9 Project Appraisal

¾ Using IRR

¾ Using NPV

9 Loan Modelling

¾ Modelling instalments

¾ Modelling loan balances

¾ Making a decision between a flat-rate v/s reducing balance priced loans

¾ Effective interest rates

Budgeting under Scenarios

9 Introductions to planning scenarios; Best Case, Base Case & Worst Case Scenarios

[PDF] [PDF] ADVANCED EXCEL TRAINING - Corporate Staffing Services