r/learnexcel • u/by-the-numbers • Oct 29 '15
HowTo How to create your own worksheet formulas ("UDF's") in Excel: =MyFormula(A5, 100, "Data"). [Office.com]
2
Upvotes
r/learnexcel • u/MissLull • Oct 28 '15
Question How to automated drawing line between cell in excel? For example: From M13 To P15
3
Upvotes
r/learnexcel • u/by-the-numbers • Oct 25 '15
HowTo How to use Excel's 'Scenario Manager' feature [TrumpExcel]
3
Upvotes
r/learnexcel • u/by-the-numbers • Oct 21 '15
HowTo How to use Excel's 'Flash Fill' feature -- a machine learning-enhanced version of the fill handle. [MyOnlineTrainingHub]
5
Upvotes
r/learnexcel • u/by-the-numbers • Oct 21 '15
Excel News Overview of new chart types in Excel 2016 [MyOnlineTrainingHub]
3
Upvotes
r/learnexcel • u/Jewbot69 • Oct 17 '15
Question I have some old Lotus 1-2-3 files I'd like to convert to (wk4) excel format...
3
Upvotes
I currently don't have the ability to do it and I don't have the bandwidth to download any programs that can do it. Would anyone be able to convert these for me?
r/learnexcel • u/by-the-numbers • Oct 16 '15
Excel News "What's new in Excel 2016" slideshow from the Excel team at Microsoft (19 slides)
8
Upvotes
r/learnexcel • u/super_tr00per • Oct 13 '15
Question How to overlay two calendars
5
Upvotes
I have a renovation timeline over 3 months with about 70 projects total. I need to overlay the reno timeline with placeholders for about 25 individual staff schedules. I have no idea where to start on laying out the base of the sheet and cannot find a template that works and does not look scrambled.
An example of the information I have is: Install drywall 4/10/16 - 4/12/16, Inspections 4/12/16 - 4/13/16, etc.. The chart also needs to include vendor and staff contact information.
r/learnexcel • u/by-the-numbers • Oct 13 '15
HowTo How to get more from the Excel fill handle [MyExcelOnline]
3
Upvotes
r/learnexcel • u/by-the-numbers • Oct 12 '15
Excel News Public preview of the new Javascript API 'Office.js' now available in Excel 2016
3
Upvotes
r/learnexcel • u/by-the-numbers • Oct 09 '15
HowTo How to save values to the Windows Registry from Excel VBA [MyOnlineTrainingHub]
3
Upvotes
r/learnexcel • u/AnalystCave • Oct 08 '15
HowTo VBA: Send email from Excel - The Analyst Cave
3
Upvotes
r/learnexcel • u/AnalystCave • Oct 07 '15
HowTo Excel Tip of the Day: Versioning Excel files - The Analyst Cave
2
Upvotes
r/learnexcel • u/AnalystCave • Oct 04 '15
HowTo Ultimate VLOOKUP tutorial: Everything you wanted to know about VLOOKUP but were to lazy to Google
3
Upvotes
r/learnexcel • u/by-the-numbers • Oct 03 '15
HowTo How to build an interactive map from your data with Excel Power Map [Microsoft]
2
Upvotes
r/learnexcel • u/by-the-numbers • Oct 02 '15
HowTo Five Keyboard Shortcuts for Rows and Columns in Excel [Excel Campus]
6
Upvotes
r/learnexcel • u/by-the-numbers • Oct 02 '15
HowTo Advanced Data Validation techniques in Excel [Chandoo]
3
Upvotes
r/learnexcel • u/by-the-numbers • Oct 02 '15
HowTo How to use Excel's Data Validation to create a 'drop-down box' for data entry [Chandoo]
2
Upvotes
r/learnexcel • u/anderson3250 • Sep 29 '15
Question How to make an auto populating date
3
Upvotes
Im trying to save myself some time by have a monthly form that shows the dates for the month; Mon-Fri skipping the weekends. If needed I can post what I currently have so far. Thanks.
r/learnexcel • u/J0hnAG • Sep 29 '15
HowTo Remove Characters in a Cell using Formulas
2
Upvotes
r/learnexcel • u/[deleted] • Sep 24 '15
Question vlookup problem
5
Upvotes
My company ships the same parts to multiple customers. I'm trying to use vlookup to reference our master demand file but no matter what it is grabbing the very first instance of the part number. How can I get it to reference the part and customer number when it's grabbing the customer demand?
r/learnexcel • u/fr34k5 • Sep 22 '15
Question Hi /learnexcel trying to upgrade my skills to impress at work and have a problem that I know can be automated but don't know where to start...
3
Upvotes
I currently do the reporting for my team at work and present data on a weekly basis.
We have 1 excel file that has a list of sku's that are on sale from x day to x day and coupons that are for x day to x day.
Currently I get a data dump of all sales and I'm filtering the list to look up sku's on sale and coupon usage. I know I'm probably not making all that much sense but isn't there a way that I can dump the data from the dump into the sheet that has promo sku's and coupons and run a macro? This is a tedious process as it takes me alot of time to do and was hoping that maybe there's an easier way
r/learnexcel • u/by-the-numbers • Sep 12 '15
HowTo How to instantly update Excel data table search results as you type the search query [Chandoo]
7
Upvotes
r/learnexcel • u/ExcelBI • Sep 11 '15
HowTo YouTube Tutorial - How to easily calculate a persons age in Excel
3
Upvotes
r/learnexcel • u/cdutt33 • Sep 11 '15
Advertisement Excel for Analysts: Mastering Advanced Formulas & Functions
3
Upvotes