Microsoft Excel Training - Starter to Expert Level training centre in Bangladesh

Forgot password?
Sign in with
New
Caution

Microsoft Excel Training - Starter to Expert Level

Introduction

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 work place. 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, PowerPivot, Sparklines, Goal Seek, Conditional Formatting, Report Automation, Subtotals, Tips and Tricks and many more!

Methodology

Face to face interactive class

Contents of Training:

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

2 Sorting & Filtering
# Data Preparation
# Sorting
# Filtering

3 Formulas Begins
# AutoSum Tricks
# Relative Versus Absolute Formulas
# Defining Names
# Tables and Table Formulas
# Goal Seek

4 Advance Formulas
# IF Formulas
# Sumifs
# VLOOKUP
# Date and Time

5 Charting and SmartArt
# Creating and Formatting a Chart
# Adding or Removing Chart Data
# Pie Chart Tricks
# Sparkline

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

  7 Pivot Tables
# Creating a Pivot Table
# 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

8 Tips n Tricks
# Hyper Link
# Removing Duplicates
# Shrink Text
# Transposing Tricks
# Data Validation
# Switch Column Trick
# Insert Blank Rows
# Fit to One Page Trick
# Speak Cells
Bonus Segments for Demo if Time Permits

9 Business Intelligence Intro
# Introduction to PowerPivot
# Introduction to PowerQuery
# Introduction to PowerBI

10 Solver

Related Courses

Price 3,000 Tk + VAT
Syed Saniat Ahmmad
  • 20 Jul - 1 Aug 2022

Practical examples, exercises & case studies with ...

IT
Online Training Register Wishlist
Price 4,500 Tk + VAT
Md. Feroz Kibria
  • 22 - 23 Jul 2022 (2 Sessions)

Having good spreadsheet skills gives you the ability to ...

IT
Offline Training Register Wishlist
Price 3,000 Tk + VAT
Sonny DCosta
  • 28 Jul - 9 Aug 2022

This is a hands-on course for anyone who wishes to ...

IT
Online Training Register Wishlist
Price 4,500 Tk + VAT
Md. Feroz Kibria
  • 5 - 6 Aug 2022 (2 Days)

Day to day HR and Admin data analysis, reporting, tools and ...

IT
Offline Training Register Wishlist

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.

Boarding

Arrangement for Certificate, lunch and two tea-break would be made by the Organizer during the workshop.

Related Jobs 94




Bdjobs eLearning, a division of Bdjobs.com Limited, started its operation in 2005. Currently it is the largest professional training house in the country that runs training ........ more

Get Email Alert

We'll email you updates on job trends, new courses, study tips and more.

About Bdjobs eLearning

Courses by Industry

Courses by Functional Area

Courses by Type

social link fb social link fb social link fb