Email : training@rjpinfotek.com

ONE DAY WORKSHOP ON EXCEL ESSENTIALS

RAJA C S N

MS Office

ONE DAY WORKSHOP ON EXCEL ESSENTIALS
          Join our “Excel Essentials” Session
If you are a beginner or using Excel for quite some time,we invite you register for our ONE DAY EXCEL ESSENTIAL WORKSHOP. You will learn many short-cuts and you will become faster, stronger and smarter in Excel.

#

Topic

Additional
 Information       

MOST IMPORTANT
TAKE-AWAY of
the session:

1

Getting started with Excel (What is NAME BOX in Excel?)

  • Excel  Ribbon,   Tabs & sections
  • Quick Access Tool bar & customizing it
  • Using Formula bar,  Name box and status bar
  • Short-cut menus and mini tool bar
  • Creating new files, saving existing file
  • You will learn a concept called NAMED RANGES in this session.

 

2

Entering Data (Learn a trick with Autofill)

  • Data entry, editing and manipulating data
  • Autofill
  • Adding comments to cells
  • Working with dates and times
  • Finding and replacing data
  • This concept will change your perception about Excel.

 

3

Creating formulas and functions and becoming LIGHTENING FASTER with ADVANCED FORMULAS

  • Creating simple formulas (Totals, averages etc.,)
  • Copying/Moving formulae to other cells
  • Calculating year-to-date profit
  • Creating a percentage increase formula
  • Other basic functions
  • You will become faster, smarter and stronger with this concept coupled with some advance formula uses

 

4

Formatting and conditional formatting
(Create formula based conditional formatting and create visual indicators with CF)

  • Fonts, styles
  • Row height, column width, wrap text, merge cells, alignment options
  • Number formats; date formats; custom formats
  • Borders
  • Creating visual indicators with conditional formatting options
  • Converting range into tables and vice-versa
  • You will perform complex tasks within 3 minutes,
    which will normally take 15 to 30 minutes for a conventional user.

 

5

Handling worksheet layout (Be sure to protect your data)

  • Inserting and deleting cells
  • Inserting and deleting rows/columns
  • Inserting and deleting worksheets
  • Protecting worksheets with password
  • You will also learn to create professionally looking charts in the shortest possible time.

 

6

Creating basic charts AS IF IT IS MAGIC

  • Creating basic charts
  • Different types of charts and their uses
  • Chart secrets
  • You will see demonstrations on creating powerful formulas like VLOOKUP, SUMIFS and Dynamic Advanced Filters & Pivot Tables, that will help you to pick up clues on moving to next level of Excel usage.

 

7

Question Hour

  • Post training test/quiz
  • Follow-up exercises
  • Discussions

 

 

 

Session delivery:

  • This entire session will be a “hands-on” workshop. We will provide you system to work or you can bring your own laptop. (You should have minimum Office 2010 version. 2013/2016 will be good)
  • Sample files for all the training topics will be distributed by the trainer on the day of training. It is mandatory that these files are copied to the systems of all participants.
  • No hard copy of any study material will be provided.

      Venue:  RJP INFOTEK PVT LTD No10, 1st Main Road, United India Colony Kodambakkam, Chennai-24

                                                 Workshop on: 23rd July, 2017 (Sundays)

                                                             Timing  : 9.30 am  - 5.30 pm

                                                                  ( Inclusive of Lunch )

                                  For Details call 9940611306/305 or mail to training@rjpinfotek.com

Testimonials

Are You ready to push your career to the next Level?

All of our speakers are highly experienced in the areas in which they work and have been shortlisted after stringent evaluations.