PROFESSIONAL DEVELOPMENT PROGRAM

 

Note:

>> Lunch, Tea Break & Refreshment will be arranged by the organizer

>> Training Materials will be provided by the organizer

>> Seats are limited and will be served on 'First Come-First Serve' basis

>> Participants will be awarded certificates at the end of the session

Who Should Attend

This course is very useful for anyone who works in Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.
Professionals who need MS Excel at work
Any individual who wants to develop their expertise on MS Excel.

Power Skills On Microsoft Excel 2007-2010

cover fundamental, intermediate and advanced topics for Excel-2007-10

Date : 19 Oct 2012-20 Oct 2012
Time : 10.00 AM - 06.00 PM
Fee  : 7000 BDT/Participant
Training venue :
AMS-LAB
House # 89/E, Road # 13/C, Block # E Banani, Dhaka-1213 [Lane Just Beside Dhaba Restaurant near Prescription Point]
Training Objective
The most widely used spreadsheet application in the world, Excel is a key part of the Microsoft Office suite of applications. You can use Excel for anything from a small spreadsheet of house hold finances to monster databases of all your company™s products, customers, and sales. You can use Excel either on its own or together with the other Office applications. This course will guide you to touch almost all the powerful tools of Excels.

It is widely agreed that close to 50% of Excel users leave 80% of Excel untouched. That is, most users don’t tap into the full potential of Excels built-in utilities. In this course we will explore those uncovered area on such fine manner that attendees can readily imply them in their regular work just after attending the program.
Training Content
Lesson 1: SUMMARIZING DATA
1.Advanced Subtotals
2.Formatting the Subtotal Rows
3.Adding and Copying with Subtotals
4.Consolidating Data
5.Looking at AutoSum Tricks
6.Utilizing Fill Handle Tricks

Lesson 2: WORKING WITH PIVOT TABLES
1.Creating a Pivot Table
2.Rearranging Fields in a Pivot Table
3.Explaining the Report Layout Options
4.Using the Report Filters Feature
5.Using Top 10 & Date Filters
6.Handling Blank Cells
7.Drilling Down in the Pivot Table
8.Sorting a Pivot Table
9.Formatting a Pivot Table
10.Creating Custom Formats
11.Explaining the Grouping Options
12.Adding Formulas to a Pivot Table
13.Changing a Calculation in a Pivot Table
14.Replicating a Pivot Table
15.Counting with a Pivot Table
16.Using Pivot Charts


Lesson 3: CHARTING IN EXCEL

1. Charts Refresher
2. Moving, Sizing & Copying Charts
3. Formatting Charts
4. Formatting a Series
5. Exploring the Home & Format Ribbons
6. Deciding What Chart Format to Use
7. Show a Time Series with Column or Line Charts
8. Using Combination Charts
9. Using Line Chart Accessories
10. Using Bar Charts to Show Comparisons
11. Using Component Charts
12. Using Correlation Charts
13. Exploring Other Charts
14. Chart Lies Revealed & Advanced Chart Types
15. Creating a Custom Layout


Lesson 4: GETTING Visuals

1. Using Conditional Formatting
2. Using Advanced Conditional Formatting
3. Highlighting, Sorting & Filtering Columns
4. Using SmartArt Functions
5. Using Different SmartArt Graphics
6. Embedding a Formula into a Shape

Lesson 5: CREATING POWERFUL FORMULAS

1. Using Goal Seek to Find an Answer
2. Auditing Formulas
3. Shrinking the Formula Bar
4. Understanding Errors
5. Joining Text Columns
6. Using Custom Formatting Codes
7. Pasting Values
8. Using Paste Special
9. Breaking Apart Text
10. Converting Text to Numbers
11. Using Date Functions
14. Using the VLOOKUP Function
19. Using the Rand Function
21. Ranking & Sorting Formulas

Lesson 6: RECORDING MACROS

1. Displaying the Developer Tab
2. Recording a Simple Macro
3. Simplifying the Macro
4. Recording Using Relative References
5. Automating the Report

Final Touch and Tips and Tricks

1. Showing Off New Tips in Excel 2007
2. Tips for Handling Worksheets
3. Using Excel as a Word Processor
4. Miscellaneous Tips
5. Validating Data
6. Changing Text Entry Direction
8. Freeze Pane
9. Split Windows
10.Protectcting Cells and Work Books
11. Password protecting a file
12. Showing list from a drop down
13. Random Tips for Preparing Dashboard
Facilitator(s) Profile
 

Samiul Huq
NovoTel Limited
Assistant Manager Revenue Assurance.
OCA- Oracle Certified Associate.Managing
  Mr.Samiul Huq is an OCA- Oracle Certified Associate.Expertise in Data Mining, Data Analysis, Statistics, Reporting, Business Analysis, Business Intelligence, Research & Development, Strategic Planning, Performance Management, MS Office Suit. BI:Business Intelligence Development Studio, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Database Engine, SQL Server Report Builder, SQL Server Data Mining SharePoint Server – Excel Services, PerformancePoint Services, Business Connectivity Services, PowerPivot Services, SharePoint Designer, PerformancePoint Dashboard Designer, Palo Olap, ETL. Conducted Several Training for bdjobs and other corporates on Excel for High Officials. Some familiar name would be Mirpur Ceramics, PEPSI, Transcom Limited, Brac Bank, Action Aid, NovoTel Limited, and Berger.
Registration Details
Registration payment can be made by cash or A/C Payee cheque in favor of Business Express, before October 18, 2012, till 08:32 pm

Registration Point
Business Express H:38/A (3rd Floor),R: 9/A Dhanmondi, Dhaka-1209 W: www.businessexpress24.com

Mob: 01717801435,01711032527
E-Mail: sazid@businessexpress24.com,info@businessexpress24.com,upol84@gmail.com

Last date of registration: Thursday, 18 Oct 2012
Visit www.businessexpress24.com for upcoming training calendar and FREE E-Learning resources