Advanced Excel

Duration
: 2 Hours
No. of Classes/ Sessions
: 6
Total Hours
: 12 Hours
Last Date of Registration
: 20 August, 2020
Class Starts From
: 21 August, 2020
Date
 : Friday & Saturday
Venue
 : Bizz Career Ltd. City Center 90/1(Lift - 26), Motijheel

Participants will experience a first look of the latest version of Microsoft Excel and get to play with the latest cool features. Get the most out of Microsoft Excel faster and easier than ever and be the Excel Guru of your workplace. In this Course, maximize your productivity with the latest version of Microsoft Excel’s best tools and shortcuts. The course simplifies powerful features including the latest released feature along with PivotTables, Goal Seek, Conditional Formatting, Subtotals, Tips and Tricks and many more.

This course will cover:

1. Handling Text with Formulas and Built-in Tools
• Drag the Fill Handler
• Joining Text
• Breaking Apart Text

Sorting & Filtering
• Data Preparation
• Sorting
• Filtering
 

2. Formulas Begin
• AutoSum Tricks
• Relative Versus Absolute Formulas
• Defining Names
• Tables and Table Formulas
• Goal Seek

 

3. Advanced Formulas
• IF Formulas
• VLOOKUP
• Date and Time

 

4. Charting and SmartArt
• Creating and Formatting a Chart
• Adding or Removing Chart Data
• Pie Chart Tricks
• Sparkline


Visual Impact
• Color Scales, Icon Sets, Data Bars
• Paired Bar Charts with Negative Data Bars
• Other Conditional Formatting Options

 

5. Pivot Tables
• Creating & Updating a Pivot Table
• Pivot Table Formatting
• Pivot Calculations
• Filtering Row Fields
• Top 10 Report
• Filtering a Pivot Table with Slicers
• Pivot Chart
• Slicers on Multiple Pivot Tables
• Building a Dashboards

 

6. Tips n Tricks & Solver
• HyperLink
• Removing Duplicates
• Shrink Text
• Transposing Tricks
• Data Validation
• Switch Column Trick
• Is Inserting Blank Rows
• Fit to One Page Trick
• Speak Cells

  • Share:

Price: BDT 4,000+VAT
(VAT is applicable with each purchase.)

Registration Date Expired, Please call for details. +880-1713-378787
  • Resource Person

Md. Monir Hosssain

Software Trainer(Tally,Excel)

Founder, E7 Training

He is a chartered certified accountants from ACCA, UK. He has been serving many companies in different industries in Accounting, Finance and Business Automation field. From his very early stage of career he had engaged himself in professional training. Now he is providing professional training on Advanced Excel, Tally.ERP9, QuickBooks and SAP. He has successfully implemented Tally.ERP9 in many companies. His unique quality in training is that he is the author of these three books- Tally and Professional Accounting, MS Office 2017-13, Professional Excel: Basic to Advanced.He is now working as COO of BDCONS (a chartered certified firm), Ecosoft Technology (a software firm) and working as corporate trainer at many organizations.

This course is very useful for anyone who works in Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.
Arrangement for Certificate & Snacks
This will be an instructor-led program delivered through hands-on labs with a real-life example. The audience will taste a new level of experience by attending the Training.