Category Archives for Excel

Over the years Ive learned which are the blogs of the Excel Ninja Masters. This blog reveals to you the secret locations of each Excel Ninja Master. Observe, learn, and spread the knowledge. In the previous blog, Awesome Excel Basic and Intermediate Training at No Cost, I told you about some of the best free []

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)

Awesome Excel Basic and Intermediate Training for Free

What you dont know you dont know can hurt you! Heres where to get awesome Excel basic and intermediate training at no cost. Years back I used to teach at University of California, Berkeley. I always tried to call my students, managers and executives, prior to the course and learn their needs. I had an []

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)

Time remaining until 20% discount ends. 01 Days 02 Hours 19 Minutes 55 Seconds The 20% discount is over, but you can still get a $20 Amazon gift certificate or copy of my book (in the USA). Myndas Excel dashboard and Power BI courses are open again! Mynda only opens her courses a few times []

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)

10 Top Tips for Creating an Excel Budget or Excel Budget Template

ExcelExcel – Formatting and ReportsFinance and BudgetTop Tips

Excel is the worlds most used tool for creating, aggregating, and analyzing budgets. Distributing an Excel budget template will reduce work and make sure everyone is aligned. Starting your budgeting process with an Excel budget template and a list of guidelines will reduce work and keep your managers aligned. Budget tips include how to prevent []

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)

Top 26 Best Excel Conditional Formatting Tips and Tutorial

ExcelExcel – Formatting and ReportsTop Tips

Conditional formatting in Excel applies formatting to cells when the cells content meets specific conditions, such as the content being greater than a number you specify. These top 26 best tips on Excel conditional formatting begin with the basics tips and progress to advanced tips, like using conditional formatting to find errors, using wildcard matches []

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)

Top 16 Best Excel Function and Formula Tips Every Excel User Should Know

ExcelExcel – Functions and FormulasTop Tips

These are the top 16 Excel function and formula tips every Excel user at any level of experience should know. Even experts can learn new tricks or combine old tricks to work faster and more efficiently. As you scan these tips keep a beginners mind. A beginners mind helps you see new opportunities and insights. []

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)

ExcelExcel – Formatting and ReportsTop Tips

These are the top 23 best tips on Excel formatting taken from research on top-ranked Excel websites and judged by 30 years of using Excel (back when it came on about 14 diskettes). Even if you consider yourself an Excel expert, you should keep a beginners mind as you scan this list of 23 Excel []

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)

ExcelExcel – Functions and FormulasTop Tips

Use VLOOKUP to find and retrieve data from an Excel list. This list of the top 21 best VLOOKUP tips will take you from novice to master in retrieving data from Excel lists. You can use VLOOKUP to, Look up prices, names, or regions from a list Use one item to find related items in []

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)

Show or Hide Data and Charts with Dynamic Excel Reports

With a few simple lines of Excel VBA your static Excel reports can become dynamic. A single click shows or hides charts, objects, or rows and columns. Dynamic Excel reports give your users the ability to show or hide specific parts of reports, such as selected sales regions or to expand a table to show []

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)

ExcelExcel – AnalyticsExcel – PivotTables and ListsTop Tips

It is easy to say that Pivot Tables and Power Pivot are the two most powerful features in Excel. I dont mean time saving as with Excel VBA macros, but rather they are powerful because the decisions made from Pivot Table (and Power Pivot) results drive key business decisions. Ive built tons of Pivot Tables []

Click to share on LinkedIn (Opens in new window)

Click to share on Facebook (Opens in new window)

Click to share on Pinterest (Opens in new window)

Click to email this to a friend (Opens in new window)

Click to print (Opens in new window)