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

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!

LOL!

Featured

LOL! Laugh Out Loud? Lots Of Love? As an instructor, LOL is Lots Of Learning. LOL (Lots Of Learning) is my new training program. LOL includes:

  • 3+ hour Zoom, live, interactive webinar 10:00 AM – 1:30 PM EST with 20 minute “virtual lunch/breakfast” break,
  • Extensive PDF manual on the subject,
  • Practice files,
  • Certificate of Achievement (for CPE/CEU credit).

All this for only $29.99. Special Bonus Offer! When you register and complete four classes at any time (unlimited time offer!), you’ll receive a greeting card with a refund of $20, as a reward for your achievement, reducing the cost to $24.99 per class.

But, wait there’s more… The LOL program includes technical, soft-skills, and combination classes. Each bullet below is hyperlink, so click on your subject and enjoy. Here are some of the upcoming sessions:

Pricing is for individuals and is charged one person for each session. If your organization would like a custom LOL! session with multiple students, including the Zoom class, PDF manual, practice files, and certificate of achievement, please contact me at creechgreg@bellsouth.net for pricing and procedures. THANKS!

LOL? You can have it all; love, laughter, and learning with this LOL! training program. This website provides a full list of offerings, dates, and course objectives and descriptions. To register visit my Shopify online store. Thank you and enjoy!

Welcome to Hotlanta! AHCAP’s 30th Annual Conference

Association for Healthcare Administrative Professionals welcome to Hotlanta and enjoy your 30th Annual Conference in our beautiful and warm (weather and friendliness) city. I am excited and honored to speak at this terrific conference where I’ll have a pre-conference Microsoft Office 365 workshop in the morning and the Opening Keynote presentation “The 5Ps to Success: Practice, Persistence, Perseverance, Patience, and Play” in the afternoon. With “Breakthrough to Excellence” as the theme for this conference, the opening keynote provides practical ways of achieving excellence and success, plus much laughter and piano music along the way.

Here are hyperlinks for the Microsoft Office 365 PDF handout and the Excel, Word, and PowerPoint files for you. Enjoy and Happy Computing!

Microsoft Office 365: Tips N Tricks and Shortcuts

Excel Budget

Excel Track

Excel Flash Fill

Word Letter

Word Manual

PowerPoint Pizzazz!

 

Southeastern Accounting Show!

 

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

 

Enjoy an autumn Admin, HR, and Operations Conference with Nancy and Greg, Fri, Oct. 13, 8:30 – 4:00

We have postponed this event until the spring, stay tuned. Thanks!

Put on your soft skills and geek hats! It isPropeller Geek Hat an Education Celebration!

Autumn – The Season of Learning

A Training Day designed  for Administrative, Human Resources, and Operations Professionals

Hosted and Presented by
Nancy Colter and Greg Creech
Register Here!

Friday, October 13, 2017,  8:30—4:00 PM   

City of Light Church, 3125 Presidential Parkway, Atlanta, GA 30340

Learn soft and technical skills with these general
sessions:

  • Time Management and Using Outlook (Nancy and Greg),
  • HR and Administrative Data Analysis using Excel’s PivotTables (Greg),
  • Working with Difficult People (Nancy),
  • Presentation Skills and effective PowerPoint Presentations (Nancy and Greg).

Cost is $110 per person (register before October 1), $125 after October 1.
Save $25! Groups registering five or more people may register for $100 per person.

Includes four general sessions, handouts, lunch, prizes and entertainment. Register at this link or through gregcreech.com or  gregcreech.biz.

Enjoy!

Conferences in St. Augustine and Tucson

Recently I presented at the 2017 Florida Secretarial Leadership Conference on Winning Communication tools in St. Augustine, FL and then at the 2017 TEC IAAP conference on Access Relational Databases and Windows. Two very different areas of the country and two very different subject matters. I enjoy the diversity of our nation and the diversity of my clients and programs. I appreciate the opportunities and the great travel.

NEW! Windows 10 and Office 2016 Books and Classes

I have a new Windows 10 manual updated for the Anniversary Edition and a hot-of-the-press Office 2016 and More manual. The “Win with Windows 10” book covers new features, like Cortana, Task View, and Settings. The “Sweet 16! Office 2016 and More” book includes versions 2010 and 2013 and covers new features and productivity with Excel, Word, PowerPoint, and Outlook. These comprehensive books provide current Windows and Office clients with full color and step-by-step instructions with big fonts and lots of screen shots.

