Get 20% discount

Excel 2016: From Novice to Professional

  • Date : 26 - 27 January 2018
  • Duration : Day(9.30 AM-5.30 PM)
  • No. of Classes/ Sessions : 2 Days Long
  • Last Date of Registration : 25 January, 2018
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.
  • 20% Discount at bKash or Online Payment, Seats are Limited

Introduction

How participants will benefit after the course
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

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:

Session 01 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
• The shortcut of Joining Text [New Features]
• Breaking Apart Text
• Parsing Fixed Width
Session 02 Diving into Formulas

• AutoSum Tricks
• Relative Versus Absolute Formulas
• Tables and Table Formulas
• IF Formulas
• IFS Formula [New Feature]
• VLOOKUP
• Date and Time
• All IFS Formula, SUMIFS, MAXIFS [New Feature]
• Forecasting Sales [New Feature]
Session 03 Sorting & Filtering

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

• Creating a Pivot Table
• Changing a Pivot Table
• Pivot Gotchas
• Pivot Formatting
• Drill Down
• Pivot Calculations
• Summarizing Dates
• Search Fields in Pivot Table [New Feature]
• Pivot Sorting
• Filtering Row Fields
• Top 10 Report
• Filtering a Pivot Table with Slicers
• Slicers on Two Pivot Tables
• 50 Reports in 5 Seconds
Session 05 Charting Creating and Formatting a Chart

• Adding or Removing Chart Data
• Saving Favorite Chart Settings
• Charting Differing Orders of Magnitude
• Pie Chart Tricks
• Sparklines
• New Charts of Excel 2016
Session 06 Visual Impact

• Color Scales, Icon Sets, Data Bars
• Paired Bar Charts with Negative Data Bars
Session 07 Recording Macros

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

• PowerPivot: Extend the capacity of excel with PowerPivot • PowerView: Explore amazing data visualization technique using these amazing new features Session 09 Tips & Tricks

• Removing Duplicates
• Copying Sheets
• Text Box Trick
• Shrink Text
• Transposing Tricks
• Insert Blank Rows
• Data Validation
• Fill up in the sideways
• Switch Column Trick
• Fill Blank Trick
• Formula to Value
• F4 trick
• Format Part of Cell
• Print Small Selection
• Fit to One Page Trick
• Speak Cells

Related Courses

Md. Shahadat Hossain
  • 25 Jan - 27 Feb 2018

100% online job placement and online earning in Digital ...

IT
Price 20,000 Tk + VAT
Chowdhury Shahreaar Ekram
  • 28 Jan - 22 Feb 2018

IT
Mostofa Monower
  • 3 - 17 Feb 2018 (5 Evenings)

This training program builds upon advanced level knowledge ...

IT
Muhammad Arif-ur-Rahman
  • 6 - 18 Feb 2018 (4 sessions)

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

IT

Price: Tk. 6,000+VAT

(15% VAT is applicable in every purchase.)

Contact

9140345, 9117179 , 01811410862, 01926673095, 01811 487981

workshop@bdjobs.com

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.

Resource Person

Samiul Huq

He is the team lead of the Routing Team [A combine team from Marketing, Billing and Core Network] at NovoTel Limited. He is also Supervising the technical team of Revenue Assurance Department- taking care of technical related issues in the whole RA Value Chain including designing, preparing and implementing the Least Cost Routing using spreadsheet technology. It also includes preparing scripts for switches and doing the routing decision, all using MS Excel.
He is also leading a BI program- deploying the Business Intelligence Stack of Microsoft Technology that includes Sql Server 2008 [Analytical Service, Integrating Service and Reporting Service] and then publishing it over SharePoint 2010.
Mr Huq is a part time excel trainer. He has had expertise in Database [Oracle Certified], Visual Basic for Application, Telecom Architecture and Business, Billing and Routing Software, Networking and Virtualizations.

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.