IoT Online Training

Session 1: Introduction

• Introduction
• Interface
• Tabs and Ribbons
• Document Windows
• Navigation Tips
• Office Button and Save

Session 2:

• 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

Session 3: Formatting Numbers

• Introduction
• Currency Format
• Format Painter
• Formatting Dates
• Custom and Special Formats

Session 4: 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

Session 5: Managing Worksheets

• Introduction
• Naming and Moving Worksheets
• Copying Worksheets
• Adding, Deleting and Hiding Worksheets
• Grouping Worksheets
• Moving, Copying, Deleting and Hiding Grouped Worksheets

Session 6: Understanding Formulas

• Introduction
• Using Operations
• Creating Formulas
• AutoSum
• Common Formulas
• Searching for Formulas
• Copying Formulas
• Using Relative and Absolute References

Session 7: AutoFill and Custom Lists

• Introduction
• AutoFill a Series
• AutoFill Non-Adjacent Cells
• AutoFill on Multiple Sheets
• Creating Custom Lists
• Series Formatting

Session 8: Changing Views

• Introduction
• Workbook Views
• Show/Hide
• Zoom Features
• Freeze Panes
• Split Windows
• Viewing Multiple Windows
• Minimize the Ribbon
• Worksheet Backgrounds
• Watermarks

Session 9: Conditional Formatting

• Introduction
• Highlight Cells Rules
• Top/Bottom Rules
• Data Bars
• Color Scales
• Custom Formatting Rule

Session 10: Tables

• Introduction
• Insert a Table and Style Options
• Add Rows and Columns
• Perform a Function in a Table
• Summarise With Pivot Table

Session 11: Data Tools

• Introduction
• Data Validation
• Drop-Down Lists
• Removing Duplicates
• Text to Columns
• Goal Seek
• Scenario Manager

Session 12: Lookups

• Introduction
• VLOOKUP
• VLOOKUP Exact Match
• HLOOKUP
• HLOOKUP Exact Match
• Resume Building
• Developing Social Media Profiles eg:- Linkdin in & Facebook etc..
• Mass/Bulk E-Mailing & Job Posting Sites
• Social Media Recruitment

• End to End Recruitment
• Recruitment Process Life Cycle.
• Recruitment Tracker.
• Recruitment Process Metrics.
• HRA’S, TAT, SLA.
• Blue Collar & White Collar Recruitment.
• Attrition Management(Attrition & Retention Policy)
• Exit Interview.

Session 13: Referencing Formulas

• Introduction
• Multiple Sheet References
• Consolidating Data - With or Without Links
• Trace the Precedents and Dependents
• Using the Watch Window

Session 14: Ranges and Dates

• Introduction
• Cell Names
• Named Ranges
• Formulas with Cell Names
• Date Formulas