If you are stuck and need help with your Excel work, this workshop is for you! In this hands-on Excel Formula Basics workshop, you’ll learn how to think in formulas and how to write formulas in Excel. By the end of this workshop, you’ll be able to work with Excel’s most commonly used functions and you’ll have the confidence to create your own formulas. Writing Formulas Is Easy Once You Understand The Basics. Don't Get Mad...Get Skills!
My 30 Favorite Excel Power Tips
12/02/21 and 12/03/21
My 30 Favorite Excel Power Tips is a collection of my best Excel tips and tricks. From the most useful to the absolutely bizarre, these power tips will help you become a better Excel user… instantly! Click here and learn more!
Keep on learning - next workshop 15 More of My Favorite Excel Power-Tips: Empower Yourself to Get Faster Better Spreadsheets
02/26/2021 - 7:00 AM PST
It takes years of using the program before you learn all of these “Secrets of Excel." That's why I have developed this webinar full of Shortcuts, Tips, and Tricks that will flatten your learning curve. You will be using Excel like a professional within seconds of participating in this webinar!
Highlights From Past Workshops and Webinars
15 More of My Favorite Excel Power-Tips: Empower Yourself to Get Faster Better Spreadsheets
It takes years of using the program before you learn all of these “Secrets of Excel." That's why I have developed this webinar full of Shortcuts, Tips, and Tricks that will flatten your learning curve. You will be using Excel like a professional within seconds of participating in this webinar! Click here and watch the full replay.
How To Build A Meeting Request Form With Dropdown Lists - 01/29/2021
Have you ever wanted to create a dependent drop-down list in Excel? Or create fields where only the type of data that you allow is determined by what is selected in another field? Click here and watch the full replay.
My 30 Favorite Power-Tips: Empower Yourself to Get Faster Better Spreadsheets 01/08/2020
Revealed: How to Become a Microsoft Office Specialist (MOS) to Get a Promotion and Higher Income - 12/23/2020
Get ready to become more valuable! People are always talking about how you must have a competitive advantage. One advantage that I have benefited from handsomely since 2010, is my MOS and MCT certifications. In this webinar, I will show you exactly how to prepare for and pass the MOS certification exams and earn your MOS badge. Click here to learn more.
Excel Formatting Skills 9/25/2020
Never let the end-user assume anything! Your spreadsheets must be easy to understand. Formatting helps you ensure your spreadsheet's success. Wow! 4.6 billion color variations! With so many colors, and formatting groups like Font, Alignment, Numbers, you can ensure that your spreadsheet will attract attention to the right places.
No fluff here, just skills! As many of you have requested, we are going to get BASIC in this session. The focus will be building your first PivotTable from an Excel workbook that we will provide so that you can follow along and enjoy it.
Calculating Your Data - Ease Into Functions - 8/28/2020
What Is A Function? Preprogrammed Formulas - Excel Does The Math - Check it out! You can manually do the math, or you can have Excel do the math. Which would you prefer? Ever hear of the SUM? What about the AVERAGE? You must have heard of the COUNT? What are they? These are functions in Excel. Think of functions as preprogrammed formulas.
Before we can learn how to build formulas in Excel, we better remember some basic math. Like, the Order of Operations. People work for years in Excel and faint when I introduce them them to their new friend, F4. Let's learn some fundamentals of formula building and formulate your success!
Learn how to tame the "World's Most Dangerous Program."
Come on now! There's the "I'm building good worksheets, and figuring it out along the way" Excel user. Then there is the "I love Excel" power user. Which one are you? Most users are self taught, the Excel power users have wisely used their time to get some BASIC skills and crush their learning curve.
Elements of the Excel Screen - Click This Do What? - 7/29/2020
Elements of the Excel Screen - Click This Do What? To be great at Excel, you have to be confident about where you are clicking on the screen. It takes years off your learning curve when you can navigate Excel with ease.
After this 38-minute session, you will have the confidence you need to start winning at Excel!
Excel PivotTable - The Filter On Steroids - Summarize, Visualize, Analyze! The PivotTable is a great tool that makes it easy for you to summarize large amounts of data into a dynamic and easily modified report. In this webinar we learned what a PivotTable is, how to make one, and some Power Tips and Tricks.
Here is the spreadsheet we used, so that you can follow along.
Easy Excel Macros - 6/24/2020
What is a MACRO? A macro is a recording of a set of steps that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to make minor changes to the way it works, and create buttons and shortcuts to run it.
Follow along with thisspreadsheet. It is the one used to record two macros.