What you'll learn:
Gain basic to intermediate level skills in Excel 2016, 2019 & 365
Create worksheets and workbooks: Create blank and populated workbooks
Navigate in worksheets/workbooks
Format worksheets/workbooks: Manage worksheet attributes; manage rows and columns;
Change the appearance of workbook contents
Search for data
Navigate to special cells or ranges, workbook elements; link to internal/external locations
Manage worksheet attributes
Searching for items within worksheet
Manage rows and columns
Modify page setup
Insert header and footer
Add worksheets; move/copy worksheets; import data
Hide/unhide contents
Modify the display of worksheets
Customize the Quick Access Toolbar (QAT)
Configure printing
Manage cells and ranges
Manage data cells and ranges
Format cells and ranges: styles, wrapping, number formats
Summarize and organize data
Insert Sparklines, Outline data and insert subtotals
Add/remove table rows and columns
Create and manage tables
Apply styles to tables
Sort and filter tables
Remove duplicates table entries
Summarize data by using functions
Perform conditional operations by using functions (SUMIFS, AVERAGEIFS...)
Format and modify text by using functions
Create charts and objects
Using the camera tool and images for data visualization

Requirements
Basic Windows 10 operations such as cut and paste. No Excel skills necessary
Good analytical skills
Attention to detail

Description
Desktop computing proficiency is increasingly important in today's business world. When screening, hiring, and training employees, employers can feel reassured of the value of your Excel skills irrespective of your role in the organization.

In this basic to intermediate Microsoft Excel course, we assume that you have used Excel for at least 6 months and you know how to enter data into cells and how to perform basic operations such as adding two numbers in a cell (=12+90), and how to perform basic cell references (=A1+A2). At the end of your training you will master the most important Excel tools to confidently handle any task within the confines of this course. This course will give you a solid foundation to build on to a more advanced Excel exploration. I believe you will be surprised how much you have learned after you finish your training. We take you step by step from the fundamentals and build you up gradually. If you want a solid foundation on which to build your Excel skills for further and more advanced exploration, this course will definitely help with your goal: