Excel Online Certificate Course

From Fundamental To Advanced In Microsoft Excel

Excel Online Certificate Course

NOW ONLY

NZ$249

Save NZ$150 (38%)
OFF RRP NZ$399
or 4 interest-free payments of $62.25 with Learn more
Get Info Pack

Study Excel Online Course Become an Instant Microsoft Excel Expert

Our Excel Online Course will give students a complete overview of Excel’s most advanced and fundamental capabilities. As they work through a series of Excel activities related to the course, students will gain a better understanding of how to use this software package. 

Even though it has been in use for over twenty-five years, the Excel program is still one of today’s office’s most widely used and vital software tools. The application’s great functionality, ease of use, and compatibility with other Microsoft Office programs make it the preferred spreadsheet program.

When you first start working with Excel, it might be challenging. On the other hand, this online course will swiftly get pupils up to speed to navigate the Excel environment with ease.

The Excel Online Course offers students the core skills needed to utilize the program effectively. This course will show you how to properly style spreadsheets to display data so that other users can comprehend it. You will discover how to use all of the formatting tools in the most effective way possible. After completing this course, you will know how to use colors, fonts, borders, and patterns effectively. You will also learn how to control the size and content of cells.

Before being introduced to more advanced procedures, students will be shown how to conduct basic calculations. Furthermore, the advanced features of Microsoft Excel and the use of formulae are covered in the Excel Online Course. The last session will assist you in unlocking the potential of Excel and improving your competence and efficiency with it.

What you will learn in a Microsoft Excel Online Course:

  • An overview of Excel and the areas of business that use Excel
  • The Excel environment, worksheets, toolbars, and ribbons
  • Basic excel skills including cells, saving, exporting and more
  • The art of formatting, fonts, text alignment, colors, and rows
  • How to calculate, formulas functions and more
  • Sorting and filtering data

Who would benefit from this Microsoft Excel Certification Online Course

This comprehensive Certificate in Excel Course is perfect for complete beginners and intermediate level Excel users looking to master the more advanced features of the programme.

What are the benefits of an Excel Online Course?

By studying a Microsoft excel online course you will learn techniques to get more out of excel and perform advanced tasks such as creating pivot tables and complex reports.

Microsoft Excel Online Course Quick Facts:

  • Learn Microsoft Excel fundamentals
  • Comprehensive 9 module Microsoft Excel certification course online
  • Study MS Excel following simple instructions and demonstrations
  • The course has been developed and written by prominent Microsoft Excel experts
  • One on one online support and help is available when needed
  • Unlimited, lifetime access to the online Microsoft Excel course
  • Students who achieve a passing score will receive a Microsoft Excel online training certificate of completion.
  • Learn how to use MS Excel at your own pace with no requirement to adhere to class timetables
  • Course content is available 24/7 using any computer or smart device with Internet access

Excel Online Course Outline

Module 1: Excel: An Overview

Part 1: The Beginnings of MS Excel

After its initial release in 1985, Microsoft Excel has grown to become one of the most significant programming programs in the current workplace. Many individuals can use Excel to create a small business's revenue outlook, calculate a multinational company's annual report, or manage a half-dozen other schedules, lists, or plans in between.

Topics to be discussed include:

  • The Beginnings of MS Excel
  • The Advantages of MS Excel
  • Time Saving
  • Fact Checking
  • Budgeting
  • Data Analysis
  • List Creation and Management
  • Form Design and Creation
  • Ongoing Data Access

Part 2: Common areas of business that use MS Excel

With all of the benefits mentioned above and more, it is clear that MS Excel is useful in almost every industry. If an individual is handling budgets, creating client relationships, designing marketing strategies, analyzing revenue, or monitoring overall business success, the likelihood that they will open Excel is high.

Topics to be discussed include:

  • Finance and Accounting
  • Sales
  • Marketing and PR
  • Human Resources (HR)

Module 2: The Excel Environment

Part 1: The Excel Worksheet

