TRAINING DETAILS

Training Categories

Master Class Data Analysis with MS Excel

Master Class Data Analysis with MS Excel
Request an In-House Proposal Contact Us Download Brochure

Microsoft Excel is the world's most used and versatile business analysis, reporting and strategy software. Having a deep practical knowledge of Excel will turn you almost superhuman at work and increase your productivity. You will be seen as a very efficient, highly competent and indispensable partner in the organization's progress. And, hopefully, it will lead to a much greater career role and opportunity for you.

This training is going to focus on making you highly proficient in the use of Excel for business data analysis and reporting the professional way. And most of this would be achieved through lots of samples that will be similar to what you'll need at work.

COURSE DESCRIPTION

There is no one-size-fits all strategy for businesses. Reporting and analytics gives organizational managers the insights they need to improve the processes and enables to close deals faster. By allowing the data to tell the story, you can be more precise in setting Goals that elicit desired results. This training is designed to meet your developing necessities and the way you work.

TRAINING METHODOLOGY

  • Interactive with trainer & trainees
  • Assessments to measure existing knowledge and deficiencies
  • Positive impact on works giving users real hands-on experience
  • Engaging –interesting Fun and learn
  • Easy to understand
  • Practical case studies, Group discussions and exercises
  • Motivational Video Clips

LEARNING OUTCOMES

Skillful use of MS Excel tools will save a lot of time. That time adds up to extra time for your more enjoyable activities. In addition, you will let know that you are more resourceful and can produce proficient looking reports and presentations that impress. This course will take you straight into a simple set of efficiency rules that will lead you towards professional excellence.

EVALUATION

  • Pre-Post Evaluation

REQUIREMENTS

  • The training requires having Excel 2010 and above. Excel 2007 will also work but you won't be able to practice the advance features. Best is Excel 2016.
  • You also must be ready to practice every topic covered.

COURSE CONTENT

 

INTRODUCTION

  • What Excel can do
  • Superiority or excellence of Excel
  • Type of operators
  • Sequence of mathematical operations
  • Smart use of reference system in Excel
  • How Excel handles different data types
  • Data consistency, starting with the end in view

 

CUSTOMIZING THE RIBBON

  • Customize the Quick Access Toolbar
  • Customize the Ribbon

 

FILE MANAGEMENT

  • Automatically save and recover office files
  • Customize the list of recently used files

 

ADVANCE VIEWING

  • Make your referencing parts visible all the time
  • Multi-level viewing your big database

 

 CREATING A USABLE DATA TABLE

  • Convert text to your preferred case
  • Write Address in single cell professionally
  • Join multiple cell values in a single cell
  • Extract your required portion of text
  • Separate cell value into multiple cells
  • When Excel cannot read dates
  • Using of Go To Command
  • Define cells in your own style
  • Put appropriate values in all empty cells in one stroke
  • Maintain serials automatically
  • Get rid of unnecessary spaces and symbols

 

USING LOGICAL FUNCTION

  • Count your write-ups or your desired item
  • What are AND, OR, IF Functions
  • Simple techniques of developing complex formula
  • Get results of portion you are seeing
  • Hide cell values when your formula returns error

 

SORT, FILTER AND ADVANCED FILTER

  • Sort your data in the way you want
  • When you need not to copy hidden cells
  • Extract Unique Records

CONDITIONAL FORMATTING

  • Auto format (colour) when data meets your demand
  • Multiple conditional colouring using formula
  • Identify duplicate data and remove in a single stroke

CREATING TABLE

  • Is using Table your best option?
  • Toggle between Table and Range

 

DATA VALIDATION

  • Allow pre-selected values only for cell inputs
  • Allow only valid Numbers or Date input in a cell
  • Do you want to allow wrong entries?
  • Avoid Red Mark of Comments by validation tooltips

 FUNCTIONS (LOOKUP)

  • Do you know, you are using LOOKUP functions, every day in your office?
  • Small ignorance can create great mistakes: 4 must rules of LOOKUP

 

