What runs through your mind when you think about Microsoft Excel? Personally, my relationship with Excel has been complicated and ranges from avoiding it at all costs to using it excessively. I have found Excel to be a useful tool for tracking personal finances and information, as well as making lists and daily schedules. I know many people may feel apprehensive about learning Excel, so I thought, who better to provide some positive insight than Jason Manibog our in-house IT expert? Recently, I visited with Jason and asked him if he could give us some advice that would be beneficial to new users of Excel. Whether you are learning Excel purely for certification purposes, or for more efficient personal use, be sure to read Jason’s feedback below.
- What advice would you give to a user new to Excel? I would start with (of course) viewing our Excel 2016 course! But to start working with Excel? I would start with building a simple file or two for something you can relate to, like a phone list of family and friends, or a budget or expenses sheet with calculations. Most importantly, make the files YOUR files as in something you can relate to.
- What type of student did you have in mind when you were creating this course? Someone trying to learn Excel and perhaps looking toward passing the Microsoft Office (MOS) 2016 Excel exam. And, someone who is trying to get important job-ready skills in Excel. The practice files are really geared toward the job-ready aspect of training.
- If a student has very little experience using Excel, how would you recommend they start using our training? Start with the very first part of the course and make sure to mix the video training with the practice exercises in the project workbook which accompanies the course.
- What are some common uses for Excel that people can use their new Excel skills for? The list is large. I would say lists, budgets, expense sheets, workout logs, golf scores (had to throw that in), or anything else that involves building a list and then, when needed, analyzing that data through charts and calculations.
- What are some of the new features in Excel 2016? There are a few, but the two which stand out to me are the “Tell Me” feature, which I brought up in a previous blog. The “Tell Me” feature allows one to search for a “How-To” and then get the actual tasks to do. For example, I can do a “Tell Me” search on “Get the Average of data” and it will lead me right to the AVERAGE function. Also, for those of you who like charts, there are several new chart types in Excel 2016, so analyze away!