4.42 out of 5
4.42
440 reviews on Udemy

Microsoft Excel Training: From Zero to Hero in 8 Hours

Excel with this Microsoft Excel Course. Learn Excel from A to Z in just 8 hours!!
Instructor:
Prof. Samer
45,997 students enrolled
English [Auto]
Worksheet basics: Creating a worksheet, Entering data automatically with Auto Fill, Inserting/deleting cells, columns, and rows, and cell formatting.
Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using IF, using SUMIF and AVERAGEIF, naming and using cell ranges.
Excel Formatting: Adjusting fonts, colors, adding pictures, shapes and borders, inserting SmartArt, built-in styles and creating and using templates.
Printing: Inserting headers and footers, generating PDFs.
Data Analysis: Named ranges, data validation, data sorting and filtering, working with goal seek and using the scenario manager in excel.
Dealing with large data: Using Find and Replace, managing worksheets, applying formulas across multiple worksheets.
Discovering PivotTables: Creating and modifying a PivotTable and a PivotChart.
Charts: Choosing chart types, inserting sparklines, creating and modifying a column chart and a pie chart.
Macros: Understanding, recording, using and editing a macro.

Welcome to Microsoft Excel 2016 Training 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, you will learn about:

Worksheet basics: Creating a worksheet, Entering data automatically with Auto Fill, Inserting/deleting cells, columns, and rows, and cell formatting.

Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using IF, using SUMIF and AVERAGEIF, naming and using cell ranges.

Excel Formatting: Adjusting fonts, colors, adding pictures, shapes and borders, inserting SmartArt, built-in styles and creating and using templates.

Printing: Inserting headers and footers, generating PDFs.

Data Analysis: Named ranges, data validation, data sorting and filtering, working with goal seek and using the scenario manager in excel.

Dealing with large data: Using Find and Replace, managing worksheets, applying formulas across multiple worksheets.

Discovering PivotTables: Creating and modifying a PivotTable and a PivotChart.

Charts: Choosing chart types, inserting sparklines, creating and modifying a column chart and a pie chart.

Macros: Understanding, recording, using and editing a macro.

Enjoy and happy learning!!

Getting Started

1
What is Excel used for? Exploring common uses
2
Getting Familiar with Excel Interface
3
Navigating the Ribbon Bar and Finding Commands
4
Using the File Tab

Worksheet Basics

1
Creating Your First Worksheet
2
Different methods for copying and pasting
3
Using Auto Fill to Automatically Enter Data
4
Selection Techniques for Large Data Range
5
Inserting Cells

Formula Basics

1
Introduction to Formulas, Functions and Cell References
2
How to Sum Numbers in Excel Manually
3
How to Sum Numbers in Excel Using Sum and AutoSum
4
How to AutoSum Across All Worksheet
5
How to Use Average, Max, Min and Count Functions in Excel
6
Using Absolute Cell References
7
Display Current Date and Time in a Worksheet
8
How to Use the Excel IF Function
9
SUMIF and AVERAGEIF Functions in Excel
10
How to Create Named Ranges in Excel

Basic Excel Formatting Techniques

1
Excel Dates and Numbers Formatting
2
How to apply fonts, background colors, and borders in Excel
3
How to Adjust Rows, Columns and Text in Excel
4
How to Apply Conditional Formatting in Excel
5
How to Customize Excel Conditional Formatting
6
How to Add Pictures and Shapes in Excel

Advanced Excel Formatting Techniques

1
How to Add SmartArt Graphics to Your Excel Worksheets
2
Using Themes to Change the Appearance of Your Worksheet
3
Apply, Create or Merge Cell Styles in Excel
4
How to Use and Create Templates in Excel

Printing in Excel

1
Preparing Your Worksheet for Printing
2
Headers and Footers, Margins and Print Titles
3
Printing and Generating a PDF

Dealing With Large Data Sets

1
Find or Replace Data on a Worksheet
2
Freezing Panes to Lock Rows and Columns
3
How to Use Excel Custom Views Like a Pro
4
How to Hide and Group Rows or Columns in Excel
5
Easy Ways to Manage Excel Worksheets
6
Calculating Values Across Worksheets with Formulas

Sharing and Collaborating on Excel Data

1
What You Need to Know About Importing and Exporting in Excel
2
How to Protect Workbooks, Worksheets, and Cells From Editing in Microsoft Excel
3
Adding Comments to Cells in Excel
4
How To Share An Excel File For Easy Collaboration

Database in Excel

1
Splitting Cells Into Multiple Columns
2
Joining Cells Into One Column
3
Sorting and Filtering Data in Excel
4
Working With Tables
5
Creating Subtotals
6
Creating Formulas that LOOK UP Values Using VLOOKUP and HLOOKUP

Analyzing Data in Excel

1
Using Goal Seek
2
Using Solver
3
Creating Data Tables
4
Using The Scenario Manager

Analyzing Data With Pivot Tables

1
Understanding and Creating a Pivot Table
2
How to Edit your Pivot Table
3
Creating and Editing a Pivot Chart

Charts

1
Hands On: Creating and Customizing a Chart
2
Creating a Pie Chart
3
Creating a Line Chart
4
Use Sparklines to Show Data Trends

Macros

1
Introduction to Macros
2
Recording and Running a Macro
3
Editing and Saving a Macro

Exercise Files

1
Exercise Files
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
4.4
4.4 out of 5
440 Ratings

Detailed Rating

Stars 5
207
Stars 4
156
Stars 3
56
Stars 2
9
Stars 1
7
53e46b95bdfbac58dbf96350dcf82796
30-Day Money-Back Guarantee

Includes

7 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion