Excel Level 2

Intermediate Level

12 chapters, 55 lessons, 12 hours

This course has over 12 hours of eLearning lessons, downloadable exercise files to help you learn and the ability for you to pause, rewind and repeat any of the lessons whenever you need.

View course breakdown and sample lessons


Overview

What does the course cover?

New to Excel? This course provides a thorough grounding in working with Excel from the ground up. You'll learn how to open and close files, how to enter formulae into a cell, build basic charts and format a spreadsheet. This course introduces you to the power of Microsoft Excel starting from the beginning. You'll learn how to use the most important features of Excel and use the most common spreadsheet formulae.

Aims

Why take this course?

This course covers everything from an introduction to how Excel works, selecting cells and modifying worksheets - right through to building formulas, sorting data and creating basic charts and graphs.

Audience

Who should attend?

Anyone needing to learn how to use Excel or those familiar with other spreadsheet programmes but new to Microsoft Excel - and anyone who has not used the product for a period of time.

excel_apprentice

Detailed Course Breakdown and Sample Lessons:

Section 1: Introduction to Excel

Lesson 1: Introduction
View Demo
Lesson 2: Starting Excel
View Demo
Lesson 3: Touring Excel
Demo Not Available
Lesson 4: Entering and Editing Data
View Demo
Lesson 5: Saving a Wordbook as an .XLSX
Demo Not Available
Lesson 6: Saving a Workbook in a different file format
View Demo
Lesson 6: Closing a Workbook
View Demo
Lesson 6: Setting Excel File Defaults
View Demo

Section 2: Selecting Cells and Ranges

Lesson 1: Introduction
View Demo
Lesson 2: Selecting Cells, Rows and Columns
View Demo
Lesson 3: Moving, Copying and Deleting Cells
View Demo
Lesson 4: Using Undo and Redo
View Demo
Lesson 5: Finding and Replacing Values
View Demo
Lesson 6: Spell
View Demo

Section 3: Modifying a Worksheet

Lesson 1: Introduction
View Demo
Lesson 2: Inserting, Deleting and Renaming a worksheet
View Demo
Lesson 3: Worksheet Views
View Demo
Lesson 4: Clearing and Deleting Cells
View Demo
Lesson 5: Inserting and Deleting Rows and Columns
View Demo
Lesson 6: Modifying Column and Row Size
View Demo
Lesson 7: Freezing and Unfreezing Rows and Columns
View Demo

Section 4: Modifying a Worksheet

Lesson 1: Introduction
View Demo
Lesson 2: Formatting cells using the font group
View Demo
Lesson 3: Changing cell alignments
View Demo
Lesson 4: Formatting numbers and dates
View Demo
Lesson 5: Cell Borders and Patterns
View Demo
Lesson 6: The Format Painter
View Demo

Section 5: Building Simple Formula

Lesson 1: Introduction
View Demo
Lesson 2: Basic Operators
View Demo
Lesson 3: Using the SUM function
View Demo
Lesson 4: Using AutoSUM
View Demo
Lesson 5: Using the AVERAGE function
View Demo
Lesson 6: Using the COUNT function
View Demo
Lesson 7: Using the MAX function
View Demo
Lesson 8: Using the MIN function
View Demo
Lesson 9: Using the ROUND function
View Demo
Lesson 10: Using the IF function
View Demo
Lesson 11: Common formula errors
View Demo

Section 6: Absolute and Relative Referencing

Lesson 1: Introduction
View Demo
Lesson 2: Using the AutoFill Tool
View Demo
Lesson 3: Relative Referencing
View Demo
Lesson 4: Absolute Referencing
View Demo

Section 7: Sorting Data

Lesson 1: Introduction
View Demo
Lesson 2: Sorting Data
View Demo

Section 8: Charts and Graphs

Lesson 1: Introduction
View Demo
Lesson 2: Inserting and Deleting a chart
View Demo
Lesson 3: Moving and Resizing a Chart
View Demo
Lesson 4: Editing the Chart type
View Demo
Lesson 5: Chart Layouts and Labels
View Demo
Lesson 6: Editing the Axes and Gridlines
View Demo
Lesson 7: Formatting Selected Items in a chart
View Demo
Lesson 8: Printing a Chart
View Demo
Lesson 9: Special Features for Pie Charts
View Demo
Lesson 10: Sparklines
View Demo

Section 9: Importing Text and Graphics

