ADVANCE EXCEL TRAINING

ADVANCE EXCEL TRAINING

As a professional in your field, you already know the benefits of using Microsoft Excel. There is a way to make it an even more powerful tool in the management of your business. The benefit of additional Microsoft Excel training for your employees will give you a more efficient vision of your operation as well as improve your bottom line.

Benefits of Basic Training

Your employees may already be familiar with many of Excel's abilities, but wouldn't it be nice if they were more proficient with macros and shortcuts? Basic Microsoft Excel training courses can help improve employee productivity by allowing mundane tasks to be completed more efficiently. 

MS - EXCEL ADVANCE COURSE DETAIL:- 

Course Contents:

·         Data filters: AutoFilter and advanced filters

·         Sorting, Customize sorting

·         Subtotals

·         Cell level validations

·         Specifying a valid range of values for a cell

·         Specifying a list of valid values for a cell

·         Specifying custom validations based on formula for a cell

·         Using data tables for data analysis

·         Mastering PivotTables

·         Multiple consolidation ranges

·         Customizing PivotTable layout

·         PivotTable advanced options

·         Pivot Charts

·         Importing text files in Excel

·         Refreshing data

·         Using data forms for managing tabular data

·         Workbook sharing

·         Merging workbooks

·         Workbook and sheet protection

·         Goal Seek

·         Customizing toolbars and menus

·         Settings

·         Creating custom lists

·         Conditional formatting of cells

·         Creating, managing and merging styles for cell formatting

·         Financial functions (DCOUNT , DCOUNTA , DMAX , DMIN , RANK 
     MAX , MIN ,AVERAGE ,TODAY)

·         Date and time function

·         HLOOKUP , HLOOKUP ADVANCE , VLOOKUP , VLOOKUP ADVANCE

·         Database functions (UPPER , LOWER , PROPOER , COUNTBLANK)

·         Text manipulation functions (TEXT, RIGHT , LEFT , FIND)

·         Worksheet and cell information functions

·         Recording and running macros

·         Assigning a macro to a toolbar or menu

·         IF , NESTED FORMULA

·         SUMPRODUCT

·         Macro actions for worksheets

Historical Sales, Cost, and Net Profit Analysis

Excel formulas used: BRIDGE ANALYSIS, RATE & VOLUME, % Gross Margin, % Net Profit, IF, MAX; MIN; AVERAGE

WE  CAN  PROVIDE  HR  FORMAT  FILE

WE  CAN  PROVIDE  SALE  FORMAT  FILE

CONTACT : ASHISH SHAH  9819359533