If you're looking for advanced Excel training courses, more than likely you're not a total newbie to the concept of a spreadsheet. In fact, you're probably quite comfortable with cells, formulas, and functions.Advanced Excel training courses will usually cover things like special functions. Check out Excel training courses These might include ways of manipulating text or other elements.For example, the COUNTIF function is very cool because it allows you to only count cells that meet a specified criteria.It works like this:=COUNTIF(Range, Criteria)If you would like the total number of all cells that have a value of over 10, you would use this formula:The formula in B10 simply sends the range B1:B8 to the COUNTIF function, and specifies the criteria ">10″. Note the use of double quotes in this case. If you wanted a total of all the values that are exactly 10, you don't need the quotes, you would just use the value 10. (e.g. =COUNTIF(B1:B8, 10)In this next example, we want the total number of orders for apples:As you can see, we can use COUNTIF on text as well as numerical data.Another topic you'll likely find in an advanced Excel training course is Macro programming. What is a macro? Simply put, it is a recording of specific tasks that can be played back at will to help you automate the things you need to do.For example, let's say that you need to format cells in a certain way every time. Borders, colors, fonts etc... all need to be consistent when you create a certain type of report, for example.You can start recording your macro, and format all the cells like you want, then stop recording your macro.The next time you need to format the cells simply select them, and run your macro, POOF! they are formatted.And you know what is really cool about using macros? They are not played back in real time. Instead, they are played back as quickly as possible.That means what might take you 30 seconds to do manually, would only take a split second if you could do it with a macro. How cool is that?Imagine the potential time you could save by carefully creating a macro to do all of your repetitive work in Excel.Macros can be called over and over again, as much as you like, and you can even have macros call other macros. Click here for more.
RSS Feed