HOME | ABOUT US | REGISTER ONLINE | RESOURCE PERSONS | WORKSHOP| PREVIOUS WORKSHOP| COMPANIES PARTICIPATED | CONSULTANCY SERVICE | CONTACT
Professional Excel by Case Studies
About Workshop


Microsoft Excel is the most commonly used spreadsheet application in the world. Excel can play a crucial part in your business, and is essential for producing accurate numeric data. The vast majority of businesses use Microsoft Excel every day to produce accounting and financial reports, budgets, and many more crucial numeric data tasks, but few appreciate the extent of the features and functions within the software. This course will enable you to maximize the potential of the powerful Microsoft Excel software to produce more professional business information. The course covers some useful tips of Microsoft Excel commonly used in the workplace.

Workshop topics to be covered:

Day-1:

Case Study-A1:
This case study is developed to let you learn and practice the following concepts:
• Relative and Absolute Cell Referencing (including Column Absolute and Row Absolute)
• Defining and Using Names
• Linking worksheet data with current and other workbooks
• Consolidating Excel Data
• Creating and Using Hyperlink (Hyperlink by objects, Hyperlinking external files, Hyperlinking web URL)

Case Study-A2:
This case study will help you to learn and practice the following concepts:
• Cell Formatting: Alignment and text control
• Formatting worksheet: Freezing panes, splitting, cell merge, manual line break, etc.
• Validating Inputs (Number, Text, Decimal, List, Custom)
• Drop down pick list
• Protecting Worksheet and Workbook
• Controlling users from editing/deleting/inserting objects/data, filtering and changing formats
• Hiding Row, Column, Worksheet, Formula

Case Study-A3:
This case study is developed to let you learn and practice the following concepts:
• Conditional Formatting
• Excel Error
• Error Handling within Formula
• CountIf(),SumIf()
• ISNA(), ISBLANK(), ISERR(), ISERROR(), INDIRECT()

Case Study-A4:
This is an in-depth case study of a student grading system. It will help you to learn and practice the following concepts:
• And(), OR(), NOT()
• IF(), Nested IFs
• EXACT()

Case Study-A5:
This case study is developed to let you learn and practice the following concepts:
• LOOKUP(), VLOOKUP(), HLOOKUP() and Nesting
• Data of a range will be compared with another range and will be highlighted according to business logic, such as:
• Data in column A of a worksheet are compared with data in column A of another worksheet, if these data match with that data, these data are shown in column B, otherwise Blank.
• Data in column A of a worksheet are compared with data in column A of another worksheet, if these data do not match with that data or data are same/not same then these data are highlighted.
• Data are compared with data within the range in same sheet, all duplicates/duplicated except the first one are highlighted.

Day-2:

Case Study-B1:
This case study is developed to let you learn and practice the following concepts:
• Excel Security Overview
• Recording and Using Macro
• Macro with VBA: Convert Amount into Words Automatically
• Macro with VBA: Sort Excel Sheets/Worksheets
• Macro with VBA: Convert Text to Upper/Proper Case
• Macro with VBA: Creating a Worksheet Index
• Creating and using Excel Add-in

Case Study-B2:
This case study will help you to learn and practice the following concepts:
• Data Sorting
• Data Filtering (Auto and Custom data filtering)
• Auto data filling
• Copy and Paste special
• SUM(), Auto SUM
• Round(), Rounddown(), Roundup(),

Case Study-B3:
This case study is developed to let you learn and practice the following concepts:
• Find the Difference Between Two Dates using datedif()
• Today(), Day(), Month(), Year()
• Format cell according to different date format and wild-card character (?, *, @, etc.)

Case Study-B4:
This case study will help you to learn and practice the following concepts:
• Forecasting and Regression Analysis
• Forecasting using formula
• Data analysis using analysis tool pack
• MS Excel Graph Trend Analysis

Case Study-B5:
This case study is developed to let you learn and practice the following concepts:
• Pivot Table Report
• Pivot Chart Report


Bdjobs.com Workshop Tracks
 
Marketing/ Sales Track
HR Track
Accounts & Finance Track
Quality & Process Track
IT Track
RMG Track
Banking & Financial Industry Track
Development/ NGO Track
Next Stage/ Career Development Track
Project Management
Commercial Track
Other Specialized Workshops
 
BdJobs.com Limited
8th Floor - West
BDBL Building (Old BSRS)
12 Kawran Bazar
Dhaka, Bangladesh
Email:
asad@bdjobs.com, jomir@bdjobs.com, sumona@bdjobs.com, bithi@bdjobs.com, saleehin@bdjobs.com, hasantareq@bdjobs.com, ridoy@bdjobs.com, training@bdjobs.com
Tel: 9117179,9140345,8124366,
9143104,9144559
Cell: 01811410861-62,01811410851 ctg