This Microsoft Excel Introduction course equips you with essential skills to build and manage basic spreadsheets. Through practical exercises, you’ll gain proficiency in Excel functions such as using shortcuts, creating formulas, working with ranges, formatting data, and basic data analysis. The course also covers printing and charting, helping to develop strong Excel skills. Whether you're new to Excel courses or need to enhance your data management, this Microsoft Excel course is ideal for learners seeking to build a solid foundation in Microsoft Office courses.
What will you learn?
The objectives of the Microsoft Excel Introduction course are to:
- Give you the knowledge to build, edit, format and print basic spreadsheets
- Introduce the basic principles of creating and using formulae and functions
- Teach users how to create and edit simple graphs
Audience?
Those new to spreadsheets, those who are self-taught or those who have been told what to do and don’t really understand why they are doing things.
Course Contents
Basic principles
- Understanding the screen layout – Ribbons, Icons, QAT, Zoom etc.
- Cursor shapes and their actions
- Cell selection techniques
Working with cells
- Entering and Editing cells
- Using shortcuts
- Autofill and Flash Fill
- Copying and Moving data
- Undo & Redo
- Clear formats
Formulae
- Setting up a basic worksheet
- Creating your own formulae
(Some basic maths is covered) - Order of calculation – BODMAS
- Using in-built functions e.g. sum, average, count, counta
- Relative v Absolute referencing
Formatting
- Text formatting
- Inserting/Deleting rows & columns
- Hide & Unhide Rows/Columns
- Altering column widths and row heights
- Adding Colours/Borders/Shading
- Alignment & Merging cells
- Wrapping text into paragraphs
- Number formatting
- Format painter
- Add/Edit comments
Conditional Formatting
- Use of Data bars, Colour scales & Icon sets
Printing
- Print preview
- Working with Page Break Preview
- Adjusting Margins
- Shrink to fit
- Setting different Print areas
- Headers and Footers
- Repeating heading over multiple pages
Larger documents
- Splitting and freezing
- Zoom
Graphs
- Insert Chart v Quick chart
- Bar/Line/Pie charts
- Adding/Editing:
Headings, Borders, Legends, Data Table - Printing Charts
Course Materials
Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable. These may be either paper based or in Adobe pdf format or a combination thereof.
“"Was great, highly recommend" - Charlotte
"Marko really gauged what was useful and would benefit us and tailored the content accordingly" - Darrelle
”
Charlie, PHV, Excel 365 Advanced
Prerequisites
No prior Excel knowledge is assumed.
Additional Information
Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.
The suggested course duration is a guideline. Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.