3 episódios

These tutorials teach beginner & intermediate Microsoft Excel users the different Excel tools: Formulas, Pivot Tables, Charts, Data Analysis, Macros, Dashboards, Add-Ins, Shortcuts plus much more.
With these Excel insights, knowledge, tips and tricks, you will be on your way to becoming an advanced Excel user!

# My Excel Online Tutorials John Michaloudis

• Tecnologia

These tutorials teach beginner & intermediate Microsoft Excel users the different Excel tools: Formulas, Pivot Tables, Charts, Data Analysis, Macros, Dashboards, Add-Ins, Shortcuts plus much more.
With these Excel insights, knowledge, tips and tricks, you will be on your way to becoming an advanced Excel user!

• video
Top 10 Excel Pivot Table Tips & Tricks

## Top 10 Excel Pivot Table Tips & Tricks

In this Excel Pivot Table tutorial you will learn the Top 10 Tips when using a Pivot Table for Microsoft Excel 2013, 2010 or 2007  - for Beginners or Advanced users.   I am using Excel 2013 in this tutorial but you can also apply what I teach in Excel versions 2010 and 2007.DOWNLOAD THE FREE EXCEL WORKBOOKS FROM THIS VIDEO: http://1drv.ms/1GgFEL8  SIGN UP TO OUR FREE WEEKLY EXCEL LESSON PLANS TO GET BETTER AT: Formulas, Pivot Tables, Charts, Analysis, Shortcuts plus more here: http://myexcelonline.com/blog/signupTo access more than 200+ Excel Pivot Table tutorials click to view my comprehensive Pivot Table Online Course: http://www.myexcelonline.com/107-2.htmlIn no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Excel Dashboards and get noticed by top management & prospective employers.You can jump to the following sections within this Excel Pivot Table tutorial by clicking on the time links below:1:19  *** TIP #10 - EXCEL TABLES ***  5:30 *** TIP #9 - AUTO REFRESH ***7:37 *** TIP #8 - COUNT TO SUM ***9:59 *** TIP #7 - NUMBER FORMATTING ***11:44 *** TIP #6 - DRILL DOWN IN A PIVOT TABLE ***13:17 *** TIP #5 - SORT FIELD LIST FROM A TO Z ***14:40 *** TIP #4 - FORMAT PIVOT TABLE ERRORS ***16:16 *** TIP #3 - FORMAT PIVOT TABLE EMPTY CELLS***17:41 *** TIP #2 - LOCK COLUMN WIDTHS ***18:37 *** TIP #1 - SHOW REPORT FILTER ON MULTIPLE SHEETS ***23:51 *** BONUS #1: FREE WEEKLY EXCEL TIPS NEWSLETTER ***http://myexcelonline.com/blog/signup24:59 *** BONUS #2: XTREME EXCEL PIVOT TABLE ONLINE COURSE ***http://www.myexcelonline.com/109-2.htmlMyExcelOnline BLOG (200+ FREE Excel tutorials): http://www.myexcelonline.com/blogMyExcelOnline PODCAST: http://www.myexcelonline.com/podcastGet the Excel Insights From The Excel Experts!If you have any questions, please email me at john@myexcelonline.com

• 33 min
• video
Learn Excel Pivot Tables In 1 Hour!

## Learn Excel Pivot Tables In 1 Hour!

• 1h 8 min
• video
Excel Slicer Dashboard In Under 3 Minutes

## Excel Slicer Dashboard In Under 3 Minutes

In this Excel Pivot Table tutorial you will learn how to build an Excel Dashboard using a Pivot Table, Pivot Chart and Slicers in under 3 minutes!Watch more free videos and view my comprehensive Excel Pivot Table course which has 200+ tutorials: http://www.myexcelonline.com/109-2.htmlThis tutorial can also be used in Excel 2013 and Excel 2007 (Slicers not available in Excel 2007 and Excel for Mac)Download Excel Dashboard Workbook: http://1drv.ms/1GgQaRLSIGN UP TO OUR FREE WEEKLY EXCEL LESSON PLANS TO GET BETTER AT: Formulas, Pivot Tables, Charts, Analysis, Shortcuts plus more here: http://myexcelonline.com/blog/signupMyExcelOnline PODCAST: http://www.myexcelonline.com/podcastGet the Excel Insights From The Excel Experts!Email me: john@myexcelonline.com

• 5 min

1.0 de 5
1 avaliação

1 avaliação