Excel charts are a great way to represent data and can be easily edited, even after creation. Here’s an example of changing from one type of chart to another. Read Danielle O'Connell's answer to How do you connect the dots in an Excel graph? on Quora
Converting text from lower case or sentence case into upper case in Excel can be achieved either with a formula or with a custom VBA function. If you’re just doing it the once, you’ll probably just use a formula (=UPPER), but if you’re doing it regularly – try creating a custom VBA function like this… […]
In the most simple terms… Logical functions are used to determine whether to perform an action or not perform the action by making comparisons and returning True or False as the result of a simple comparison. However using logical functions in practicality is much cooler… Use them to determine whether to apply a conditional format […]
If you’re working with dates in VBA – it can be a little painful when the date format defaults to US format (mm/dd/yyyy). Sure when you enter 30/10/1979 (my birthday incidentally), it knows it’s the 30th October because there is no 30th month, but when you enter 03/05/1957 (my dad’s birthday), it reads it as […]
If you’re a keyboard user (like me) and hate having to take your hands off of the keyboard to reach for the mouse… There’s a keyboard shortcut to achieve everything in Excel. Ctrl, Alt and Shift in combination with letter keys, number keys and each other are used to negate the need for your hands […]
If you’re wasting time with tedious and repetitive tasks in Excel, it might be time to review your processes or do some training. Macros can be created to automate so much manual processing in Excel. Here’s a simple “copy all files in a folder to a single workbook” macro. This one loops through all files […]
Return the first, second, third or nth cell that meets given criteria with a “simple” array formula…The instruction in this sample will show you which functions you’ll need and illustrate how they all work together
The CONCATENATE function in Excel has never been one of my toolbox – too cumbersome, but the newest version of Excel includes the TEXTJOIN function… like Concatenate but so much more intuitive. Check it out!
Array formulas are pretty handy. This example looks for records that match columns A, B & C between 2 sheets, returns the text “Duplicate” only if there is a record that matches all 3 columns and nothing if it doesn’t… There aren’t many Excel instructors who teach Excel to this level – but I do. […]
Easily find, edit, add and delete records in an Excel data table using the forms tool. Excel’s Form tool simulates a database user interface when working with structured tables holding multiple records in Excel. It’s super simple to use and requires absolutely NO setting up. The Form tool isn’t available in Excel’s default ribbon though, […]