|
Excel Video 359 Using SMALL to Find the Third Next Available Appointment0 Comments added to this post Here’s a way you might start using arrays in your practice. |
|
Excel Video 358 ROUND in an Array0 Comments added to this post Here’s another way an array might make your life easier. |
|
Excel Video 357 LEN in an Array0 Comments added to this post As promised, an easier array example today. |
|
Excel Video 356 SUM with OR Criteria in an Array0 Comments added to this post One more complicated formula, but once it works it’s very powerful. |
|
Excel Video 355 SUM and Multiple IFs in an Array0 Comments added to this post Here’s hoping you aren’t rewinding this complicated Excel Video too much. |
|
Excel Video 354 SUM and IF in an Array0 Comments added to this post Here’s a practical example of an array formula. |
|
Excel Video 353 Using Arrays to Copy Data0 Comments added to this post Here’s our first array trick. |
|
Excel Video 352 Transposing Arrays0 Comments added to this post If you have a horizontal array and need to use it with a vertical range, watch Excel Video 352. |
|
Excel Video 351 Changing Named Array Constants0 Comments added to this post Here’s how to make your named array constants a little more flexible. |
|
Excel Video 350 Naming an Array0 Comments added to this post Today we’ll simplify the formula we created in Excel Video 349 by naming an array in Excel Video 350. |
|
Excel Video 349 Using Constants in an Array Formula0 Comments added to this post As promised, here’s a way to use constants in an array formula. |
|
Excel Video 348 Constants in Array Formulas0 Comments added to this post Here’s how to use constants in an array formula. |
|
Excel Video 347 Deleting, Moving, and Expanding Array Formulas0 Comments added to this post Some tricks to manage your array formulas… |
|
Excel Video 346 Multi-Cell Array Formulas0 Comments added to this post We’ve created an array formula in one cell. Here’s how to create an array formula in multiple cells at the same time. |
|
Excel Video 345 Introducing Arrays0 Comments added to this post Arrays can make you a real Excel power user. |
|
Excel Video 344 Data Tables Tips and Tricks0 Comments added to this post
Three things you should know about Data Tables… |
|
Excel Video 343 Data Tables with Three Variables0 Comments added to this post
It’s hard to analyze and show three variables in two dimensional space with a Data Table, but here are some ideas on how you might do it. |
|
Excel Video 342 Data Tables with Two Variables0 Comments added to this post
Now that you’re familiar with Data Tables, here’s how to vary two variables instead of just one. |
|
Conditional Formatting Part 3 Article Posted0 Comments added to this post
New HBMA Billing article available. |
|
Excel Video 341 Introducing Data Tables0 Comments added to this post
Here’s another What-If tool that can be very helpful in Excel. |
