Self-Paced
60 Minutes of Excel Secrets
Credits - CEU 0.1 CPE 1.5
Excel is packed with shortcuts, tools, and hidden features that can help you work faster, clean up data, and turn large worksheets into useful insights. This five-part, on-demand course, gives you practical Excel techniques you can use immediately to save time and reduce frustration. You’ll start with essential keyboard shortcuts that help you move, select, edit, fill, and calculate without relying on the mouse. Then you’ll explore powerful text functions like PROPER, UPPER, LOWER, CONCAT, LEFT, and RIGHT to clean, combine, and extract information from messy data. The course also shows you how to merge and total data across multiple worksheets using 3D references, Consolidate, and an introduction to Power Query. You’ll learn how to turn rows of data into quick insights with Sparklines and conditional formatting, including rules that highlight entire rows when action is needed. You’ll also work with PivotTables to group data, create calculated fields, adjust layouts, and summarize information more clearly. Finally, you’ll explore XLOOKUP, including vertical, horizontal, two-way, approximate, and error-handled lookups. Walk away with practical Excel “secrets” that help you work smarter, analyze faster, and build more useful spreadsheets.
Access This Course
PryorPlus 12 Months Access
Best Value
$ 399 CAD
Access this course & thousands more
Training for Teams of 10+
Save up to 30% per employee with course assignment and tracking tools, real-time progress records and a dedicated consultant to support your learning and compliance needs.
Also available in:
Excel Training Collection
$ 99.00 CADIncludes 421 courses
Discounted rates for groups.
Trusted by 3M+ organizations and 13M+ individuals
Covers Excel 2013 and previous versions. Demoed in Excel 365
Information — it's the cornerstone of your career. You are responsible for providing essential data to others and for making smart decisions based on the information you receive. Microsoft® Excel® can help you sift through data to find the information you need, but the process can be time-consuming and frustrating. That's where 60 Minutes of Excel® Secrets training comes in: Through this one-hour webinar, you'll discover the amazing data analysis tools that were created specifically to help you achieve your information goals. In short, you'll learn the hidden Excel tips and tricks!
How many times has this happened? You receive an Excel file, and buried somewhere in all that data is the information you need for a big presentation, to meet your department's sales goals, to figure out who deserves a promotion or to formulate a mailing strategy. Your job is to get to those key performance indicators quickly, efficiently and accurately. Don't sit and stare at row upon row of numbers — this one-hour workshop shows you how to zip through your tasks and turn data drudgery into data done.
This one-hour webinar, brought to you by the creators of the award-winning "Unlocking the Secrets" series, can eliminate the anxiety of data analysis and help you harness the true power of Excel!
If asked today, could you:
- Create a custom AutoFill list?
- Get a quick total with Auto Calculate?
- Add popup instructions for correctly entering data in a cell?
- Use the Format Painter?
If you're not sure how to use even one of these time-saving tools, you must attend this program! This course is an investment in your personal productivity, and you'll find yourself using your newfound knowledge for all kinds of projects. Your work will go faster, your data will be cleaner and more accessible and you'll "wow" your boss by pulling together reports with ease, accuracy and speed.
You and your entire team will benefit from this informative and exciting one-hour class. Find out how to get the most from that spreadsheet — with the Excel shortcuts, tips and tricks the power users know!
- Create time-saving macros
- Customize your Excel environment to match what you do and how you work
- Organize a spreadsheet so that you can see the data you need
- Format cell data so that it appears as it should
- Generate shared spreadsheets that collect data consistently and correctly
- And achieve amazing results for yourself and your organization
You and your entire team will benefit from this informative and exciting one-hour webinar.