Efficient Excel Formulas and Functions: A Comprehensive Mini Course
Efficient Excel Formulas and Functions: A Comprehensive Mini Course - with Shelley Fishel - The MS Office Maestro
Unlock the Power of Excel – Master Formulas and Functions for Effortless Data Management.
Welcome to “Efficient Excel Formulas and Functions,” your gateway to becoming a proficient Excel user. This comprehensive mini course is meticulously crafted to take you through the intricacies of Excel, empowering you with the skills needed for efficient data manipulation and analysis.
What's Inside?
Master the Essentials
Dive deep into the world of absolute and partial absolutes, ensuring precision in your calculations. Understand the versatility of named ranges and learn how to define and scope them effectively.
Conditional Magic:
Unravel the secrets of conditional calculations – from SUMIF and SUMIFS to AverageIF and more. Harness the power of IF statements, nested IFs, VLOOKUP, INDEX-MATCH combinations, and unleash the true potential of your data.
Visualize with Charts:
Create visually appealing charts that not only showcase your data but also seamlessly link to Word or PowerPoint for impactful presentations.
Text and Date Mastery:
Manipulate text effortlessly with a selection of text functions. Navigate the intricacies of date functions like NOW(), TODAY(), DAYS(), NETWORKDAYS(), and NETWORKDAYS.INTL().
Formula Auditing:
Gain confidence in auditing your spreadsheets, ensuring accuracy and reliability in your data-driven decisions.
Introduction to Macros:
Demystify macros with our introductory module. Learn to record, add to the toolbar, and create a personal macro workbook for enhanced efficiency.
Why Choose Our Course?
- In-Depth Learning: Our course goes beyond the basics, providing you with a deep understanding of Excel formulas and functions.
- Practical Application: Hands-on exercises reinforce your learning, ensuring practical proficiency.
- Expert Instruction: Learn with Shelley Fishel – The MS Office Maestro an IT Trainer with over 22 years of experience.
- Lifetime Access: Access course materials for a lifetime, allowing you to revisit and reinforce your skills whenever needed.
- Certification: Receive a certificate of completion, validating your expertise in Excel.
How long is the course?
This comprehensive mini course is designed to be completed at your own pace, it is 1 hour and 40 minutes in total.
Most lessons are between 5 and 7 minutes long although some are shorter, and a few may be longer.
Enrol Now and Transform Your Excel Experience!
Don’t miss out on the opportunity to boost your Excel proficiency. Join our “Efficient Excel Formulas and Functions” mini course today and take the first step toward mastering Excel with confidence.
Course Curriculum
Shelley Fishel
Meet Shelley Fishel – Your Microsoft Office Maestro
Shelley’s path has been anything but ordinary. She left school at 17 to run her father’s business, gaining hands-on experience in managing priorities—something every assistant knows all too well.
When her children grew up, she returned to work and found her calling - helping assistants master Microsoft Office. With over 20 years of training experience, 10,000+ hours delivered, and 2.5 million books sold worldwide, Shelley is a trusted expert in her field.
She holds respected industry qualifications: COLF (Certified Online Learning Facilitator), CDOL (Certified Designer of Online Learning), and is a Fellow of the Learning and Performance Institute (FLPI).
Why Assistants Love Learning from Shelley
- She gets it. Shelley understands the unique pressures assistants face and tailors her training to your world.
- No tech-speak. Just clear, practical steps you can use right away—no Googling required.
- It works. One client cut a 3-hour task down to 30 minutes after just one session.
As one learner put it, “Shelley’s like the angel on my shoulder.” Her bite-sized lessons help you work smarter, faster, and with confidence—so you can shine in your role
