Hot Microsoft Office How-Tos
How To: Create a Basic Attendance Sheet in Excel
If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software, you can create a simple yet functional attendance sheet to keep track of your students.
How To: Generate random numbers (with decimals) in Excel
This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=randbetween" function. If you want to use decimals, you will have to use a different but similar function. Start by typing "=rand()". Next, you multiply this by the difference between the limits and add the lower limit. Fo...
How To: Create a Tangent Line with Excel
Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for Stewart Calculus sections 2.1 and 2.2.
How To: Find a P-Value with Excel
So you need to find the p-value for your hypothesis test. To do so, employ the spreadsheet program Microsoft Excel. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis.
How To: Conditionally format at every change in value in 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. In this tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
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: Force text formulas to wrap with Excel's CHAR 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 228th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHAR (10) function to add hard line returns (forced wrapped text) to a text formula created with the ampersand (&) and concatenation tools.
How To: Hide scroll bars, sheet tabs & charts in Excel
This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, where you will see some check boxes. Uncheck the boxes for horizontal scroll bar, vertical scroll bar and sheet tabs. This will remove them from the current workbook. This feature only works with the current workbook.
How To: Cross-check two lists for discrepancies 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 528th installment in their series of digital spreadsheet magic tricks, you'll learn how to check two data sets (lists & tables) to see if there are discrepancies using the MATCH and VLOOKUP functions.
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: 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: 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: Build a 15-minute schedule in Microsoft Excel
Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that using the Fill Handle. For a complete walkthrough, watch this Microsoft Office how-to.
How To: Turn off AutoCorrect symbols in Excel
In this Excel magic trick video the instructor shows how to stop automatic copyright symbol ©. While using Microsoft Excel when you type the letter c in between a pair of curved braces Excel automatically turns it into the copy symbol © even if we did not intend to use it. Now to get rid of this feature go to the file menu and then to the options menu. In the options window that pops up go to the proofing sub menu and there is a button for auto correct options. Go into it and it shows the lis...
How To: Find critical values with T functions in MS Excel
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 91st installment in his "Excel Statistics" series of free video lessons, you'll learn how to use TINV and TDIST functions to find critical values given an unknown sigma value.
How To: Create a two-variable data table 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 255th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a two-variable data table in Excel for what-if analysis. See the PMT function and learn about the formula equivalent to a data table.
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: Use conditional formatting for a student grading report in Microsoft Excel
If you're looking for a way to create a student report, Microsoft Excel makes it easy to create a wonderful spreadsheet with tons of information. This video shows an example of a student report being created, which has three simple items in the columns of the sheet, which are the names of the students, the marks obtained and the grades.
How To: Generate a dynamic list from a table in MS Excel
New to 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 Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
How To: Calculate YTM and effective annual yield from bond cash flows in 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 49th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate YTM & effective annual yield from bond cash flows.
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: Chart cross-sectional and time series data in MS Excel
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 11th installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with, and create charts for, cross-sectional and time-series data.
How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
You know that moment when you finally figure out something, but you figured it out years after you really needed it? Don't you freaking hate that?!
How To: Insert movie files into a MS Word document
In order to insert movies into Microsoft Word 2007, Click on Insert. For AVI, go to Object, Create From File, and select the location of the file. Then, click on Insert. It will now appear on your document. The video should play. The video can be repositioned or adjusted. It can be saved with your document, although this is not true for other movie formats.
How To: Create a pass-fail grade formula 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 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pass-fail grading formula using the IF and AND and VLOOKUP functions.
How To: Check your voicemail in Microsoft Outlook
In this how to video, you will learn how to check your voice mail in Microsoft Office Outlook. Your exchange administrator must enable unified messaging for these messages to appear. First, open the program to set up your voice mail options. Go to options and click the voice mail tab. Your phone number should appear in the correct form. Click call to check your voice mail. Enter your number and click x and okay. Now you are ready to listen to your voice mail messages on your computer. From Ou...
How To: Insert, format, resize & crop pictures in MS Word
This video is a Microsoft Word 2007 tutorial on working with pictures. To insert a picture in your document, click on Insert and select Picture, then find the picture, select and insert it. To resize the picture without distorting it, click and hold on the corner circles. You can adjust Brightness and Contrast by using the various choices within these settings. The Recolor setting gives you a number of options for changing the coloring of the picture, such as sepia, black and white, or graysc...
How To: Score a Full Version of Microsoft Office for Only $10
When it comes to text documents and spreadsheets, Microsoft Office is the be-all and end-all office suite—but it's not cheap. Paying anywhere from $140 to $400 puts a big dent in your bank account, especially if you're a broke college student eating ramen for breakfast, lunch, and dinner. Something that I wish I would've known about during college is Microsoft's HUP (Home Use Program). With HUP, any employee or student of an organization that has a Microsoft volume license is eligible to purc...
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: Count Mondays between 2 dates 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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.
How To: Summarize survey results with a pivot table 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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize survey results with a pivot table (PivotTable) or a formula. See how to create a Pivot Table in Excel 2003 or 2007.
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: Create and use outlines in Microsoft PowerPoint for Mac 2011
Want to know how to use outlines within PowerPoint for Mac 2011? This video will show you how it's done. Whether you're new to Microsoft's popular word digital slideshow application, new to MS PowerPoint 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 detailed, step-by-step instructions, watch the video.
How To: Make an Excel scatter chart to show the relationship between bond rate & price
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 50th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to demonstrate the inverse relationship between bond rate and price with a scater chart.
How To: Calculate the present value of an annuity with Excel's PMT function
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 35th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the present of a loan with the PMT function.
How To: Work with math equations in Microsoft Excel 2010
Learn how to store, use and manipulate equations in MS Excel 2010. 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 2010, you're sure to be well served by this video tutorial. For more information, and to get started using mathematical equations and formulas in your own 2010 worksheets, watch this free video guide.
How To: Create horizontal subtotals for a data set 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 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.
How To: Build an Excel table of fraction & percent equivalents
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 24th installment in his "Excel Business Math" series of free video lessons, you'll learn how to build a table of decimal, fraction and percent equivalents. See how fractional formatting can be misleading.
How To: Add current stock prices to an Excel table
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 33rd installment in his "Excel Business Math" series of free video lessons, you'll learn how to add current stock prices to a stock analysis table in Excel using a web query.
How To: Work with mathematical word problems in MS Excel
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 13th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for math word problems in Excel.