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

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €50.00  (€50.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
2.00
CPD hours:  
2.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

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.