Contents
·Module
1: Introduction
·Module 2
: Entering, Editing and Formatting Data
·Module 3:
Formatting Numbers
·Module 4:
Managing Worksheets
· Module 5:
Modifying Rows and Columns
· Module 6:
Understanding Formulas
· Module 7:
Changing Views
·Module 8:
AutoFill and Custom Lists
·Module 9
: Conditional Formatting
·Module 10:
Tables
·Module 11:
Data Tools
·Module 12:
Referencing Formulas
· Module 13: Ranges
and Dates
· Module 14: Lookups
·Module 15:
Conditional Logic
·Module 16 : Text
Formulas
·Module 17:
Introduction to Charts
·Module 18:
Formatting Charts
·Module 19: Adding
Graphics to Spreadsheets
·Module 20: Outline,
Sort, Filter, and Subtotal
·Module 21:
PivotTables
·Module 22 :
Protecting Data
·Module 23: Collaboration
·Module 24: Printing
·Module 25: Saving a
Workbook
·Module 26: Macros
Introduction
- Introduction
- Interface
- Tabs and Ribbons
- Document Windows
- Navigation Tips
- Office Button and Save
Entering, Editing and Formatting Data
- Introduction
- Entering Data
- Fonts, Fills, and Alignment
- Cut, Copy, and Paste
- Paste Special
- Undo and Redo
- Moving, Finding, and Replacing a Value
- Cell Styles
- Comments
Formatting Numbers
- Introduction
- Currency Format
- Format Painter
- Formatting Dates
- Custom and Special Formats
Managing Worksheets
- Introduction
- Naming and Moving Worksheets
- Copying Worksheets
- Adding, Deleting and Hiding Worksheets
- Grouping Worksheets
- Moving, Copying, Deleting and Hiding Grouped
Worksheets
Modifying Rows and Columns
- Introduction
- Inserting
and Deleting Columns and Rows
- Inserting
& Deleting Cells
- Inserting
Multiple Columns & Rows
- Modifying
Cell Width and Height
- Hiding
and Unhiding Rows and Columns
Understanding Formulas
- Introduction
- Using Operations
- Creating Formulas
- AutoSum
- Common Formulas
- Searching for Formulas
- Copying Formulas
- Using Relative and Absolute References
Changing Views
- Introduction
- Workbook Views
- Show/Hide
- Zoom Features
- Freeze Panes
- Split Windows
- Viewing Multiple Windows
- Minimize The Ribbon
- Worksheet Backgrounds
- Watermarks
AutoFill and Custom Lists
- Introduction
- AutoFill
a Series
- AutoFill
Non-Adjacent Cells
- AutoFill
on Multiple Sheets
- Creating
Custom Lists
- Series
Formatting
Conditional Formatting
- Introduction
- Highlight Cells Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Custom Formatting Rule
Tables
- Introduction
- Insert
a Table and Style Options
- Add
Rows and Columns
- Perform
a Function in a Table
- Summarise
With Pivot Table
Data Tools Data Tools
- Introduction
- Data
Validation
- Drop-Down
Lists
- Removing
Duplicates
- Text
To Columns
- Goal
Seek
- Scenario
Manager
Referencing Formulas
- Introduction
- Multiple
Sheet References
- Consolidating
Data - With or Without Links
- Trace
the Precedents and Dependents
- Using
the Watch Window
Ranges and Dates
- Introduction
- Cell Names
- Named Ranges
- Formulas with Cell Names
- Date Formulas
Lookups
- Introduction
- VLOOKUP
- VLOOKUP
Exact Match
- HLOOKUP
- HLOOKUP
Exact Match
Conditional Logic
- Introduction
- IF
Statement
- Nested
IF
- AND
- OR
- NOT
- IFERROR
- SUMIF
- AVERAGEIF
- COUNTIF
& COUNTIFS
- SUMIFS
- AVERAGEIF
Text Formulas
- Introduction
- Case
Formulas
- Fix
Number Fields
- Trim
Spaces
- Substitute
Text
Introduction to Charts
- Introduction
- Chart
Types
- Instant
Chart
- Update
Chart
- Column
Chart
- Picture
Fill
- Adjust
Chart Size
- Line
Chart
- Scatter
Chart
Formatting Charts
- Introduction
- Chart
Styles
- Chart
Layouts
- Add
Labels
- Axis
Options
- Chart
Title
- Legends
- Data
Labels
Adding Graphics to Spreadsheets
- Introduction
- Insert
Pictures
- Modifying
Pictures
- Insert
Shapes
- Insert
SmartArt
- Apply
Themes
- Arrange
Outline, Sort, Filter, and Subtotal
- Introduction
- Group
and Ungroup
- Sort
Data
- Sort
Multiple Levels
- Filter
Data
- Advanced
Filter
- Conditional
Sorting and Filtering
- Sorting
with Custom Lists
- Subtotal
PivotTables
- Introduction
- Creating
PivotTables
- Choosing
Fields
- PivotTable
Layout
- Filtering
PivotTables
- Modifying
PivotTable Data
- PivotCharts
Protecting Data
- Introduction
- Workbook
Passwords
- Protecting
Workbooks
- Unlocking
Cells
Collaboration
- Introduction
- Document
Properties
- Inserting
Hyperlinks
- Sharing
a Workbook
- Track
Changes
- Accept/Reject
Changes
- Mark
as Final
Printing
- Introduction
- Page
Orientation
- Page
Breaks
- Print
Area
- Margins
- Print
Titles
- Headers
and Footers
- Scaling
- Sheet
Options
Saving a Workbook
- Introduction
- Save
As Previous Version
- AutoRecover
Save Options
- Templates
- Save
As PDF
- Save
As Web Page
- Macro-Enabled
Workbook
Macros
- Introduction
and Macro Security
- Recording
a Macro
- Assign
a Macro to a Button or Shape
- Run a
Macro upon Opening a Workbook
- How to
Inspect and Modify a Macro
Our Location:-
Our Institute Provides Students are taught Professionally Advance Microsoft Excel Course Education in Every Cities of Delhi .Contact for More Details.- Sagarpur West | Sagarpur East | Desu Colony | Raghu Nagar | Madanpuri | Mohan Nagar | Vashist Park | Durga Park | Jagdamba Vihar | Dabri | Nangal Raya | Sitapuri | Indra Park | Vijay Enclave | Mahavir Enclave | Nasirpur | Madhu Vihar | Dwarka More | Dwarka Sector 3 | Dwarka Sector 4 | Dwarka Sector 12 | Dwarka Sector 13 | Lajwanti Garden | Pankha Road | Manglapuri | Hari Nagar | Palam | Raj Nagar | Sadh Nagar | Kailash Puri | Bindapur | Dashrath Puri | Delhi Cantt | Mayapuri | Jeewan Park | Janakpuri A Block | Janakpuri D Block | Janakpuri District Center | Tilak Nagar | Janakpuri C1 Block | Chanakya Place | Uttam Nagar | Mohan Garden | Nawada | Om Vihar | Mansa Ram Park | Rama Park | Dwarka etc.
No comments:
Post a Comment
Thankyou Dear, for the feedback on your Experience with our Support Team.