4.32
63 reviews
Microsoft Excel Training: Learn Essential Excel Skills
Exercise Files included, Formulas, Formatting, Printing, Data Analysis, Charts, PivotTable, PivotChart, Macros and more
- Description
- Curriculum
- FAQ
- Reviews
Welcome to Microsoft Excel 2016 Training: Learn Essential Excel Skills course.
If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start.
Learning Excel will become very easy if you do it the right way. First you need to get all the basics in place, and then you can learn to do advanced stuff in Excel.
In this Excel course, I have focused on the following subjects: Worksheet basics, Formulas, Formatting, Printing, Data Analysis, Charts, PivotTables and PivotCharts, Macros.
Enjoy and happy learning.
Worksheet Basics
Formula Basics
Basic Excel Formatting Techniques
-
10Introduction to Formulas, Functions and Cell ReferencesVideo lesson
-
11How to Sum Numbers in Excel ManuallyVideo lesson
-
12How to Sum Numbers in Excel Using Sum and AutoSumVideo lesson
-
13How to AutoSum Across All WorksheetVideo lesson
-
14How to Use Average, Max, Min and Count Functions in ExcelVideo lesson
-
15Using Absolute Cell ReferencesVideo lesson
-
16Display Current Date and Time in a WorksheetVideo lesson
-
17How to Use the Excel IF FunctionVideo lesson
-
18SUMIF and AVERAGEIF Functions in ExcelVideo lesson
-
19How to Create Named Ranges in ExcelVideo lesson
Advanced Excel Formatting Techniques
-
20Excel Dates and Numbers FormattingVideo lesson
-
21How to apply fonts, background colors, and borders in ExcelVideo lesson
-
22How to Adjust Rows, Columns and Text in ExcelVideo lesson
-
23How to Apply Conditional Formatting in ExcelVideo lesson
-
24How to Customize Excel Conditional FormattingVideo lesson
-
25How to Add Pictures and Shapes in ExcelVideo lesson
Printing in Excel
Dealing With Large Data Sets
Sharing and Collaborating on Excel Data
-
33Find or Replace Data on a WorksheetVideo lesson
-
34Freezing Panes to Lock Rows and ColumnsVideo lesson
-
35How to Use Excel Custom Views Like a ProVideo lesson
-
36How to Hide and Group Rows or Columns in ExcelVideo lesson
-
37Easy Ways to Manage Excel WorksheetsVideo lesson
-
38Calculating Values Across Worksheets with FormulasVideo lesson
Database in Excel
Analyzing Data in Excel
-
43Splitting Cells Into Multiple ColumnsVideo lesson
-
44Joining Cells Into One ColumnVideo lesson
-
45Sorting and Filtering Data in ExcelVideo lesson
-
46Working With TablesVideo lesson
-
47Creating SubtotalsVideo lesson
-
48Creating Formulas that LOOK UP Values Using VLOOKUP and HLOOKUPVideo lesson
Analyzing Data With Pivot Tables
Charts
Macros
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Course available for 2 days
Course details
Lectures
1
Quizzes
3
Video
7 hours
Certificate of Completion
Full lifetime access
Access on mobile and TV
Popular courses
External Links May Contain Affiliate Links read more