Google Docs Tips and Tricks: A Quick Guide to Get Started

November 13, 2013 Google Docs  No comments

Google’s suite of apps offers a variety of ways for you to create and share information. One of the most used and most beneficial tool that Google offers is their Google Docs. Similar to Word, Google docs allows you to create original text documents. Unlike Word, Google allows you to save your docs online so you can access them from anywhere. Another benefit of Google Docs is that you can share the information with anyone online. The following Google docs tips and tricks are designed to help you begin creating and sharing Google docs today.

Types of Google Docs:

  • Document:
  • Presentation
  • Spreadsheet
  • Form
  • Drawing

Share a Document with Others:

One of the most useful features of Google Docs is that it allows you to share and collaborate with others...

Read More
Excel Charts: A Quick Guide to What You Can Do and Getting Started

November 6, 2013 Excel  No comments

One of the many useful features when using Excel is the ability to create Charts. Charts are a visual representation of data. By making your data presentable and easy to read, you can find important trends, make quick comparisons and present your date in a visually appealing way to executives. Here is a quick guide to different types of Excel charts you can create and how to get started.

Chart Types:

  • Column and Bar Chart: Used to compare multiple values
  • Line Chart: Used to look at continuous data
  • Area Chart: Used to observe differences between several sets of data over time
  • Pie Chart: Used to look at the relationship of pieces to the whole
  • Doughnut Chart: Used like a pie chart, but can display more than one series of data
  • Scatter Chart: Shows the relationship between two sets of data

Tr...

Read More
A Quick Guide to the Excel Macro Button

October 24, 2013 Excel  No comments

Why should you use Macros?

Using macros is a great way to save time by automating tasks that you do often. This eliminates the repetition of doing the same action over and over. It also helps standardize procedures by doing them the same way each time.

Excel Macro Button & the Developer Tab

“Developer” Tab:

The Macros button is located on the “View” tab, but you can also add the “Developer” tab to give you even more options. To add the “Developer” tab, go to the Microsoft Office Button (in the top left-hand corner), select “Options.” Then select “Customize Ribbon” and click on the Developer check box (Office 2010) or check the box “Show Developer Tab” (Office 2007). In the “Code” section of the “Developer” tab, you will find all things Macro.

The “Macro...

Read More
Outlook Calendar Easy Tips to Keep You Organized

October 16, 2013 Outlook  No comments

Outlook calendars have multiple tools available to help you plan and organize. Here are some Outlook Calendar tips and tricks you can begin using today.

Understanding the Lingo:

  • Appointments: Personal engagements that are used only by you
  • Events: All day appointments
  • Meetings/Invited Events: Others are invited

Reoccurring Appointments, Meetings or Events:

The reoccurring meetings or events function is a great way to keep track of events or meeting that occur yearly, monthly, bi-weekly, weekly, or daily. To make an appointment, meeting, or event reoccurring, simply add the appointment into your calendar like you normally would, then click the “Reoccurring” icon on the tool bar. You will be prompted to set the start and end time, the duration, and the reoccurrence pattern (how often)...

Read More
Outlook Time Saving Tips to Make Your Emails Pop

October 11, 2013 Outlook  No comments

With all of the emails you get every day, you need to keep yourself and your inbox organized. Luckily, Outlook’s built-in tools make it easy. Check out these Outlook time saving tips to help you use your email for all its worth.

Quick Parts

With Quick Parts, you can save time by creating reusable content only once. Similar to Gmail’s “Canned Responses,” it allows you to store email messages that you send often, so that you don’t have to retype the same thing each time you want to send that email. To create a Quick Part, type what you want included, then highlight it. From there, go to the “Insert” tab and click on the “Quick Parts” button and choose “Save Selection to the Quick Part Gallery...

Read More
Excel Dashboards Simple Tips for Easy Creation

October 4, 2013 Excel  No comments

Dashboards are a visual interpretation of data that act as an interactive reporting tool and give you a comprehensive snapshot of your data. They are created with a specific goal or purpose in mind, so it saves the user time and energy, because they don’t have to perform their own analysis of the data. Consequently, the data is more focused and relevant, so dashboards are able to communicate information more accurately and faster. This post will give you the Excel Dashboards simple tips to get started today.

Read More
Excel Formatting Top Tips: Easy Ways to Save Time!

September 18, 2013 Excel  No comments

With Excel, you can use formatting tools to make your worksheets look better and keep your data organized. Check out these great tips and tricks to make use of all the formatting features Excel has to offer.

 

Free...

Read More
Get to Know Our Speakers: An Interview with MS Office Guru Melissa Esquibel

August 30, 2013 Speaker Interviews  No comments

We here at Desktop Training Academy know the importance of being able to trust the ability of experts. It is with that in mind that we conducted the following interview with Office expert and trainer, Melissa Esquibel, to get to know her and her mission to inform working professionals better. Melissa is a technology consultant, coach, trainer, and speaker with over 25 years’ experience in the field. She frequently presents webinars for Desktop Training Academy.

What ...

Read More