LF logo
by learnformula
search
Log in
search
Courses/Office Productivity/MS Excel

Excel Shortcuts

Tips and Tricks for becoming more productive in Excel

Created byTom Fragaleworkspace_premium
4.5
(166 reviews)
IntermediateUpdated Jun 14, 2025
Excel Shortcuts

What You'll Learn

check_circleMaster essential Excel formulas, functions, and text tools for data analysis.
check_circleAutomate repetitive tasks using macros, custom formats, and error handling.
check_circleImprove data accuracy with validation, conditional formatting, and relative references.
check_circleCustomize your Excel interface with toolbar, ribbon, and shortcut modifications.

About This Course

Take your Excel skills to the next level with this hands-on course designed to boost productivity and efficiency. Whether you're managing data, building reports, or automating tasks, this course covers the most powerful formulas, functions, and customization tools to help you work smarter—not harder.

You’ll learn how to streamline data entry, format sheets for clarity, automate repetitive tasks, and handle errors like a pro. With step-by-step lessons on conditional formatting, macro recording, data validation, and interface customization, you’ll be equipped to handle real-world Excel challenges with confidence.

Your Instructor

Tom Fragale
Tom Fragale

Microsoft Certified Trainer with over 25 Years of Training Experience, and over 40 years in IT overall

menu_book56 courses
star5,752 reviews

Tom Fragale is a computer professional with over 40 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel, and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 50,000 business people in online webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including insurance, manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Copilot, ChatGPT, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access, and another on Excel Pivot Tables. He graduated in 1988 from LaSalle University in Philadelphia, PA with a B.A. in Computer Science.

Credit Information

Do these courses count toward my professional development requirements?

This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.

If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.

What Students Are Saying

4.5
Student's Choice
166 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.