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
- Start Excel
- Get help
- Enter information
- Edit information in cells
- Using Undo/Redo
- Save, close, and re-start workbooks
- Exit Excel
- Use Basic Formulas
- Use Functions
- Using AutoFill
- 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
- Hide/Unhide Worksheets
Managing Worksheets Contd…
- Naming Sheets
- Moving Sheets
- Copying Sheets
- Freeze Panes
- Repeat Titles on each Page
- Page Orientation
- Split Screen
- Scale to fit
Formatting Worksheet Information
- Apply currency format
- Apply percent style
- Apply decimals
- Merge and Centre
- Copy and Paste/Transpose
- Apply Borders and Shading
- Deleting formatting
- 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.