This module is designed to help you understand the fundamental Excel world and how to navigate it effectively. It, like the rest of the modules, is built on Excel 2013. If they have previously used MS Excel 2010 or 2007, you might be familiar with areas such as the Quick Access Toolbar, Ribbon, and Backstage View.

Topics to be discussed include:

  • The Excel Worksheet (Spreadsheet)

Part 2: How to Use and Customize the Quick Access Toolbar

This module is designed to help you understand the fundamental Excel world and how to navigate it effectively. It, like the rest of the modules, is built on Excel 2013. If they have previously used MS Excel 2010 or 2007, they might be familiar with areas such as the Quick Access Toolbar, Ribbon, and Backstage View.

Topics to be discussed include:

  • Add Other Commands to the Quick Access Toolbar
  • Removing Commands
  • Customizing the Ribbon
  • Minimize the Ribbon

Part 3: Spreadsheet

There are many options to display worksheets in an Excel workbook, including regular view, table layout view, and page split view. When they first open Excel, the standard view is the main view - the one they can see. At the bottom of their list, they can see tabs for your open spreadsheet, as well as a plus sign icon to add new sheets.

Topics to be discussed include:

  • Workbook
  • Backstage View

Module 3: Basic Excel Skills

Part 1: Introduction to Cells

People who work in business development, plan budgets, organize and analyze data, or perform routine administrative tasks will benefit from a thorough understanding of Microsoft Excel, as stated in Module 1. Even if their work does not actually require any of the above functions, it is worthwhile to have more than a passing familiarity with an Excel spreadsheet.

Topics to be discussed include:

  • Introduction to Cells
  • Cell Ranges
  • How to Select a Cell Range
  • Cells and Data
  • Entering Data into Cells
  • Deleting Data from Cells
  • Cutting and Pasting Cell Content
  • Drag and Drop Cells
  • Using Flash Fill
  • Replacing Cell Content

Part 2: Sharing, Saving & Exporting Workbooks

Workbooks is added in Module 2. A workbook is a set of worksheets or spreadsheets in an Excel format. In Excel, starting a new project entails developing a new workbook. A individual may also be familiar with the process of creating a new workbook, but it is often possible to open an old workbook that they or another person saved previously.

Topics to be discussed include:

  • How to Open an Existing a Workbook
  • Saving a Workbook
  • Difference between Save and Save As
  • Auto Recover
  • Exporting Workbooks
  • Export a workbook in other file types
  • Sharing Workbooks

Module 4: The Fine Art of Formatting

Part 1: Formatting Fonts

Formatting a job is more about making things look polished and professional; it's all about making sure the material you're providing is transparent and understandable to anybody who interacts with the spreadsheet. Creating this level of consistency also tends to reduce the likelihood of mistake, which is clearly critical in any Excel workbook.

Topics to be discussed include:

  • Formatting Fonts
  • Changing Cell Fonts
  • Changing Font Size
  • Changing the Font Color
  • Font Styles

Part 2: Text alignment

When you type text into the worksheet, it will default to the bottom-left corner of the cell. Numbers, on the other side, would be positioned in the bottom-right corner by chance. However, if they discover that this makes the material on their spreadsheet more difficult to understand, they should re-align the cell text.

Topics to be discussed include:

  • Formatting Text and Numbers

Part 3: Applying Colors, Borders and Patterns

Using colors, shapes, and borders to enhance the cells is one way to distinguish different data within parts of the spreadsheet. In addition to assisting them in clearly organizing documents, both will make the data look even better.

Topics to be discussed include:

  • Cell Styles
  • Create a custom cell style
  • Cancelling a cell style

Part 4: Modifying Columns and Rows

It might be appropriate to increase the width of a column or the height of a row when formatting the worksheet. Row heights will automatically adjust to match the size of the row material. Column widths can also change automatically, but it is more likely that they may need to be modified manually to ensure that the data falls inside them.

Topics to be discussed include:

  • AutoFitting the Width
  • Inserting, deleting, moving, and hiding rows and columns
  • Wrapping and Merging Text
  • Conditional Formatting

Module 5: How to Calculate with Excel

Part 1: Understanding Formulas

