Your entertaining and educational Summer School is here!

Let the Geek Speak!Here’s your technology and soft skills summer school. Attend Millennium Manager – How to Supervise and Manage in the Digital Age at no cost with the discount code ManageMe. Move from zero to hero with Microsoft Excel and PowerPoint with the popular Excelling @ Excel series and How to present like a Pro – PowerPoint Pizazz. Also, Office 365/2013/2013 and Windows 8 in August. Stay tuned and stay informed.
Here are the links to register with the subjects, dates, and times:

Microsoft Office Specialist Certification Support/Study Group Webinar 6

Hi, Let’s continue to Excel @ Excel. With our webinar 6 on Wednesday, March 25, 2015 at 7:00 PM EST. we will increase our Excel learning and march into success as we prepare for the Excel 2013 Core exam. This webinar focuses on the differences between Excel 2010 and 2013 which there are many. Generally, the Microsoft Office Specialist Exams emphasize new features and functionality of the latest and greatest product version. After exploring the new features in 2013 Excel, we will take a practice exam on the new project based 2013 Excel certification.

Register at this link:  http://www.anymeeting.com/PIID=EB56D680894E3D

Here is the replay link after Registering: http://www.anymeeting.com/gregcreech/E157DA828648.

So let’s learn 2013 Excel’s new features and prepare for our MOS certifcation.

Microsoft Office Specialist Certification Study/Support Group Webinar 6

Hi, Let’s continue to Excel @ Excel. With our webinar 6 on Wednesday, March 25, 2015 at 7:00 PM EST. we will increase our Excel learning and march into success as we prepare for the Excel 2013 Core exam. This webinar focuses on the differences between Excel 2010 and 2013 which there are many. Generally, the Microsoft Office Specialist Exams emphasize new features and functionality of the latest and greatest product version. After exploring the new features in 2013 Excel, we will take a practice exam on the new project based 2013 Excel certification. Put on your geek hat as we excel at Microsoft’s Excel 2013.

Register at this link: http://www.anymeeting.com/PIID=EB56D680894E3D

So let’s learn 2013 Excel’s new features and prepare for our MOS certifcation. ENJOY!

Ready to Excel?! Certifications for Excel 2010 and 2013 – March to Success! Let’s Excel!

I have had several requests for 2010 and 2013 Excel MOS webinars. So let’s plan Excel 2010 on Tuesday, February 24, at 7:00 PM EST and Excel 2013 in March. We will work with important formulas and functions in Excel that we are likely to be tested on the exam. I will teach about the syntax of formulas and functions and the different reference types and offer best practices for creating and editing formulas and functions. Then we will take a practice 2010 Excel core exam through GMetrix. If any one has passed an Excel 2010 core exam, let me know; everyone would love to hear of your experience and advice.

Here’s the link for the February 24 MOS Webinar.

In March, we march on to Excel 2013/365 and the more difficult project based exam for 2013 Excel core. In the future get ready for the All Powerful and All Difficult project based Excel Expert 2013 which is unbelievable in the power of new Pivot Tables and new functions. I have asked Melissa Esquibel, MCT and Master at the 2013 level (and beyond to infintity!), to help us through the exam and preparation. .

The future is NOW! Do you know 75% of organizations will convert to Office 2013/Office 365 by next year, based on my IT and HR contacts? As an example. I have one nonprofit and one  government agency as clients, that are converting to Office 2013/Office 365 from Office 2007 and 2010  in March for which I am very grateful.   Practice, Prepare, and Plan for the future of Microsoft Office with these webinars for 2010 and 2013.

So put on your math hat as we concentrate on formulas and functions. Let’s excel with the MOS 2010 and 2013 Excel exams.

Technology Across America with IAAP’s TEC15

I am honored to present in February – April for the International Association of Administrative Professional’s (IAAP) TEC 15 conferences. These technology conferences cover a wide range of technology and office productivity sessions and span a variety of job titles from Administrative/Executive Assistants to Program Managers/Coordinators, Project Managers and Coordinators, CPAs, Lawyers, you name the job title and these conferences benefit. Here is a list of cities and dates:

Here’s the link for more information: http://www.iaap-tec.org/home.

I’m teaching Microsoft’s Office Applications including Data Analysis and Functions of Excel, PowerPoint Pizzazz, Take Note! It’s OneNote, and performing my popular technology humor show, “Technology Bytes: And it just bit my funny bone” at lunch.

Here are links to some of my sessions:

Celebrate TODAY() in Excel!

TechTip: Celebrate TODAY() in Excel. The TODAY() function in Excel is versatile. Simply typing =TODAY() in a cell displays your computer’s current date. Using this function in a formula calculates the information in days. For example, in a blank worksheet in cell A1 type 01/15/2014 and in cell B1 enter =TODAY()-A1. Excel may display the result as date, so change the cell’s format to a number as displayed below. Excel displays the number of days (after changing your format to number). This is great for calculating 30-60-90 day money or days since a customer appointment; anytime you want to calculate the difference in days. The calculations for measuring in years is: =(TODAY()-A1)/365.25; my birthday and age appear below (SHAME!). Both calculations display below in a picture. So, enjoy TODAY()!

Excel's TODAY function

Excel’s TODAY function

Common MS Office Function Keys – Adds Functionality, Saves time

TechTip: In Word, Excel, Outlook (Email, Appointment), and PowerPoint (PC versions) these four Function Keys at the top of your keyboard work the same:

  • F1 is Help (not that I would EVER need help HA!),
  • F7 runs your Spell Checker,
  • F10 is Key Tips (Keyboard shortcuts for using the Ribbon and tabs), and
  • F12 (my personal favorite) key quickly activates Save as for you.

The other Function Keys work differently in the applications, such as F5 is Go To in Excel and Word, but begins your PowerPoint presentation from the beginning and activates Find and Replace in Outlook.

Stay Tuned! Plenty more keyboard shortcuts coming soon.

Fall into Technology Learning Success!

Propeller Geek HatFall into Success with Microsoft Excel and PowerPoint learning plus iPad learning to start the new year. Classes are 8:30AM  – 1:00 PM at First Metropolitan Community Church, 1379 Tullie Road, Atlanta, 30329 (I-85 and North Druid Hills across from Executive Park. The fee is $75 which includes practice files, extensive handout/manual, light breakfast, juice/water, and unforgettable learning.   Click here to register and for more information about the classes.  Here is a schedule of classes:

  • Analyze This! Data Analysis with Excel’s Pivot Table and More – December 11, Tuesday morning
  • PowerPoint FUNdamentals – December 13, Thursday morning
  • PowerPoint Pizzazz – December 20, Thursday morning
  • It All Adds up! Excel’s Formulas and Functions – January 10, 2013, Thursday morning
  • iPad for the iGeneration – January 17, 2013, Thursday, monring