Excel Teacher

What do you do in #Excel that saves you a lot of time? (Don't worry we won't tell your boss!)

Think you have a designer's eye for #PowerBI? Download our cheat sheet and build #data that dazzles: msft.social/BfJQGQ

I just learned that you can't name a worksheet as "history" in excel... What other names are reserved @msexcel ?

Breaking news! We're extending the deadline of our #DiggingTheData #visualisation challenge until the end of July! Use our dataset to develop & visualise innovative solutions to two key questions facing the #grantmaking sector & win thousands of pounds! buff.ly/2HRFW0V

Sometimes you need to grab the path of a file without actually opening the file. The #VBA GetOpenFileName method is a convenient way to do just that. wellsr.com/vba/2018/excel…

How to convert Numbers to Words in Indian Currency Format - VBA Macros rviv.ly/lPDFBy

Just when you think you learned everything there is to know about concatenating strings in #VBA, you hear another neat trick. Check out this article full of tips, tricks and common errors people make when using the & operator. wellsr.com/vba/2018/excel…

The Macro Recorder, a very useful tool included in #Excel #VBA, records every task you perform with Excel. All you have to do is record a specific task once. Next, you can execute the task over and over with the click of a button: excel-easy.com/vba/examples/m…

By default, the VLOOKUP function performs a case-insensitive lookup. However, you can use the INDEX, MATCH and the EXACT function in #Excel to perform a case-sensitive lookup: excel-easy.com/examples/case-…

Keeping track of #Excel #VBA Variable values when debugging code via @ExcelTeacherCom bit.ly/2Jork74

Excel VBA Tutorial 107 - Add a submenu to the right click menu quadexcel.com/excel-vba-tuto…

@Syenta1 Thank you @Syenta1 , I've fixed this now and I'm putting it down as a @WordPress bug :-) We're glad you like our site

@ExcelTeacherCom Nice website but... your black area at the top dominates the space available for reading your excellent content. If you look at the image I have provided you will see that there are duplicated links which probably cause this issue. Hope this helps.

@PSpreadsheets Thanks for sharing @PSpreadsheets 🙂

Tidy Up Your Pivot Table by Removing Errors in #Excel via @ExcelTeacherCom bit.ly/2GFRmAz

Want to hide the workings in your #Excel Workbook? Use “;;;” as the custom number format. The value/formula is there, but it is not displayed. Find more quick tips here: exceloffthegrid.com/excel-quick-ti…

Checkout our crazy VLOOKUP solution for returning a value based on 2 input variables and 2 separate lookup columns - wp.me/p75PHn-8v - Its a bit mind blowing :-)

Looking for something to do this weekend? Why not Build your own #Excel Add-in with it's own custom Ribbon. It's not as hard as you might think :-) exceloffthegrid.com/build-your-own…

Wow! Over the weekend the 2,000th person signed up for my latest, free #googlesheets course, Advanced Formulas 30 Day Challenge, since it launched in December. Thank you all! 🙏😍 courses.benlcollins.com/p/advanced30/

Multiple IF Formula in #Excel! The MAGIC Version via @ExcelTeacherCom bit.ly/2Dvgp9d

Experts discuss the top 5 reasons why #Excel & #PowerBI are even better together. Watch now to level up your #data: msft.social/EJyfZG

Have a bunch of checkmarks or other annoying objects (icons) on your spreadsheet that you want to delete (or move) quickly? Home -> Find & Select -> Go To Special... -> Objects #exceltips #thursdaythoughts #msexcel