MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Power Excel 2010 with MrExcel

### Course Summary

Bill Jelen will save you 100 hours per year with the Excel Tips and Tricks on this LiveLessons video tutorial.

• +

### Course Syllabus

• Part 1: Excel® Interface
• Learning Objectives
• 1 - Ribbon, QAT, Mini Toolbar, Live Preview
• 2 - Finding Icons
• 3 - Customizing the Ribbon
• 4 - Backstage View
• 5 - Recent Documents
• 6 - Keyboard Shortcuts
• 7 - Zoom Slider and Page Layout
• 8 - Unlocking the Big Grid
• 9 - Data Entry Tricks
• 10 - Customize All Future Workbooks
• 11 - Copy Worksheets
• 12 - Change All Worksheets
• 13 - Arranging Windows
• 14 - Saving Workbook to PDF
• 15 - Saving Workbook to Excel® Web App
• Part 2: Text Formulas
• Learning Objectives
• 16 - Drag the Fill Handle
• 17 - Create Your Own Series
• 18 - Joining Text
• 19 - Rapid Formula Copy
• 20 - Convert to Proper Case
• 21 - Joining Dates
• 22 - Formulas to Values
• 23 - Breaking Apart Text
• 24 - Parsing Fixed Width
• Part 3: Formulas
• Learning Objectives
• 25 - AutoSum Tricks
• 26 - Formula Auditing
• 27 - Three Ways of Entering Formulas
• 28 - Relative Versus Absolute Formulas
• 29 - Tables and Table Formulas
• 30 - Discovering Functions
• 31 - Goal Seek
• 32 - IF Formulas
• 33 - VLOOKUP
• 34 - Date and Time
• Part 4: Sorting & Filtering
• Learning Objectives
• 35 - Data Preparation
• 36 - One-Click Sorting
• 37 - Sorting by Color
• 38 - Sorting by Weekday
• 39 - Rearranging Columns
• 40 - Filter by Selection
• 41 - Other ways to Filter
• 42 - Remove Duplicates
• Part 5: Subtotals
• Learning Objectives
• 43 - Subtotals
• 44 - Collapsing Subtotals
• 45 - Copy Subtotals
• 46 - Formatting Subtotals
• 47 - Sorting Subtotals
• 48 - Changing Sum to Count in 1 column
• 49 - Data Consolidate
• 50 - Easy-XL
• Part 6: Pivot Tables
• Learning Objectives
• 51 - Creating a Pivot Table
• 52 - Changing a Pivot Table
• 53 - Pivot Gotchas
• 54 - Pivot Formatting
• 55 - Drill Down
• 56 - Pivot Calculations
• 57 - Summarizing Dates
• 58 - Pivot Sorting
• 59 - Filtering Row Fields
• 60 - Top 10 Report
• 61 - Filtering a Pivot Table with Slicers
• 62 - Slicers on Two Pivot Tables
• 63 - 50 Reports in 5 Seconds
• 64 - Using GetPivotData
• Part 7: PowerPivot
• Learning Objectives
• 65 - Getting Data into PowerPivot
• 66 - Adding Calculations in PowerPivot
• 67 - Linking Tables in PowerPivot
• 68 - Creating Pivot Table in PowerPivot
• 69 - Sorting in PowerPivot
• Part 8: Charting and SmartArt
• Learning Objectives
• 70 - Creating and Formatting a Chart
• 71 - Adding or Removing Chart Data
• 72 - Saving Favorite Chart Settings
• 73 - Charting Differing Orders of Magnitude
• 74 - Pie Chart Tricks
• 75 - Sparklines
• 76 - Labeling Sparklines
• 77 - Creating SmartArt
• 78 - Smart Art Formulas
• Part 9: Visual Impact
• Learning Objectives
• 79 - Cell Styles and Document Themes
• 80 - Color Scales, Icon Sets, Data Bars
• 81 - Icons for Only a Subset
• 82 - Paired Bar Charts with Negative Data Bars
• 83 - Picture Tools and WordArt
• 84 - Picture Background Removal
• 85 - Insert Screen Clipping
• 86 - Equation Editor
• Part 10: Tips & Tricks
• Learning Objectives
• 87 - Web Queries
• 88 - Turn Data
• 89 - Choose from a List
• 90 - ToolTips for a Cell
• 91 - Word Processing in Excel®
• 92 - Have a Talk with Excel®
• Code Examples
• Code Examples

Course Fee:
USD 99

Self-Study

### Course Status:

Active

1 - 4 hours / week

Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software