K2's Road to Excellence
|
Upcoming Seminars |
Recorded Seminars
Recording Date |
Title |
Overview |
Partner |
Recommended Webinars |
Jan 19, 2021 |
Throughout the series, we will reinforce key learning points with practical, real-world examples to improve your understanding and comprehension of the topics presented. Part 1 will focus on protecting and securing Excel workbooks and worksheets. |
|||
Feb 11, 2021 |
Part 2 will present Excel's Custom Lists and how to use them to be more efficient. |
|||
Mar 9, 2021 |
Part 3 will present Excel's custom date formats, global assumptions and Precision as Displayed. |
|||
April 13, 2021 |
Part 4 will present how to properly indent, and use conditional formatting to improve readability of reports. |
|||
May 12, 2021 |
Part 5 will focus on Excel options to maximize your efficiency, using formatting macros and including macros in the Quick Access Toolbar. |
|||
June 17, 2021 |
Part 6 will present three different ways to parse data in Excel. |
|||
August 19, 2021 |
Part 7 will present using Table names in formulas, how to use Sumifs, Maxifs, Minifs and demonstrate how to trap errors with Iferror. |