KEMBAR78
Excel Basics & Intermediate Guide | PDF
Scribd
Upload
842 views2 pages

Excel Basics & Intermediate Guide

The document outlines an 8 module training program for basic and intermediate Excel skills. Module 1 covers working with worksheets, entering and formatting data, and protecting workbooks. Module 2 focuses on formatting options like number formats, fonts, borders, and conditional formatting. Module 3 discusses working with formulas, functions, and cell references. Module 4 covers sorting, filtering, and viewing data. Modules 5-8 introduce charts, data tools, pivot tables, and pivot charts. The overall program aims to teach essential Excel skills over 8 modules that last approximately 60 minutes each.

Uploaded by

Padma Narayanan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
842 views2 pages

Excel Basics & Intermediate Guide

The document outlines an 8 module training program for basic and intermediate Excel skills. Module 1 covers working with worksheets, entering and formatting data, and protecting workbooks. Module 2 focuses on formatting options like number formats, fonts, borders, and conditional formatting. Module 3 discusses working with formulas, functions, and cell references. Module 4 covers sorting, filtering, and viewing data. Modules 5-8 introduce charts, data tools, pivot tables, and pivot charts. The overall program aims to teach essential Excel skills over 8 modules that last approximately 60 minutes each.

Uploaded by

Padma Narayanan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Suggestive Content Outline

The duration for each Module will be around 60 minutes.


Module 1: Working in Excel
● Inserting/Deleting/Moving/Naming Worksheets
● Entering Data in Series. (Ascending and
descending)
● Copying and Moving Cell contents
● Deleting/Inserting/ Clearing Cells
● Inserting/Deleting Rows and Columns
● Using Excel Shortcut and Function Keys
● Understanding Data types in Excel.
● Creating Custom AutoFill Lists
● Protecting a Workbook with Password
Module 2: Formatting Options
● Number Formatting
● Alignment, Font, Border & Patterns
● Format Row, Column, Sheet
● Format Painter
● Date Formats
● Custom formats
● Conditional Formatting
Module 3: Working with Formulas
● Entering, Editing, Copying, Moving, Displaying Formulas
● Using Auto sum And Auto calculate Features
● Cell Addressing or Referencing Methods
● Absolute, Relative & Mixed Referencing
● Referring to Other Sheets & Workbooks
Module 4: Sorting, Filtering and Viewing Data
● Sort options in Excel
● Sorting by custom lists
● Filtering Data
● Window management to view data
Module 5: Working with Functions
● Entering Functions
● Specifying Arguments
● Using VLookup Function
● Using an IF Function
Module 6: Introduction to Charts
● Creating basic charts
● Knowing about different types of charts
Module 7: Data Tools in Excel
● Text to column
● Removing Duplicates
● Data Validation
● Data Consolidation
Module 8: Introduction to Pivot Tables
● Creating basic Pivot tables
● Creating Pivot Charts
Suggestive Course content outline for Basic & Intermediate Excel Training Program Page|1

You might also like