My Excel Online Tutorials

These tutorials will teach beginner & intermediate Microsoft Excel users the different Excel tools: Formulas, Pivot Tables, Charts, Data Analysis, Macros, Dashboards, Add-Ins, Shortcuts plus more.

Rank #1: 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 CELLS17: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

Rank #2: Learn Excel Pivot Tables In 1 Hour! .
In this Excel Pivot Table 2010 tutorial you will learn the basics of building a Pivot Table to more advanced Pivot Table commands like creating a Dashboard with Slicers and Pivot Charts.DOWNLOAD EXCEL WORKBOOK: http://1drv.ms/1ElBsULWatch more free videos and view my comprehensive EXCEL PIVOT TABLE COURSE which has 200+ tutorials: http://www.myexcelonline.com/109-2.htmlAfter this free tutorial you will be a able to use Excel Pivot Tables confidently at your work, make insightful business analysis and create interactive Management Reports & Dashboards.  This  will make you more important and extend the reach of your work to a lot more people than before, which means a greater opportunity for a promotion.This Excel tutorial can also be used in Excel 2013 and Excel 2007 (Slicers not available in Excel 2007 and Excel for Mac)Jump to the Pivot Table tutorial topic you want to view by clicking on the numbers below:  2:40  CREATE A PIVOT TABLE;14:20  FORMAT A PIVOT TABLE;18:00  SUMMARIZE WITH VALUES;20:30  SHOW VALUES AS YTD & DIFFERENCE FROM   PREVIOUS MONTH;28:10  GROUPING;35:15  SLICERS & PIVOT CHARTS & DASHBOARDS;46:00  PIVOT TABLE TIPS;55:40  XTREME PIVOT TABLE COURSE STRUCTUREDownload Course Syllabus: http://myexcelonline.com/descargas/xtreme-pivot-table-course-syllabus.pdfSIGN 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 if you have any Excel queries: john@myexcelonline.com

Chandoo.org Podcast - Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel

Become Awesome in Excel by Chandoo.org – A podcast aimed to teach you data analysis, charting, visualization, dashboard reporting, big data analysis, Power Pivot, Self-service BI, Excel based spreadsheet-modeling, automation thru VBA, macros, project management, business analysis, interactive & dyanmic graphs, pivot tables, Excel formulas, functions, calculations, summarizing data, Excel formatting, shortcuts, productivity, application development, beginner to advanced Excel skills, excel tips, techniques, tutorials and templates. We do this by providing you with spreadsheet design strategies & tactics, Excel tips, keyboard shortcuts, productivity hacks, case studies, personal experiences, interviews with Excel authors & Microsoft MVPs, book & product reviews related to Excel and answering your Excel questions & doubts.

Rank #1: CP050: Fifty Excel Tips to make you awesome.
This is going to be epic!!! In the 50th session of Chandoo.org podcast, we have 50 Excel tips to make you awesome. What is in this session? In this podcast, Thank you message Fifty tips in 5 buckets Shortcuts & Productivity Formulas Managing Data Charts Using Excel better Listen to this session Click here to download the MP3 file. Resources for this podcast Keyboard shortcuts: Top 10 keyboard shortcuts for you – podcast 012 Comprehensive list of Excel keyboard shortcuts 25 Excel tricks to boost your productivity Formulas: Top 10 formulas for analysts & managers Beyond SUM & IF – 15 formulas for you Using wild cards in formulas (* &) Formulas discussed in the podcast: SUMIFS SUBTOTAL CHOOSE AND OR – Logical formulas – podcast 028 IFERROR Managing Data: Excel Tables – an introduction Using Text to Columns to convert dates Flash fill – an introduction Remove Duplicates – a quick tutorial Go to special – what is so special about it? Introduction to Data model & Relationships in Excel 2013 Power Query – an intro – podcast 040 Charting: Data bars in Conditional formatting – a case study Sparklines can go right to left Hide ‘0’ in axis Dynamic titles & labels in charts Using Excel: How to create custom ribbons in Excel – tutorial Work with charts faster using selection pane How to make gorgeous printable workbooks – podcast 025 Hide away unused rows & columns & 9 more tips to create awesome workbooks Transcript of this session: Download this podcast transcript [PDF] What is your favorite tip? Now it’s your turn. Which one of the fifty is your favorite? Or do you have something new altogether? Please share in the comments. Spread the love – Review my podcast If you enjoy Chandoo.org podcast, please take a minute and write a review on iTunes. Also, do share this podcast on a colleague / friend. Make them awesome. Send them here: http://chandoo.org/podcast The post CP050: Fifty Excel Tips to make you awesome appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

