Certification Course on: Microsoft Excel 2007 Specialist (For Professional and Business Use)

Microsoft Excel 2007 Specialist (For Professional and Business Use) Date :12 July - 11 August 2009 Last Date of Registration :8 July, 2009 Time :6:00 pm - 8:45 pm Shift :Evening Venue :Bdjobs Training, BSRS Building, Level 14 (East Side), 12 Kawran Bazar C/A, Dhaka-1215. Registration Fees :Tk. 8000.00/Participant RESOURCE PERSON M. Xane Alam Raabid Consultant M. Xane Alam Raabid has about 15 years of experience in ICT industry. He has worked for some world leading brand like Microsoft, Dell, Xerox and Aptech and got necessary exposure of modern business processes and practices. He is currently a freelance consultant in the verticals of e-business, e-governance, information security, education, digital media, and publications. He is also the Chief Executive Officer of SohomApps and edu4bd.com. He has been working with MSF, OOAD, .NET Framework, XML, UML, and RUP since year 2000. He is the First Microsoft certified Professional in .NET track in Bangladesh from Microsoft (Ref: The Bangladesh Observer, October 01, 2002). He is also an MCSD.NET, MCAD, MCDBA, MCSD (VB 6.0). He has experience in designing enterprise-level network architecture, database storage solution and solutions integration. He has also significant experience in sales and marketing, training, project management and technical leadership in application software, database development, e-commerce, and management consultancy. He has some publications on various subjects also. * Currently working as CEO of SohomApps and edu4bd.com * Worked as IT Consultant for a joint funded (GOB and donor) education project. * Worked as Partner Engagement Manager, Offshore Outsourcing Division, Southtech Limited. * Worked as Technical Specialist and End User Manager for Microsoft Corporation in their Marketing Development Provider Program with Southtech Limited. * Worked as ICT Consultant for Bangladesh National Commission for UNESCO. * Worked as Head, Software Solutions Division, Axiom Technologies Ltd. * Worked as Training Head, Franchisee Network, Aptech Dhanmondi. * Worked as Team-Leader, Marketing and Sales, Information Solutions Ltd. He can be reached at raabid@consultant.com, raabidx@gmail.com WHO CAN ATTEND Anybody who needs Microsoft Excel at professional or academic work. METHODOLOGY The course combines theory and practice by mixing lectures and exercises throughout the session(s). Participants will have to sit for an assessment test at the end of the training. WORKSHOP DETAILS Venue: Bdjobs Training, BSRS Building, Level 14 (East Side), 12 Kawran Bazar C/A, Dhaka-1215. Date & Time: Date: 12 July - 11 August 2009 Time: 6:00 pm - 8:45 pm Workshop Fees: Tk. 8000.00/Participant Microsoft Excel 2007 Specialist (For Professional and Business Use) (36 hours total; 3 days a week: Sun, Tue, Thu) Microsoft Excel 2007 is the latest version of Microsoft's famous spreadsheet application. It is one of the most powerful and widely used spreadsheet applications available today. Excel's functionality and popularity have made it an essential component on computers in countless organizations, businesses, and other institutions throughout the world. Microsoft Excel 2007 is the latest version of Microsoft's famous spreadsheet application. It is one of the most powerful and widely used spreadsheet applications available today. Excel's functionality and popularity have made it an essential component on computers in countless organizations, businesses, and other institutions throughout the world. Excel 2007 provides a wealth of financial, mathematical, and statistical functions that you can apply to your data. Excel 2007 also offers numerous formatting and presentation options that will help you create slick, professional looking reports. You can use Excel as a database, a graphing and charting tool, a means of evaluating complex formulas, and as a way of sharing data and collaborating with others. When you change data in an Excel spreadsheet, Excel will recalculate your totals, functions, and formulas accordingly. Excel 2007 is comprehensive enough to meet the needs of beginners and experienced users alike. With Excel you can perform a wide range of tasks, from building basic spread sheets to performing advanced data analysis. Excel can help you process, interpret, and extract meaningful conclusions from your information. Contents of Training: What's New in Excel 2007 . New User Interface and Ribbon . New Features introduced . Extended capabilities over Excel 2003 Setting up a Workbook . Creating Workbooks . Saving Workbooks . Modifying Worksheets and Workbooks . Customizing the Excel 2007 Program Window Working with Data and Data Tables . Entering and Revising Data . Moving Data Within a Workbook . Finding and Replacing Data . Correcting and Expanding Upon Worksheet Data . Defining a Table Performing Calculations on Data . Naming Groups of Data . Creating Formulas to Calculate Values . Summarizing Data That Meets Specific Conditions . Finding and Correcting Errors in Calculations Changing Document Appearance . Formatting Cells . Defining Styles . Applying Workbook Themes and Table Styles . Making Numbers Easier to Read . Changing the Appearance of Data Based on Its Value . Adding Images to a Document Focusing on Specific Data Using Filters . Limiting Data That Appears on Your Screen . Manipulating List Data . Defining Valid Sets of Values for Ranges of Cells Reordering and Summarizing Data . Sorting Data Lists . Organizing Data into Levels . Looking Up Information in a Data List Combining Data from Multiple Sources . Using Data Lists as Templates for Other Lists . Linking to Data in Other Worksheets and Workbooks . Consolidating Multiple Sets of Data into a Single Workbook . Grouping Multiple Sets of Data Creating Dynamic Lists with PivotTables . Analyzing Data Dynamically with PivotTables . Filtering, Showing, and Hiding PivotTable Data . Editing PivotTables . Formatting PivotTables . Creating PivotTables from External Data Creating Charts and Graphics . Creating Charts . Customizing the Appearance of Charts . Finding Trends in Your Data . Creating Dynamic Charts Using PivotCharts . Creating Diagrams by Using SmartArt Printing . Adding Headers and Footers to Printed Pages . Preparing Worksheets for Printing . Printing Data Lists . Printing Parts of Data Lists . Printing Charts Automating Repetitive Tasks with Macros . Introducing Macros . Recording and Modifying Macros Working with Other Microsoft Office Programs . Importing from and exporting to other office programs . Creating Hyperlinks . Pasting Charts into Other Documents Collaborating with Colleagues . Sharing Data Lists . Managing Comments . Tracking and Managing Colleagues' Changes . Protecting Workbooks and Worksheets Register Online Certificates will be awarded to participants at the end of workshop REGISTRATION DETAILS For Registration or additional information please call us at 9140345,9117179, 01811410862, 01818720972 or E-mail at nahar@bdjobs.com or mostafa@bdjobs.com To confirm your registration, Please pay the registration fee by 8 July, 2009 at Bdjobs.com Office by A/C Payee Cheque or cash. Bdjobs.com Ltd. 8 th floor (west), BSRS Bhaban 12 Karwan Bazaar Dhaka - 1215 Bdjobs.com Training Program in July 2009