Excel for the Workplace
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.
Requirements
- Install Microsoft Office: Excel 2016+.
- No previous knowledge is required!
- Great for students or employees who want to learn at their own pace
Certificate
A Verifiable Certificate of Completion is presented to all students who request it upon completion of this course.
Application
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
- Auditor
- Accountant
- 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
- Entrepreneur
- Someone who is involved with a business and would like to be successful
- Students
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
Lesson 2: Calculating the SUM, AVERAGE etc. in Excel
Lesson 3: Basic Formulas: Multiplying, Division and Subtraction in Excel
Lesson 4: Absolute, Relative and Mixed References
Lesson 5: Using Conditional Formatting and Data Analysis in Excel
Lesson 6: Data Sorting and Filtering in Excel
Lesson 7: Calculating Percentages in Excel
Lesson 8: Creating and Customizing Charts in Excel
Lesson 9: Cross-Sheet Calculations in Excel
Lesson 10: Using the IF Function in Excel
Lesson 11: Using Named References in Excel
Lesson 12: Using Data Validation and Dropdown Lists in Excel
Lesson 13: Using Pivot Tables in Excel
Lesson 14: Setting the Print Area in Excel
Lesson 15: Linking Data from Excel with Word for Reports
Lesson 16: Importing and Exporting Data in .csv Files in Excel to Transfer Data Between Systems
Lesson 17: Sharing and Saving Data in PDF Format
Lesson 18: Creating a Mail Merge using Excel
Lesson 19: Using VLOOKUP in Excel with 5 examples
User Comments:
“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
Questions?
See also these FAQs.
Bulk Enrollments/Licensing
If you are a business owner and would like bulk enrollments/licensing, please contact us. Bulk discounts are available.
This is a really good tip particularly to those fresh to the blogosphere.
Brief but very accurate information… Thank you for sharing this one.
A must read post!
Here is my web page :: Royal CBD
Thanks very nice blog!