Course Duration: 16 hrs
Trainer: Sathish
Training Date: Nov 8th, 22nd, 29th, Dec 6th (Sundays, 4hrs each day)

Overview:
Microsoft Excel is the product, which has everything in it. Anything and Everything can be done
in Excel. The Person knows 50% of Excel well doesn’t need to learn other computer languages.
Everyone in the computer world knows to create or handle data in Excel. But while entering
data, taking print out, Editing, making reports or charts it takes more time. This workshop is
designed to Handle this Easily, Efficiently, and quickly (just by pressing a Key or Simply clicking or
Dragging).

Objective:
To impart Awareness of Advanced concept in MS Excel towards Handling, Creating, Maintaining
of Data, Printing Options, Reports, Formula, Function, charts &, etc.

          Methodology:

•  LCD presentation of the concepts with live exercise and examples
•  Hands-on experiences (the immediate practice of the exercise & examples)
•  Doubts and queries almost cleared immediately
  Key Takeaway:
  After this workshop the participants are able
• To work on excel very effectively
• To save the time
• To work without errors
• To make interpretation faster
• To create report very quickly
•  To create chart in span of seconds
• To take print out in a click
• To use formula and function

Participants:
Basically, well suited for people of all levels who already have basic knowledge of computers.

            Session 1

•  Knowing new features of Excel
•  Exploring QAT, Ribbon, Dialog Box Launcher, Command Button & Command Sets
• Investigating the use of Smart Tag
• Short cut keys, Tips & Tricks
• Fill data in a flash
• Create formula, charts, formats, charts quickly
• Filling and data entry Fast by Fill Handle, Smart Tag and Custom List
  Session 2
• Tips about the Format Cells
•  Innovation in paste special
• Categories of View
  o Normal
  o Appending Header & Footer
  o Arrange Page Setup
  o Insert and Position the Page Break
  o Making rows and columns to be repeated
  o Saving the Page Setup (Print out at time from anywhere)
   Session 3
•  Import of data from external data source
  o Fixed Width
  o Delimiters (Single & Multiple)
  o Import with link
  o Advanced (Decimal & Thousand Separator)
• Cell referencing (Absolute, Relative & Mixed)
  Session 4
• Features in conditional formatting
  o Highlight Cells
  o Find Duplicate
  o Top / Bottom
  o Data Bars (Positive & Negative)
  o Color Scales
  o Manage the formats
• Preventing Data Entry Error by Validation
  o Accepting only preferred values
  o Finding the error
  o Creating drop-down list
  Session 5
• Sort and Filter – Advanced Filter
  o  Multiple sorts
  o Level of sorting
  o Color & Icon Sort
  o Multiple Filter
  o Date, Text & Number Filter
  o Color Filter
  o Clear & Reapply
• Single and Multiple Subtotal
  Session 6
• Turning Data into Decisions using Pivot table & charts – 1
  o Pre-condition for Pivot
  o Understanding Report filter, Row & Column and Σ value
  o Basic reports by Dropping the fields
  o Working with Design and layout
  o Summarize with different function
  o Modifying the table
  o Showing different values like Percentage, Running total, Index and etc
• Visualizing using chart
  o Creating basic chart (Line, Column, Bar or Pie)
  o Charts by shortcut keys
  o Selecting right chart for the data
  o Customizing chart
  o Changing chart type
  o Combination of chart
  o Using predefined design and layout
  o Creating the chart template
  o Drawing chart based on a +template
  o Making a default chart

Trainer Summary:
Sathish is a certified Microsoft Trainer for MS word, Excel, PowerPoint, and other
Programming Tools. He has 20+ years of vast industry experience in IT software training and
consulting experience. He has trained more than 20,000+ participants, conducted more than
1500 batches for more than 100 customers across various locations in India/Abroad since
1998.