Get 20% discount

Power Excel 2010 Workshop

Introduction

Get the most out of Microsoft Excel 2010 faster and more easily than ever before! In this Power Excel 2010 semimar, maximize your productivity with Microsoft Excel 2010’s best tools and shortcuts. Expert Sami simplifies powerful features including PivotTables, PowerPivot, Sparklines, Goal Seek, Cell Styles, Color Scales, Icon Sets, Data Bars, Web Queries, Backstage View, and more! Get more 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! Just Attend the Course: You’ll master high-powered Microsoft Excel 2010 skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2010 fast–from novices to experienced power users.

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:


Day One:

Part 1 Excel Interface
Ribbon, QAT, Mini Toolbar, Live Preview
Finding Icons
Customizing the Ribbon
Backstage View
Recent Documents
Keyboard Shortcuts
Zoom Slider and Page Layout
Unlocking the Big Grid
Data Entry Tricks
Customize All Future Workbooks
Copy Worksheets
Change All Worksheets
Arranging Windows
Saving Workbook to PDF
Saving Workbook to Excel Web App

Part 2 Text Formulas
Drag the Fill Handle
Create Your Own Series
Joining Text
Rapid Formula Copy
Convert to Proper Case
Joining Dates
Formulas to Values
Breaking Apart Text
Parsing Fixed Width

Part 3 Formulas
AutoSum Tricks
Formula Auditing
Three Ways of Entering Formulas
Relative versus Absolute Formulas
Tables and Table Formulas
Discovering Functions
Goal Seek
IF Formulas
VLOOKUP
Date and Time

Part 4 Sorting & Filtering
Data Preparation
One Click Sorting
Sorting by Color
Sorting by Weekday
Rearranging Columns
Filter by Selection
Other ways to Filter
Remove Duplicates

Part 5 Subtotals
Subtotals
Collapsing Subtotals
Copy Subtotals
Formatting Subtotals
Sorting Subtotals
Changing Sum to Count in 1 column
Data Consolidate

Part 6 Pivot Tables& PowerPivot
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
Using GetPivotData
Getting Data into PowerPivot
Adding Calculations in PowerPivot
Linking Tables in PowerPivot
Creating Pivot Table in PowerPivot
Sorting in PowerPivot

Day Two:
Part 7 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
Sparklines
Labeling Sparklines
Creating SmartArt
Smart Art Formulas

Part 8 Visual Impact
Cell Styles and Document Themes
Conditional Formatting Color Scales, Icon Sets, Data Bars
Advance Conditional Formatting
Icons for Only a Subset
Paired Bar Charts with Negative Data Bars
Picture Tools and WordArt
Picture Background Removal
Insert Screen Clipping
Equation Editor

Part 9 Recording Macros
Displaying the Developer Tab
Recording a Simple Macro
Simplifying the Macro
Recording Using Relative References
Automating the Report

Part 10 Tips & Tricks
Web Queries
Turn Data
Choose from a List
ToolTips for a Cell
Word Processing in Excel
Have a Talk with Excel

Related Courses

Price 18,000 Tk + VAT
Muhammad Rabiul
  • 30 May - 18 Jul 2017

IT
Abu Shams Mahmood Arif
  • Friday, June 2, 2017

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

IT
Mostofa Monower
  • 2 - 3 Jun 2017 (2 Days Long)

This training program builds upon advanced level knowledge ...

IT
Md. Rabiul Islam
  • 2 Jun - 29 Jul 2017

There are many high-level languages. Python is one of ...

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.