Select Page
Excel Course for Beginners

Excel Course for Beginners. Suitable for existing Excel users or those who are new to Excel. Learn the foundations of Microsoft Excel.

g

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

CPD Certification

Requirements

  • No prior knowledge is needed
  • Software is provided in the Classroom and Live Virtual options

Learning paths

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

  • This field is for validation purposes and should be left unchanged.

I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.

0
YOUR CART
  • No products in the cart.