A self-paced course on using Microsoft Excel in the workplace.
What you will learn:
- Master Microsoft Excel from Beginner level to Intermediate level.
- Learn the most commonly used Excel functions in today’s business environment.
- Master unique tips and concepts that you won’t find in other courses.
- Build a solid understanding of the basics of Microsoft Excel to increase your proficiency at work.
- Create dynamic charts and data analysis using IF, VLOOKUP, and PivotTables.
- Access to a Professional Trainer with 15+ years of Excel and IT experience.
- Get lifetime access to the quizzes, exercises and new updates.
- Install Microsoft Office: Excel 2016, 2013 or 2010. The course is designed using Excel 2016.
- No previous knowledge is required!
- Great for students or employees who want to learn at their own pace
A Verifiable Certificate of Completion is presented to all students who request it upon completion of this course.
This course is suitable for individuals without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, pivot tables, custom formatting, Excel 2016 charts, and other tools that are often used the business environment.
This course is perfect employee training for small and midsize businesses and for individuals such as students, entry-level finance, Business and Marketing professionals who would like to grow faster than their peers.
- Executive Assistant
- Office Clerk
- Business Analyst
- Financial Analyst
- Credit Counselor
- Sales Representative
- Sales Manager
- Financial Manager
- Investment Banker
- Real Estate Agent
- Market Research Analyst
- Financial Advisor
- Business Operations Manager
- Someone who is involved with a business and would like to be successful
Please don’t forget that the course comes with an unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?
Unit Sections and Objectives
Lesson 1: Getting Started with Excel – General Concepts
- Getting started with Excel
- General interface
- The Office Ribbon
- General concepts on using Excel and Spreadsheets
- How to use Excel basic features
- How to enter a formula in Excel
- How to calculate the sum of a series of cells
- How to calculate the average of a series of cells
- How to calculate the Max of a series of cells
- How to calculate the Min of a series of cells
- How to calculate the count function in a series of cells
- How to use the Autofill feature in Excel
- Basic arithmetic functions in Excel
- Dividing using formulas
- How and when to use different types of references in formulas in Excel.
- Difference between absolute and relative references
- Mixed references
- How to apply formatting styles to the data in a spreadsheet.
- How to apply conditional formatting to selected data
- How to use Data Analysis in Excel
- How to sort data in Excel
- How to filter data based on various criteria
- How to customize the filters
- How to clear the filters
- How to use sorting and filtering by right clicking
- How to calculate percentages using a formula in Excel
- How to create various types of charts in Excel
- How to customize the charts
- Which types of charts to use for certain types of data
- How to use formulas to perform cross-sheet calculations in Excel
- How to enter the value from a formula in a previous sheet in a new worksheet.
- How to use the IF Statement or function in a variety of ways in Excel 2013 via a formula
- How to define Named References in Excel.
- How to apply Named References and how to use this important feature in Excel.
- How and why use data validation in Excel
- How to define data validation rules and criteria.
- How to apply data validation lists and drop-down lists
- How to setup the data to use it with Pivot Tables.
- How to create pivot tables in Excel
- How to customize the pivot tables using various criteria.
- Setting and clearing the print area.
- Headers and footers
- How to link data from Excel into Word for reports etc. using Paste Special.
- Update the data in your Excel spreadsheet and have that data updated automatically in Word.
- Understanding .csv files and their usage.
- How to import .csv files in Excel
- How to export an Excel file to .csv format.
- How to share data files in Excel.
- How to export data in PDF format directly from Excel
- How to perform a mail merge using an Excel Data File
Lesson 19: Using VLOOKUP in Excel with 5 examples
“This is the best tutorial that I ever encountered on web and thousand times better then any college or university instruction that I came across. The beauty of this tutorial is that you can really learn and master information on your own convenience and time and your own pace. I am so amazed at the wonderful job that the instructor performs making excel so easy to understand and have a very valuable learning experience for which it is an incredible gift from this great deal of information. Thank you much Sali Kaceli, you are the best instructor I ever come across. You are so awesome. Thank you so much!!!!” Anna CP
See also these FAQs.
If you are a business owner and would like bulk enrollments/licensing, please contact us. Bulk discounts are available.
- Teacher: Sali Kaceli