Monday, November 10, 2014

Professional Advance Excel Training @Gulshan

BD Training is proud to offer a comprehensive line of training for Advanced Microsoft Excel 2010/2013.

Regular Course Fee: BDT 8000.00| Early bird Price: BDT 5000.00| Early bird Date: 12th Nov 2014.

Duration: 2 days || Class hours: 8 hrs || Timing: 10:00 AM to 6:00 PM

Seats are Limited. 


Training Content (summary):

  • Summarizing Data
  • Working with Pivot Tables
  • Charting with Dashboard
  • Advanced Formatting
  • Creating Powerful Formulas
  • Advanced Data Sorting & Subtotal
  • Lookup Table
  • Document Protection
  • Filter & Advanced Filter
  • Consolidations With Server Worksheet
  • Managing Documents with Workbooks Templates & Scenarios
  • Sharing & Distributing Your work
  • Array Formula
  • Conditional Formatting
  • Data Validation
  • Auditing & Importing Data
  • Working With Macros
  • Tips & Tricks

Out Comes

  • Explore the Microsoft Office Excel environment and create a basic worksheet.
  • Perform calculations.
  • Modify and Format worksheet.
  • Manage large workbooks.
  • Calculate with advanced formulas.
  • Organize worksheet and table data using various techniques.
  • Create and modify charts.
  • Analyze data using PivotTables and PivotCharts.
  • Insert graphic objects.
  • Customize and enhance workbooks and the Microsoft Office Excel environment.
  • Analyze Excel data by applying enhanced conditional formatting, and generate specific information using the sort and filter options.
  • Manage real-time Dashboard


Class schedule: 

 

Date

Batch Name

Nov 14 & 15

Ist batch

Nov 28 & 29

 

2nd Batch

Dec 5 & 6

 

3rd Batch


Lunch, Tea Break, refreshment and training material will be arranged by the organizer
Participant will be awarded certificates after completion this course.


Do feel free to contact us should there be any further clarifications and I'd be more than glad to assist!

Warm Regards,

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Anica |Contact no- 01762026363|Email-   anica@bdtraining.com.bd
Flat#3/b, House# 17, Road# 42, Gulshan#2,

Dhaka-1212, Bangladesh.

No comments:

Post a Comment