Office Guide

We offer office guides and easy step by step tutorials with images and videos that help you to do easy your work.

Create and Use Sparklines in Excel to Show Data Trends

Sparklines in Excel is an important feature which allows you to view or print visual representation of numerical data. If you are working on Microsoft Excel 2010 or upper version then you can create a use sparklines in Excel to show data trends. Sparklines are smaller charts which is used to show numerical data in-terms of charts.  Read More

How to convert standard date mm-dd-yyyy format into mm/dd/ format

Excel by default use MM-DD-YYYY format during filling the date in any cell. But most of the person use different format to fill the date of birth in Excel. Sometime we need to fill the date in different format as compared to standard format. In that situation it will take lot of time to do this job manually. In this guide we have to discuss how to quickly convert standard date mm-dd-yyyy format into mm/dd/ format using Find and Replace command. Read More

How to use Countif function with wildcards in Excel

Countif is an important function which is used to count number of cells which meet the given single condition or criteria. You can use Countif function to count number of cells which have any number, text or dates that match the given specific condition. But sometime we need to use wildcards for partial matching in the given range of cells in active worksheet. In that situation you must know how to use Countif function with wildcards in Excel Read More

Beauty of Goal Seek feature in Excel to Find the Answer

Goal Seek feature in Excel is an important part of What-If-Analysis. it is an important feature of Excel which allows you how to one value in the formula impacts to other cell value. Goal Seek is the best tool used to find the result by adjusting an input value. There are lot of situation in which you can use Goal Seek feature during preparing different kind of reports. If you have more than one variable values and you want to change the final result value but want to apply effect only for one cell. Read More

Latest 7 Excel Tricks which makes you an Excel Expert

Excel plays an important role during daily working on different worksheets. If you have a big data than you must have to use given latest 7 Excel tricks which makes you an Excel expert. Most of the novice Excel users don’t about these tricks. But after using these tricks your working speed is faster than others. You can also gain lot of knowledge about the Excel. If you want to become an expert on Excel then you must know about the different Excel tips and tricks.  Read More

Excel FV Function to know future value of an Investment

Hi friends today we are talking on Excel FV Function to know future value of an Investment. The Excel FV function is an important financial function. The Excel FV function allows you to quickly return the future value of an investment with constant interest rate, payments and periodic. FV stand for future values and this function is located in Formula > Financial library functions. Read More