Excel is the world’s leading spreadsheet tool that lets you store and analyze data more intelligently. Ensure you become a proficient user of this powerful tool and choose from programs on introducing worksheet design and formulas through to working with macros, multiple spreadsheets, pivot tables, manipulating data and data analysis features.
We offer Basic MS Office Excel Training Class . which is customizable based on client’s requirements.
Class: 1 |
|
Session 1: Introduction |
|
| 1.01 | Introduction |
| 1.02 | Interface |
| 1.03 | Tabs and Ribbons |
| 1.04 | Document Windows |
| 1.05 | Navigation Tips |
| 1.06 | Office Button and Save |
Class: 1 |
|
Session 2: Entering, Editing and Formatting Data |
|
| 2.01 | Introduction |
| 2.02 | Entering Data |
| 2.03 | Fonts, Fills, and Alignment |
| 2.04 | Cut, Copy, and Paste |
| 2.05 | Paste Special |
| 2.06 | Undo and Redo |
| 2.07 | Moving, Finding, and Replacing a Value |
| 2.08 | Cell Styles |
| 2.09 | Comments |
Class: 2 |
|
Session 3: Formatting Numbers |
|
| 3.01 | Introduction |
| 3.02 | Currency Format |
| 3.03 | Format Painter |
| 3.04 | Formatting Dates |
| 3.05 | Custom and Special Formats |
Class: 2 |
|
Session 4: Managing Worksheets |
|
| 4.01 | Introduction |
| 4.02 | Naming and Moving Worksheets |
| 4.03 | Copying Worksheets |
| 4.04 | Adding, Deleting and Hiding Worksheets |
| 4.05 | Grouping Worksheets |
| 4.06 | Moving, Copying, Deleting and Hiding Grouped Worksheets |
Class: 3 |
|
Session 5: Modifying Rows and Columns |
|
| 5.01 | Introduction |
| 5.02 | Inserting and Deleting Columns and Rows |
| 5.03 | Inserting & Deleting Cells |
| 5.04 | Inserting Multiple Columns & Rows |
| 5.05 | Modifying Cell Width and Height |
| 5.06 | Hiding and Unhiding Rows and Columns |
Class: 3 |
|
Session 6: Understanding Formulas |
|
| 6.01 | Introduction |
| 6.02 | Using Operations |
| 6.03 | Creating Formulas |
| 6.04 | AutoSum |
| 6.05 | Common Formulas |
| 6.06 | Searching for Formulas |
| 6.07 | Copying Formulas |
| 6.08 | Using Relative and Absolute References |
Class: 4 |
|
Session 7: Changing Views |
|
| 7.01 | Introduction |
| 7.02 | Workbook Views |
| 7.03 | Show/Hide |
| 7.04 | Zoom Features |
| 7.05 | Freeze Panes |
| 7.06 | Split Windows |
| 7.07 | Viewing Multiple Windows |
| 7.08 | Minimize The Ribbon |
| 7.09 | Worksheet Backgrounds |
| 7.10 | Watermarks |
Class: 4 |
|
Session 8: AutoFill and Custom Lists |
|
| 8.01 | Introduction |
| 8.02 | AutoFill a Series |
| 8.03 | AutoFill Non-Adjacent Cells |
| 8.04 | AutoFill on Multiple Sheets |
| 8.05 | Creating Custom Lists |
| 8.06 | Series Formatting |