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

Citi College - Canada Logo

Computerized Office Application

Citi College offers a 16-week diploma program in Computerized Office Application. This program will help individuals attain knowledge and skills in using popular software programs essential for entry-level careers.

by Citi College - Canada [Claim Listing ]
ICIT Canada Knowledge Logo

Excel Refresher

This Excel Refresher is designed to cover all essential Excel tools, from beginners to advanced levels, that we feel everyone dealing with numbers should be an expert in, especially if he is working as an analyst or in the accounting and finance field

by ICIT Canada Knowledge [Claim Listing ]
The Great Canadian Training & Consulting Company Logo

Microsoft Access Training

Learn how to plan and create a database from scratch and how to use tables, queries, and forms to maintain and customize your data. You’ll also be linking to other database sources and seeing the results as you generate reports.

by The Great Canadian Training & Consulting Company
CTC Computer Training Logo

Microsoft Outlook 2016

Microsoft Outlook is not just about email. It is a  full Personal Information Manager that contains email, calendar, contact, tasks and note elements. Use multiple calendars to manage both your business and personal life in one screen.

by CTC Computer Training [Claim Listing ]
Working Skills Centre Logo

Microsoft PowerPoint 2013

PowerPoint takes your MS Word document and brings it to life. You will learn to create slides using wizards and many of the software’s functions to show off your data, charts, photos, and other information.

by Working Skills Centre [Claim Listing ]

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