Advance Ecxel

 INTRODUCTION TO EXCEL:

An Overview of Excel Screen, Basic Concept of Spreadsheet and Workbook

Excel Terminology – Rows, Column and Cell, Difference between Excel 2003, 2007 And 2010, its Boundaries & Features,   Simple Data Entry – Number, Text, Date, Selecting Range, Cut, Copy, Paste, Format Painter and Move Data. Saving Excel   Format.

 BASIC FUNCTIONS:

Basic Formula Like Add, Subtract, Multiplication, Divide. Sum and Count Function. Auto Sum, Formatting a Cell- Number,   Text,  %, Date and Custom Format. Font , Borders, Fill Colors And Patterns,  Conditional Formatting, Format A Table, Cell   Style
 EXCEL FUNCTIONS/FORMULAS:

Sum, Count, Counta, Countifs, Subtotal, Average, Ceiling, Floor, Round, Roundup, Rounddown, Chart, Text, Clean, Trim,   Concatenate, Substitute, Hour, Date, Value, Day, Month, Year, Day, Today. Exact, Forecast, Getpivotdata, Sumproduct,   Frequency, Rank, Rand, Randbetween. Transpose, Match, Upper, Lower, Proper, Left, Right, Mid, Row, Column, Combin.

 LOOKUP FUNCTIONS:

Lookup, V-Lookup, H-Lookup, Match, Index, Usage Of Match Function In Vlookup, Hlookup  And Index

 LOGICAL & MATHEMATICAL FUNCTIONS:

If, Sumif, Sumifs, Countifs, Nested If (Usage of More Than 1 If Condition Within 1 Formula

Iferror, Iserror, Isna, And, Or, False, Not, True, Ceiling, Even, Int, Lcm, Power, Odd, Sumif, Sumproduct, Seriessum

 Description Of Excel Menu

Paste Special, Paste Formula, Paste Format, Skip Blank and Other Paste Special Option, Find, Replace and Merge & Center   Option, Copying/ Moving/ Renaming, Inserting/ Deleting/ Grouping / Hiding & Un-hiding Worksheets

Hiding and Displaying Data, Rows, Columns, Worksheet & Workbooks

 USING PIVOT TABLE:

Preparing Pivot Table, Using Pivot Table Wizard, Arranging Data, Various Options in Pivot Table, Effective and Attractive   Summarized Presentation of Data Using Pivot Tables, Modifying a Pivot Table, Pivot Table Option

 ADVANCE OPTIONS:

Advance Filter and Sorting Option in Excel, Filtering and Sorting By Color. Various Option of Text to Column, Remove   Duplicate  Record, Data Validation, Freezing Pane, Protecting and Sharing a Worksheet/Workbook, Hyperlink

 CHART & DESIGNS & Dashboard

Preparing Charts Using Excel – Column Cart, Pie Chart, Line Chart, Bar Chart, Bubble Chart, Area of Chart, Editing Chart   Contents, Formatting and Modifying Chart, Adding Data to a Chart

 PRINTING TECHNIQUES:

Print Preview, Print Setup, Page Layout, Page-break & Normal View, Headers & Footer, Print Title

 EXCEL MACRO:

Introduction to Macro and VBA Editor, Usage of Macro, Recording and Saving a Macro

Running Macro in Different Worksheets

 

 Advance Excel, & MIS

 

Advance Pivot Table, V-Lookup, H-Lookup Reverse Lookup 2D Lookup, 3D Lookup, Picture Lookup, Advance use of if/Nested   if, Advance Chart, Calendar Creation, Dash Board, Data Analysis, Financial Analysis, N, Data Validation, Sheet Protection,   ABS Consolidate, MIS Reports, Speedometer Creation, What if Analysis, Conditional formatting, conditional formula, Use of   index, Match, Choose, Indirect, Offset, Cell Formatting, Paste Special, Excel Option, 100 of other formulas….

 

 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *