View Cart

Data manipulation & formatting

Summary

This hands-on, beginner course by Kubicle is designed to get you quickly up and running in Microsoft Excel. It is focused on radically improving your productivity. You will learn the most useful keyboard shortcuts for to navigate, select, insert, edit, delete and sort data at a lightning-fast pace. customized for Chartered Accountants Ireland by kubicle.com

Description

Product type:

CPD online course

Category:

Kubicle, Technology and data

Who Should Attend?

This course is suitable for beginner learners who have a very basic level of familiarity with Microsoft Excel. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 15 lessons, 3 exercises and 1 Exam. It covers the following topics:

Getting to know the user interface
Keyboard shortcuts
Adding, editing and deleting data
Keyboard shortcuts for Excel navigation
Keyboard shortcuts for cell selection
Inserting rows & columns
Adjusting columns & rows
Freeze panes, split boxes & zoom
Formatting numbers
Formatting cells
Grouping and hiding cells
Paste special
Sorting and filtering data

Key Outcomes

Once you have completed this course you will have a greater understanding of the value of efficient Excel practices. You will also learn the fundamentals of manipulating spreadsheet data at a rapid pace. By applying the skills gained from this course, you’ll gain the confidence to accomplish tasks in Excel much faster than before.