Bloomington Tutors | Blog
Finite math, calculus, statistics, and other problems - explained.

To be honest, Excel's text functions are kind of awkward and limited. Unlike full-blown programming languages like Python and Javascript, you don't have access to regular expressions or standard string functions such as split, join, and replace. Instead, you have to make due with complicated combinations of Excel's LEFT, RIGHT, MID, LEN, FIND, and CONCATENATE formulas to manipulate text.

In this video, we walk you through a common GP9 string (text) manipulation problem that asks you to use these functions to split, format, and rearrange text into more useful representations.

Download the sample exercise files

Continue Reading...

Even casual Excel users have probably encountered a situation where they wanted to test a formula against a range of possible input values. One way to do this is by simply copying a formula down a column or row of your table. A more structured way of doing this, though, is Excel's Data Tables (What-if Analysis) feature. Most K201 students don't usually have much trouble with figuring out how this feature works, but it can be easy to forget under the pressure of an exam.

Actually, the trickiest thing we cover in this video is defining custom data formats. We're not sure why, but K201 GPs and exams usually like to ask you to create custom data formats as a followup to two-variable data table questions.

Download the sample exercise files

Continue Reading...

One of the more powerful features of Excel is its collection of lookup functions, which let you cross-reference tabular data in your spreadsheets. K201 students sometimes find them tricky to master though, especially when it comes to determining when to use a VLOOKUP, HLOOKUP, or INDEX-MATCH formula.

In this video for GP7, Dalia goes over examples for each of these formulas - you'll be done in no time!

Download the sample exercise files

Continue Reading...

Our last video for GP6 covers Excel's IF formula. We go over some simple use cases (for GP6), as well as some more complicated applications. We'll talk about how IF formulas can be used inside another IF formula ("nested IFs") along with the AND and OR boolean functions to build decision trees.

Nested IF statements tend to give K201 students a lot of trouble, so we hope this video can help clear things up a bit!

Download the sample exercise files

Continue Reading...

In this video, we cover some of the other common financial formulas that come up in K201's Excel unit. Examples include comparing investment options using the PV (present value) function, planning a college fund with the NPER formula, and computing the annual interest rate on a known payoff amount for an investment with RATE.

Download the sample exercise files

Continue Reading...