Subtracting dates can be easy. However, formatting the answer to be shown as a countdown to an event is a little tricky. First, let’s subtract our dates, to get the number of days between now and the event. This is
Creating a countdown for two dates in Excel Read Post »
If you want a presentation that does not put people to sleep and forces them to listen, then learn the art of expansion! PowerPoint presentations were meant to be placeholders, not read-a-longs. Less is more, when it comes to PowerPoint!
Less is more with PowerPoint Read Post »
In the Formulas tab, in the Formula Auditing group, there is a command that helps you evaluate the formulas you have written. Example formula: =IF(A5>0,”True”,B5) To evaluate a formula, ensure you have that cell selected; then click the Evaluate Formula
Excel: Evaluating Formulas Read Post »
Use the Animation Painter tool in PowerPoint to quickly duplicate animations from one object to another. For more power point techniques see our PowerPoint classes.
PowerPoint Animation Painter Read Post »
Use the same design elements on several PowerPoint presentations by using templates. For more power point techniques see our PowerPoint classes.
Saving PowerPoint Themes Read Post »
In Excel, a 3D reference is when the information from a cell in a different worksheet is pulled to a worksheet needing the information. Example: If your separated worksheets are laid out with information from each quarter (ie: Q1, Q2,
Excel: Creating 3D references Read Post »
Use hyperlinks in PowerPoint to link to slides or other presentations. For more PowerPoint techniques see our PowerPoint classes.
PowerPoint hyperlink buttons Read Post »
Quickly align objects together to create a professional Org Chart using the Arrange tool in PowerPoint. For more PowerPoint techniques see our PowerPoint classes.
PowerPoint Org Chart Read Post »
Instead of scanning all of the information in a spreadsheet, use conditional formatting to highlight when issues exist. Then all you will need to do is look for colorful indicators. Example: The conditional formatting formula, in this case, is: Conditional
Use Conditional Formatting to Highlight in Excel Read Post »
Change you PowerPoint color scheme to prevent hyperlinked text from blending into the background. For more power point techniques see our PowerPoint classes.
Edit your PowerPoint color scheme Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
