@ExcelTeacherCom

learn how to do stuff in excel using standard functions or more advanced bits and pieces via VBA and macros

ExcelTeacher.com
Joined November 2014
  • Tweets277
  • Following228
  • Followers1.2K
8Media
Excel Teacher retweeted
Microsoft Excel
@msexcel8 Nov 2018
What do you do in #Excel that saves you a lot of time? (Don't worry we won't tell your boss!)
89
42
8
153
Think you have a designer's eye for #PowerBI? Download our cheat sheet and build #data that dazzles: msft.social/BfJQGQ
26
1
48
Excel Teacher retweeted
Chandoo.org@r1c124 Sep 2018
I just learned that you can't name a worksheet as "history" in excel... What other names are reserved @msexcel ?
4
6
26
Excel Teacher retweeted
360Giving@360Giving11 Jul 2018
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
18
3
20
Excel Teacher retweeted
Ryan Wells
@ryanwellsr11 Jul 2018
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/ge…

Get Filename with VBA GetOpenFilename

Use GetOpenFilename to browse for and import a filename with VBA. GetOpenFilename is part of the Application object in Excel and lets you store file paths without opening them.

wellsr.com
1
4
How to convert Numbers to Words in Indian Currency Format - VBA Macros rviv.ly/lPDFBy
1
3
Excel Teacher retweeted
Ryan Wells
@ryanwellsr29 Jun 2018
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/vb…

VBA Concatenate Strings with Ampersand Operator

In VBA, you concatenate strings into a single string using the &, or ampersand, operator. Simply add an ampersand between your strings to combine them into one string.

wellsr.com
1
3
Excel Teacher retweeted
Excel Easy
@ExcelEasy28 Jun 2018
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/…
1
12
1
54
Excel Teacher retweeted
Excel Easy
@ExcelEasy22 May 2018
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…
1
12
2
55
Keeping track of #Excel #VBA Variable values when debugging code via @ExcelTeacherCom bit.ly/2Jork74
2
3
Excel VBA Tutorial 107 - Add a submenu to the right click menu quadexcel.com/excel-vba-tuto…
1
2
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-qu…
5
1
9
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 :-)
8
1
13
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-yo…
3
1
12
Excel Teacher retweeted
Ben Collins
@benlcollins5 Feb 2018
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/ad…

Advanced Formulas 30-Day Challenge

Master 30 Advanced Google Sheet Formulas in 30 Days

courses.benlcollins.com
3
1
7
Multiple IF Formula in #Excel! The MAGIC Version via @ExcelTeacherCom bit.ly/2Dvgp9d
1
2
Experts discuss the top 5 reasons why #Excel & #PowerBI are even better together. Watch now to level up your #data: msft.social/EJyfZG
Experts discuss the top 5 reasons why #Excel & #PowerBI are even better together. Watch now to level up your #data: https://info.microsoft.com/excel-powerbi-better-together-ondemand.html?wt.mc_id=AID640073_QSG_SCL_215962

ALT Experts discuss the top 5 reasons why #Excel & #PowerBI are even better together. Watch now to level up your #data: https://info.microsoft.com/excel-powerbi-better-together-ondemand.html?wt.mc_id=AID640073_QSG_SCL_215962

37
2
58
Excel Teacher retweeted
mikesmacros@MikesMacros11 Jan 2018
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
2
6
If you've mastered named ranges and you've mastered dynamic named ranges, what’s next? #Excel Answer: Relative named ranges exceloffthegrid.com/creating…

How to create a relative named range in Excel

In this post, we look at a feature called relative named ranges. It gives is the ability to create ranges which change based on where they are used.

exceloffthegrid.com
3
8
I have a customer who has been waiting patiently for the option to select WHO can publish to web in #PowerBI, so today I did my weekly check and NOW YOU CAN! One very excited customer @MSPowerBI Awesome work #PowerBI Team
21
3
38
Load more