Excel Business Analysis
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.
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.
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.
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.
Detailed Course Breakdown and Sample Lessons:
Section 1: Introduction to Excel
Lesson 4: Entering and Editing Data
Lesson 5: Saving a Wordbook as an .XLSX
Lesson 6: Saving a Workbook in a
different file format
Lesson 6: Closing a Workbook
Lesson 6: Setting Excel File Defaults
Section 2: Selecting Cells and Ranges
Lesson 2: Selecting Cells, Rows and Columns
Lesson 3: Moving, Copying and Deleting Cells
Lesson 4: Using Undo and Redo
Lesson 5: Finding and Replacing Values
Section 3: Modifying a Worksheet
Lesson 2: Inserting, Deleting and Renaming a worksheet
Lesson 3: Worksheet Views
Lesson 4: Clearing and Deleting Cells
Lesson 5: Inserting and Deleting Rows and Columns
Lesson 6: Modifying Column and Row Size
Lesson 7: Freezing and Unfreezing Rows and Columns
Section 4: Modifying a Worksheet
Lesson 2: Formatting cells using the font group
Lesson 3: Changing cell alignments
Lesson 4: Formatting numbers and dates
Lesson 5: Cell Borders and Patterns
Lesson 6: The Format Painter
Section 5: Building Simple Formula
Lesson 2: Basic Operators
Lesson 3: Using the SUM function
Lesson 5: Using the AVERAGE function
Lesson 6: Using the COUNT function
Lesson 7: Using the MAX function
Lesson 8: Using the MIN function
Lesson 9: Using the ROUND function
Lesson 10: Using the IF function
Lesson 11: Common formula errors
Section 6: Absolute and Relative Referencing
Lesson 2: Using the AutoFill Tool
Lesson 3: Relative Referencing
Lesson 4: Absolute Referencing
Section 7: Sorting Data
Section 8: Charts and Graphs
Lesson 2: Inserting and Deleting a chart
Lesson 3: Moving and Resizing a Chart
Lesson 4: Editing the Chart type
Lesson 5: Chart Layouts and Labels
Lesson 6: Editing the Axes and Gridlines
Lesson 7: Formatting Selected Items in a chart
Lesson 8: Printing a Chart
Lesson 9: Special Features for Pie Charts
Section 9: Importing Text and Graphics
Lesson 2: Inserting Images onto an Excel Sheet
Lesson 3: Importing Text Files (*.TXT)
Section 10: Printing and Page Setup
Lesson 2: Excel Sheet Views and Inserting Headers & Footers
Lesson 3: Settings in Page Setup
Lesson 4: Scaling our Data for Printing
Section 11: Printing and Page Setup
Lesson 2: Using the HELP function in Excel
Section 12: Sharing Workbooks with Others
Lesson 2: Save and Send Options
Lesson 3: Using Comments in Excel
Lesson 4: Using Hyperlinks
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
When you pass that you will receive an internationally recognised accreditation certificate like this:
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 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.
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
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.
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.
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.
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.
There is a reason we keep coming back – our productivity increases substantially after every course.
I really enjoyed the course, learned a lot and feel more equiped for day to day work with excel.
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.
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.
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.