K2's Advanced Excel - Webcast
Overview
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas:
- Collaborating seamlessly with other users and securing your workbooks
- Utilizing tables to analyze and report data efficiently
- Integrating and manipulating data from external sources with ease
- Creating and auditing complex formulas
- Harnessing advanced data analysis tools for deeper insights
- Employing visualization techniques to communicate information effectively
Drawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills!
Highlights
- Collaboration and security techniques
- Tables, data models, and PivotTables
- Advanced formulas
- Data queries
- Creating effective visualizations
Prerequisites
Experienced Excel user
Designed For
Business professionals who work with Excel and want to extend their knowledge with advanced features and functions.
Objectives
- Formulate the best techniques to secure Excel data and collaborate with others efficiently.
- Evaluate the usefulness of tables and take advantage of their advanced features, such as dynamic data ranges, structured reference formulas, and the ability to relate multiple tables together into a Data Model.
- Assess Power Query's capability to link and transform data from external data sources into Excel.
- Formulate calculations that reference functions such as XLOOKUP, GROUPBY, PIVOTBY and others.
- Evaluate worksheet data using techniques such as Data Tables, Subtotals, Slicers, Filters, and PivotTables.
- Assess techniques used to create, manipulate, and customize charts for analyzing and communicating information.
Leader(s):
Leader Bios
Lawrence McClelland, K2 Enterprises
Lawrence A. (Mac) McClelland, MBA, JD, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas.
Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting.
He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence.
Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.
(3/22/21)
Non-Member Price $395.00
Member Price $315.00