Description

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.

What you'll learn

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

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

Microsoft Excel Foundation Intermediate Course - Hindi Edition