CREATING CHARTS

  •  Knowing and controlling Chart Components
  • How to select perfect chart type for your data
  • Creating A Self Expanding/Dynamic Chart
  • Combination chart
  • Smart use of chart for Target vs Achievement
  • How easy you can create a Organogram or Process
  • How and when to use SmartArt

 

PIVOT-TABLE AND PIVOT CHART

  • Play with your Report Layouts by using Pivot Table
  • Querying large amounts of data user-friendly ways
  • Combine Dates by Month, Year, Quarter and Days
  • Show Data as Percent of Total
  • Case Studies and Group Exercise

DASHBOARD CREATION

  • Overview of how dashboards are so useful
  • Using Tables to Dynamically Link Charts & Lists
  • Linking Charts Across Worksheets
  • How to use Pivot table slicer in Dashboard
  • Dashboard Charting techniques
  • Visually presenting data
  • Bringing it all together

 

MASTER CLASS DATA ANALYSIS TECHNIQUE

  • Basic of Financial functions in Excel
  • PMT |  RATE  |  NPER  |  PV  |  FV
  • What-If Analysis
  • Analysis ToolPak
  • Histogram
  • Descriptive Statistics
  • Correlation
  • Regression analysis

 

WHAT IS MACRO?

  • Basic of Macro.
  • How to record and use a Macro
  • Creating a Macro using code
  • Creating an index to move your sheets like magic
  • What is Add Ins and how to use it for converting your accounting figure to word.

PROTECTION

  • Protect worksheet, workbook elements
  • Control other users’ access to your worksheet
  • Hide your valuable formula from others

PRINTING AND GRAPHICS

  • Working with shapes
  • Printing Large Datasheet professionally
  • You need not to show calculation errors in printing
  • Print row and column headings on every printed page
  • Manual page breaks in a worksheet

CRITICAL THINKING

  • Practical problem solving
  • Case study
  • Group discussions and exercises
  • So many more tips & tricks

 
Md. Anowar Hossain Fakir

Md. Anowar Hossain Fakir

Lead Consultant

Presently he is an entrepreneur of Training Bangla and having solid working experience of 19+ years in different positions in Project Management, Procurement, Fleet Management, Store Management, Quality Control and Occupational Health & safety through working in all intermediary positions with job enlargement & enrichment with diversified job responsibility. 

He has experienced from different national and international organizations including Robi Axiata Limited, A leading Telecommunication Company and Intertoll Management system, which was worked as O&M Company in Bangabandhu Bridge.

Apart from his creative and strategic contributions to the Organization, He was a leading in-house official trainer of Robi Axiata Limited starting from 2012. He has successfully conducted training on MS Excel (Basic & Advance), Graphical Data Representation with Excel, MS PowerPoint and Presentation Skills, Project Management with Microsoft Project, Essential Leadership Skills in Managing Team Performance, Data analysis and Financial Modeling. He is also a regular trainer of ICAB (The Institute of Chartered Accountants of Bangladesh), BRAC, DaySpring Limited, Prothom-Alo-Jobs, ICT Bangladesh and freelancing in various organization. He has conducted training at more than 100+ corporate houses of the country. Trained around 3,000 people on Microsoft Office and Leadership 600 days in 5 years and about 2500+ training Hours & rating was 9.5 out of 10.

Mr. Anowar is the author of Easy way to learn Microsoft Office (Sohoje Shikhi Microsoft Office). The book has been nominated as the Official Training Manual of Robi Corporate Social Responsibility Programs on Basic Computer Training for College Students of Less Developed Areas and covered 72 colleges for 7,200 students.

Date
October 12 & 13, 2018
Time
09:30 am - 05:30 pm
Duration
2 Days
Reg. Before
October 11, 2018
Vanue
NRB Jobs Training Center
NRB Jobs Training reserves the right to alter dates, content, venue and trainer.
Per Perticipant
BDT 7,500/- 


Early Bird Discount
BDT 6,500/- 
(Excluding All Tax & VAT)
Confirmation & Cancellation Policies

N/A