Hot Microsoft Office How-Tos
How To: Enter formulas in Excel with a macro
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
How To: Calculate salary based on work experience in MS Excel
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 629th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP, MATCH, DATEDIF, SUMIF, SUMPRODUCT and INT functions to look up salary based the number of relevant years worked.
How To: Change Excel options directly in the Registry
This video shows us the method to block the formula bar, scroll bars and the status bars in Excel. Click on 'Start' and type 'regedit'. Click on 'regedit' and go to 'HKEY_CURRENT_USER'. Open it and go to 'Software' and 'Microsoft'. Expand it and go to 'Office' and open the version of Office on your computer. Expand it and go to Excel. Choose the options folder. Go to the 'Options' item and right click on it. Go to 'Modify' and type 150 in the text box. Click on 'OK'. Now restart the Excel and...
How To: Download & install the Microsoft Excel MoreFunc add-in
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 276th installment in their series of digital spreadsheet magic tricks, you'll learn how to download and install the MoreFunc supplementary function add-in.
How To: Create a checkbook-balancing formula in Excel
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an efficient checkbook balance formula and see when to use the ROUND function on a sales invoice.
How To: Measure the spread of a data set with Excel's AVEDEV
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVEDEV function to measure the spread (variation) in a data set. Also see the STDEV function and learn how to measure whether a mean represents its data points fairly.
How To: Put your MS Access databases on your website
To start off the process of publishing your access database online we first look at a sample MS ACCESS database with typical formats and a online searchable application where users can search by library name or city and get details of the library. There are 3 steps to publish the database. The first step is importing data which can be done through clicking on the file menu and then click on import data through a Microsoft Access Database. Now select the file you want to import through the bro...
How To: Create a dynamic weekly chart in Microsoft Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck.
How To: Use the if Function in Excel
Video: . IF function
How To: Save Your Word Document as PDF with One Click (Using a Macro)
In this article, we're going to create an additional button in our Word toolbar which creates a PDF file of our loaded file with one simple click. We are going to use the function to create Macros, which are little 'programs' in
How To: Calculate interest rate risk in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 54th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate interest rate risk or IRR.
How To: Remove spaces from numbers in Excel with the SUBSTITUTE function
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 715th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a number with spaces, remove spaces and convert text to number using the SUBSTITUE function and plus zero.
How To: Track cash on hand with a table Microsoft Excel 2010
Learn how to keep track of cash on hand via special table in your MS Excel 2010 workbooks. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started tracking cash for your own budgets, take a look.
How To: Type a bomb symbol in Microsoft Word
This video will show you how you can simply type a symbol of a bomb in Microsoft Word. Using three easy steps, the symbol can be simply inserted into a word document. After opening up the Microsoft Word program, the user should then change the font type to a font which is called "Wingdings". This font will create symbols in the place of the regularly typed letters. In order to obtain the bomb symbol, simply type "M" (capital m) and the symbol will appear. The symbol should appear as a simple ...
How To: Copy and move worksheets in Microsoft Excel 2007
Learn how to copy and move sheets in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started manipulating your own Excel 2007 worksheets, watch this free video guide.
How To: Pull data from one Excel worksheet to another via DGET
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
How To: Do matrix multiplication and inverse in MS Excel
This is a video about the multiplication, determination, and inverse of matrix using excel. First we have to take two matrix in excel. If you take two 3x3 matrices and multiply it then you will get a 3x3 matrix as a result. First we have to select 3x3 cells in the excel and give then a formula of =mmult(and then select the first matrix it will automatically takes the row and cell numbers, next select the second matrix). Then it will give the answer. Next if you want to find the determinant of...
How To: Create collapsible and expandable cell ranges in Excel
This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
How To: Quickly insert formulas in Excel
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
How To: Create a sudoku puzzle in Excel with array formulas
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.
How To: Count values between a lower & upper bound in MS Excel
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.
How To: Make a footnote in MS Word 2007
This video shows you how to make a footnote in MS Word 2007. 1. Click on the last letter of the word where the footnote refers to. 3. Click on the References tab. 4. Click Insert Footnote. 5. A tiny number will appear beside the word where you clicked and a footnote number with a line on top will also appear on the last part of the page. 6. Type in the words or the notes. 7. You may now continue typing your work.
How To: Calculate total savings in Excel
This video will show you how to calculate the total savings on a transaction where there are two percentage series discounts and two dollar discounts. This video shows frugal bargain hunters how to simplify with an Excel sheet and find the total saving percentage. It teaches functions that can be used in the Excel sheet, plus useful tweaks and formulas.
How To: Create a table for the VLOOKUP function in Excel
In this video tutorial, viewers will learn how to create a table for the VLOOKUP function in Excel. Create a dynamic table for the VLOOKUP function as well as a dynamic lookup area so that as you add new data or columns to the Lookup table. Create dynamic ranges using the Excel Table feature and Table Formula Nomenclature for the Data Validation drop-down list, the VLOOKUP table and the MATCH table. See an IF function formula that creates new labels as new columns are added to the lookup tabl...
How To: Create subforms in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating subforms (assuming relationships have already been created). For more on subforms, watch this MS Access how-to.
How To: Change the Default Font in Excel 2010
Some people may don't like the default word or hyperlink font in their Excel. Though you can change the word font of the whole sheet by using the font tools in the Home menu, but the default font still remains when you create a new Excel file. So, here is the solution.
How To: Use table styles in Microsoft Word for Mac 2011
Want to know how to style tables in Microsoft Word for Mac 2011? It's easy and this video will show you how it's done. Whether you're new to Microsoft's popular word processing application, new to MS Word 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using table styles in your own Office for Mac 2011 projects, watch the video.
How To: Calculate APR, EAR & period rates in Microsoft Excel 2010
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, part of his "Excel Finance Class" series of free video lessons, you'll learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate) and Period Rate.
How To: Use conditional formatting for a student attendance report in Microsoft Excel
You can use conditional formatting in Microsoft Excel to create an easy attendance report for you classroom. This can also be applied to other similar types of reports. The report in this video includes the names of the students, the total possible days of attendance, the actual amount of days attended by each student, the percentage of attendance, and their rank in the class. Just follow along with the video to see how it's done.
How To: Graph the probability density function in an Excel file
One of Microsoft Excel's capabilities is to allow you to graph Normal Distribution, or the probability density function, for your busines. This is a quick and easy tracking feature you can learn in just a few minutes.
How To: Format charts in MS Word 2007
In order to format graphs and charts using Microsoft Word 2007, click on Chart Tools. The tabs at the top of the screen provides you with your options. You can change the type of chart or graph by clicking on Change Chart Type. If there is a particular type of chart that you would like to use again and again, then you can save it as a template via the Save As a Template icon. You can edit the data in your chart of graph by clicking on Edit Data. You can modify the chart layout by clicking on ...
How To: Create drop down menus in Excel
In this software video tutorial you will learn how to create drop down menus in Excel using Data Validation. This example will show you how to display a list of parts in a drop down menu. Create the list of parts somewhere in your worksheet. Then in the cell underneath the one where you want to display the parts, go to the data validation window and enter the data. For this select the cell and then press 'Alt + D + L' to bring up the data validation box. Here you click on 'settings' and selec...
How To: Remove tabs & scroll bars from an Excel spreadsheet
This video tutorial is in the software category where you will learn how to remove tabs and scroll bars from an Excel spreadsheet. Open a work sheet and you will find scroll bar on the right and at the bottom. But, why should you take them off? If you are making a user form that you want to send to your employees and you don't want them to mess it up, then you may do this. Go to the office button and click on 'excel options' at the bottom. On the next window go to the 'advanced' tab and scrol...
How To: Use a calendar for future projects in MS Project 2007
In this tutorial, we learn how to use a calendar for future projects in MS Project 2007. First, go to the "tools" menu, then down to organizer. Choose the calendar tab and then change what the calendars are available in. Choose ABC Limited, then click on "copy". Now, click on "close" and open up a new project. From here, go to "project" then "project information", and you will be able to change to the other calendar. Remember to change the default under the options so you have the correct tim...
How To: Creating data-entry forms in Microsoft Access 2010
Learn how to create data-entry forms when working in Microsoft Access 2010. Whether you're new to Microsoft's popular database management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using data-entry forms in your own Access projects, watch this free video guide.
How To: Navigate worksheets in Microsoft Excel 2007
Learn how to get get around worksheets in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started navigating Excel 2007 worksheets yourself, watch this free video guide.
How To: Create linkage formulas in Microsoft Excel 2007
Learn how to create linkage formulas in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started using linkage formulas in your own 2007 workbooks, watch this free video guide.
How To: Fix a DGET #NUM! error in Microsoft Excel
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.
How To: Control percentages with a scroll bar in MS Excel
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 46th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create scroll bars that will control a percentage in a cell.
How To: Reference worksheets and workbooks in Excel formulas
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 6th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create worksheet and workbook references in formulas.