According to a 2014 study conducted by the Business Application Research Center (BARC), when it comes to tech solutions, MS Excel is the most commonly used planning method, with 86 percent of American survey respondents using it for project planning and budgeting.

Topics to be discussed include:

  • Understanding Formulas
  • Order of Precedence
  • Creating Simple Formulas

Part 2: Benefit of Cell References

The main advantage of using cell references is that your calculations are still right. That even though the number or value of the referenced cells changes, the formula remains unchanged.

Topics to be discussed include:

  • Cell Reference Types
  • Circular References
  • Checking for Other Mistakes in your Formulas
  • Editing your Formula
  • Understanding Functions
  • Where to Find Functions in Excel
  • Quotation Marks in Excel Formulas
  • Creating Functions
  • Insert a Function

Part 2: Nesting Functions

You may use AND and OR functions alone or in conjunction with IF functions to obtain even more insight into your results. In reality, you can integrate a wide range of Excel functions. This is known as nesting, because it means nesting one feature inside another.

Topics to be discussed include:

  • Date and Time Functions
  • VLOOKUP Function

Module 7: Sorting and Filtering Data

Part 1: Sorting

This module explains when sorting and filtering are most useful and how to apply various forms of sorting and filtering methods to their Excel results.

Topics to be discussed include:

  • Sorting
  • Types of sorting
  • Custom sorting
  • Sorting levels

Part 2: Filtering

It can be difficult to locate details easily if the worksheet includes a lot of content. Filters may be used to filter down the details on their worksheet, allowing them to see just what they need to see.

Topics to be discussed include:

  • Advanced Filtering

Module 8: Charts and Graphics

Part 1: Understanding Charts

Excel's ability to generate maps, graphs, and tables, as well as integrate different graphics into its spreadsheets, is one of its most thrilling features. A image is worth a thousand words, and graphics and diagrams will make data easier to read while still making it look informative and compelling.

Topics to be discussed include:

  • Understanding Charts
  • Inserting a Chart

Part 2: How To Modify Your Chart

Perhaps a user would like to change the way some of their data is displayed in their table. They may choose to rearrange the rows and columns so that different content is brought to the forefront, or just organize it in a manner that makes it easy to search and absorb.

Topics to be discussed include:

  • Tables
  • Modifying tables

Part 3: Pivot Tables

Creating PivotTables is an excellent method for students to explore a large amount of data in their worksheet. PivotTables are reports that allow you to sum, count, average, and do other calculations based on the reference points you reach. They will switch between different types of reports without having to produce a new one - hence the term "pivot"!

Topics to be discussed include:

  • Recommended PivotTables
  • Changing PivotTable Layouts
  • Pivoting Data

Part 4: Sparklines

Sparklines are tiny maps that fit into a single cell and provide data information. Because of their size, they can fit a lot of sparklines into a single workbook. Sparklines are useful for a variety of purposes, not the least of which is that they can provide a concise analysis of data at a very superficial level, eliminating the need to delve further into the data.

Topics to be discussed include:

  • Types of Sparklines
  • Modifying Sparklines
  • How to Insert ClipArt, Pictures and Other Images into Excel
  • Inserting SmartArt and Shapes into Excel

Module 9: Viewing & Printing

Part 1: Viewing

Depending on the work being done in Excel, different display choices will be used to inspect the results. There are certainly occasions when they are dealing on different classes of knowledge in their workbook and need to look at all the details or compare the groups together.

Topics to be discussed include:

  • Freeze Panes
  • How to split a worksheet
  • Opening Multiple Windows for a Single Workbook

Part 2: Page Layout, Orientation and Formatting

Viewing a job on their computer screen isn't often enough; they still need to look at it off-line. They will want to print a workbook to view and post their data online at times. If they've decided on their page layout, they can easily display and print a workbook from Excel using the Print pane.

Topics to be discussed include:

  • Preparing a Workbook for Printing
  • Page layout
  • Page orientation
  • How to insert a page break
  • How to insert headers and footers
  • Printing Your Workbook

Recognition & Accreditation

