About

To learn more about Excel, go to the organized listing of all my Excel tutorial posts or review the
 

My name is Matthew Kuo and I am a UCLA Anderson MBA graduate.  I originally built this site to display the Xcelsius dashboards I designed for a school project, but decided to continue using this space as my own digitial repository.  I am passionate about visual design and analysis, and I hope you find my work useful.

The foundation of this site will be around Microsoft Excel, a tool I’ve used for years both in the consulting world and in the healthcare industry.  However, I also plan to blog about other subjects related to my MBA studies.  Below is a preliminary list of intended categories:

If you have any questions, please feel free to email me at matthew at rusinfomos.ru dot com.


{ 13 comments… read them below or add one }

Monika z Polski March 1, 2013 at 8:47 am

Hello,
at the beginning: I’m sorry for my poor English 🙁
I am delighted with your Excel sheet MBA Homework Tracker
Can you share a password to protect the sheet – the sheet I would like to slightly modify (enter Polish fild and change width the cell )

I’ll be grateful for your help.
I greet the Poland
Monika

Reply

Matthew March 6, 2013 at 6:09 pm

Hi Monika,

Thanks for downloading. Apologies, but I built the tool a long time ago and have since lost the password. I think you should be able to copy most of the features over to a new file though.

Reply

Mirza July 30, 2013 at 10:08 am

Your website is a great tool.

Keep up the good work

Reply

Blake October 16, 2013 at 2:07 pm

I downloaded the tracker. I have followed the instructions, but for some reason i can’t get anything to populate in the Calendar view. Can you help me troubleshoot this issue?

Reply

Ishan Shah December 12, 2013 at 3:46 am

Excellent Job Matthew…… Much Appreciate your work…
This litterally amzed me..!!!

Reply

m z January 26, 2014 at 10:52 am

I think this is the best assignment calendar I have seen. I just wished I could also show a monthly calendar

Reply

Rej May 15, 2014 at 3:47 pm

This is a great tool. I want to change the header ‘Mba exce….’ and remove the reference comments given underneath that. So I tried to copy the content to new sheet as its protected.

But the last calender sheet gets collapsed. In Calender sheet there is a reference to ‘Consolidated Items’ which I am not able to find or relate to anywhere in your excel.
Is it possible for you to suggest me how to resolve this?

Reply

Gary April 10, 2015 at 2:03 pm

Hi Mathew,
Great job, mate, I actually turned your Homework tracker into financial and budgeting tool
The only feature I’d like to change is the weekly view to a Monthly
Any Suggestions would be greatly appreciated.
Thanks

Reply

Gisele June 16, 2015 at 5:15 pm

I am SO happy I discovered this site – there is so much useful information. It is concise, comprehensive, but understandable by beginner and intermediate Excel users. Thank you!

Reply

reza June 26, 2015 at 12:55 pm

hello dear sir
i use a huge excel spreadsheet for Document Controlling, and it has a lots of formulas in about 8000 rows and 400 columns, when i want to filter a document number in a column, i have to wait some minutes to excel processed this process and this problem makes me crazy, how can i fix this?, or if you know a way to speeding up filtering process so please help me, although yesterday when i did my works the excel shows an error and i didn’t care and i closed the error, after that the speed of filtering in that file was very fast, so please help me …

Reply

Nitin July 25, 2016 at 3:23 am

It’s a fantastic Excel to track the activities and i am very happy to have the same.

Sir- just want to know that do you have Monthly planner same as Weekly as mentioned. If yes, kindly share the same. I can also ready to Buy if chargeable. Also need to know password if possible. Awaiting your great response.

Reply

Barbara August 7, 2016 at 9:01 pm

Hi Matthew, I love your blog! Super useful. I needed a refresher in the INDEX MATCH formula and your explanation was really good. Thanks for having this blog. You will be added to my favourites 🙂

Reply

February 1, 2017 at 4:41 am

Hello team,

We are currently buying video inventory from rusinfomos.ru through a third party provider. We are seeing good performance with you and I’m writing to understand if you’d be open to a direct relationship.

As I said we’re seeing a really high % of coverage and we don’t have our most premium demand connected, so I really think that we have potential.

Please, let me know your thoughts, I’ll be looking forward to your message.

Thanks,
Natalia

Reply

Leave a Comment

{ 1 trackback }


Related pages


how do you remove duplicates in excelmultiple if statement in excelucla anderson alumnihow to build histogram in excelformula of excel sheet with exampleformula excel sheetvlookup formula explanationucla anderson campusmicrosoft office 2010 download free trial 60 daysexcel templates calendarvlookup next valueexcel countif uniquevlookup tutorial in excelmaking line graph in excelname picker generatorcreate macros excelspreadsheet random number generatorexcel vlookupstacked column charterror bar excel 2010keyboard shortcut for filter in excelvlookup table arrayvlookup lock table arraypay stub format in excelhow to calculate w4insert a symbol in excelcreate a macro excelmyulaexcel 2007 if statementstacked barssimple excel commandsexcel lookup exact matchexcel detect duplicatesvlookup with multiple conditionsexcel countif in rangestacked and clustered chart excelexamples of checklists in excelisnasindex function in excel 2007hlookup formula in excel 2010deduplication exceldownload microsoft hupv look excelexcel cool tricksusing vlookup and if function togethertask tracker excelhow to use iferror with vlookupvlookup in another sheethow to sort randomly in excellookup tables excelcompound if statement excelmultiple if excel formulaindex match vlookuplearning vlookupms excel trial versioncell reference excel definitioncompare two columns in excel 2013key excel formulasthe vlookup functionexcel formulas syntaxa blank cell has the numeric value ofv look up formulaexcel count duplicatesaverage vlookupms excel lookup functionfind duplicates in two columns in excelucla grading policyexcel vba hlookupvba randlearning vlookup in excel 2007how to show total on stacked bar chartvlookup row numberhow to create stacked bar chart in excel 2010
\n