Free Excel 2013 Self-Paced Courses By Microsoft

excel 3013 logo

Click here  to check the beginner, intermediate and advanced Excel 2013 courses.

Posted in Excel | 2 Comments

Free Self-Paced Training Courses for Access 2013 By Microsoft

access 2013 logo

Access this link for beginner and intermediate self-paced courses for Access 2013 produced by Microsoft.

 

Posted in Access | 2 Comments

Download my Student Exercise Files on OneDrive

Locate and download the student training files I use in class.

Click here to search and download the training files.

They are located in my shared public OneDrive folders.

OneDrive

Posted in OneDrive, Training Files | Tagged | Leave a comment

3 Parts to a Query Formula in Access

There are three parts to a query formula. The field name, colon, and the formula. From the query design view, click in the next available blank field. Then type what you would like to name the field. Follow with a colon, then the formula. User defined field names have square brackets around them.

access query

A view from the Query design will look like the following screenshot below.
Access query formula

Another option is to right click the formula field in the query design view then click build. This option is nice because you can double click on the field to insert it in the formula. It also helps avoid typo mistakes.
Expression Builder access query

Posted in Access | Leave a comment

How To Make an Excel Chart of the Spurs vs Heat Game 5 NBA Finals [Video]

This Youtube video will teach you the new Chart features in Excel 2013. I created a line chart that uses data points for each team’s scoring totals at the quarters. Game 5 of the NBA finals between the San Antonio Spurs and Miami Heat was exciting if you are a Spurs fan! The Spurs played exciting basketball and won with teamwork.

Posted in Excel | Tagged | Leave a comment

Easily Remove Double Spaces After Each Sentence in Word

To space or double space after each sentence– that is the question? Well, if you are like me, you learned in high school that you should space twice after each sentence. Well that was so the 90s. The standard today is one space after each sentence.

So if you are needing to do a double space to single space make  over in Word, use the find and replace feature.

Access the find and replace tool by clicking Control + H as the keyboard shortcut. Also find replace command from the Home tab–> Editing group. Just click the binocular icon for find and replace.

find and replace word

Type two spaces in the find what box. Type one space in the replace with box. Click replace all. Word will then report how many instances it replaced.

Inspect all spaces in the document by clicking on the show/hide button. Every space in the document will display as a tiny dot. This makes it easy to see if you have 1 or 2 spaces(represented with dots) after each sentence.

show hide word

 

Posted in Word | Leave a comment

Excel Icon Sets Conditional Formatting Reports [Video]

This video post will share how to create a report in Excel using Icon Sets. Icon Sets are part of the conditional formatting. I share how to customize the icons. For example, each cell with a poor performance will have a red flag icon. Green circle icons will appear next to the cells with the best performance. Overall, the conditional formatting will help communicate data with your team.

If you liked this video, please sign up on my email list for notifications of my future posts to your inbox.

Posted in Excel | Tagged | 1 Comment