Home » Microsoft » Archive by Category "Excel"

From Excel Tables to PivotTables

You (and, more importantly, your boss) love what you’ve created thus far in Excel. You’ve spent hours entering your data into your worksheets, organizing the data using best practices, and creating advanced formulas to calculate what you need to see. So, what have you learned about your data?

read more

Advanced Excel Data Analysis – Data Table

While working in Microsoft Excel on data analysis, there are a handful of built-in analysis tools available. If you’re interested in studying the effect that a range of values has on the formula, you should consider setting up a data table.

read more

Setting up an Excel Workbook? What Should Be Avoided.

Let’s imagine that you are able to create a Microsoft Excel workbook from scratch. You want to set it up for long-term, future success, right?

If the amount of data is going to grow over time, you need to think a few steps ahead to make sure that you are “future-proofing” how you will work with your workbook and the data. There are some easy steps you can take to ensure that the workbook is effective now and for the long term.

read more

Excel Developer Tools – Checkbox Controls

One of the more popular form controls is the checkbox. The checkbox form control is a simple control that you can use when you want to assign a Boolean (true or false) value to a cell. In other words, when you check the box you can assign one value, but when you un-check the box you assign another value.

read more

Business Administration Certification – Get Started!

With new small businesses coming on to the scene daily, it can be intimidating for any entrepreneur to jump into the fray. There are many skills that you need to know in order to be successful in today’s tech-savvy marketplace, and it’s hard to know where to start. For most companies, from the design sector to the financial sector, there are several key software programs that must be mastered for maximum efficiency and workflow. Luckily, you can get all the training you need to launch your own business right from the comfort of your own couch!

read more

Top 3 Beginner Excel Mistakes to Avoid

When beginning to use Microsoft Excel, there are several key mistakes that all students should avoid in order to be successful for the long term of a project. Depending on your industry and specific Excel needs, this list of pitfalls can certainly become a long one. I’ve narrowed down the top 3 mistakes that all beginning Excel users should avoid.

read more