1 Day workshop on Advance Excel at Indiranagar Bangalore on 28th October 2017

7 years ago Posted By : User Ref No: WURUR15062 0
  • Image
  • TypeWorkshop
  • Image
  • Location Bangalore, Karnataka, India
  • Price
  • Date 28-10-2017
Workshop Title
1 Day workshop on Advance Excel at Indiranagar Bangalore on 28th October 2017
Event Type
Workshop
Workshop Date
28-10-2017
Last Date for Applying
27-10-2017
Location
Bangalore, Karnataka, India
Organization Name / Organize By
SBTIT TECHNOLOGIES
Presented By
Experienced software trainer
Organizing/Related Departments
Training Division
Organization Type
Education Institution
WorkshopCategory
Technical
WorkshopLevel
State/Province/Region
Related Industries

Education/Teaching/Training/Development

Computer Science

Information Technology

Computer/Technology

Internet/Ecommerce

Location
Bangalore, Karnataka, India

SBTIT Technologies Announces 1 Day workshop on Advance Excel at Indiranagar Bangalore on 28th  October 2017

  • Date :-  Saturday,  28th October 2017.  
  • Time :-10 AM to 4.00 pm
  •  Trainer is having 17 yrs. teaching experience.
  • Notes, participation certificate & Tea/coffee & snacks will be provided to every participant.
  • Every participant has to bring their own laptop with excel installed for practise.
  • Venue address & Pass will be emailed/sms sent to registered participants.

Advance Excel topics to be covered in workshop.

  1. What is spread sheet & Advantages of  Excel
  2. How to protect a sheet / workbook.
  3. Format the cells & Custom Fill Handle
  4. How to merge Cells
  5. Functions / Excel Formulas
  6. Auto sum function
  7. Difference Between Sum() and Auto sum
  8. Other functions covered are  SUM, Countif, Max,  Min, Average, Sqrt, mod, count, now, today, if, if and,  len, sqrt, lower, proper, trim, upper, concatenate, left, mid, right, find,  Vlookup & Hlookup
  9. Sorting
  10. Custom Filter
  11. Auto Filter
  12. Advance Filtering
  13. Conditional formatting & Goal Seek
  14. What is a Chart
  15. Chart Types, Pie Chart, Bar Chart, Line Chart & Column Chart
  16. Formatting Charts
  17. Comment Lines
  18. Data Validation
  19. Introduction to Pivot tables
  20. Comments in Cell &  Printing sheets in Excel

Contact

SBTIT Technologies, 
C/o Common Desk,  1st Floor,
CMH Road, Indiranagar, Bangalore Pincode :- 560038.
Note: Only participants who have registered & have valid pass will be allowed to attend the workshop.

Others Details

http://go.eventshigh.com/599s

Registration Fees
Available
Registration Fees Details
Early Bird Fees is Rs. 1,250/- and regular price is Rs. 1,490/-
Registration Ways
Phone
Website
Address/Venue
  SBTIT Technologies C/o Common Desk, Opp Indira park, 271, 1st Floor,14th Cross Rd, Eshwara Layout, Indiranagar, Stage 2, Hoysala Nagar, Indiranagar, Bengaluru, Karnataka 560038, India  Pin/Zip Code : 560038
Landmark
Near Indiranagar, Metro Station,
Official Email ID
[email protected]
Contact
SBTIT Technolgies

SBTIT Technologies C/o Common Desk, 271, 1st Floor,14th Cross Rd, Eshwara Layout, Indiranagar, Stage 2, Hoysala Nagar, Indiranagar, Bengaluru, Karnataka 560038, India

[email protected]

   9945581975

Date & Time

  • Date
    October 28 2017

Venue/Address

  • SBTIT Technologies C/o Common Desk, Opp Indira park, 271, 1st Floor,14th Cross Rd, Eshwara Layout, Indiranagar, Stage 2, Hoysala Nagar, Indiranagar, Bengaluru, Karnataka 560038, India