ONE DAY WORKSHOP ON EXCEL ESSENTIALS

ONE DAY WORKSHOP ON EXCEL ESSENTIALS

 

  • EXCEL

    Sale Date Ended

    INR 2500
    Sold Out

Invite friends

Contact Us

Page Views : 17

About The Event

 One Day Workshop On Excel Essentials

 

If you are a beginner or using Excel for quite some time, we invite you register for our ONE DAY EXCEL ESSENTIALS COURSE. You will learn many time saving short-cuts and you will become faster, stronger and smarter in Excel.

 

#

    Topic

        Additional Information

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

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

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

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

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

6

Creating basic charts AS IF IT IS MAGIC

  • Creating basic charts
  • Different types of charts and their uses
  • Chart secrets

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.

 

                 For More Details call : 9940611306 or mailto training@rjpinfotek.com

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Venue Map