Excel Course for Beginners. Suitable for existing Excel users or those who are new to Excel. Learn the foundations of Microsoft Excel.
Beginners
1 Day
Certification Awarded
Online Resources
Course overview
- This course introduces you to the power of Microsoft Excel starting from the beginning. You’ll learn how to open, close and save files, how to enter formulae into a cell, build basic charts and format a spreadsheet. You’ll learn how to use the most important features of Excel.
Skills you’ll learn
- Better understanding of Excel fundamentals
- Work with basic functions/formulas
- Manage better looking spreadsheets
- Format and edit proficiently
- Sort and organise data better
Who would benefit
- Anyone needing to learn how to use Excel or those familiar with other spreadsheet programmes but new to Microsoft Excel, or anyone who has not used the product for a period of time. If you’re about to start a new role, or are looking for a new position, this course is ideal.
Why take this course
- If you’re new to Excel or are going to be using Excel in the future, you’ll need to understand the fundamentals. This course will provide you with a solid platform from which you can learn. By completing this course, you’ll save yourself a lot of time when using Excel.
Certification
- At the end of the course, you’ll be Certified by the Irish Academy of Computer Training.
- CPD Certification
Requirements
- No prior knowledge is needed
- Software is provided in the Classroom and Live Virtual options
Learning paths
- Progress to our Excel Advanced Course
- Complete as part of MOS Certification
- Part of IACT’s Microsoft 365 Learning Path
Why choose IACT
- Ireland’s leading training provider for 30 years
- Full-time Certified Trainers who use the software every day
- Smaller class sizes to accelerate learning
Course curriculum
Module 1: Introduction to Excel
- Starting Excel
- Opening a Workbook
- Understanding the Display Screen
- Working with the Ribbon
- Exploring the File Tab
- Working with the Quick Access Toolbar
- Working with the Status Bar
- Switching Between Opened Workbooks
- Using Excel Help
Module 2: Entering Data
- Moving the Cell Pointer
- Selecting a Range of Cells
- Creating a New Workbook
- Inserting, Renaming, and Deleting Worksheets
- Entering Constant Values
- Using Auto Fill to Enter Data
- Saving a Workbook
- Editing Cell Contents
- Clearing Cell Contents
- Working with Undo and Redo
- Closing a Workbook
Module 3: Using Formulas
- Entering Formulas
- Using Auto Fill with Formulas
- Using the SUM Function
- Summing Columns or Rows Automatically
- Using Statistical Functions
- Working with the Range Finder
- Using Formula Error Checking
Module 4: Working with Constant Values and Formulas
- Copying and Pasting Constant Values and Formulas
- Cutting and Pasting Constant Values and Formulas
- Using Collect and Paste
Module 5: Formatting Worksheets
- Formatting Numbers
- Changing the Font Format
- Aligning Cell Contents
- Merging Cells
- Adding Borders
- Applying Cell Styles
Module 6: Modifying Columns and Rows
- Changing Column Width
- Changing Row Height
- Inserting and Deleting Columns or Rows
- Hiding Columns or Rows
Module 7: Editing Workbooks
- Working with AutoCorrect
- Checking Spelling
- Using Find and Replace
Module 8: Printing Worksheets
- Using Print Preview
- Working with Print Settings
- Using Page Setup Tools
- Working in Page Layout View
- Creating a Header and Footer
- Using Page Break Preview
- Printing a Worksheet
- Exiting Excel
Contact us.
We'll reply quickly.
Enquiry
I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.