If attending this course, it is ESSENTIAL to bring along your own laptop with the required software installed (Microsoft Excel 2013)
Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. If utilised correctly, the benefits of Microsoft Excel cannot be overstated. Due to the program’s capability of formatting data, performing calculations, analysing data and integrating information, a working knowledge of Excel is vital for most office based professionals today.
On leaving this course, you will be able to enter and edit information in a worksheet, manage workbooks and navigate worksheets and workbooks. You 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.
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.
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, you will receive your CMG MasterClass Certificate as well as your CPD Certificate containing 5 Structured CPD Hours. Please note certificates are issued only at the end of the training course to participants who complete the full five hours.
This course costs €375 (Early-bird), normal rate is €425. Includes course documentation and light refreshments. While the course fee does not include lunch, we do provide freshly made sandwiches, Nespresso coffee and a range of teas and fresh juice for those who require a light lunch. Alternatively, you can avail of the local food stores and coffee shops opposite the training center for hot food or alternative lunch options.