Advanced Excel Training Course - (2013 , 2010, 2007)
Duration : 18 Period [Every Period is of 1 hour] Course Fee : Rs.4500/-
We Offer Everyone Who will benefit
- Project Managers
- Data Analyst
- Financial Analyst
- Data Miners
Selecting To capture or highlight a set of data. Navigating To move from one worksheet or one workbook to another.
Custom Keyboard Shortcuts Various combinations to work faster and independent of the mouse. Copying & Pasting To duplicate a set of data to a different location.
DGET Extracts from a database a single record that matches the specified criteria. DMAX Returns the maximum value from selected database entries.
DMIN Returns the minimum value from selected database entries. DSUM Adds the numbers in the field column of records in the database that match the criteria.
DATE Returns the serial number of a particular date. TIME Returns the serial number of a particular time.
CONVERT Converts a number from one measurement system to another. COUNTBLANK Counts the number of blank cells within a range.
IF Specifies a logical test to perform. HLOOKUP Looks in the top row of an array and returns the value of the indicated cell.
TRANSPOSE Returns the transpose of an array. VLOOKUP Looks in the first column of an array and moves across the row to return the value of a cell.
COUNTIF Counts the number of nonblank cells within a range that meet the given criteria. SUM Adds its arguments.
SUM_as_Running_Total Sample. SUMIF Adds the cells specified by a given criteria. SUMPRODUCT Returns the sum of the products of corresponding array components.
AutoSum shortcut key Using Alt and =. Percentages How to calculate various percentages. AVERAGE Returns the average of its arguments.
COUNT Counts how many numbers are in the list of arguments. COUNTA Counts how many values are in the list of arguments. REPLACE Replaces characters within text.
TEXT Formats a number and converts it to text. FORMULAS mathematical equations, entries that have an equation that calculates the value to display.
SORT lets you easily reorder your data based on the type of sorting that you choose. DATABASE & FILTERS an easy way to turn the values in Excel column into specofic filters based on the cell contents.
CONSLIDATION Allows to consolidate data from one or several sheets from one or many open workbooks quickly and easily. PIVOT TABLE PivotTables allow you to create multidimensional data views by dragging and dropping column headings.
NAMING Defining Names for Ranges. MACRO If you perform a task repeatedly in Microsoft Excel, you can automate the task with a macro.