Upon completion of your course assessment, you will receive 3 certificates. An accredited certificate from the awarding body relating to your course, a CPD certificate displaying the number of CPD points earned from the course and a certificate of completion.

Module 1: Excel: An Overview

  • Part 1: The Beginnings of MS Excel
  • Part 2: Common areas of business that use MS Excel
  • Module 1 Assessment

Module 2: The Excel Environment

  • Part 1: The Excel Worksheet (Spreadsheet)
  • Part 2: How to Use and Customize the Quick Access Toolbar (QAT) and the Ribbon
  • Part 3: Spreadsheet (worksheet) views
  • Module 2 Assessment

Module 3: Basic Excel Skills

  • Part 1: Introduction to Cells
  • Part 2: Sharing, Saving & Exporting Workbooks
  • Module 3 Assessment

Module 4: The Fine Art of Formatting

  • Part 1: Formatting Fonts
  • Part 2: Text alignment
  • Part 3: Applying Colours, Borders and Patterns
  • Part 4: Modifying Columns and Rows
  • Module 4 Assessment

Module 5: How to Calculate with Excel

  • Part 1: Understanding Formulas
  • Part 2: Benefit of Cell References
  • Module 5 Assessment

Module 6: Advanced Formulas and Functions

  • Part 1: More about Operators
  • Part 2: Nesting Functions
  • Module 6 Assessment

Module 7: Sorting and Filtering Data

  • Part 1: Sorting
  • Part 2: Filtering
  • Module 7 Assessment

Module 8: Charts and Graphics

  • Part 1: Understanding Charts
  • Part 2: How To Modify Your Chart
  • Part 3: Pivot Tables
  • Part 4: Sparklines
  • Module 8 Assessment

Module 9: Viewing & Printing

  • Part 1: Viewing
  • Part 2: Page Layout, Orientation and Formatting
  • Module 9 Assessment

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

About this Course

Study Excel Online Course Become an Instant Microsoft Excel Expert

Our Excel Online Course will give students a complete overview of Excel’s most advanced and fundamental capabilities. As they work through a series of Excel activities related to the course, students will gain a better understanding of how to use this software package. 

Even though it has been in use for over twenty-five years, the Excel program is still one of today’s office’s most widely used and vital software tools. The application’s great functionality, ease of use, and compatibility with other Microsoft Office programs make it the preferred spreadsheet program.

When you first start working with Excel, it might be challenging. On the other hand, this online course will swiftly get pupils up to speed to navigate the Excel environment with ease.

The Excel Online Course offers students the core skills needed to utilize the program effectively. This course will show you how to properly style spreadsheets to display data so that other users can comprehend it. You will discover how to use all of the formatting tools in the most effective way possible. After completing this course, you will know how to use colors, fonts, borders, and patterns effectively. You will also learn how to control the size and content of cells.

Before being introduced to more advanced procedures, students will be shown how to conduct basic calculations. Furthermore, the advanced features of Microsoft Excel and the use of formulae are covered in the Excel Online Course. The last session will assist you in unlocking the potential of Excel and improving your competence and efficiency with it.

What you will learn in a Microsoft Excel Online Course:

  • An overview of Excel and the areas of business that use Excel
  • The Excel environment, worksheets, toolbars, and ribbons
  • Basic excel skills including cells, saving, exporting and more
  • The art of formatting, fonts, text alignment, colors, and rows
  • How to calculate, formulas functions and more
  • Sorting and filtering data

Who would benefit from this Microsoft Excel Certification Online Course

This comprehensive Certificate in Excel Course is perfect for complete beginners and intermediate level Excel users looking to master the more advanced features of the programme.

What are the benefits of an Excel Online Course?

By studying a Microsoft excel online course you will learn techniques to get more out of excel and perform advanced tasks such as creating pivot tables and complex reports.

