Module 1 – Entering Data, Selection
- Familiarisation
- Selection techniques
- Insert/Delete/Resize Rows & Columns
- Copy/Cut/Paste/ Find & Replace
- Worksheets
- Autofill
Module 2 – Formatting data- Font /Alignment Formatting
- Number Formatting
- Format Painter
- Conditional Formatting
Module 3 – Formulas & Functions- Creating Formulas
- Operators
- Relative & Absolute Ref
- Named cells
- Creating Functions
- Sum/Average/Max/Min/Count
- Autosum
- Error messages
Module 4: (2hrs) (Optional for In-house training)- Printing
- Views
- Headers & Footers
- Worksheet Margins, Orientation, Page size
- Backstage
- Info
- Share/Export
- Options
- Case Study – Consolidation of all modules
Upon successful completion of this course, students will be able to:
- Explore the Excel 2016 environment
- Work with an Excel worksheet by entering and selecting the data in it, as well as saving the data in the worksheet
- Modify a worksheet
- Perform calculations
- Format a worksheet
- Develop a workbook
- Print workbook contents
- Customise the layout of the Excel application window
- Create charts
This course is for those who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2016 worksheets.
This course is one of a series of courseware titles that addresses Microsoft Certified Application Specialist skill sets. The Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Application Specialist certification.
All delegates who successfully complete this course will receive an electronic certificate of attendance.
We deliver our Microsoft Excel Introduction course throughout the UK and beyond. We can facilitate onsite at your premises, as a virtual training option for those who are working from home or at any number of venues in Belfast, Glasgow, Edinburgh, Aberdeen, Inverness, Newcastle, Manchester, Leeds, Birmingham, Cardiff or London. Contact Us for more information or click the green button below to see when we are next running this as an open course anyone can attend.
Chat with us via Whatsapp