Make VBA String Comparisons Case In-sensitive [Quick Tip]
Today, while answering a reader’s email, I wrote this VBA code, If Target.Value = “yes” Then ‘do something End If But I realized that my
December 1, 2011
Hello, Namaste & Kia Ora. Welcome to Chandoo.org.
My name is Chandoo. My mission is to make you awesome in Excel and Power BI.
I do this by sharing Excel & Power BI tutorials, examples, tips, videos and articles on this website. I live in Wellington, New Zealand with my beautiful wife Jo & our twins Nishanth & Nakshatra. Take a minute to browse various topics of the site to see how I can help you.
Thank you and welcome.
Today, while answering a reader’s email, I wrote this VBA code, If Target.Value = “yes” Then ‘do something End If But I realized that my
Congratulations Chandoo.org on reaching 1,000,000 page hits in November 2011.
Hui…
.
.
.
.
.
.
.
This is the Forth post in Chandoo’s, Formula Forensics series.
Last week Luke showed us how to extract a sorted list according to a criteria from a larger list
and he analysed a formula to solve this problem
This week we look at Fred’s Problem…
How do I simplify a very long formula?
Maintenance on the 18 month old, Data Tables, Monte-Carlo Simulations and Fractals in Excel – A Comprehensive Guide has been completed.
Last year, Steven shared a beautiful Christmas Gift List template with all of us. It is packed with lots of Excel goodness. Just a few days ago, he emailed me another copy of his file with some improvements. So if you are planning for Christmas shopping and want a handy tracker, you don’t want to miss this.
So how did your weekend go?
I did a bit of gardening, painted our car shed, played badminton (I am learning), attended 60th birthday of a close friend’s dad. Pretty hectic, but fun as usual.
To start this week, let me share a simple but fun way to add data to charts.
Lets say you have a chart that depicts Annual sales for last few years. And you want to add the data of Profits (or Expenses) to this chart. Here is a dead-simple way to do it.
Today we publish what is hopefully the First of many posts by guest author Luke M. it is also the Third post in the Formula Forensics series, which has now moved to a regular and new Thursday slot ?
Luke has taken up Hui’s and 3G’s challenge of explaining how the technique he regularly uses on the Chandoo.org Forums for extracting individual records out of a group.
Today Luke tells us how to extract a list of items from a larger list according to some criteria.
Today, lets learn how to create small-multiples (or panel charts) to visualize trend of 2 product lines over years in various regions. The inspiration for this chart and article came from my friend, Paresh‘s recent article on his blog.
See how you can create a combination of area & line chart to create the small-multiple chart and clone it. You can also download the workbook and play with it to understand this technique better.
for more videos…
Everything from Power Query to Dashboards, Shortcuts to Formulas, Pivots to Charts in one course.
BeginnerTables & Structural Referencing
Cell referencing
Excel operators
IF
IntermediateSUMIFS, COUNTIFS
XLOOKUP NEW
VLOOKUP
INDEX + MATCH lookups
AdvancedMulti-condition lookups
Array Formulas
OFFSET
INDEX
Lists100+ Excel Formulas list
Top 10 formulas
15 Everyday formulas
Challenges & Home workExcel Homework
BeginnerExcel Pivot Table Tutorial
Multi-table pivots with data model
Advanced
Advanced Pivot Tables
Distinct count in Pivots
Ranking values in Pivots
GETPIVOTDATA
How to use slicers
Lists35 shortcuts & tricks for data analysis
Top 10 pivot table tricks
15 quick & powerful ways to analyze business data
ResourcePivot Tables Page
BasicsHow to pick right charts
Why bar charts should start at 0
Add a line to column chart
Correlation vs. Causation
ExamplesHand-drawn charts
Budget vs. Actual chart
Interactive charts
Chart typesHistograms & Pareto charts
Forecasting with charts
Gantt chart
Funnel chart
5 star chart
Indexed charts
Panel charts - Small multiples
AdvancedTarget vs. Actual progress - Biker on a hill chart
Stacked chart with indicators
Cropped chart - when some values are too big
Jitter plot
Joy plot
Step chart
Dynamic chart with check boxes
Lists & TricksCharting shortcuts & tricks
Using shapes in charts
Awesome chart titles with this trick
Use chart themes and styles
Use selection pane to work with charts faster
If you are new to Excel or have never used it, use below links to come up to speed.
Have been using Excel for a while? Check out these tutorials to learn more and become awesome.
Work with Excel a lot and know your game well? We have some very-advanced topics for you too.
Check out:
Excel challenges
Advanced Charting
Data Tables & Simulations
Power BI
Power BI is the most exciting thing to happen for your data since spreadsheets. If you are looking for a new skill to learn this year, I highly recommend Power BI. Check out below tutorials and get started today.
Learn how to work with data, make calculations, pivots, create amazing charts and powerful dashboards from scratch using Excel School + Dashboards program. Suitable for analysts, managers or professionals who need to use Excel often.
Use VBA to automate your tasks and build powerful spreadsheet based apps. In this course, learn all about how to program with VBA, how to use the language and object model to your advantage. Suitable for people who build a lot of things with Excel.
