Advanced Excel Course

Learn Advanced Excel Skills for Business. Master Excel to add a highly valuable asset to your employability portfolio.

About The Course

Microsoft Excel has proven to be one of the most important applications for businesses around the world. Yet most of its powerful features are underutilized. Boost your productivity with an Excel  training course and learn to utilize them to the full.

How Participant will be Benefited

Microsoft Excel allows you to manipulate, manage, and analyze data, which aids in decision making and creates efficiencies that have a direct impact on your bottom line. Whether you’re using it for business or to help manage your personal database and expenses, Microsoft Excel provides you with the tools you need to get the job done. 

If you already have some experience with Excel and want to further boost your skills, this  course will quickly amplify your knowledge of intermediate and advanced Excel functions.

Methodology

  • Face to face interactive class
  • Practical Case Studies 

Contact Us

  • +88 01733405068
  • support@icdb.info
  • Ka-7/ A (4th Floor), Jagannathpur Super Market, Bashundhara R/A Main Road

Who Can Attend?

This course is very useful for anyone who works in Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.

Certification & Duration

  • Certificate: Yes 
  • Course Duration: 18 Hours

CONTENT OF PURE ADVANCED COURSE ON MICROSOFT EXCEL

Microsoft Excel has proven to be one of the most important applications for businesses around the world. Yet most of its powerful features are underutilized. Boost your productivity with an Excel  training course and learn to utilize them to the full.

Cell References

  • Relative Reference

  • Absolute Reference

  • Mixed Reference

Fundamental Functions

  • Sum  |  Sumif  |  Sumif with Numeric Criteria |  Sumif with Text Criteria  |  Sumif with Date Criteria  | Sumifs
  • Average  |  Averageif  |  Averageifs
  • Min  |  Minifs
  • Max  |  Maxifs
  • Count  |  Counta  |  Countblank  |  Countif  | Countifs

Logical Functions

  • Understanding Logical Functions
  • Using IF With Text
  • Using IF With Numbers
  • Nesting IF Functions
  • Using IFERROR
  • Using TRUE and FALSE
  • Using AND
  • Using OR
  • Using NOT

Validating Data

  • Validating Data
    Understanding
  • Data Validation
  • Creating a Number
  • Range Validation
  • Testing a Validation
  • Creating an Input Message
  • Creating an Error Message
  • Creating a Drop Down List
  • Using Formulas as Validation Criteria
  • Circling Invalid Data
  • Removing Invalid Circles

Look-up Functions

  • Understanding Data Lookup Functions
  • Using CHOOSE
  • Using VLOOKUP
  • Using VLOOKUP for Exact Matches
  • Using HLOOKUP
  • Using INDEX
  • Using Match
  • Understanding Reference Functions
  • Using ROW and ROWS
  • Using COLUMN and COLUMNS
  • Using ADDRESS
  • Using INDIRECT
  • Using OFFSET

Data Consolidation

  • Understanding Data Consolidation
  • Consolidating Data with Identical Layouts
  • Creating a Linked Consolidation
  • Consolidating Data with Different Layouts
  • Consolidating Data Using the SUM Function

Scenarios

  • Understanding Scenarios
  • Creating a Default Scenario
  • Creating Scenarios
  • Using Names in Scenarios
  • Displaying Scenarios
  • Creating a Scenario Summary Report
  • Merging Scenarios

Excel Date Functions

  • DATE function
  • TODAY
  • NOW
  • DATEVALUE
  • TEXT
  • DAY
  • MONTH
  • YEAR
  • EOMONTH
  • WEEKDAY
  • WEEKNUM
  • DATEDIF
  • EDATE
  • YEARFRAC
  • WORKDAY
  • WORKDAY.INTL
  • NETWORKDAYS
  • NETWORKDAYS.INTL

Chart

  • Pie
  • Bar
  • Column
  • Line Chart
  • Map
  • XY Scatter Chart
  • Spark Line Chart
  • Combo

Pivot Tables

  • Understanding Pivot Tables
  • Recommended Pivot Tables
  • Creating Your Own PivotTable
  • Defining the PivotTable Structure
  • Filtering a PivotTable
  • Clearing a Report Filter
  • Switching PivotTable Fields
  • Formatting a PivotTable
  • Understanding Slicers
  • Creating Slicers
  • Inserting a Timeline Filter

Pivot Table Features

  • Using Compound Fields
  • Counting in a PivotTable
  • Formatting PivotTable Values
  • Working With PivotTable Grand Totals
  • Working With PivotTable Subtotals
  • Finding the Percentage of Total
  • Finding the Difference From
  • Grouping in PivotTable Reports
  • Creating Running Totals
  • Creating Calculated Fields
  • Providing Custom Names
  • Creating Calculated Items
  • PivotTable Options
  • Sorting in a PivotTable

Power Pivot

  • What is Power Pivot
  • Getting data from Power Pivot
  • Data Modeling Techniques 
  • Building Measures with DAX 

Power Query

  • What is Power Query?
  • Importing Data
  • Appending Tables
  • Merging Tables 
  • Data Transformation

Record Macros

  • Understanding Excel Macros
  • Setting Macro Security
  • Saving a Document as Macro Enabled
  • Recording a Simple Macro
  • Running a Recorded Macro
  • Relative Cell References
  • Running a Macro With Relative References
  • Viewing a Macro
  • Editing a Macro
  • Assigning a Macro to the Toolbar
  • Running a Macro From the Toolbar
  • Assigning a Macro to the Ribbon
  • Assigning a Keyboard Shortcut to a Macro

Contact us
+88 01733405068
E-mail: mhossain@icdb.info
Institute of Career Development, Bangladesh – ICDB