DAY -1
Session 1
The Fundamentals of Excel
How to Start Excel, Creating and Saving Workbooks
Toolbars and Task Panes in Excel
Insert/Delete/Name/Move Worksheets
Cells, Moving Around Workbooks, Exiting
Basic Copy/Cut & Paste
*Assignment
Session 2
Quick Copying Using the Fill Handle
Pasting Using Paste Special
Inserting Rows, Columns and Cells
Changing the Standard Default Options in Excel
*Assignment
Session 3
Using the Undo and Redo Feature
Using the Format Painter to Copy a Cells Format
Using Dates and Times in Excel
*Assignment
Session 4
Working with Custom Formats in Excel
The Basics of Excel Formulas
Excel Cell References. Relative and Absolute Cell References
Avoid Typing Whenever Possible. Use Your Mouse Pointer
Excel Arguments and Syntax in Formulas
Excel AutoSum Function/Formula
*Assignment
DAY – 2
Session 1
Excel Auto Calculate. Calculate Without Formulas
How to Use the Insert Function Feature to Create Formulas
Using Some of Excel’s most Common Functions
Using Named Ranges in Excel as an Alternative to Cell References
Using Constants to Name Values and the Paste Name Dialog
*Assignment
Session 2
Excel Calculations/How Excel Calculates/The Order of Calculations
Excel Cell Comments
Excel Find & Replace
Different Methods of Clearing Cell Contents
Effective Printing in Excel 1
Effective Printing in Excel 2
*Assignment
Session 3
Sorting Data in Excel
Hide/Show Rows/Columns in Excel
Excel AutoFormats
Creating a Basic Spreadsheet
Charting the Basic Spreadsheet
*Assignment
Session 4
Excel Worksheet Protection
Excel IF Formula/Function
Doubt Solviing
Doubt solving
*Assignment
HEMANT KAJARIA
SENIOR CORPORATE TRAINER
TRAINING FOR INDIVIDUALS | GROUP | CORPORATE
(+91) 9821041860 | 9820625162
Email: hkajaria@gmail.com
