Course Curriculum

Introducing Microsoft Excel

• Working With Excel
• Worksheets and Workbook    
• Understanding the User Interface     
• Quick Access Toolbar
• Ribbon
• Formula Bar        
• Worksheet Area
• Worksheet Tab
• Status Bar
• The Backstage View
• Saving Excel Workbook
• Creating New Excel Workbook        
• Opening Existing Excel Workbook

Customizing Common Options in Excel

• File location
• Number of sheets, Alignment Of row & Column
• Cursor movement
• Font face and size
• Startup folder
• File format, Enable text wrap
• Advance Filter, Advance Sorting
• Maintain Track Changes
• Hide ,Unhide Row & Column
• Merge & Unmerge
• Insert Header & Footer In Excel
• Insert Shape ,Picture ,Smart Art Etc..

Entering Data

• Concept of Tabular Data
• Cell Nomenclature
• Editing Workbook
• Editing Worksheet
• Entering Data      
• Renaiming Sheet

Working With Numbers

• Excel Data Types: Number ,Date,Time  Etc..
• Moving Data
• Organizing Data in Excel Tables
• Creating Simple Formulas .
• Arithmatic & Comparison Operator
• Relative vs. Absolute References
• Using Functions
• Using Math Functions:
• Round,Power,SQRT,RoundUp,
• Using Statistical Functions
• Average If,Count,Countif
• Averageif,Min,Max ,Sumif,Countif Etc..
• Using Financial Functions: Etc..
• FV,INTRATE,IPMT,Rate,NPER,PPMT

Formatting Data

• Common Font Formatting,
• Font Type ,Size,Color,Style, Text Orientation
• Cell Border, Fill Colour
• Cell Alignment, Text Alignment
• Text Indentation, Text Wrapping,
• Formatting Numbers, Merging Cells
• Number – Format, Currency Format
• Accounting  Format, Format As Percent
• Decimal Formatting, Applying Styles
• Additional Cell Formatting Features,
• Conditional Formatting
• Using Format Painter

Managing Your Data in Excel  

• Setting Named Range    
• Finding and Replacing Data
• Inserting Cut or Copied Cells,Paste Special
• Sorting Worksheet Data
• Filtering Worksheet Data,Color  Filter Etc.
• Formula Auditing, Adding, Displaying.
• Editing, and Removing Comments
• Trace Dependents,Formula Auditing

Working with Text and Date

• Text Functions: concatenate, Left Function
• Trim,Find,Replace,Exact,Search
• Using Date & Time : Today ,Days360,Networkdays,Now
• Formatting Date: Hour,Yearfrac,Minut,Month,Time,Weekday
• Formatting Time in Different Format

Manipulating Data

• Relative & Absolute Referencing
• Transposing Rows Into Columns
• LOOKUP Functions : Vlookup,Hlookup
• Lookup_value,Table_Array,Range_Lookup
• Manipulating Data

Working with Charts

• Charts in Excel :Column,Line,Pie,Bar,Area,Scatter
• Chart Tools Tabs: The Anatomy Of Chart
• Chart Area,Label,Grid Lines   
• Creating Charts
• Changing Chart Type
• Editing Charts
• Changing Data Source
• Changing Chart Style / Appearance 
• Resizing Charts
• Moving Charts
• Changing Chart Layout 
• Managing Chart Labels
• Managing Axes Layout
• Adding a Trendline to Chart
• Naming Your Chart
• Formatting Chart Area and Labels

Working with PivotTable

• Creating PivotTable
• PivotTable Tools Tabs
• PivotTable Field List Task Pane
• Report Filter,Axis Field
• Legend Field & Values
• Applying Style to PivotTable
• Applying Filters and Slicers
• Applying Filter , Applying Slicer
• Filtering Data and Creating PivotCharts

What If Analysis

• Using Goal Seek
• Using Scenario Manager
• Recording Macro
• Managing Macro Security Level in Excel
• Recording Macros
• Running Macros

Printing Excel Files     

• Page Layout
• Setting Up Your Page
• Printing Your Worksheet
• Applying Background
• Printing Headers
• Printing Data

Managing Excel Files

• Saving Files
• Excel Workbook
• Excel Macro-Enabled Workbook
• Excel 97-2003 Workbook
• Web Page,csv,pdf
• Emailing Workbooks

Grouping and Outlining Data

• Grouping Your Data ,Outline Your Data
• Adding Subtotal
• Adding Outline ,Automatic Style,
• Linking and Protecting Worksheets

Working With Reports

• Convert data to tables
• Finding the related data
• Creating Subtotal
• Multiple-level subtotals
• Formatting and Customizing Pivot Tables
• Using data Consolidation feature to consolidate data
• Freeze Pane
• Setting of row & column (height & width)

Exam & Certification

• Once you complete this master’s program, you will receive the course completion certificate by ICIT

ICIT Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 50% marks in the quiz. ICIT certification is well recognized in top  MNCs .

Who should attend?

Everyone!! Practically everyone can benefit from this course. Proficiency in MS Excel is desired skill set no matter whether you are an experienced professional or a fresher.

FAQ's

1) What is ribbon?

Ribbon refers to the topmost area of the application that contains menu items and toolbars available in MS-Excel. Ribbon can be shown/hidden using CTRL+F1. The ribbon runs on the top of the application and is the replacement for the toolbars and menus. The ribbons have various tabs on the top, and each tab has its own group of commands.

2) Explain Spreadsheet and its Basics.

Spreadsheet can be compared to a paper ledger sheet. It consists of rows and columns and their intersection called cells.

3) How many data formats are available in Excel? Name some of them.

Eleven data formats are available in Microsoft Excel for data Storage. Example:

• Number – Stores data as a number
• Currency – Stores data in the form of currency
• Date – Data is stored as dates
• Percentage – Stores numbers as a percentage
• Text Formats – Stores data as string of texts

4) Specify the order of operations used for evaluating formulas in Excel.

The order of operations in Microsoft Excel is same as in standard mathematics. It's defined by the term "PEMDAS" or "BEDMAS".

• Parentheses or Brackets
• Exponent
• Multiplication
• Division
• Addition
• Subtraction

5) How can you wrap the text within a cell?

You must select the text you want to wrap, and then click wrap text from the home tab and you can wrap the text within a cell.

6) Explain Macro in MS-Excel.

Macros are used for iterating over a group of tasks. Users can create macros for their customized repetitive functions and instructions. Macros can be either written or recorded depending on the user.