Microsoft Excel Online Course Quick Facts:

  • Learn Microsoft Excel fundamentals
  • Comprehensive 9 module Microsoft Excel certification course online
  • Study MS Excel following simple instructions and demonstrations
  • The course has been developed and written by prominent Microsoft Excel experts
  • One on one online support and help is available when needed
  • Unlimited, lifetime access to the online Microsoft Excel course
  • Students who achieve a passing score will receive a Microsoft Excel online training certificate of completion.
  • Learn how to use MS Excel at your own pace with no requirement to adhere to class timetables
  • Course content is available 24/7 using any computer or smart device with Internet access

Excel Online Course Outline

Module 1: Excel: An Overview

Part 1: The Beginnings of MS Excel

After its initial release in 1985, Microsoft Excel has grown to become one of the most significant programming programs in the current workplace. Many individuals can use Excel to create a small business's revenue outlook, calculate a multinational company's annual report, or manage a half-dozen other schedules, lists, or plans in between.

Topics to be discussed include:

  • The Beginnings of MS Excel
  • The Advantages of MS Excel
  • Time Saving
  • Fact Checking
  • Budgeting
  • Data Analysis
  • List Creation and Management
  • Form Design and Creation
  • Ongoing Data Access

Part 2: Common areas of business that use MS Excel

With all of the benefits mentioned above and more, it is clear that MS Excel is useful in almost every industry. If an individual is handling budgets, creating client relationships, designing marketing strategies, analyzing revenue, or monitoring overall business success, the likelihood that they will open Excel is high.

Topics to be discussed include:

  • Finance and Accounting
  • Sales
  • Marketing and PR
  • Human Resources (HR)

Module 2: The Excel Environment

Part 1: The Excel Worksheet

This module is designed to help you understand the fundamental Excel world and how to navigate it effectively. It, like the rest of the modules, is built on Excel 2013. If they have previously used MS Excel 2010 or 2007, you might be familiar with areas such as the Quick Access Toolbar, Ribbon, and Backstage View.

Topics to be discussed include:

  • The Excel Worksheet (Spreadsheet)

Part 2: How to Use and Customize the Quick Access Toolbar

This module is designed to help you understand the fundamental Excel world and how to navigate it effectively. It, like the rest of the modules, is built on Excel 2013. If they have previously used MS Excel 2010 or 2007, they might be familiar with areas such as the Quick Access Toolbar, Ribbon, and Backstage View.

Topics to be discussed include:

  • Add Other Commands to the Quick Access Toolbar
  • Removing Commands
  • Customizing the Ribbon
  • Minimize the Ribbon

Part 3: Spreadsheet

There are many options to display worksheets in an Excel workbook, including regular view, table layout view, and page split view. When they first open Excel, the standard view is the main view - the one they can see. At the bottom of their list, they can see tabs for your open spreadsheet, as well as a plus sign icon to add new sheets.

Topics to be discussed include:

  • Workbook
  • Backstage View

Module 3: Basic Excel Skills

Part 1: Introduction to Cells

People who work in business development, plan budgets, organize and analyze data, or perform routine administrative tasks will benefit from a thorough understanding of Microsoft Excel, as stated in Module 1. Even if their work does not actually require any of the above functions, it is worthwhile to have more than a passing familiarity with an Excel spreadsheet.

Topics to be discussed include:

  • Introduction to Cells
  • Cell Ranges
  • How to Select a Cell Range
  • Cells and Data
  • Entering Data into Cells
  • Deleting Data from Cells
  • Cutting and Pasting Cell Content
  • Drag and Drop Cells
  • Using Flash Fill
  • Replacing Cell Content

Part 2: Sharing, Saving & Exporting Workbooks

Workbooks is added in Module 2. A workbook is a set of worksheets or spreadsheets in an Excel format. In Excel, starting a new project entails developing a new workbook. A individual may also be familiar with the process of creating a new workbook, but it is often possible to open an old workbook that they or another person saved previously.

Topics to be discussed include:

  • How to Open an Existing a Workbook
  • Saving a Workbook
  • Difference between Save and Save As
  • Auto Recover
  • Exporting Workbooks
  • Export a workbook in other file types
  • Sharing Workbooks

Module 4: The Fine Art of Formatting

Part 1: Formatting Fonts

