Get 20% discount

MS Excel 2013: From Novice to Professional

Introduction



Get the most out of Microsoft Excel faster and easier than ever andbe the Excel Guru of your work place. In this Course, maximize your productivity with Microsoft Excel’sbest tools and shortcuts. The course simplifies powerful features including PivotTables, PowerPivot, Sparklines, 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 Techniques 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
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
Sorting & Filtering

• Data Preparation
• Sorting by Color

Formulas Begins

• AutoSum Tricks
• Relative Versus Absolute Formulas
• Tables and Table Formulas
• Goal Seek

Tips of the Session 2

• Shrink Text
• Transposing Tricks
• Hide Data
• Important Sheet

Part 2 Intermediate Excel

Session 3

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

Charting and SmartArt

• Creating and Formatting a Chart
• Adding or Removing Chart Data
• Charting Differing Orders of Magnitude
• Pie Chart Tricks
• Sparklines
• Creating SmartArt

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

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

Session 6

Recording Macros

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

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

Related Courses

Price 12,000 Tk + VAT
Nusrat Jahan
  • 13 Dec 2017 - 15 Jan 2018 (10 Sessions)

UX design is not just a fascinating field to get into, ...

IT
Price 20,000 Tk + VAT
Chowdhury Shahreaar Ekram
  • 14 Dec 2017 - 9 Jan 2018 (12 Sessions)

IT
Md. Shafiul Alam
  • 14 Dec 2017 - 9 Jan 2018 (15 Sessions)

This course covers the main aspects of SQA.

IT
Muhammad Rabiul
  • 14 - 26 Dec 2017 (6 Sessions)

This course focuses on motion graphics and animation from a ...

IT

Price: Tk. 6,000+VAT

(15% VAT is applicable in every purchase.)

Contact

9140345, 9117179 , 01811410862, 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.