Creating an Excel template allows a person to reuse a workbook setup over and over, without the need to recreate the wheel every time, nor continuously to clean out old information. By using a template, your workbook is ready and
Creating an Excel Template Read Post »
When creating a PowerPoint presentation in PowerPoint 2013, it’s important to know that the slides are saved in a widescreen format by default. If you need something different, you will need to physically change the format of the PowerPoint by
PowerPoint – Wide Screen format Read Post »
A Timeline can be inserted into your PivotChart, if dates are listed in your table. After you insert your PivotChart, add a Timeline, located in the Filters group of the Insert tab. Watch this short video to see a Timeline
Excel: Insert a Timeline Read Post »
Is there information that you are constantly scrolling to find? Use “Groups” in Excel to bring the information to you. Drag-select the columns (or rows) that you wish to group Then click the Group command in the Outline group of
Use “Groups” to bring the information to you. Read Post »
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 »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
