बेसिक से एडवांस तक MS-Excel कोर्स हिंदी में सीखें

Description

In this course, you will learn:

• Introduction to MS Excel 2010 with using Formula
• Basic Formulas
• Formatting Cell and workbook
• Filter Data
• Draw Symbol and Insert Pictures
• Text to column
• Page setup
• Array Function
• Date Time Functions
• Conditional functions
• Logical Functions
• Conditional Formatting
• Hyperlink
• Information Functions
• Macro
• Statistical Functions
• Text Functions
• Logical Functions
• VLookup and Hlookup functions
• Advance Formatting
• Different types of Graphs
• Pivot Table
• More than 100s of trick and tips
• Practical Examples

Syllabus:

1. Excel Basic Operations

• Introduction to MS Excel 2010 with using Formula
• Formula, Cut, Copy, Paste, Format Painter, Alignment
• Wrap Text, Merge and Center, Number
• Conditional Formatting, Format as table, Cell Style, Cell Insert, Cell Delete
• Format, AutoSum, Fill, Clear
• Sort Filter, Find Select
• Pivot Table, Table, Picture, Clipart
• Shapes, Smart Art, Screen Shot, Charts
• Page Setup, Scale to Fit, Sheet Options
• Hyperlink, Text box, Header Footer, Word Art, Signature, Equation, Symbol
• Formulas
• Text to Column, Remove Duplicate, Data Validation, Consolidate, What if analysis
• Group, UN Group, Sub Total, Spelling, Thesaurus
• New Comment, Protect Sheet, Protect Work Book, Track Change
• Page Break, Full Screen, Zoom, Freeze Pane, Macros

2. Advance Excel

• If, OR, AND Function
• Array function
• Autofill and Custom List
• Autosum row and column reference
• Concatenate
• Conditional Formatting with Mod Function
• Convert Function
• COUNTBLANK and COUNTA function
• Creating Combo Box
• Large and small
• Find, search and mid function
• Formula Copy Shortcut
• Hyperlink
• Index Function
• Information function
• Left and Right Function
• Macro Function
• Match and index function
• Match Function
• Mod Function
• More Text Function
• Nested If
• Proper, Upper and lower function
• Rank Function
• Replace and Substitute Function
• Countif, Sumif and averageif Function Part-1
• Countif, Sumif and averageif Function Part-2
• Text Function
• Transpose Function
• Lookup Formula
• Hlookup Function
• Vlookup
• Weekday
• Insert and Edit data multiple Worksheet
• Insert Watermark
• Quickly Transpose data using shortcut
• Turn Off and On Worksheet and Scrollbar
• Grideline color and formula bar off and on
• Cycle Font Color
• Specify the behavior key
• Changing Label Orientation
• Selecting Group Of Cells
• Changing Worksheet in one go
• Selecting Ranges With Keyboard
• Shortcut To Viewing Formulas
• Switch between Workbooks
• Create Button
• Manipulating Objects
• Deleting Graphics when Deleting Rows
• Hide Graphics
• Column Label Change in number Label
• Change Shape of Comment
• Controlling display of the Scrollbar
• Print Gridlines and Headings
• Print page number at the bottom of each page
• Print Several Worksheet on Single Page
• Printing A Draft Of Worksheet
• Printing A Portion Of Worksheet
• Printing Rows Conditionally
• Printing Without Opening Workbooks
• Hiding Error On Printout
• Print Comment In Excel
• Quickly Copy Formula
• Quickly Insert Current Date and Time
• Open A Copy Of Workbook
• Centering the Worksheet Data
• Create Bar Graph
• Applying Range Names To Formula
• Entered Values are Divided By 100
• Share Workbook
• Split Column Data
• Trick to Changed Predefined Group name
• Trick to create Own Tab
• Trick to Insert Picture Comment
• Open A New Workbooks
• Un-protect only A Portion of a Spreadsheet
• Spelling Check
• Insert Total Row
• Search box
• Data validation
• Dependent Dropdown List
• Conditional Formatting
• Pivot table
• Insert Sheets
• Copy Numbers Only
• Text Convert Number