Application:	Microsoft Excel
Level:	Introduction
Duration:	1 Day
Target:	New or recent Excel users.
Objectives:	This course is designed to give users a good introduction to the basic concepts of Excel. It explores the structure of the Excel workbook and demonstrates basic techniques required for working with spreadsheets.
Content:

1. Exploring Excel
    Finding and using commands
    Moving around a worksheet
    Navigating the workbook

2. Basic Workbook Skills
    Creating a workbook
    Selecting cells and ranges
    Opening, closing and saving workbooks
    Entering data into cells
    Entering values into ranges

3. Creating Simple Formulas
    Writing formulas in cells
    Using the Formula Bar
    AutoSum and other basic functions
    The Paste Function tool
    Automatic calculation

4. Copying and Moving Data
    Copying and cutting data
    Absolute cell references
    Filling cells
    Using drag-and-drop
    Undo and Redo
    Find and Replace

5. Managing Worksheets
   Naming worksheets
    Copying and moving worksheets
    Grouping worksheets
    Moving data between sheets
    Adding and deleting worksheets
    Creating 3-D formulas

6. Printing
    Choosing what to print
    Previewing and printing
    Page Setup
    Margins and page orientation
    Headers and footers
    Repeating column/row headings
    Page Break Preview
    Printing gridlines

7. Formatting Data and Cells
    Formatting numbers
    Formatting text
    Colouring data and cells
    Wrapping and shrinking text
    Merging cells
    Using indents
    Applying borders to cells
    The Format Painter
    Conditional formatting

8. Working with Columns and Rows
    Selecting columns and rows
    Changing column width and row height
    Hiding and unhiding
    Inserting and deleting

9. Using Large Spreadsheets
    Changing the magnification
    Full Screen view
    Splitting the window
    Using Freeze Panes

10. Named Ranges
    Naming a range of cells
    Jumping to a named range
    Using range names in formulas
    Re-defining and deleting range names

11. Working with Data Series
    Creating a linear series
    Working with Date series
    Using Autofill

Gallery (3)

About the Trainer

4.4 Avg Rating

21 Reviews

68 Students

23 Courses

Sailaja Akkala

B Tech, MBA

7 Years of Experience

I am a trainer in Soft Skills with a passion for learning. I believe training is an experience that is engaging, high-energy style and ability to make learning fun. With a strong determination and commitment towards training, I am energized to help others succeed.
I am focussed to keep learning relevant to the learners' needs. My ultimate aim is to make learning earn Personality Empowerment.

My Strengths:

A passion for learning and training people
An excellent communication
Perfect presentation
Always smile on the face
A continuous urge to excel

Conducted Training in the following Areas:

·Johari Window
· Fish Philosophy, Motivation
· Telephone Etiquettes
· Personality Development
· Body Language.
· Leadership Skills
· Listening Skills
· Public Speaking
· Presentation Skill
· Effective Communication
· Induction & Orientation
· Interviewing Skill
· Email Etiquettes
· Business writing
· Customer Handling
· Stress Management
· Time Management
· Positive Thinking
· Grooming
· Change and Innovation
· Conflict Management
· Negotiation Skills
· Team Building
· GD Sessions