Formatting a job is more about making things look polished and professional; it's all about making sure the material you're providing is transparent and understandable to anybody who interacts with the spreadsheet. Creating this level of consistency also tends to reduce the likelihood of mistake, which is clearly critical in any Excel workbook.

Topics to be discussed include:

  • Formatting Fonts
  • Changing Cell Fonts
  • Changing Font Size
  • Changing the Font Color
  • Font Styles

Part 2: Text alignment

When you type text into the worksheet, it will default to the bottom-left corner of the cell. Numbers, on the other side, would be positioned in the bottom-right corner by chance. However, if they discover that this makes the material on their spreadsheet more difficult to understand, they should re-align the cell text.

Topics to be discussed include:

  • Formatting Text and Numbers

Part 3: Applying Colors, Borders and Patterns

Using colors, shapes, and borders to enhance the cells is one way to distinguish different data within parts of the spreadsheet. In addition to assisting them in clearly organizing documents, both will make the data look even better.

Topics to be discussed include:

  • Cell Styles
  • Create a custom cell style
  • Cancelling a cell style

Part 4: Modifying Columns and Rows

It might be appropriate to increase the width of a column or the height of a row when formatting the worksheet. Row heights will automatically adjust to match the size of the row material. Column widths can also change automatically, but it is more likely that they may need to be modified manually to ensure that the data falls inside them.

Topics to be discussed include:

  • AutoFitting the Width
  • Inserting, deleting, moving, and hiding rows and columns
  • Wrapping and Merging Text
  • Conditional Formatting

Module 5: How to Calculate with Excel

Part 1: Understanding Formulas

According to a 2014 study conducted by the Business Application Research Center (BARC), when it comes to tech solutions, MS Excel is the most commonly used planning method, with 86 percent of American survey respondents using it for project planning and budgeting.

Topics to be discussed include:

  • Understanding Formulas
  • Order of Precedence
  • Creating Simple Formulas

Part 2: Benefit of Cell References

The main advantage of using cell references is that your calculations are still right. That even though the number or value of the referenced cells changes, the formula remains unchanged.

Topics to be discussed include:

  • Cell Reference Types
  • Circular References
  • Checking for Other Mistakes in your Formulas
  • Editing your Formula
  • Understanding Functions
  • Where to Find Functions in Excel
  • Quotation Marks in Excel Formulas
  • Creating Functions
  • Insert a Function

Part 2: Nesting Functions

You may use AND and OR functions alone or in conjunction with IF functions to obtain even more insight into your results. In reality, you can integrate a wide range of Excel functions. This is known as nesting, because it means nesting one feature inside another.

Topics to be discussed include:

  • Date and Time Functions
  • VLOOKUP Function

Module 7: Sorting and Filtering Data

Part 1: Sorting

This module explains when sorting and filtering are most useful and how to apply various forms of sorting and filtering methods to their Excel results.

Topics to be discussed include:

  • Sorting
  • Types of sorting
  • Custom sorting
  • Sorting levels

Part 2: Filtering

It can be difficult to locate details easily if the worksheet includes a lot of content. Filters may be used to filter down the details on their worksheet, allowing them to see just what they need to see.

Topics to be discussed include:

  • Advanced Filtering

Module 8: Charts and Graphics

Part 1: Understanding Charts

Excel's ability to generate maps, graphs, and tables, as well as integrate different graphics into its spreadsheets, is one of its most thrilling features. A image is worth a thousand words, and graphics and diagrams will make data easier to read while still making it look informative and compelling.

Topics to be discussed include:

  • Understanding Charts
  • Inserting a Chart

Part 2: How To Modify Your Chart

Perhaps a user would like to change the way some of their data is displayed in their table. They may choose to rearrange the rows and columns so that different content is brought to the forefront, or just organize it in a manner that makes it easy to search and absorb.

Topics to be discussed include:

  • Tables
  • Modifying tables

Part 3: Pivot Tables

Creating PivotTables is an excellent method for students to explore a large amount of data in their worksheet. PivotTables are reports that allow you to sum, count, average, and do other calculations based on the reference points you reach. They will switch between different types of reports without having to produce a new one - hence the term "pivot"!

