Get 20% discount

Beginners to Advanced Excel Training

Introduction

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 Microsoft Excel’s best tools and shortcuts. The course simplifies powerful features including PivotTables, PowerPivot, Sparkline, Goal Seek, Conditional Formatting, Report Automation, Subtotals, Tips and Tricks and many more! Get more things done faster with customized workbooks, the Quick Access Toolbar, and keyboard shortcuts…control and analyze data more effectively…communicate more visually with new charting tools and SmartArt…and plenty more!

The course is separated in three Difficulties level- Beginner, Intermediate and Advance. As the course progresses you will be introduces with Powerful Technics that will take you from Novice to Professional.

How participants will benefit after the course:
It is widely agreed that close to 50% of Excel users leave 80% of Excel untouched. That is, most users don’t tap into the full potential of Excels built-in utilities. In this course we will explore those uncovered area on such fine manner that attendees can readily imply them in their regular work just after attending the program.

Methodology

This will be an instructor led program delivered through hands on labs with real life example. Audience will taste a new level of experience by attending the course.

Contents of Training:

Part 1 Beginners Excel
Session 1
Chapter 1: Getting Familiar with the Excel Interface

• Ribbon, QAT, Mini Toolbar, Live Preview, Finding Icons
• Customizing the Ribbon
• Backstage View, Recent Documents
• Zoom Slider and Page Layout

Chapter 2 Handling Text with Formulas and Built in Tools
• Drag the Fill Handle
• Create Your Own Series
• Joining Text
• Rapid Formula Copy
• Convert to Proper Case
• Formulas to Values
• Breaking Apart Text
• Parsing Fixed Width

Tips of the session 1
• Navigate Fast through Range workbooks and Worksheets
• Removing Duplicates
• Number Format Shortcut

Session 2
Chapter 3 Sorting & Filtering

• Data Preparation
• One-Click Sorting
• Sorting by Color
• Sorting by Weekday
• Rearranging Columns
• Filter by Selection
• Other ways to Filter
• Remove Duplicates

Chapter 4 Formulas Begins
• AutoSum Tricks
• Formula Auditing
• Three Ways of Entering Formulas
• Relative Versus Absolute Formulas
• Tables and Table Formulas
• Discovering Functions
• Goal Seek

Tips of the session 2
• Shrink Text
• Transposing Tricks
• Hide Data
• Important Sheet

Part 2 Intermediate Excel
Session 3
Chapter 5 Advance Formulas

• IF Formulas
• Sumifs
• VLOOKUP
• Date and Time

Tips of the Session 3
• Data Validation
• Fill up in the sideways
• Switch Column Trick
• Fill Blank Trick

Session 4
Part 8 Charting and SmartArt

• Creating and Formatting a Chart
• Adding or Removing Chart Data
• Saving Favorite Chart Settings
• Charting Differing Orders of Magnitude
• Pie Chart Tricks
• Sparkline
• Creating SmartArt
• Smart Art Formulas

Part 9 Visual Impact
• Color Scales, Icon Sets, Data Bars
• Icons for Only a Subset
• Paired Bar Charts with Negative Data Bars

Tips of the Session 4
• Formula to Value
• F4 trick
• Format Part of Cell
• Copying Sheets

Part 3 Advance Excel
Session 5
Part 6 Pivot Tables

• Creating a Pivot Table
• Changing a Pivot Table
• Pivot Gotchas
• Pivot Formatting
• Drill Down
• Pivot Calculations
• Summarizing Dates
• Pivot Sorting
• Filtering Row Fields
• Top 10 Report
• Filtering a Pivot Table with Slicers
• Slicers on Two Pivot Tables
• 50 Reports in 5 Seconds

Tips of the Session 5
• Insert Blank Rows
• Text Box Trick
• Pick from List
• Working In Group Mode

Session 6
Part 10 Recording Macros

• Displaying the Developer Tab
• Recording a Simple Macro
• Simplifying the Macro
• Keys to Successful Recording

Part 11 Solver
• Understand Solver
• Using Solver to Solve your Business Problem

Tips of the Session 6
• Print Small Selection
• Fit to One Page Trick
• Speak Cells
• Excel as word processor

Related Courses

Abu Shams Mahmood Arif
  • Friday, July 7, 2017

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

IT
Muhammad Arif-ur-Rahman
  • 7 - 8 Jul 2017 (2 Days)

If you are a new comer in Excel or after all these years of ...

IT
Mostofa Monower
  • 8 - 21 Jul 2017 (4 evenings)

This training program builds upon advanced level knowledge ...

IT
Muhammad Arif-ur-Rahman
  • 9 - 18 Jul 2017 (4 session)

Advanced Microsoft Excel 2007 & 2010 course to develop ...

IT

Contact

9140345, 9117179

workshop@bdjobs.com

Bdjobs.com Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

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, lunch and two tea-break would be made by the Organizer during the workshop.