Quality Training & Software Solution Provider

  1. Home
  2. Training

ADVANCED EXCEL

When you hear the term “Microsoft Excel”, you may automatically think of number-crunching careers like accounting or finance. But you could potentially use it in other fields as well to transform your data into a business decision or to maintain a simple to complex database in an easy & faster manner or analyze the data with graphs, pivot table or macro. Excel training can help organization to improve the productivity and efficiency. It can manage huge amount of transactions and data with the help of hyperlinks, lookup and advanced formulas. In nutshell, excel is a powerful application which can make your tasks easier, faster and secured.

The course is designed for the working class who have basic knowledge in MS Excel and wish to be master in it. It will cover the intermediate & advanced modules i.e. Formula, Graphs, Security, Pivot Table, Macro, Dashboard, Security, Validation etc. It has been a very widely applied spreadsheet. Excel is a part of Microsoft Office.

We follow a blended learning methodology with case-based hands-on training. The course coverage is given below-

Course Coverage   Trainer's Profile
  • Introduction
  • Excel as a Data Analysis Tool
    • Data, Information and Knowledge
  • Cell Reference
    • Relative & Absolute Reference
    • Exercise(relative and absolute reference)
  • Naming data range
  • Excel Functions
    • Introduction to functions
    • A walkthrough on how to use functions
    • How to use the function bar and menu
    • Summation, Subtraction, Multiplication, Division.
    • IF Function
      • Example/Exercise of Payroll System
      • Example/Exercise of Grading System
    • Sum, Count, CountA, CountIf Function
      • Example of Sales System
    • Min, Max, Average Functions
    • Date Function
    • And Function
    • FV Functions
    • Goal Seek
    • Lookup Function
      • HLookup
      • VLookup
      • XLookup
  • Subtotal
  • Pivot Table
  • Case Study
    • Banking Transaction
    • Money Exchange
  • Introduction to Graphs
    • How to effectively use Graphs
    • When to use graphs
    • Strengths of each graphs
    • Creating and Modifying a Chart
    • Column Chart, Pie Chart, Cylinder Chart
    • Changing the Chart Type
    • Changing the Gridlines
    • Changing Color, Value, Category Axis, Floor, Wall of Chart
    • Removing Data from a Chart
    • Excel Chart placing to PowerPoint
  • Proofing and Security
    • Conditional Formatting
    • Data Validation
    • Protecting workbook and worksheets
  • Working with Macro
    • Introduction to Macros
    • How it works in excel
    • The advantages of macros(automation)
    • Walkthrough
    • How to record a macro
    • Assigning a keyboard shortcut for macro
    • Absolute and Relative referenced macros
    • Exercise(macros)
    • Dashboard
  • VBA for Excel
    • Introduction to VBA Scripts
    • Accessing and working with VBA Editor
    • Creating a sub-routine
    • Using variables
    • The If condition
    • The If-else condition
    • Assigning a VBA Script or a Macro to a Button
      • Final Exercise
    • Creating your own custom function
    • Example of Solver
  • Working with Power Pivot
    • Enabling Power Pivot
    • Adding Data Sources Visualization
  

Shafiq has 20 years of diversified working experience in ICT education industry with specialization in conducting skills development training, project management, implementation, monitoring, evaluation, quality control, resource allocation, scheduling, customization, need analysis etc.

He has been teaching graduates, undergraduates, corporate, diplomats, diploma-holders and HND students in multi-cultured environment with full students’ satisfaction in Bangladesh, Saudi Arabia, Philippines and Uganda. He was speaker in many academic seminars in several countries. He is expert in govt. & non-govt. liaison and technically sound in software engineering, database designing & administration, programming, web designing and open source technologies. He is a certified trainer of Aptech Worldwide in 16 different skills. He is also prince2 certified Project Management Professional. He has achieved International Best Faculty Award in 2007-08 from Aptech Worldwide.

He has conducted corporate training for the employees of Canon, Alpha Aviation, Oracle, American Express, Microsoft, Asian Terminals, BCS Realty, DP World, Accenture, Emerson, Grieg Philippines, Indian Assurance, Hinduja GSL, Indonesian Embassy, Nigerian Embassy, United Nations, Royal Canin and many more organizations.

 
Course Schedule
Duration: 20 Hours

 
Course Fee & Payment Mode
Fee:
BDT 5,000/Participant

 

Payment Options:

1. bKash: 01738442377

2. Bank:
MEEK Technologies Ltd.,
A/C: 7022-0212000985,
Trust Bank Ltd,
Millennium Corporate Branch,
Dhaka.

 
Contact Us
Phone: 01910607050, 01738442377
email: meektechnologies@gmail.com

 
Register Now