Manage worksheets, perform calculations, manipulate data, format worksheets
If attending this course, it is ESSENTIAL to bring along your own laptop with the required software installed (Microsoft Excel 2013)
31st October 2019
A good working knowledge of Excel is vital for most professionals today, particularly those based in an office environment, and stronger Excel skills can open the door to promotion and leadership opportunities. Excel is a powerful tool but cannot function alone. It requires someone to take advantage of everything Excel has to offer to provide the best results for their company.
This one-day introductory class covers all the basics of Microsoft Excel, showing attendees how to enter and edit information in a worksheet, manage and navigate worksheets, perform calculations and manipulate worksheet data, format the worksheet contents, and prepare, set up, and print information.
On leaving this course, attendees should be able to enter and edit information in a worksheet, manage workbooks and navigate worksheets and workbooks. The user will be able to perform basic calculations on worksheet data, manipulate the data, format the contents of a worksheet and prepare, set up and print information. All delegates will also receive a full course pack to refer back to at any time.
Prerequisites: Delegates should be familiar with PC’s/Laptops and have used a mouse and keyboard; be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.
All attendees will get a chance to engage in an informative Q & A session, and will receive a highly informative course pack, and leave with 5 structured CPD Points.
Working with Worksheets and Workbooks
Edit information in cells
Save, close, and re-start workbooks
Use Basic Formulas
Understand the Order of Operations
Understand and create Relative, Absolute, and Mixed References
Linking calculations across sheets
Navigate a Worksheet using the Keyboard
Insert/Delete Columns and Rows
Resize Columns and Rows
Hide/Unhide Columns and Rows
Managing Worksheets Contd…
Repeat Titles on each Page
Scale to fit
Formatting Worksheet Information
Apply currency format
Apply percent style
Merge and Centre
Copy and Paste/Transpose
Apply Borders and Shading
Wrap Text and Line Breaks
Checking and Printing Information
Check Spelling in a Worksheet
Preview a Worksheet,
Set the Page Options and Margins
Add Headers and Footers
Insert and remove Page Breaks
Print a Worksheet
Set a Print Area
Who Should Attend?
This course would be ideal for those who require a basic grounding in Microsoft Excel, this course will provide you with the knowledge to enter and edit information in a worksheet, manage and navigate worksheets, perform calculations and manipulate worksheet data, format the worksheet contents, and prepare, set up, and print information.
On completion of this one-day training course, you will receive your CMG MasterClass Certificate as well as your CPD Certificate containing 5 Structured CPD Hours. Please note certificates are issued at the close of the training course to participants who complete the full five hours.
This training course costs €395 EARLY-BIRD (Normal rate €495). The price includes course documentation and training pack, teas and coffee, snacks, biscuits, fruit on arrival. Lunch is a light fare containing freshly cut sandwiches, wraps, a selection of teas and coffee. Alternatively, you can avail of the local food stores and coffee shops within a one-minute radius of the training centre for hot food or alternative lunch options.