REGIONAL TRAINING INSTITUTE, SHILLONG
Course Schedule
Course Name : MS Excel (Advanced)
Duration : 5 Days (30-01-2023 to 03-02-2023)
Session Timings Break Timings
Session 1: 10:00 AM – 11:15 AM First Tea Break: 15:15 AM – 11:30 AM
Session 2: 11:30 AM – 12:45 PM Lunch Break: 12:45 PM – 01:45 PM
Session 3: 01:45 PM – 03:00 PM Second Tea break: 03:00 PM – 03:15 PM
Session 4: 03:15 PM – 04:30 PM
Day and Session Topic Faculty
Date No.
Day 1 Inauguration and Course Briefing Director General, RTI
Monday (10:00 AM – 10:15 AM) Shillong
30-01-2023 1 Understanding the difference between MS Faculty from the O/o
office 2013 and the earlier/newer versions: the PAG (Au),
Migrating from Menu style to Ribbon Style of Meghalaya
commands. Introducing the Ribbon user
interface, Parts of Excel Screen, shortcut menus
and dialog boxes. Introduction to keyboard
shortcuts.
2 Protecting cells, Templates, Worksheets: -do-
Protecting cells, Templates, Worksheets. New
Templates in MS-Excel 2013. Page Layout tab.
Themes, page setup, scale to fit, sheet options,
arrange
3 Understanding types of data.: Entering text -do-
and values, dates and time. Formatting /
Modifying and editing contents of cells.
4 Formatting and Editing: Applying Number -do-
Formatting. Conditional formatting, cell styles.
Editing – Fill series, justify, Flash fill, text to
columns & CLEAR options. Protecting
workbook.
Day 2 1 Font/Character, Worksheets: Understanding -do-
Tuesday Excel worksheet essentials. Adding, deleting,
31-01-2023 renaming worksheets. Manipulating rows and
columns. Copying, moving and naming ranges.
Grouping of worksheets.
2 Adding comments to cells. Controlling the -do-
worksheet view: Adding comments to cells.
Controlling the worksheet view such as
freezing panes, comparing sheets side by side.
REGIONAL TRAINING INSTITUTE, SHILLONG
Day and Session Topic Faculty
Date No.
3 Formula, hiding and un-hiding, find- -do-
replace: Using formulas and formula auto
complete. Using cell references in formulas.
Correcting formula errors. Hiding & Un-hiding
cells, rows and columns, Finding and replacing
etc.
4 Case study and Exercises for participants -do-
based on the training imparted during Day
1 and Day 2. Exercises for participants based
on the training imparted as above mentioned
programme. Discussion of solution to those
exercises.
Day 3 1 Conditional summing formula, Charts: Faculty from the O/o
Wednesday Conditional summing formulas with a single or the PAG (Au), Assam
01-02-2023 multiple criteria- return number of cells
satisfying given criteria. Understanding chart
types. Creating and handling charts in Excel.
Embedded and separate charts. Printing charts.
2 Date and time functions: Insert values using -do-
Excel’s date and time functions. Logical
functions. Date and time valid formats.
Calculating days/months/years between two
dates.
3 Text functions. Database Functions. -do-
Information Functions.: Text functions Like
Left, Len, Concatenate, Clean etc. Database
Functions like sum, average etc. Information
Functions viz. Iserror, Isblank etc. Track
precedence and dependence
4 Data validation. Filters.: Create Drop down -do-
list for data validation. Establishing Data
validation Rules. Refer to a source list in a
different Worksheet. Filter items by color,
Filter a range of data, use of Custom Filters.
Removal of filter, Auto Filter, Advanced Filters
Day 4 1 Sorting Data, Multi Level Sorting and -do-
Thursday Filtering: Sorting Data in a list, Use of sub-
02-02-2023 totals and working with Filtered list Multi
Level Sorting and Filtering
2 Scenario and Pivot Table: Understand what is -do-
Scenario and Creating a Pivot Table.
Automatic and manual creation of Pivot Table.
How to set up a Scenario
3 What-if analysis. Goal Seek Feature.: To -do-
produce a summary report using What-if
analysis. The use of Goal Seek Feature in
Excel. To create a Scenario Pivot Table report.
Comparison of Scenarios
REGIONAL TRAINING INSTITUTE, SHILLONG
Day and Session Topic Faculty
Date No.
4 Advanced features. Vlookup, Hlookup. -do-
Advanced features in Charts: Advanced
features like Slicer in Filters, Pivot. Financial
functions viz. Vlookup, Hlookup. Advanced
features in Charts – Sparklines, Timeline ,
export of files
Day 5 1 Advanced features. Vlookup, Hlookup. -do-
Friday Advanced features in Charts: Contd.
03-02-2023 2 Introduction to Macros: Recording simple -do-
macros to simplify basic repetitive tasks
3 Case study and Exercises for participants -do-
based on the training imparted during Day
3 to Day 5. Exercises for participants based on
the training imparted as above mentioned
programme. Discussion of solution to those
exercises.
4 Course End Test Core Faculty, RTI,
(03:15 PM – 04:00 PM) Shillong
5 Feedback and Valediction Director General, RTI
(04:30 PM – 04:45 PM) Shillong
