Advanced Excel

About The Course As a professional in your field, you already know the benefits of using Microsoft Excel. There is a way to make it an even more powerful tool in the management of your business. Our Advanced Microsoft Excel training will give you a more efficient vision of your operation as well as improve your bottom line.

Batch Duration

Starting Date : 9th November, 2018

Last Date of Registration :8th November, 2018

Class Schedule : 1.5 Months (24 Hours); Friday:- 09:00 AM- 01:00 PM

Total Hours : 24

Course Curriculum

Module 1: Using Formatting and Functions

  • Applying Formatting to Numbers
  • Creating Custom Number Formats
  • Applying Conditional Formats
  • Using Formulas in Conditional Formats
  • Absolute and Relative References  Naming a Range
  • Using a Named Range in a Formula
  • Using Lookup Functions
  • IF Functions 

Module 2: Using Templates and Workbooks

  • Applying a Template
  • Using a Template
  • Creating a New Template
  • Editing a Template
  • Linking Between Workbooks
  • Importing Data from Text Files
  • Importing Data from Other Applications
  • Importing an HTML Table
  • Publishing Data to the Web

Module 3: Working with Data

  • What is a List?
  • Validating Data Entries
  • Sorting Data
  • Subtotaling and Outlining Data
  • Extracting Data with Filters
  • Using Advanced Filters
  • Using Query
  • Querying the Web
  • Using XML to Share Data

Module 4: Analyzing Data

  • Using PivotTable Add info about Slicers
  • Managing PivotTable Reports
  • Creating PivotChart Reports
  • Using Charts and Trendlines
  • Working with Scenarios 

Module 5: Using Macros and Auditing Tools

  • What is a Macro? 
  • Recording a Macro 
  • Running a Macro 
  • Editing a Macro 
  • Auditing Workbooks 
  • Tracing Errors

Module 6: Sharing Workbooks

  • Creating a Shared Workbooks 
  • Consolidating Data 
  • Protecting Columns 
  • Protecting Worksheets 
  • Protecting Worksheet Content 
  • Protecting Cells 
  • Assigning a Password 
  • racking Changes 
  • Adding Comments 
  • Preparing a Workbook 
Faham Kabir

Course Instructor

Faham Kabir

Faculty

Admission Open

20% OFF

Course Fee : ৳ 8000
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech
Clients PeopleNTech