# Excel tips

## Collection by Bernadette Recio

507
Pins
•
302
Followers

If you are interested in learning Microsoft Excel, we've put together the 40 best tutorials to make it easy to become an expert.

If you are interested in learning Microsoft Excel, we've put together the 40 best tutorials to make it easy to become an expert.

Weekly Status Report Format Excel

Pivot tables help you quickly analyze, summarize and visualize your data. Here is a compelete intro, step-by-step tutorial on Excel Pivot Tables - creation, customization, filtering, sorting, charts and refresh.

These are the 50 Things you can do with Excel Pivot Table that will make you an Excel Pro within an HOUR! Click here to learn more about Pivot Tables.

In Part 1 of this little jump start series on Pivot Tables for Absolute Beginners I explained what excel pivot tables are the science behind their working through example and explained how pivot table let you analyze and make great reports by presenting them in meaningful way. View ContentsPrepping your data – Very Important!Going Bare-bone or […]

Microsoft Excel Short Cut Keys: Alt+FDF Convert (save as a copy) a work book (included all worksheets) to a PDF file and attached to an email (default email)

Learn over ten of the best techniques to report variance analysis or actual vs target reports in Excel. Free Excel tips, tricks, tutorials, templates, dashboards, formula core book and cheat sheets.

You will find many Microsoft Excel formula examples for key functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, & many more! This Excel tutorial is from #MyExcelOnline | Microsoft Excel Formula Tips + Tutorials | #Excel #MSExcel #MicrosoftExcel #ExcelFormulas #ExcelforBeginners #ExcelTips

SWITCH Formula in Excel - Learn how to evaluate multiple conditions in Excel in just a few steps! I will show you in this free tutorial...

These are the 50 Things you can do with Excel Pivot Table that will make you an Excel Pro within an HOUR! Click here to learn more about Pivot Tables.

An Excel Spin Button is a button made up of an up arrow and a down arrow. Each time you click an arrow, a value will increase or decrease by a certain amount. Take a look at how you can add a spin button to your Excel spreadsheet. #Excel Microsoft Excel tips, hacks. #spreadsheets #spreadsheet

Update:The original file was sent to me by a friend to see if I could work out how it was done. I did, and so I posted the how to. You can find the original here: Great work!!!Original postExcel…

Excel formulas have a powerful tool in conditional formatting. This article covers three ways to boost productivity with MS Excel.

Earlier this month we learnt how to carry out ABC inventory analysis in Excel using conditional formatting technique. It was easy and we had loads of fun as we not only understood how to apply conditional formatting we learnt bunch of other things too like AND() function and how to manage different conditions to get […]

Today lets talk about how to build world-class dashboards. What is a dashboard? Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. A dashboard is usually a one page report that contains critical information for decision support. How to make dashboards? Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner. But creating a dashboard takes a lot of skill…