Microsoft Excel - Level 2 - Essentials
87 students enrolled
Microsoft Excel - Level 2 - Essentials
This course builds on the foundations to teach you how to use the essential tools in Excel.
87 students enrolled
Current price: $13.99
Original price: $19.99
Discount:
30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
- 2 hours on-demand video
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Training 5 or more people?
Get your team access to 4,000+ top Udemy courses anytime, anywhere.
Try Udemy for Business
What you'll learn
- This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You'll have a powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role.
Requirements
- Basic understanding of Excel
Description
This course builds on the Excel Level 1 foundations course to teach you how to use the essential tools in Excel. You’ll learn V and H lookup, CountIf and SumIf and database functions. You’ll work with charts, graphs, filters and lists, import different file formats (like XML data) and track changes in a spreadsheet.
Who this course is for:
- If you work with Excel on a regular basis there is a huge amount to gain by being confident at this level. There are many features to learn and this course will save you hours and hours of work as you start to start make the most of the functionality of Excel.
Course content
Expand all
41 lectures
02:03:49
+
–
Sharing workbooks with others
4 lectures
08:29
+
–
Protecting and maintaining a workbook
5 lectures
17:35
Preview
00:25
Saving as a template
02:46
Importing and Exporting XML data
06:49
Protecting a worksheet and workbook
04:45
+
–
Track changes
5 lectures
09:34
Preview
00:19
Accept and Reject changes
02:25
Sharing workbooks
02:25
Restricting Access to a shared workbook
01:04
+
–
Naming Cells
4 lectures
07:38
+
–
Data lists
11 lectures
41:44
Preview
00:23
Preview
04:55
Advanced sort options
03:27
Applying conditional Formatting
04:56
Applying Filters
05:35
Applying custom filters
01:40
Subtotalling a list
03:14
Grouping and outlining data
03:02
Data validation
05:06
Drop down menus using validation lists
05:07
Creating a table to manage lists
04:19
+
–
Advanced Formulae
6 lectures
20:21
+
–
Advanced Charts and Graphs
6 lectures
18:28