Select Page

Excel Functions

Functions can do a lot of the heavy lifting as you build power and complexity into your spreadsheets.  Get started with the Functions Basics playlist to learn fundamental Excel functions like SUM and COUNT.  Once you’re familiar with the basics, there are Text Functions that can do things like combining or separating patient names.  Date and Time Functions make time based functions like anesthesia much easier.  Don’t miss VLOOKUP.  If you have data in two places, such as fee schedules, it’s easy to combine data into one table with VLOOKUP.  If you can do VLOOKUP, you can do 95% of Excel’s functions.  Keep going.  If I thought a medical practice would use an Excel function, there’s a video for that function in these playlists.