BEGINNERS TO ADVANCED EXCEL TRAINING IN PAKISTAN

Type Computer 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. 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 Venue:- Thinkers Overseas Education 1/6 -j (first floor) block -6 PECHS Near Dehli sweets, Advance Hair Center, Nursery, Main Shah rah-e-Faisal Contact: Sir Abdul Rehman Saturday and Sunday Open