Course Description:
You have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets. Demonstration will be based on the MS Office version.
Contents:
Understanding layout of Excel
Finding and using commands
Moving around a worksheet
Navigating the workbook
Basic Formatting
Formatting numbers
Formatting text
Coloring data and cells
Wrapping and shrinking text
Merging cells
Using indents
Applying borders to cells
The Format Painter
Conditional Formatting
Formatting based on the values
Color code values as per requirement
Editing conditional formatting rules
Generating reports using conditional formatting
Using some functions/formula
Using date functions- today, now
Using statistical functions- sum, count, min, max, product
Working with charts
Using chart templates
Using trend lines on the charts
Changing the chart types
Labelling the chart
Modifying the charts as per your requirement
Working with sheets- Printing/renaming/ deleting
Working across multiple worksheets
Generating reports
Copying and Moving Data
Copying and cutting data
Absolute cell references
Filling cells
Using drag-and-drop
Undo and Redo
Find and Replace
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
Working with Columns and Rows
Selecting columns and rows
Changing column width and row height
Hiding and unhiding
Inserting and deleting
Managing Worksheets
Naming worksheets
Copying and moving worksheets
Grouping worksheets
Moving data between sheets
Adding and deleting worksheets
Using Large Spreadsheets
Changing the magnification
Full Screen view
Splitting the window
Using Freeze Panes
Who should attend?
This program is designed for Directors/ Operation – Production Managers/ Heads, Finance Head, Engineers/ Industrial Engineers, Process Owners, Supervisors, Officers, Team leaders, Secretaries or anyone interested to learn about Basic Excel.
IITD Sr. Expert Faculty:
Highly experienced faculty from Indian Institute of Training & Development will conduct this training program. The training sessions will provide participants an opportunity to discuss specific problems with the expert faculty.
Medium: English/ Hindi/ Marathi
Fees & Registration Details:
Rs. 2,800 + GST 18% per person.
Rs. 2,600 + GST 18% per person for a group of Three to Four participants.
Rs. 2,400 + GST 18% per person for a group of Five or More participants.
Kindly provide the below given details of registration on email: iitdpune@gmail.com &/or rajiv@iitdworld.com
Name of the program:
Name of the participant(s):
Participants email id for sending venue details:
Name of the company:
GST number:
Certification: Participation certificate will be provided to all the participants.