Excel is the solution that thousands of companies use today as they struggle with their day-to-day and Big data issues. In simple words, it converts raw data into a very easily understandable format.
In this course, you will learn how to edit and organize data, perform various calculations with simple functions, how to work with multiple worksheets, format the presentation of your data and sheets, how you can proficiently build charts, and PivotTables.
You will also learn powerful IF, VLOOKUP, and COUNTIF family of functions; In the data analysis, you will learn the Goal Seek, Solver, and some other data analysis tools; How to automate your excel tasks with macros. A few crucial keyboard shortcuts will help you discover and reveal formula cells and quicken working with Excel formulas—even on multiple sheets.
Post completion, You will be well versed with the excel foundation course and can also appear for the Microsoft Excel Associate Exam You will learn how to effectively use Subtotal, Charts, Goal Seek, Data Tables, Solver, Pivot Tables, Pivot Charts, Sparkline’s, Conditional Formatting, Security, Slicers, Scenario Managers, Flash Fill, Validation Tools, If and Power Functions, Macros, And Much More.
Curriculum for this course
82 Lessons
10:45:28 Hours
Lets Get Started with Microsoft Excel
10 Lessons
00:59:07 Hours
-
What is Excel used for ?
00:04:09
-
Using the Menu System
00:09:35
-
What is Quick Access Toolbar
00:07:33
-
Understanding Workbooks and Worksheets
00:05:53
-
Using the Formula Bar
00:02:38
-
Excel Status Bar
00:07:16
-
Using Navigation Tools
00:05:31
-
Excel Shortcut Menu and The Mini Toolbar
00:06:10
-
Creating New Workbooks
00:04:13
-
Using Excel Help
00:06:09
Excel Data Entry
6 Lessons
00:38:50 Hours
-
Exploring Data Entry and Editing Techniques
00:07:11
-
Entering Data using Auto Fill
00:05:56
-
Working with Dates and Times
00:08:45
-
Undo and Redo in Excel
00:06:35
-
Adding Comments
00:05:01
-
Using Save or Save As
00:05:22
How to Create Formulas and Functions
7 Lessons
00:45:24 Hours
-
Creating Simple Formulas
00:08:58
-
Coping Formula to Next Cell
00:03:53
-
Calculating YTD Totals
00:05:05
-
Creating a percent change formula
00:05:03
-
Excel Relative, Absolute, and Mixed References
00:07:20
-
SUM and Average Function
00:06:34
-
Some Common Functions
00:08:31
Formatting Excel
9 Lessons
01:38:13 Hours
-
Explore Font Styles and Effects
00:07:10
-
Adjusting Row Height and Column Widths
00:09:01
-
Align, Wrap and Merge Text and Numbers
00:10:57
-
Designing and Creating Borders in Excel
00:05:49
-
Exploring Numeric and Special Formatting
00:11:11
-
Formatting numbers and dates
00:08:44
-
Using Conditional Formatting
00:12:25
-
Creating Tables and Slicers
00:17:51
-
Inserting Shapes, Arrows, Pictures, and Other Visual Features
00:15:05
Adjusting Excel Layout and Data
4 Lessons
00:34:03 Hours
-
Inserting and Deleting Rows and Columns
00:09:36
-
Hiding and Unhiding Rows and Columns
00:06:41
-
Moving, Copying, and Inserting Data
00:08:22
-
Finding and Replacing Data
00:09:24
Printing Excel
3 Lessons
00:28:10 Hours
-
Explore Page Layout Tab and Page Layout View
00:11:53
-
Page Break Preview
00:05:41
-
Page Setup Options and Printing Controls
00:10:36
Excel Charts
6 Lessons
00:59:25 Hours
-
Creating Charts
00:09:11
-
Different Chart Types
00:09:53
-
Formatting Charts
00:13:18
-
Axes, Chart Titles, and Other Chart Elements
00:08:35
-
Creating In-Cell Charts with Spark-lines
00:06:16
-
New charts
00:12:12
Adjust Worksheet Views
3 Lessons
00:15:29 Hours
-
Freeze and Unfreeze Panes
00:04:34
-
Splitting Screens Horizontally and Vertically
00:05:10
-
Collapsing and Expanding Data Views with Outlining
00:05:45
Working on Multiple Workbooks and Worksheets
5 Lessons
00:58:13 Hours
-
Display Multiple Worksheets and Workbooks
00:15:57
-
Renaming, Inserting, and Deleting Sheets
00:08:14
-
Moving, Copying, and Grouping Sheets
00:12:28
-
Use Formulas to Link Worksheets and Workbooks
00:11:38
-
Find, Locate and Maintaining External Links
00:09:56
IF, Vlookup and Count IF Functions
4 Lessons
00:33:12 Hours
-
IF Functions and Relational Operators
00:09:59
-
Getting Approximate Table Data with VLOOKUP
00:08:37
-
Getting Exact Table Data with VLOOKUP Function
00:09:13
-
COUNTIF Family of Functions
00:05:23
Excel Security and Sharing
5 Lessons
00:44:11 Hours
-
Unlocking Cells and Protecting Worksheets
00:14:44
-
Protecting Workbooks
00:07:40
-
Assigning Passwords to Workbooks
00:05:06
-
Sharing Workbooks
00:07:54
-
Tracking Changes
00:08:47
Excel Data Management Services
7 Lessons
00:35:20 Hours
-
Sorting Data
00:06:43
-
Inserting Subtotals in a Sorted List
00:06:05
-
Using Filters
00:05:28
-
Splitting Data Into Multiple Columns
00:03:56
-
Splitting and Combining Data with Flash Fill
00:02:37
-
Removing Duplicate Records
00:03:22
-
Using Validation Tools
00:07:09
Excel Data Analysis Tools
4 Lessons
00:24:23 Hours
-
Using Goal Seek
00:06:07
-
Using Solver
00:05:59
-
Using Scenario Manager
00:05:02
-
Using Data Tables
00:07:15
Excel Pivot Tables
6 Lessons
00:50:43 Hours
-
Creating Pivot Tables
00:12:02
-
Manipulating Pivot Table Data
00:10:26
-
Grouping by Date and Time
00:10:41
-
Grouping By Other Factors
00:04:41
-
Using Slicers To Clarify and Manipulate Fields
00:06:46
-
Using Pivot Charts
00:06:07
Macros for Beginner's
3 Lessons
00:20:45 Hours
-
Why do We Need Macros ?
00:06:06
-
Creating Simple Macro
00:06:45
-
Running A Macro
00:07:54
Read more