Office

Download free Office templates for PowerPoint, Excel and Access. Find good articles on how to create your own Office presentations.

How to Use the SMALL Function in Excel

small function example

For those who have been using Excel, you may already be familiar with the many functions that you can create in your spreadsheets. However, not everyone is as comfortable working with functions. Our blogs offer many tips to help you navigate Excel. This program may truly be daunting, but once you know how to make …

How to use IFNA Function in Excel

if function in excel example

There is the Excel IF function that creates True or False results. However, if there is an N/A error, there is another function that takes care of that. This is the IFNA function in Excel. In a previous post we showed you how to use the AND function. This time we will show you how …

How to Use the AND Function in Excel

and function in excel

Excel is a nifty application for all kinds of data gathering, sorting, and analysis. One of its best features is that it allows users to make use of logical expressions. These are then used to check if certain conditions are met in a list of data. This particular function is called the AND function.

How to Freeze Panes to Lock Columns and Rows in Excel

freeze panes

When you’re working with spreadsheets, there can be a lot of data that your worksheet would take up many cells. It can be easy to get lost, if this is the case. You may have a hard time recognizing what row or column the cell you’re viewing belongs to. And this is where Microsoft Excel’s …

How to Create PivotTables in Excel to Calculate, Summarize and Analyze Data

Sample Pivot Table

One of the most powerful and most widely used features of Excel is the PivotTable. A PivotTable allows you to extract the data that you need from a large, complex, and detailed data set. Many may find themselves intimidated by pivot tables. However, once you get the hang of it, you will see how easy …

6 Creative PowerPoint Templates for Your Professional Business Presentations

Creating a compelling and memorable presentation is always every presenter’s dream. While you can’t really please everybody, nothing is more fulfilling for a presenter when they can get everybody’s attention, at the very least. This is especially true for business presentations when being informative must meet being entertaining and persuasive at the same time. After …

How to Use Your Smartphone as Remote and Laser Pointer for PowerPoint

Laser Pointer PowerPoint for Android

These days, we rely on our smartphones for so many things. From our schedules to our calls, workouts to socialization, alarms, and productivity. And now, we can also use our smartphones for presentations, particularly as a remote and laser pointer. Here is a tip on how to use your smartphone as a remote and laser …

How to Insert a Linked Excel Chart in PowerPoint

Embed or Insert Chart from Excel to PowerPoint

When you’re creating PowerPoint presentations, listing your ideas and data in every slide can make your slides look dull. It’s nice to break it up with images and visuals. And while pictures can paint many words, if you want to present comprehensive information, you have to have charts. Here is a tip on how to …

Animated Comparative Analysis PowerPoint Template

Animated Comparison Slide Toolkit for PowerPoint

When you are making a comparative analysis, or are comparing two ideas, objects, or situations in your presentation, you can expect a lot of confusion, maybe even indifference. One thing is for sure though–it’s going to take up a lot of slides. If you want to make a distinct and comprehensive comparative analysis, simply listing …

How to Use Mentions in PowerPoint to Get Advice and Feedback

Start Writing Comments and Mention People Involved

Ever wish you could easily and quickly get the attention of a certain team member or manager for feedback on your project? Usually, it goes like this. You finish your document, then email or share it with your team members or submit it to your client. Then you wait for their feedback. If you need …