Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more.
This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. Expert Bill Jelen simplifies powerful features including Formatting, Calculations, Sort & Filter, DAX Calculated Fields, Troubleshooting, Animation and more! Truly harness the power built into Excel! Just watch: You’ll master high-powered skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2013 fast–from novices to experienced power users.ġ - Use a Pivot Table to Summarize Detailed DataĢ - Your Manager Wants Your Report Changedģ - Add or Remove Fields from an Existing Pivot TableĤ - Summarize Pivot Table Data by Three Fieldsĥ - Why Does the Pivot Table Field List Dialog Keep Disappearing?Ĩ - Why Does This Look Different from Excel 2003? Return to the Classic Pivot Table Layoutĩ - Compare Four Ways to Show Two Values Fields in a Pivot Tableġ1 - Eliminate Blanks in the Outline Format of a Pivot Tableġ2 - Suppress Grand Totals in a Pivot Tableġ3 - Replace Blanks in a Pivot Table with Zerosġ4 - Specify a Number Format for a Pivot Table Fieldġ5 - Format Pivot Tables with the Galleryġ9 - Create a Report That Shows Count, Min, Max, Average, EtcĢ0 - Percent of Parent, Rank, Running Total InĢ2 - Add a Calculated Item for Budget - ActualsĢ3 - Instead of Using Calculated Items Group Text FieldsĢ4 - Present a Pivot Table in High-to-Low Order by RevenueĢ5 - Manually Re-sequence the Order of Data in a Pivot TableĢ6 - Limit a Pivot Report to Show Just the Top 12 CustomersĢ8 - Add Visual Filters to a Pivot Table with Slicersģ0 - See Detail Behind One Number in a Pivot Tableģ1 - Group Daily Dates by Month in a Pivot Tableģ5 - Group Numbers to Create Frequency Chartģ6 - Grouping one pivot table groups all pivot tables new Cacheģ7 - Create a Unique List of Customers with a Pivot Tableģ8 - Use a Pivot Table to Compare Two Listsģ9 - Fixing Customer Name problems Using a Pivot TableĤ1 - Base your pivot table on a Table When New Data Might Be AddedĤ2 - Show Yes/No As the Values in a Pivot TableĤ3 - Create Perfectly Formatted Pivot Tables Using GETPIVOTDATAĤ4 - Create a Worksheet for Every Customer Using Show Report Filter PagesĤ5 - Controlling Multiple Pivot Tables with One Set of SlicersĤ6 - Reduce Pivot Table Workbook Size by 50% Before SendingĤ7 - Create a Pivot Table from Access DataĤ8 - Create a chart from a pivot table with Pivot Chartsĥ0 - Force Missing Months to Show in a Pivot Tableĥ1 - Whatever Happened to Multiple Consolidation Ranges in Pivot Tables?ĥ2 - Cleaning up bad data before creating a pivot tableĥ3 - Pivot Data Where the Source Data Has Dates Stretching Across the Columnsĥ4 - Using the Data Model in Excel 2013 to Join Two Tablesĥ7 - Using Named Sets for Asymmetric ReportsĦ0 - Define Relationships in the PowerPivot Window or Diagram ViewĦ1 - Creating the Pivot Table - Compare ChoicesĦ2 - Changing the Calculation from Sum & Other DifferencesĦ4 - Use DAX Measures to Calculate a RangeĦ5 - Use DAX Measures to un-apply a FilterĦ6 - Using a Calendar Table for Time IntelligenceĦ8 - Disconnected Parameter Tables with FILTER()ħ2 - First Initial Slicer (and turning off cross-slicer filtering)ħ3 - Convert the Pivot Table to Cube Formulasħ6 - Adding a Dashboard Element as a TableĨ3 - Showing Images in Table or Card View
These video lessons will ensure that you can harness the power of Excel faster and more easily than ever before! In 89 quick video lessons, Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel shows how to increase your productivity and optimize Excel's best tools and features.
Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons (Video Training)Įxplore the most popular and some of the lesser known features of Excel – PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel as your guide!