[go: up one dir, main page]
Scribd
Upload
59 views2 pages

MS Excel Training Course

The MS Excel Training Course consists of seven lessons covering essential skills, from basic worksheet management and formulas to advanced data analysis and automation techniques. Key topics include formatting, conditional formatting, data management, various formulas, chart creation, and using PivotTables. The course also introduces macros for task automation and integrating Excel with other programs like Word.

Uploaded by

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

MS Excel Training Course

The MS Excel Training Course consists of seven lessons covering essential skills, from basic worksheet management and formulas to advanced data analysis and automation techniques. Key topics include formatting, conditional formatting, data management, various formulas, chart creation, and using PivotTables. The course also introduces macros for task automation and integrating Excel with other programs like Word.

Uploaded by

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

MS Excel Training Course - Lesson 1: Excel Basics

Formatting & Managing your Worksheet & workbook


Basic Formulas, Number Formats & Working
Working with Menus Tabs & Excel Advance Options

MS Excel Training Course - Lesson 2: Formats, Conditional


Formatting & Sorting
Cell Formatting
Data Bars, Colour Scales & Icon Sets,
Conditional formatting with formulas,
Sorting basic & advance
Filters Basic & Advance

MS Excel Training Course - Lesson 3: Data Management


Data from other Sources
Data Validation and dealing with Invalid Data
Group and Outline Data,
Data Consolidation
Text to Column.
Removing Duplicates

MS Excel Training Course - Lesson 4: Formulas & Functions


Text Formulas : Exact, Find,
Lookup Formulas : Vlookup, Hlookup, Lookup, Match etc..
Logical Formulas: If, AND, OR, NOR etc..
Date & Time Formulas : Today, Now, Years, etc..
Financial, Math ,Trig , Index, Formulas etc..
How & when to apply Nested Functions

MS Excel Training Course - Lesson 5 Chart & Graphs


Chart Basics: What, When & How
Why to use Line Chart
Most Commonly used: Column Chart
Typical Spark lines

MS Excel Training Course - Lesson 6 Data Analysis


Creating a PivotTable,
Specifying the Data a PivotTable Analyzes
Changing a PivotTable's Calculation
Selecting What Appears in a PivotTable
Grouping Dates in a PivotTable,
Updating a PivotTable
Formatting and Charting a PivotTable
Scenario Modelling
Goal Seek
MS Excel Training Course - Lesson 7: Automating your Work
Introduction to Form Controls,
Macros: Introduction to Form Controls,
Macros, Create and Edit a Macro.
Automating Tasks with Macros
Recording a Macro
Playing a Macro and Assigning a Macro a Shortcut Key
Adding a Macro to a Toolbar
Working with Other Programs
Inserting an Excel Worksheet into a Word Document
Modifying an Inserted Excel Worksheet
Inserting a Linked Excel Chart in a Word Document
Inserting a Graphic into a Worksheet

You might also like