Duration : 01 Months
- MS Excel
- Spreadsheet
- MS Excel Interface: Title Bar, File Menu, Quick Access Toolbar, Ribbon, Formula bar, Name box, Status Bar(Microsoft Office Frame), Worksheet, Sheet tab bar, Sheet tabs, Tab scrolling buttons, Insert Worksheet tab
- WORKBOOK
- Worksheet
- Rows & Columns in Excel
- Cell Introduction
- Save Workbook in Excel 2010
- Home tab : Clipboard, Font, Alignment, Number, Styles, Cells, Editing
- Copy Paste using Office Clipboard
- Copy Paste in Special way
- Setting Cell Type in Excel
- Formatting Cell
- Various Cell Formats
- Rotate Cells in Excel
- Setting Colors in Excel
- Changing Background Color
- Changing Foreground Color
- Text Alignments in Excel
- Change Alignment from Home Tab
- Change Alignment from Format Cells
- Merge Cells
- Wrap Text and Shrink to Fit
- Borders and Shades in Excel
- Conditional Format in Excel
- Find & Replace in Excel
- Insert tab : Table, Illustrations, Charts, Links, Text
- Pivot Tables
- Pivot Charts
- Adding Graphics in Excel : Insert Shape, Insert Smart Art, Insert Clip Art, Insert Word Art,
- Charts in Excel
- Header and Footer in Excel
- Using Symbols
- Using Special Characters
- Page Layout Tab : Themes, Page setup, Scale to fit, Sheet options, Arrange
- Adjust Margins in Excel
- Page Orientation in Excel
- Options in Sheet Options Dialogue
- Formulas Tab : Function library, Defined Names, Formula auditing, Calculation
- Creating Formulas in Excel
- Elements of Excel Formula : References, Operator, Constants, Functions
- Cell References in Formulas : Relative Cell References, Absolute Cell References, Mixed Cell References
- Built-in Functions in Excel
- Math & Trig : SUM(),PRODUCT(),POWER(),SQRT(),Round(),Roundup(),Rounddown(),ABS(),GCD(),LCM(),QUOTIENT(),MOD(),RANDBETWEEN(),ROMAN()
- Text Functions : CONCATENATE(),UPPER(), LOWER(),PROPER(),LEN(),LEFT(),RIGHT(),MID()
- STATISTICAL FUNCTIONS : AVERAGE(),MAX(),MIN(),COUNT(),COUNTA()
- DATE FUNCTIONS : NOW(),TODAY()
- LOGICAL FUNCTION : IF(),AND(),OR()
- Cross Referencing in Excel : VLOOKUP(),HLOOKUP()
- Defined Names
- Types of names : Defined name, Table name, Define a name for a cell or cell range
- Data Tab
- Get external Data
- Filters in MS Excel
- Sorting in MS Excel
- Data Validation in Excel
- The Review Tab : Proofing, Comments, Changes
- Spell Check in Excel
- Insert Comments in Excel
- The View Tab : Workbook Views, Show/hide, Zoom, Window, Macros