Category Archives: Excel

Let’s Pivot! Analytics made easy with Microsoft’s Excel PivotTables

Posted on by

Let’s Pivot! Microsoft’s Excel makes analytics easy with PivotTables. PivotTables summarizes tons of information, so managers can make wise business decisions based on accurate and easy to understand analytics. We’ll include PivotCharts with our PivotTables and use PivotTables for many industries, including sales, human resources, operations, marketing, administration, finance, and more!

This is part of the LOL! Lots of Learning training program, which includes 3+ hour live, Zoom webinar Friday, August 28, 10:00 – 1:30, PDF Manual, practice files, and Certificate of Achievement. All this for $29.99. Thanks and enjoy Pivoting. Thanks! Visit the Excelling @ Excel: PivotTable page for content and a video of our session. ENJOY!

Register for your class here. Thank you!

My Excelling @ Excel training program has enjoyed 20 years of success at universities, conferences, and many clients. This comprehensive technical education on Microsoft’s Excel covers fundamentals, essentials, intermediate, and advanced sessions. Note: These classes are not for those new to Microsoft Office/365 or Excel and have never used the application; a basic understanding of Excel is a requirement. I designed these classes for the novice to advance users of Excel and everyone in between.

I list my full catalogue of Microsoft Excel sessions below as hyperlinks. You’ll find detailed descriptions of these sessions using the class hyperlink. The list is in progression order from casual user to the advance user. Based on your skill level, you may take the classes in any order and subject you like, unless you are a novice user – please use the progression of the classes.

Enjoy Excelling @ Excel with me and boost your Excel skills. Remember: No one has ever been fired or laid off because they knew too much about Microsoft’s Excel! Register for your class here. Thank you!

University of Georgia – 2020 Administrative Professional Conference

Posted on by

 

 

 

 

Welcome! Celebrating 2020 University of Georgia’s
Administrative Professional Conference – Online  Propeller Geek Hat

While we love being together, our online learning with our pre-conference workshop of Intermediate Microsoft Excel and then our breakout sessions for Excelling @ Excel the FUNdamentals proved successful despite the distance. Although separated physically, we enjoyed our sessions through online learning and hope we are together to celebrate next year in person.

Thanks to all attendees. I appreciate UGA letting a USC graduate present, again.

Southeastern Accounting Show!

Posted on by

 

Presenting for one of my favorite organizations and industries – my accounting friends. The Southeastern Accounting Show is a great event with over 1,000 accountants and finance folks in one place; how will there organizations cope with them out of the office for a couple of days?! I love my accountant, Lynn; she keeps me out of jail and off of the IRS nasty list. All businesses, small, large, or, like me, self-employed, must have an accountant, even before a lawyer.

Let’s geek out together in Excel and Microsoft Office! For the attendees and fellow accountants, here are my PowerPoint presentations and some of the files that I use in my sessions.

Excelling @ Excel: Tips N Tricks and Shortcuts

Microsoft Office Made Easy

Excelling @ Excel: Deep Dive

Track – Excel Workbook    Budget – Excel Workbook   Database Functionality – Excel Workbook    VLOOKUP – Excel Workbook  Loan – Excel Workbook 

Word Letter – Word Document  Word Manual – Word Document

Enjoy!

Geeky Greg

Propeller Geek Hat

 

Your entertaining and educational Summer School is here!

Posted on by
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

Posted on by

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

Posted on by

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!

Posted on by

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

Posted on by

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!

Posted on by

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

Posted on by

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!

Posted on by

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