Rank #2: CP029: Impress your boss with Excel charts – 6 step road map for you.
In the 29th session of Chandoo.org podcast, let’s impress the boss with Excel charts. What is in this session? Many Excel charts live a short life. They spawn in an ambitious analyst’s spreadsheet. They go to boss with literally flying colors. The boss frowns, they disappear in to recycle bin. Don’t curse your Excel charts with short life span. Here is a 6 step road map to help you create awesome Excel charts, everytime. That is our topic for this podcast session. In this podcast, you will learn Quick announcements about 50 ways & Einstein 6 step road map for charting success ONE: Dig your data TWO: Validate insights THREE: Pick charts that go well FOUR: Add title & message FIVE: Remove clutter SIX: Prompt action A real life example with road map in action Resources for creating awesome charts Listen to this session Click here to download the MP3 file. Links & Resources mentioned in this podcast 50 ways to analyze data course: Join the waiting list Course launching on 11th of Feb Book recommendation Albert Einstein – his life & universe by Walter Isaacson Chart creation process & tips: Selecting right chart for your data Tips for creating awesome column charts Best charts to depict % progress Never use simple numbers in your dashboards More charting principles & chart examples Additional resources for charting: Dashboard contest entries & winners – 2014, 2012, 2011, 2010 NY Times visualization lab Charting tutorials & best practices from Jon Peltier Advanced Excel chart examples from Roberto et al Transcript of this session: Download this podcast transcript [PDF]. How do you impress your boss with charts? My personal favorites are interactive charts & dashboard displays. What about you? How do you impress your boss with Excel charts? What techniques & process you follow? Please share your thoughts and tips in comments. Subscribe to our podcast and get latest episodes automatically Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you. Other options to subscribe The post CP029: Impress your boss with Excel charts – 6 step road map for you appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

Learn Microsoft Excel with MyExcelOnline

This podcast will teach beginner & intermediate Microsoft Excel users the different Excel tools like: Formulas, Pivot Tables, Charting, Analysis, Macros, VBA, Dashboards, Power BI, Add-Ins, Shortcuts plus much more.I interview Excel MVPs and experts around the world to share their Excel insights, knowledge, tips and tricks that will get you on the way to becoming an advanced Excel user, just like them.

Rank #1: 016: Excel Power Pivot With Rob Collie.
Rob Collie is an Excel MVP since 2010 who is a world expert and author in Excel Power Pivot and Power BI and resides in Indianapolis, USA! One of the founding engineers behind Power Pivot during his 14 year stint at Microsoft, Rob Collie now runs a consulting and analytics company over at www.PowerPivotPro.com In this episode, Rob talks about his adventure into Excel, the various features within Power Pivot (Measures, DAX, etc) and his online and public courses. 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/016-excel-power-pivot-with-rob-collie-from-powerpivotpro/

Rank #2: 015: Excel Power BI With Mynda Treacy.
Mynda Treacy is an Excel MVP since 2014 who resides in sunny Queensland, Australia and is an expert in Power BI and Excel Dashboards. In 2009 she started an online training website called MyOnlineTrainingHub.com, where they provide free and paid online training tutorials and courses on Microsoft Excel, Outlook and Word. Mynda has trained over 5,000 people from all over the world and today she focuses on Excel online courses. 👉 Join Our Academy Online Excel Course 👉 Show Notes: https://www.myexcelonline.com/podcast/015-excel-power-bi-mynda-treacy-from-myonlinetraininghub/ 

Excel Tutorials

Excel Tutorials

Rank #1: Common issues.
This video shows some common formatting errors and explains the solutions.

Rank #2: Sorting.
This video explains how to sort content in Excel.

