Course description
This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.
Upcoming start dates
Choose between 6 start dates
Outcome / Qualification etc.
Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.
Training Course Content
Getting Started with Excel
- Navigate the Excel User Interface
- Use Excel Commands
- Create and Save a Basic Workbook
- Enter and Edit Cell Data
- Fill Cells with Series of Data (AutoFill and Flash Fill)
- Use Excel Help
Performing Calculations
- Create Worksheet Formulas
- Insert Functions and use Autocomplete
- Reuse Formulas and Functions
- Create an Absolute Reference
Modifying a Worksheet
- Insert, Delete, and Adjust Cells, Columns, and Rows
- Move and Copy Data between Cells
- Search for and Replace Data
- Use Spellcheck and Proofing
Formatting a Worksheet
- Apply Text Formats
- Apply Number Formats
- Align Cell Contents
- Apply and Copy Cell Styles
- Apply Basic Conditional Formatting
Printing Workbooks
- Preview and Print a Workbook
- Controlling Page Layout
- Adding Headers and Footers
- Set Print Titles and Print Ranges
Managing Workbooks
- Manage Worksheets
- Insert and Delete Worksheets
- Manage Workbook and Worksheet Views
- Manage Workbook Properties
Request info
Nexus Human
Level 30, Leadenhall Building, 122 Leadenhall Street
EC3V 4AB London
Nexus Human
For over 20 years Nexus Human has specialised in IT and Business Skills Training and Certification in the UK and Ireland. What makes Nexus Human different is putting people at the core of what we do. We deliver both private...
Ads