Trainer Tips
Looking for tips from Full Circle on how to increase efficiency and accomplish some of your most challenging tasks with ease? See below for our favorite Full Circle Trainer Tips for step-by-step instructions on how to make the most of your favorite software applications.
Using the VLOOKUP Function in Excel
You can easily create a function to look up information! The VLOOKUP function consists of three required arguments, in the following order: lookup...
Learn to Build Maps in Tableau
Using Tableau Desktop, you can create Visualizations from information stored in your spreadsheets and databases, giving you the ability to quickly...
Password Protect Your Confidential Excel Files
Assigning a Password to an Excel File Passwords are used to protect a file. You can assign one password to open a file, and a different password to...
Using an Excel IF Statement Combined with a VLOOKUP Function
Did you know that you can use Excel IF statements along with VLOOKUPs? For example, if you wanted to enter a value from a table into a cell, based...
Create a Dynamic Tableau Dashboard
Using Tableau Desktop 2018, you can create Visualizations from information stored in your spreadsheets and databases, giving you the ability to...
How to Work with Automatic Time Grouping in Excel 2016
Automatic Time Grouping, a new feature in Excel 2016, helps use time-related fields in a PivotTable by auto-detecting and grouping them on your...
Using Excel FlashFill
Here's a nice tip on Excel FlashFill...when you need to combine fields or create a new format (e.g., telephone numbers with hyphens), Flash Fill can...
How to Filter Excel Data Using Slicers
PivotTables and PivotCharts are fantastic Excel features that allow you to analyze data. Sometimes you need an easy way to manipulate only specific...
Easily rearrange an object on a single layer in Photoshop
The Content-Aware Move tool is a great new feature in Adobe Photoshop CS6. It's an awesome tool that allows you to move an object to another...
Why use SQL when you have Access?
Access gives you the easy to use query design grid interface for combining data from tables that share one or more related fields. It's simple to...
Build a Drop Cap in Publisher
Ever wonder how to create those awesome looking letters at the beginning of a storybook...like the "O" in "Once upon a time..."? You can do it with...
Using AutoCreate in Outlook
You can use AutoCreate to quickly create new items from existing ones. With AutoCreate, you can drag and drop Outlook items from the view area to...
Create Custom Number Formats in Microsoft Excel
Thousands, Millions, etc. -- Learn about number formats in Excel! If you use a number format like 0, Excel simply writes the number with no decimal...
Save a Microsoft Word Document in a Prior Version
In Microsoft Word 2007 and 2010, you can save an individual document in Word 2003 version by clicking the Office button in 2007 or the File Menu in...
Adobe Dreamweaver allows you to insert a Photoshop Image in a web page as a “Smart Object”
Stay connected to your original Photoshop document. In Dreamweaver Design View, position your cursor where you'd like to insert an image.Choose...