Order your books today at this link to my on-line store.

IAAP – Success Skills for the Administrative Supervisor and Manager

Hi,

Here are materials for being a successful administrative supervisor and manager. I use these materials for my webinars and on-site presentations. I would love to hear back from you and about your experiences in supervisory/management roles greg@gregcreech.com. Thanks!

Success Skills for the Administrative Supervisor and Manager – PDF

TIPS Form

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:

Happy Valentines! Free OneNote manual and webinar.

Happy Valentine’s!

Happy ValentinesFall in love with being an organizational maestro with Microsoft’s OneNote – a notebook for the digital age. I love my clients and friends and celebrate with technology gifts of Microsoft’s OneNote.  Let’s learn and have fun – download the 2010/2013 OneNote Manual as a PDF and register for the webinar. Webinar is WOneNoteednesday, February 18, 11:00 AM – 12:30 PM – use the Discount Code – loveonenote to register and attend at no fee with this link. Enjoy! 

 

MOS Webinar 4 – Project Based Exams

Thanks to Kathi Robinson, CAP-OM and MOS, our webinar proved successful with educating everyone on theses items:

  • Differences between task oriented exams and project oriented exams
  • Best learning tools and resources for preparation
  • Important tips and tricks in taking practice exams, such as the Reset and Save buttons
  • Her example of why as an Executive Assistant she is building and using Microsoft Access

After her interview, we demonstrated taking an Access 2013 project oriented training exam.

If you have not registered, you will need to register before watching the replay.

Here is the Registration Link: http://www.anymeeting.com/PIID=EB54DC84844639

Here is the Recording Link: http://www.anymeeting.com/gregcreech/E153DE858846

Our next webinar is Tuesday, February 27, 2015 at 7:00 PM EST. Let me know the application and version that you would like for our webinar.

Happy Computing and best wishes on your certification path.

 

MOS Support/Study Group – Webinar 3 and 2015 Plan

My Geek Hat

Hi, Everyone!
Special thanks to Richard Hemma, Senior Director of Sales Corporate and Commercial Pearson – Certiport for his presentation and information. He provided valuable information on the value of certifications, taking exams, location issues, and offered members of this MOS Study/Support Group a free trial of GMetrix – the practice test and training tool for MOS certifications. You will want to register and view this webinar. Here are the links: Registration link and Recording link.

Here are quick notes from the webinar and our plan for 2015.

  • Locations must honor vouchers from IAAP, Certiport, and other organizations. Locations may set their own hours and offerings and may charge a proctoring fee.
  • When taking an exam use the Ribbon rather than keyboard shortcuts, such as CTRL + S for Save, CTRL + C for Copy and so on. Using keyboard shortcuts rather than the Ribbon for commands may make part or all of a question incorrect.
  • You may use the new Office 2007, 2010, and 2013 feature entitled Key Tips as keyboard shortcuts by pressing the F10 or ALT key to activate the badges for Key Tips.
  • In the future there may be a re-certification process similar to the Adobe associate certification; however, once you certify as a Microsoft Office Specialist in a particular application and version that certification lasts forever.
  • Several webinar participants commended GMetrix for the practice tests and using the product.
  • We discussed text books; there are plenty of resources and books available. My personal favorite and that I recommend are the QUE In Depth series which are more detailed that most Office books. Richard concurred that these books follow the domains and learning objectives for the applications.
  • FREE! Richard will provide a free GMetrix trial for those people in this MOS Study/Support Group. I will collect emails and information over the next two weeks and provide them to Richard. If there is a limit to the number, I will prioritize the list based on regular attendance of these webinars including viewing the recording. Look for details in the coming weeks. Email me at creechgreg@bellsouth.net if you wish to be part of the GMetrix free trial offer.

In 2015, we will continue our monthly (or so) webinars with the next webinar in mid-January. We will update our certification plan and process and answer several exam questions for two applications. Plan now to make your New Years resolution about certifying next year and perhaps as you wait for Santa take some practice tests and study! I’ll send the content, date, and time for January’s webinar after January 2. Happy Holidays and Enjoy your learning.