You will learn as below.

1. Introduction: Use of Excel, Ribbon or Menu System, Quick Access Tool Bar, Formula Bar, Status bar, Cell Navigation – changing the same to fit your requirement, Keyboard shot cut menu’s, Mini Tool Bar, Zoom Slider, Recent Documents Controls, Save as PDF, using templates, creating, saving, and closing workbooks. Cell References – Absolute, Relative and Mixed. Addition, Subtraction, Multiplication, Division.
2. Data Entry and Customizations:
• Data Entry Tricks
• Auto-Fill and Fill-Handle
• Using Undo and Redo
• Adding comments or notes or Input Message to a cell.
• Move and copy worksheets.
• Working sheets in group mode – including entering data in group mode.
• Arranging Windows – Viewing vertical, horizontal.
• Switch Windows – operate multiple windows.
• Printing Options [ Workbook, Active Sheet, Selection]
• Page Layout – Header and Footer
3. Excel Features:
• File extensions – xlsx, xlsm
• Build in Cell Styles gallery.
• Themes and WordArt, Smart Art, Dynamic Display using smart art
• Conditional Formatting – Data Bars, Color Scales, Icon Sets, rules and managing rules.
• Tables and Table Formulas – Extension, Deletion, Usage for Pivot table.
• Sorting Techniques – Ascending, Descending, By Color, By Font, By Icon Set.
• Vlookup
• Hlookup
• Auto Sum
• Data Validation
• Joining Text
• Pivot Table
• Charting Techniques