It is almost weekend. Today we (Jo and I) are going to watch a cricket match being played in Vizag. We are pretty excited as this is the first time we are watching a match in stadium.
So, let keep this light and fun. I want to know What is one area of Excel you want to learn more?
I will go first. I want to learn more about Data Tables & Simulation.
What about you? Go ahead and tell us using comments.
Note: Here are a few choices if do not know what else is out there.
- Formulas
- Array Formulas
- Formatting
- Conditional Formatting
- Charting
- Advanced Charting
- Pivot Tables & Charts
- Tables
- Data Tables
- Validation
- Filters & Sorting
- VBA (Macros)
- Linking to Databases etc.
- Solver
- Statistical Analysis (regression, time series etc.)
- Scenarios, What if analysis
- Dashboards
So go ahead and tell us.
191 Responses
… I would vote for pivot tables and reports. Enjoy to see more about.
I would like to learn about VBA (macros).
Hi Chandoo;
I wish to learn more about:
– Formulas (as they relate to real-world problems);
– Dashboards / Balanced Scorecard
Cheers,
I would like to see a complete accounting package in Excel. Individual excel sheet for raw data entry and generating reports like ledger, sundry creditors, sundry debtors in a consolidated sheet.
There are more areas for me thet have my interest.
Advanced Charting
Dashboards
VBA (Macros)
Array Formulas
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
I still struggle with VLOOKUP. I have yet to find a tutorial that is simple enough to help me. I am able to create complex queries in Access and do simple SQL statements, but VLOOKUP remains a mystery.
Definitely, Pivot Tables. I know how to do some basics with them, but anytime I research anything more advanced, it seems too advanced, and I end up not having a clue what is being discussed.
I would like to lern more about VBA (Macros) and Dashboards, and how to combine them.
Elegant, simple solutions to complex though common situation. For instance using less common excel function to replace large nested “if” formulas.
Advanced charting and dashboards definitely!!
BTW, thanks for the awesome tips and tricks and keep up the excellent work buddy!
More solver and statistical (regression and time series) would be amazing. But I will read anything you post, because I enjoy it a LOT! Thank you.
PivotTables, specifically how to setup/use calculated fields. (I never get mine to work)
My vote is for using Solver for Data Mining purposes.
VBA
If I could cast 2 votes it would be (1) Pivot Tables and (2) Dashboards. Pivot Tables seem to be such a powerful tool, but like other posters, I have such a hard time getting them setup and configured to work how I want them to. Love the site Chandoo!
Excel models are often passed around and used by many people. I hear this a lot: “I just received this model, can you help me figure out how it works?” Two major neglected areas I have seen are: Spreadsheet design principles and then proper documentation.
Pivot tables (or work around), particularly around doing things not built into it like unique counts.
– Solver
– Statistical Analysis (regression, time series etc.)
dashboards
Pivot tables! maybe a 5 day series…basics working up to an advanced homework or something…
Array formulas, pivot tables, and data tables. You didn’t say we had to choose just one:). I would be interested in statistical analyses and scenarios, but I don’t know enough about them to know how I might use them.
Array formulas, different lookup types (I still have some scenarios that I can’t figure out using index, match, etc.), macros, scorecards.
Linking to Databases
I would like to learn more on…
VBA (Macro)
Solver
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Dashboards
Pivot Tables & Charts
Definitely Pivot Tables – I use them all the time and I know there are lots of tricks I don’t know.
Array formulas
VBA
VBA for sure!! Arrays would be my second choice!
i’d like to learn more about charting!
Hi Chandoo,
I would like to learn more on
VBA (Macros)
Linking to Databases etc.
Solver
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Dashboards
VBA
Statistical Analysis
Array Formulas
Dashboards!
vba macros and dynamic dashboards. Also statistical capabilities of excel
I would like to see more design tips and tricks. I feel like I struggle putting important info into dashboards while keeping it clear and concsise.
I would like to learn more about:
Formulas
VBA and Macros
Dashboards
Charts/Graphs
Specifically Gantt Charting
I would love it to see some Stock Balance Reporting, Trending for production planning, EPR/MPR in Excel, Supplier Report cards…..
Dashboards
Advanced charting
I would like to learn about VBA (macros) and Pivot Tables!
Linkage to databases and passing data back and forth. Currently I’m exploring having pivots in a dashboard – I want the user to select a value ( like a filter/pull down etc) then use that to call to a sql server, run a query with the selection as a parameter, and have it return a dataset to the dashboard – eg data is weekly – user selects the 3rd week – data is refreshed for 3rd week
Scenarios, What if analysis
VBA Linking to SQL and Access Databases
Statistical Analysis (regression, time series etc.)
For me, charting, VBA, and the intersections betweent the two.
Pivot tables (which I know nothing about) and Dashboards (only slightly more than nothing).
That being said, my knowledge is so basic, pretty much anything is of interest to me.
Pivot Tables/Charts – but in regard to how to use VBA to manipulate them and create more flexible reports more efficiently
Statistical and time series analysis and what if (solver, monte carlo simulation, etc.)
Love the site. Thank you…
pivot tables
VBA (Macros)
VBA.
The whole language is so redundant and confusing! Theres “ActiveCell.CurrentRegion” but also “ActiveSheet.UsedRange” ? Some folks use “.Select” all the time, but others say to only somehow use ranges?
VBA!!!!
Here are mine…
Data Tables & Simulation.
Formulas
Array Formulas
Formatting
Conditional Formatting
Pivot Tables
Tables
Data Tables
Validation
Filters & Sorting
VBA (Macros)
Linking to Databases etc.
Solver
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Dashboards
A lot of examples of Formulas and Dashoboards
Array Formulas
Data Tables
Scenarios, What if analysis
I would like to learn more about advanced charting.
Dashboards in general and Databases
Hi Chandoo, thanks for your great help.
I’d like to know more about linking and working with external databases.
Hi Chandoo,
my interest would be Dashboards and free templetes!
Enjoy the game, Live!!
How different functions react in array formulas.
When / why do some functions output arrays versus single functions and how that can be changed.
My vote is for array formulas: not only what they are, but when to use them and what alternatives to array formulas exist.
Thanks!
Hi Chandoo,
;o)) What about audio tips and tricks…
i.e. sounds, music, speech
in warning, comments or help and debugging
Dashboards & Advanced Charting
VBA – especially dealing with outputs to Word Documents and Templates for better report presentation.
I’d like to learn all, but mostly how to send data to access
I would like to see a top ten ranking of the best,useful and interesting solution giving by n formula.
How to create a Income tax estimation taking the income slabs given by government of india.
Formulas and Scenarios, What if analysis….
Array forumulas, especially in conjunction with named ranges
Statistical analysis
Forecasting methods utilizing Excel
Pivot Tables! They hate me!
Hellow Chandoo:
My options in descending ranking order are:
. ? Dashboards
. ?Scenarios, What if analysis
. ?Pivot Tables
Regards
I saw a plenty how-to videos & tutorials about functions, VBA, dasboarding, array functions, multifunctions around a net, but still cannot find good resource for linking Excel with databases, like Access or SAP R/3.
Integrating excel into HTML format, and keeping the functionality.
I would like to see more on the VBA adn dashboard functions.
Hi Chandoo,
I would like to know more about solver and the analysis toolpack.
Thanks for the good work!
Antoine
VBA
Array Formulas
Advanced Charting
VBA ( Still dont understand this at all :-/ )
I would like to learn more about Pivot Tables, Conditional Formatting, Advanced Charting. I create a lot of charts with my data and look for different and interesting ways to disply the data. Also, Scenarios – “what if”, would be interesting.
Thanks so much and enjoy the game!!
Chandoo, a big thanks for sharing all your knowledge in such a straightforward, easy to grasp manner. I would need like to see more about pivot tables and charts, array formulas and dashboards. Keep up the great work.
Hi Chandoo,
I would like to learn more about:
* VBA (Macros)
* Validation
* Solver
* Statistical Analysis (regression, time series etc.)
* Scenarios, What if analysis
* Dashboards
Regards,
Gabriela
Walkenbach recently posted a link on his blog to an article about excel skills that will keep you employable…
“Using Excel to ensure employability means familiarising yourself with pivot tables, VBA, importing and exporting data from SQL servers and more complex elements like DDE (dynamic data exchange strings).”
Arrays and VBA
My vote is for advanced charting techniques for dashboards.
VBA! definitely VBA!
Formulas are good, but some things just can’t be done by complex arrays or nested conditions… (wow! first time I participated!)
Pivot tables! Sometimes they seem to work for me, other times…
Formulas
Array Formulas
Formatting
Conditional Formatting
Charting
Advanced Charting
Pivot Tables & Charts
Tables
Data Tables
Validation
Filters & Sorting
VBA (Macros)
Linking to Databases etc.
Solver
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Dashboard
For me,
Scenarios, What if analysis
Pivot Tables
Advanced Charting
Dashboards
Array Formulas
Data Tables
Scenarios, What if analysis
And many many exemples
1. Databases
2. Pivot tables (complex)
3. Array formulas
would be really great topics, although I love what I’ve read so far.
In the order I would like to learn more:
1. Dashboards
2. Charting
3. Pivot Tables
VBA (Macros)
I’d like to see further discussion on the following:
1) Solver
2) Statistical Analysis (regression, time series etc.)
3) Scenarios, What if analysis
Please email more me macro exercises with some added formula forensics if possible. For I feel uncomfortable at work when a co-worker sends me a macro to use. I would like to be able to understand and possibly fix others’ macros, but now I just have to trust that there are no mistakes and that the macro will do exactly what I want. Thank you very much!
Simulations and scenario analysis beyond two way data tables will be my interest. Especially, managing and comparing project timelines and costs using these tools will be great. I can contribute as well.
Advanced Charting
Problem is : the more you know about Excel. The more you want to learn but if forced to choose I would vote for Array formulas and statistical analysis.
I would like to know more about Balanced Score Card and Dashboards
1) Dashboards
2) Pivot Table
Learning is some thing new is always my cup of Tea. i am ok with any of topic….More than happy if we get oppurnity to learn all…
Hi Chandoo,
I second the vote for more on Data Table and simulations. Hui’s post rocks!
Additional ideas:
[1.] File Scripting Object
[2.] Early binding/late binding
[3.] Global Unique Identifiers (GUI’s)
[4.] All things Excel Extensibility:
A. Access (other database)
-Parameter queries
-Insert
-Read/Write
-JET/ACE/ISAM
B. Outlook
-Creating/Managing tasks from Excel to Outlook
-Email distributution lists
-Email Workbooks
[5.]Statistical Functions
[6.]API’s
Hi Chandoo,
I would like to learn more on
VBA (Macros)
Solver
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Dashboards
Sorry, a few more:
[7.]Power Pivot Pro / DAX
[8.]OLAP/MDX
[9.]Data Mining Add-in
[10.] Developing Add-ins
[11.]RibbonX
[12.]Add-ins that may have potential to extend the power of excel
(i.e. OpenSolver opensolver.org, RExcel http://www.r-project.org/)
Statistical Analysis (regression, time series etc.)
1) OLAP cubes
2) excel limitations
Hi Chandoo!
I love this site!
I’d like to learn more about
Linking to Databases
VBA (macro)
Thanks and more power!
I would vote for linking to databases, using parameterized queries and connecting this to dashboards making them more dynamic.
Another subject is add-in creation e customizing the office 2007 ribbon
chandoo,
my interest list is exactly the order given by you..starting with formulas and ending with dashboards….though would like to know more on
pivot tables and charting,
advanced charting
VBA (Macros)
Linking to Databases etc.
Solver
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Dashboards
Arrays/Named Ranges
Solver
What-if Analysis
Hi, I would suggest..
VBA(Macros)
Dash Boards
Macros please.
I would like to learn more about charts and graphs. That’s what helps me at work. Thanks.
Hi Chandoo
My priorities to learn more in MS Excel are:
Advanced Charting
Solver
Scenarios, What if analysis
Dashboards
Hi Chandoo,
I need to know about pulling information from the website and uploading in to Excel for example we have Shares market information from the web linked to Excel rather than copy pasting and also more on VBA.
Thanks,
Paddy
Statistical Analysis
Hi Chandoo,
I would like to know more on data table and simulation, array formulas, name managers, and VBA macros.
Thanks!!
Hi Chandoo,
Use surveymonkey to survey about this, that will help you to understand the results of the survey better.
I would like to review whole of the set again.
I would personally vouch to see again
Array Formulas
Advanced Charting
VBA (Macros)
Linking to Databases etc.
Solver
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Dashboards
Chandoo. My congratulations and admiration on setting up such a useful learning web site for Excel.
I would like to learn more about VBA macros that I can generate through the Excel macro recorder, then customise for particular audiences. For example record the creation of a pivot table, but then adapt the code to refer to any size table in a different spreadsheet. ( I know how to do this, but it took a lot of searching to find the answer)
I also have a problem that I have to create macros for running on Excel 2007, but I have Excel 2010 and have to recreate the macro on another machine. Is there a way I can create macros for Excel 2007 using Excel 2010?
Many thanks Chandoo
Peter
Hi Chandoo,
Would like to look at arrays and indexes as well as simple macros…
Dear Sir,
Would like to look at VBA , arrays and indexes as well as various excel macros…
Hi Chandoo,
Congratulations on reaching 1,000,000 Page Hits. I wish you & your family all success with all the nicest things the nature can offer.
I am an analyst (fresher) to this role.
I am interested in
Formulas
Array Formulas
Solver
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Dashboards
Thanks.
Hi Mr. Chandoo!
It’s very difficult to choose for all are important things to learn in Excel. But I would priorities Formula and Dashboard..
Thanks..
VBA is the area for me
Thanks
how to effectively present Excel financial data in professional-looking PowerPoint slides that C-level executives will understand and remember. Use animation tools that help your audience focus on important information, avoiding “data dump”. Insert a live Excel spreadsheet in PowerPoint; be able to use Excel from within PowerPoint!
Chandoo, I am here on your web-site for short period of time, but this is a great site, where I can learn a lot.
My priorities are:
VBA (Macros)
Statistical Analysis (regression, time series etc.)
Dashboards
Thank you.
VBA, Stats, Dynamic Arrays
Well, after a quick scan of the posts so far, VBA and Dashboarding appear to be the most called for.
I’m surprised as these areas are extensively covered in both the free site and and training packages. So, I don’t think I have much of a chance in requesting methods of analysis from multiple worksheets extracted from relational databases. However, I’ll still submit my request and hope for the best.
I found a post on your site on how to avoid circular reference when modelling debt during construction using macros very useful, so more posts on using VBA Macros in Financial Modeling will be useful. I would also like to have your general view on using macros in financial modelling. Some experts say that it’s best to avoid macros and circular reference by using simple algebra. What’s your take on that? Thanks
I would like to know more on VBA and formulas
Arrays, Statistical Analysis, Linking to Databases
Simple solutions using formulas.
What if.
Dashboard
VBA
vba macros, advanced charting, dashboards. Thanks
I echo both, Kevin’s thoughts about spreadsheet design & documentation, and, how to more elegantly dynamically link to external databases.
YOU ROCK, Chandoo! LOVE your site!
Les
Pls include some videos or explanations more on
Solver,
Macros,
Animated dashboards,
Automating tasks,
VBA
dashboard
VBA macros and dashboards… simple and real use. nothing too complex… thanks!
Excel formulas which will help of an accountant.
Pivot Tables, Dashboards
XML data mapping
Parameterised SQL queries
animated dashboard with examples and VBA.
Thank you very much for all effort and thanks sharing.
I would be very happy if you can provide some tutorials regarding Class Modules and the related topics or application.
Thanks……..
For me,
VBA (Macros)
Linking to Databases etc.
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Data Tables & Simulation
🙂
When could our wishes come true?
Scenarios, What if analysis
Cell styles. I know the *what* they are and *how* to use them, but *when* should I use them? *Who* uses cell styles? *Why* do you use them?
I want to learn
VBA (Macro)
Data linking
Array formula
Pivot tables
VBA
Dashborad
VBA, for sure
VBA (Macros)
Linking to Databases
Household budget in form of comprehensive dashboard.
Hi Chandoo
Your website is just amazing …. its like Excel university
Your postings are indeed very helpful and easy to learn, However I would like learn more about
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Thank you
Your’s sincerly
Narayan
I would like to learn Array Formulas and VBA.
Thanks!
VBA Macros, Dashboards, Array formula, Data tables & Simulation.
? Advance level of Validation
? VBA (Macros)
? Linking to Databases
VBA Macros and Dashboards, plz
VBA Macros and Dashboards
VBA and Dashboards would be great
VBA
I would like to know a lot more on how to fully use the power of index and offset and nesting these in to formulas for dynamic uses. PLEASE!!!
Array formulas & pivot tables would be good.
Formulas
Array Formulas
Formatting
Conditional Formatting
Pivot Tables
Tables
Data Tables
Validation
Filters & Sorting
VBA (Macros)
Linking to Databases etc.
Solver
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Dashboards
One can always learn something new and interesitng in all the areas listed here, what it matters is how to apply that to the daily job; in my case, Finance and Accounting. So what I like about Chandoo web site is the clever, simple and direct approach of applying Excel tools to solve the problems we encounter often.
With that said, a little exploration of those two will be great:
– Statistical Analysis (regression, time series etc.)
– Scenarios, What if analysis
Thanks,
Pablo
My AOI (area of intrest)
1.Formula
>nested “if” formulas Solution.
>”Offset” formula
>Revers “Vlookup”
>different Lookups and why they use?
2.Array Formulas
> what it is?
> why we use it?
3.Advanced Charting
4.Dashboards
>How to setup data in single sheet.
5.VBA (Macros)
>Basics
6.Statistical Analysis (regression, time series etc.)
>what it is?
>why we use it?
7.Scenarios, What if analysis
8.Solver
9.Linking to Databases etc
I wanna forgot to visit this site.
Regards
!$T!
Microsoft Powerpivot!!!
Solver
What-if
Advanced Pivot
VBA, please.
VBA
Pivot Tables
Advanced Charting
Dash Boards
Array Formulas
Calculated fields in pivot tables, and an explanation of array formulas in plain English.
Formulas
Array Formulas
Formatting
Conditional Formatting
Charting
Advanced Charting
Pivot Tables & Charts
Tables
Data Tables
Validation
Filters & Sorting
VBA (Macros)
Linking to Databases etc.
Solver
Statistical Analysis (regression, time series etc.)
Scenarios, What if analysis
Dashboard
I would like to learn about data analysis
I want learn about :-
VBA (Macros)
Formulas
Pivot Tables & Charts
Validation
Array formulas
Hi Chandoo,
i like to learn more about Pivot Tables & Charts.
Dashboards would be top of my list 🙂
My votes:
1) Advanced conditional formatting
2) Pivot tables
3) In general, replicating Tableux as much as possible with as little VBA as possible 🙂
Love the site
Hi Chandoo,
Always awesome work!
I love to learn more about Excel presentations, either through powerpoint or within Excel.
Also data tables and simulation sounds good 🙂
1.Statistical Analysis
2.Printout Formatting : to have the headers in every page
3.Web refreshing of the excel sheet: such as financial portfolio.
I would like to learn more:
1. Pivot Tables
2. Dashboards
3. Charting
4. Advance Charting
5. Conditional Formatting
6. Formulas
I vote for any of the above, but What if scenarios would be good to learn.
Cheers
Here’s mine. This knowledge is quite important in my career in Proposal Engineer.
– Array Formulas
– VBA (Macros)
– Solver
– Statistical Analysis
– Scenarios, What if analysis
– Dashboards
Advanced charting and dashboards would be my choices.
BTW why don’t you put up a survey consisting those choices ?
– Solver
– Statistical Analysis
– Dashboards
For me:
Userforms and “non-standard” controls that you can get
Solver
Working with shapes in VBA
Macros, dashboards, and formulas.
Next step on Pivot Tables. I think people know how to create them and basic use but the next step will be is to apply them to create graphs and dashboard. I believe that making tables and charts interactive makes one “awesome in excel”
Great site.
1. Dashboards
2. Pivot tables
3. Charts (Advanced)
1. Dashboards
2. Conditional Formatting
3. Formulas
– Solver
– Statistical Analysis (regression, time series etc.)
Chandoo – Thanks to you and others who contribute to this site. It has been a tremendous help to me. It would be great to learn to better leverage statistical tools within Excel and probably some tips and tricks on maintaining file size and speed within a excel spreadsheet.
For e.g. cleaning up various tabs and maintaining the file size(Formatting, unneeded conditional formatting, unneeded rows/columns), knowing impact of certain formulas that slow down calcs in a large file, best use of vlookups, how to reference data on other sheets (best practice) and tools to identify bottle necks within a spreadsheet, etc.
Regards,
Megsu
-Ak
Array Formulas
Advanced Charting
Pivot Tables & Charts
Linking to Databases etc.
Scenarios, What if analysis
Dashboards
… do I have plenty till 2012 arrives? 🙂
I would like to learn more about using excel for budgeting and forecasting and charts.
Vlookup
Macros
Pivot Tables
I keep a lot of blocks of text in Excel cells. They range in size from a few characters to many thousands. I would like to know some work around methods for displaying beyond the 1000 character limit on the spreadsheet. A jagged approach would be using len(), but that might split a word, perhaps a ” ” near the break point, Anything simpler?
Thanks,
Roy
I would like to learn shortcuts to enter data into cells of a Data Entry Form… Such as DropDown menus, Date Picker Calendar, Default entries, automatic formatting of telephone numbers or postal codes, etc. any ways that would speed up the process of inputting data into an Excel Speadsheet Data Table and also prevent errors by narrowing the type of entries that can be entered into a specific cell. A Date Picker is essential in this case as it can be very time consuming to input dates into a cell… as well as I would like a way to enter 10 numbers into a cell that would automatically be converted into a telephone format like (123) 456-7890 into the data table. I have created my own Data Entry Form as a separate sheet so the formatting in some cases could possibly be done as I Save each record to the Data Table using a Macro (VBA Procedure). I am using Excel 2010. Thank you Chandoo.
LacGagnon
Chandoo. My congratulations and admiration on setting up such a useful learning web site for Excel.
I would like to learn Excel from Basics please Suggest and Help me in this area.
Many thanks Chandoo
Kishore
Vlookup and Design Tips 🙂
Sorry Guys for being extremely ambitious and crazy abt below comment
But I would like to learn anything and everything about Excel and I am in the Quest @ this website
Maverick…