top of page

Advance Excel Skills

Inquriy

OVERVIEW

In today's fast-paced, technical business environment, numbers are everything. Much of our success hinges on how well we can manage the data - statistics, planning, reporting - that we encounter on a daily basis. We learn how we are doing and discover our next course of action by studying numbers. An incredibly powerful tool for doing this is Microsoft Excel.

 

Microsoft Excel is the standard spreadsheet application for both the business world and personal use. This training will teach you basic to advanced features of Excel.

TRAINING OBJECTIVES

By the end of the training course, participants will be able to:

  • Learn about overview of Advanced Microsoft Excel 

  • Calculate with advanced functions & formulas.

  • Create and modify charts & graphs.

  • Analyze data using Pivot Tables and Pivot Charts

  • Learn about Macro

TRAINING CONTENT

Microsoft Excel New Features

  • Condition Formatting

  • Data Validation

  • Flash Fill

  • Text to Columns

  • What If Analysis

  • Group

  • Consolation

 

Advanced Excel Functions

  • Sum, Sumif, Count, Now, Countif, Countifs, Counta, Countblank

  • Average, Min, Max, Date, Int, Mod, Left, Right, Mid, Dollar

  • Day, Month, Year, Day360, Today

  • Round, Rounddown, Roundup,

  • DSUM, DCOUNT, DCOUNTA, DMIN, DMAX, DAVERAGE

  • CONCATENATE, SUMPRODUCT

  • Lookup Function

  • If Function

  • PV Calculation

Chart Report

 

Pivot Table

 

Macro

bottom of page