Lesson 1: Introduction
View Demo
Lesson 2: Inserting Images onto an Excel Sheet
View Demo
Lesson 3: Importing Text Files (*.TXT)
View Demo

Section 10: Printing and Page Setup

Lesson 1: Introduction
View Demo
Lesson 2: Excel Sheet Views and Inserting Headers & Footers
View Demo
Lesson 3: Settings in Page Setup
View Demo
Lesson 4: Scaling our Data for Printing
View Demo

Section 11: Printing and Page Setup

Lesson 1: Introduction
View Demo
Lesson 2: Using the HELP function in Excel
View Demo

Section 12: Sharing Workbooks with Others

Lesson 1: Introduction
View Demo
Lesson 2: Save and Send Options
View Demo
Lesson 3: Using Comments in Excel
View Demo
Lesson 4: Using Hyperlinks
View Demo

Top 10 skills you'll learn

Of the thousands of different things you can learn within Excel, here are the top 10 you will learn on this course:

  • Navigate your way around a spreadsheet
  • Open, Save and Close workbooks
  • Select cells, rows and columns
  • Build simple formulas
  • Sort and organise data
  • Import data from other applications
  • Perform "what-if" analysis
  • Create and enhance charts
  • Start to print and export into presentations

How you can apply these skills?

Our Excel course shows in a series of practical hands on lessons how to use Excel in everyday life such as:

  • Perform sales analysis
  • Calculate expenses
  • Design budgets
  • Create invoices
  • Creating a wide range of other powerful real world Excel spreadsheets

Certification

When you pass that you will receive an internationally recognised accreditation certificate like this:
Excel_Apprentice_Certificate

What's next?

Upon completion, you can move onto Excel Level 2, then 3. After you have completed the 3 levels you will be ready to take the Expert or Specialist courses in Excel for advanced Certification and for preparation for the Microsoft Certification exams.

Careers that require these skills at this level?

Excel is used in practically every business and in nearly all departments in those businesses - ranging from sales to accounting and administration. Any office role will require you to be proficient to this level.

What people have said about this course:

I really enjoyed the course, learned a lot and feel more equiped for day to day work with excel.
Aoife Lawless – Astra Zeneca
There is a reason we keep coming back – our productivity increases substantially after every course.
Martin Dorgan – Leaseplan
I found this course to be very good. The instructor was very knowledgeable and professional and had a very good teaching manner. She was also patient and supportive.
Tom Kinsella - Eircom
I wanted to learn excel for my new Operations Manager job. Level 1 and 2 taught me what I needed to know so I felt confident using excel.
Kim Turner - Manager at Westwood
I wanted to learn more about excel as its use becomes increasingly prevalent in work. I found the course from iactonline easy to follow and engaging. I learned quickly and keep dipping back into the course whenever I have a query.
Francis O'Toole - Professor at Trinity College Dublin
As an MD of 20 years, I wanted to get a better grip of Excel to speed up quotes. I bought annual membership for each of my finance team and it’s been great. They work more efficiently and in a much more streamlined way.
Steve Jones - MD at Tarpey Harris Engineering
When setting up my new business, I quickly realised I needed excel knowledge. I bought levels 1,2 and 3 from iactonline and I’m now up and running. I liked the way the instructor was really seemed to understand when to go into more detail on a topic. I couldn’t have set up my accounts without it.
Niall Boon - Sole trader
I have several Excel training courses in the past, usually in book form and have always struggled with them, but E Learning is the most student centred course I have tried. It is easy to navigate around and has given me the confidence I lacked in the past with Excel.
Adrian Webster - Retired solicitor
I needed to learn excel to make tracking client invoicing easier. I liked the way I could pick and choose what I wanted to learn and I now use excel every day! Best €20 a month I spend, it’s saved me loads of time. Thank you
Stephen McElhinney - Web designer
I’ve been using excel for years, but really wanted to learn more about the complex aspects of it. I bought annual membership from iactonline and have completed four courses so far. Courses are enjoyable and easy to follow – it’s a great resource and I’m now the guy in the office that people go to with an excel query.
David Kerrigan - 3
I wanted to do an online course to help me standardise some spreadsheets in the office. After reviewing all the options, I decided to go with iactonline because they seemed the most professional. I wasn’t disappointed, the course was easy to follow and the files I downloaded were really helpful. I’d recommend them to anyone.
David Buxonat - Barcelona


[ratingwidget]

Excel Level 1 – Foundation

$99.00

The sidebar you added has no widgets. Please add some from theWidgets Page