Advanced Excel

by CPA Alberta Claim Listing

If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly course, you will learn critical advanced Excel skills in six key areas:

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

CPA Alberta Logo

img Duration

7 Hours

Course Details

If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly course, you will learn critical advanced Excel skills in six key areas:

1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. 
 
The content of this course draws from over twenty-five years of experience in delivering Excel training to accountants and other business professionals and throughout the program, relevant, real-world examples reinforce the major topics presented.

You do not want to miss this opportunity to become more efficient and proficient in Microsoft Office Excel, the accounting and financial professional’s tool of choice. This course covers advanced Excel topics found in Excel 2007 through Excel 2016. 

 

Learning Objectives:

Upon completing this course, you should be able to:

  • Identify and implement the best techniques to secure sensitive information in Excel workbooks and collaborate with other users to improve accuracy and efficiency
  • Create 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
  • Import and link data into Excel from external sources – including text, Access, and SQL Server – and use advanced tools, such as Power Query and various cleanup tools to manipulate the data  to meet specific needs
  • Use advanced functions, such as SUMPRODUCT, VLOOKUP, HLOOKUP, MATCH, INDEX, NETWORKDAYS, RAND, RANDBETWEEN, NPV, IRR, XNPV, and XIRR to create and audit complex formulas
  • Analyze worksheet data using techniques such as Data Tables, Subtotals, Slicers, Filters, and PivotTables
  • Describe techniques used to create, manipulate, and customize charts for analyzing and communicating information 
  • Calgary Branch

    800-444 7 Avenue SW, Calgary
  • Edmonton Branch

    1900 TD Tower, 10088 – 102 Avenue, Edmonton

Check out more MS Excel courses in Canada

OptionTrain College of Management and Technology Logo

Microsoft 365 Excel ( Beginner)

If you are new to Excel, this course will teach you the essential skills needed to start using Excel spreadsheets. You will learn to navigate with ease, enter data into spreadsheets, manipulate data, format data, and start creating formulas and using functions.

by OptionTrain College of Management and Technology [Claim Listing ]
DJH Training & Application Solutions Inc. Logo

MS Visio

MS Visio course is offered by DJH Training & Application Solutions Inc. DJH Training & Application Solutions Inc. provides its clients with high quality computer training, support and application development services.

by DJH Training & Application Solutions Inc. [Claim Listing ]
Versalys Logo

Visio (2013/2016/2019/2021/365)

Produce a wide variety of diagrams and format them elegantly, from editing to printing.

by Versalys [Claim Listing ]
AFI Expertise Logo

Access Basics

Discover Access with this program. Learn how to manipulate records, format a table structure and create a database. Please note that the version most represented in the group will be installed on all computer stations, but the differences between the versions will be addressed during the training.

by AFI Expertise [Claim Listing ]
PMVISION Logo

Microsoft Word Training Courses (Advanced Level)

This Microsoft Word Advanced Level course is designed for Microsoft Word users who are keen to extend their understanding and knowledge of the Microsoft Word beyond basic document creation so that they can create and work with features such as SmartArt, indexes, master documents, interactive fields...

by PMVISION [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy