Learn to use Microsoft Excel like a Pro

Learn to use Microsoft Excel like a Pro - Beginner Level

Your Excel journey starts here!

Course description

Whether you have little or no experience with Excel, start with "Learn to use Microsoft Excel like a Pro" at the Beginner Level to:

Learn from the fundamentals, to the most advanced features, this training covers everything you need to know about Excel
Create spreadsheets
Master all the basics of Excel, even if you've never seen a spreadsheet before!

Who this course is for:

Students and Corporate employees wanting to improve their Excel skills

Course curriculum

1

Excel Beginner
- Introduction
  FREE PREVIEW
2

Excel Fundamentals
- Launching Excel
  FREE PREVIEW
- Start Up Screen
  FREE PREVIEW
- The Excel Interface
- The Quick Access Toolbar
- The Ribbon
- Creating New Excel Workbooks
- Saving Excel Files
- Opening Excel Files
- Beginner Shortcut Keys
3

Entering and Editing Text
- Entering Text
- Working with Numbers
- An Introduction to Dates
- Find and Replace
- Sorting Data
- Working with Cell References
- Relative Versus Absolute Cell Reference in Formulas
- Understanding the Order of Operation
4

Basic Excel Functions
- The structure of an Excel Function
- Working with the Sum Function
- Working with Min and Max
- Working with Averages
- Working with Count and CountA
5

Modifying an Excel Worksheet
- Moving and Copying Data
- Inserting and Deleting Rows and Columns
- Changing the Width and Height of Cells
- Hiding and Unhiding Rows, Columns and Sheets
- Renaming Worksheets
- Deleting Worksheets
- Moving and Copying Worksheets
6

Formatting Data
- Adding Borders to Cells
- Formatting Percentages
- Merging and Centering Cells
- A Quick look at Styles
- Basic Conditional Formatting
7

Images, Shapes and Smart Art
- Inserting Images and Shapes
- Working with SmartArt
8

Printing in Excel
- Print Preview
- Margins, Scaling and Orientation
- Printing
9

Bonus # 1 - Advanced Pivot Tables
- Intro to Excel Templates
- Opening an Existing Template
- Creating a Custom Template
10

Excel Beginner - Conclusion
- Conclusion

Meet your instructor!

Andries Nienaber
Office 365 - Engineer

Hi there, my name is Andries and I have been working with Excel for over 20 years. I have worked with major corporate companies such as Nespresso and various Banks.

I currently am one of the preferred in classroom trainers for Office and I am dedicated to helping you create outstanding tools and reports in Excel. Our courses are for those who want to learn Excel, accelerate your careers and achieve more in less time.

For over 20 years I have worked in the Finance and IT departments implementing reporting systems based on SQL and XML. All the while using Excel VBA to automate and improve processes.

Our courses include examples based on real-life experience as well as the consulting work I have done for many international companies.

I place great value on keeping my Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises, and downloadable files to practice so they can maximize the value gained from each course.

Private Label Rights (PLR)

This course is available with Private Label Rights (PLR).

When you buy a course with private label rights on Uthena, the author of the course gives you permission to download the course and sell it as your own on your website according to the terms of the PLR license included.

If you would like to know more about the license terms, please visit this page.

After purchasing, you will have access to the course on Uthena and you will receive the PLR license with a download link and a special bonus.