Coaching for Leaders

Leaders aren’t born, they’re made. This Monday show helps you discover leadership wisdom through insightful conversations. Independently produced weekly since 2011, Dr. Dave Stachowiak brings perspective from a thriving, global leadership academy, plus more than 15 years of leadership at Dale Carnegie. Bestselling authors, expert researchers, deep conversation, and regular dialogue with listeners have attracted 10 million downloads and the #1 search result for coaching on Apple Podcasts. Activate your FREE membership to search the entire episode library by topic at CoachingforLeaders.com

Rank #1: 306: Five Steps to Hold People Accountable, with Jonathan Raymond.
Jonathan Raymond: Good AuthorityJonathan Raymond is the founder of Refound, a firm that believes we should all be aiming for more Yoda and less Superman. He is the author of the book, Good Authority: How to Become the Leader Your Team Is Waiting For*.Many managers and leaders recognize when more accountability is needed, but few use a process that invites high performance and embraces the whole person. In his work at Refound, Jonathan invites leaders to imagine a world where personal and professional growth are one thing, and where improving your relationships and owning your strengths translate directly into the rest of your life.In this conversation, Jonathan teaches us a common language around accountability that works for almost everyone. Plus, he teaches us the five key steps of the accountability dial.Key Points Micromanagement is focused on tasks, but accountability is focused on relationships. Accountability doesn’t work unless there’s a context of personal caring. Employees want growth, and growth comes from productive discomfort. If you if you orient your day towards acknowledgment only on the positive side, you’re missing the better part of it.The 5 Steps of the Accountability Dial: The Mention The Invitation The Conversation The Boundary The LimitResources Mentioned Good Authority: How to Become the Leader Your Team Is Waiting For* by Jonathan Raymond Download the Accountability Dial Refound (Jonathan's Firm)Book NotesDownload my highlights from Good Authority in PDF format (free membership required).Related Episodes How to Create Team Guidelines, with Susan Gerke (episode 192) New Management Practices of Leading Organizations, with David Burkus (episode 253) Moving Beyond Command and Control, with Brian Robertson (episode 258)Discover MoreActivate your free membership for full access to the entire library of interviews since 2011, searchable by topic.

Rank #2: 282: How to Motivate People, with Dan Ariely.
Dan Ariely: PayoffDan Ariely is the James B. Duke Professor of Psychology and Behavioral Economics at Duke University and a founding member of the Center for Advanced Hindsight. His books include Irrationally Yours, Predictably Irrational, The Upside of Irrationality, The (Honest) Truth About Dishonesty, and his most recent book, Payoff: The Hidden Logic That Shapes Our Motivations.Key Points The things that motivate us are about accomplishment and achievement, not day-to-day happiness. Most people realize that they themselves are not truly motivated by money, but they still assume other people are completely motivated by it. Figure out a way to pay people that adds to the development of a long-term relationship, not a short-term transactional one. It is important to find a way to connect people’s jobs to the final outcome of their work, because many people don’t feel connected to their organization’s main purpose.Resources Mentioned Payoff: The Hidden Logic That Shapes Our Motivations* by Dan Ariely Predictably Irrational* by Dan Ariely Drive* by Daniel Pink www.danariely.comBook NotesDownload my highlights from Payoff in PDF format (free membership required).Activate Your Free Coaching for Leaders MembershipGet immediate access to my free, 10-day audio course, 10 Ways to Empower the People You Lead. Give me 10 minutes a day for 10 days to get the most immediate, practical actions to become a better leader. Join at CoachingforLeaders.com.Related Episodes CFL84: Daniel Pink on To Sell is Human CFL181: Create the Best Place to Work CFL251: What to Do When Somebody Quits CFL253: New Management Practices of Leading Organizations CFL276: Employee Engagement With Management 3.0Next EpisodeBonni and I return for the monthly question and answer show. Submit your question for consideration next week or for the first question and answer show the first Monday of every month at http://coachingforleaders.com/feedbackThank YouThank you to Greg Hall and Chase Batt here in the States and Lynn Wang in Hong Kong for the kind reviews on iTunes. To leave a rating or review, visit http://coachingforleaders.com/itunes