Topics to be discussed include:

  • Recommended PivotTables
  • Changing PivotTable Layouts
  • Pivoting Data

Part 4: Sparklines

Sparklines are tiny maps that fit into a single cell and provide data information. Because of their size, they can fit a lot of sparklines into a single workbook. Sparklines are useful for a variety of purposes, not the least of which is that they can provide a concise analysis of data at a very superficial level, eliminating the need to delve further into the data.

Topics to be discussed include:

  • Types of Sparklines
  • Modifying Sparklines
  • How to Insert ClipArt, Pictures and Other Images into Excel
  • Inserting SmartArt and Shapes into Excel

Module 9: Viewing & Printing

Part 1: Viewing

Depending on the work being done in Excel, different display choices will be used to inspect the results. There are certainly occasions when they are dealing on different classes of knowledge in their workbook and need to look at all the details or compare the groups together.

Topics to be discussed include:

  • Freeze Panes
  • How to split a worksheet
  • Opening Multiple Windows for a Single Workbook

Part 2: Page Layout, Orientation and Formatting

Viewing a job on their computer screen isn't often enough; they still need to look at it off-line. They will want to print a workbook to view and post their data online at times. If they've decided on their page layout, they can easily display and print a workbook from Excel using the Print pane.

Topics to be discussed include:

  • Preparing a Workbook for Printing
  • Page layout
  • Page orientation
  • How to insert a page break
  • How to insert headers and footers
  • Printing Your Workbook

Recognition & Accreditation

Upon completion of your course assessment, you will receive 3 certificates. An accredited certificate from the awarding body relating to your course, a CPD certificate displaying the number of CPD points earned from the course and a certificate of completion.

Module 1: Excel: An Overview

  • Part 1: The Beginnings of MS Excel
  • Part 2: Common areas of business that use MS Excel
  • Module 1 Assessment

Module 2: The Excel Environment

  • Part 1: The Excel Worksheet (Spreadsheet)
  • Part 2: How to Use and Customize the Quick Access Toolbar (QAT) and the Ribbon
  • Part 3: Spreadsheet (worksheet) views
  • Module 2 Assessment

Module 3: Basic Excel Skills

  • Part 1: Introduction to Cells
  • Part 2: Sharing, Saving & Exporting Workbooks
  • Module 3 Assessment

Module 4: The Fine Art of Formatting

  • Part 1: Formatting Fonts
  • Part 2: Text alignment
  • Part 3: Applying Colours, Borders and Patterns
  • Part 4: Modifying Columns and Rows
  • Module 4 Assessment

Module 5: How to Calculate with Excel

  • Part 1: Understanding Formulas
  • Part 2: Benefit of Cell References
  • Module 5 Assessment

Module 6: Advanced Formulas and Functions

  • Part 1: More about Operators
  • Part 2: Nesting Functions
  • Module 6 Assessment

Module 7: Sorting and Filtering Data

  • Part 1: Sorting
  • Part 2: Filtering
  • Module 7 Assessment

Module 8: Charts and Graphics

  • Part 1: Understanding Charts
  • Part 2: How To Modify Your Chart
  • Part 3: Pivot Tables
  • Part 4: Sparklines
  • Module 8 Assessment

Module 9: Viewing & Printing

  • Part 1: Viewing
  • Part 2: Page Layout, Orientation and Formatting
  • Module 9 Assessment

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

We provide a 7 Day Money Back Refund on all Courses

Now Only NZ$249 Save NZ$150 (38%)
OFF RRP NZ$399
or 4 interest-free payments of $62.25 with Learn more
Get Info Pack
MASSIVE MAY SALE

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value NZ$600)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Training 2 Or More People?


Empower your business with access to 500+ job & soft skills online training courses.

SUCCESS PRO - For Business

Course Summary

Course ID: CFS03ME31
Delivery Mode: Online
Access: Unlimited lifetime
Tutor Support: Yes
Time: Study at your own pace
Duration: 6-8 Hours
Assessments: Yes
Qualification: Certificate

Similar Courses

Get a FREE Career Planner