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

The Great Canadian Training & Consulting Company Logo

Microsoft PowerPoint Training Courses (Basic)

Our PowerPoint training classes come in two standard levels: one for beginners and one for those who want to learn more advanced features

by The Great Canadian Training & Consulting Company
Willis College Logo

Microsoft Word

Students will be introduced to word processing using Microsoft Word. No prior computer experience is assumed. Students will learn how to create, edit, and format documents and multiple page reports; work with templates, themes, styles, and mail merge; and learn advanced techniques, such as automati...

by Willis College [Claim Listing ]
Tech-knowlogy Inc. Logo

Power Point & Outlook

If you want to present any information creatively and professionally, Microsoft PowerPoint is the perfect tool. With this course, we help you learn how to use Microsoft PowerPoint and start creating memorable PowerPoint presentations.

by Tech-knowlogy Inc. [Claim Listing ]
Mount Royal University Logo

MS Office Pro Extension Certificate

MS Office Pro is a versatile and powerful office productivity software bundle that includes Word, Excel and PowerPoint.

by Mount Royal University [Claim Listing ]
Diamond Learning Logo

MS Word

MS Word course is offered by Diamond Learning. We are a group of highly qualified professionals from different industries. Diamond Learning is based in Saskatoon and offers training classes across western provinces of Canada.

by Diamond Learning [Claim Listing ]

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