ADVANCE EXCEL TRAINING

EXCEL ADVANCE FORMULA

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. 

 EXCEL ADVANCE FORMULA

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

·         Working with functions (based on your requirements)

·         Financial functions

·         Date and time functions

·         Statistical functions

·         Lookup and reference functions

·         Database functions

·         Text manipulation functions

·         Logical functions

·         Worksheet and cell information functions

·         Recording and running macros

·         Assigning a macro to a toolbar or menu

·         IF...ELSE

·         SELECT...CASE

·         FOR...NEXT

·         Macro actions for cells and ranges

·         Objects, properties and methods

·         Processing individual cells in a range

·         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