MS EXCEL BASICS – Prime Education Centre

About Course

This course covers all basic to Advanced concepts of MS excel which will help students to work once selected in company and can prepare reports in company.

Course Content

Introduction

Excel Introduction

00:58
Create a new workbook

00:40
Insert or delete a worksheet

01:00
Move or copy worksheets or worksheet data

00:42
Fill data automatically in worksheet cells

00:38
Create a drop-down list

00:59

Rows & Columns

Cells

Formatting

Formulas & functions

Overview of formulas in Excel

01:28
XLOOKUP function

00:44
VLOOKUP Function

00:49
SUM function

00:33
COUNTIF function

01:09
IF function

00:42
IFS function

00:52
SUMIF function

00:55
SUMIFS Function

01:01
MATCH function

01:26

Tables

Charts
Charts help you visualize your data in a way that creates maximum impact on your audience.

Pivot Tables
A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. PivotTables work a little bit differently depending on what platform you are using to run Excel.

Share & Co Author
Share a workbook with others, right within Excel. You can let them edit the workbook or just view it.

Linked Data Types
Not only can you get data on subjects like cities, foods, stocks, geography, and more, but you can also get data types provided by your organization through Power BI. You can view data type cards to get specific info about your converted data and extract that to your workbook. Refresh to keep your data up to date and see Power BI data without ever leaving Excel.

Convert text to an Organization data type

01:48
Specify Organization data types with the Data Selector

00:40
Use Organization data types to view and insert data

00:59
Import data from the web

01:41
Import from an Excel Table

03:12
Set up your header row

01:24
Convert a data type

00:57
Filter unnecessary rows

01:10
Split data into multiple columns

01:12
Create a column from an example

02:36
Create a conditional column

01:43
Merge queries and join tables

00:29
Review the applied steps

02:13
Add data and then refresh your query

01:09

Practice Templates

Student Ratings & Reviews

No Review Yet

About Course

Course Content

Introduction

Excel Introduction

Create a new workbook

Insert or delete a worksheet

Move or copy worksheets or worksheet data

Fill data automatically in worksheet cells

Create a drop-down list

Rows & Columns

Insert or delete rows and columns

Select cell contents in Excel

Freeze panes to lock rows and columns

Hide or show rows or columns

Filter for unique values or remove duplicate values

Split text into different columns with the Convert Text to Columns Wizard

Create a list of sequential dates

Cells

Move or copy cells and cell contents

Change the column width or row height in Excel

Find or replace text and numbers on a worksheet

Merge and unmerge cells

Apply data validation to cells

Formatting

Available number formats in Excel

Conditional Formatting

Align or rotate text in a cell

Change the format of a cell

Copy cell formatting

Add a watermark in Excel

Display or hide zero values

Create a custom number format

Formulas & functions

Overview of formulas in Excel

XLOOKUP function

VLOOKUP Function

SUM function

COUNTIF function

IF function

IFS function

SUMIF function

SUMIFS Function

MATCH function

Tables

Create and format tables

Sort data in a table

Filter data in a range or table

Total the data in an Excel table

Use slicers to filter data

Charts Charts help you visualize your data in a way that creates maximum impact on your audience.

Create a chart from start to finish

Add or remove titles in a chart

Show or hide a chart legend or data table

Add or remove a secondary axis in a chart in Excel

Add a trend or moving average line to a chart

Instant charts using Quick Analysis

Update the data in an existing chart

Use sparklines to show data trends

Pivot Tables A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. PivotTables work a little bit differently depending on what platform you are using to run Excel.

Create a PivotTable to analyze worksheet data

Use the Field List to arrange fields in a PivotTable

Group or ungroup data in a PivotTable

Filter data in a PivotTable

Create a PivotChart

Share & Co Author Share a workbook with others, right within Excel. You can let them edit the workbook or just view it.

Share your Excel workbook with others

Collaborate on Excel workbooks at the same time with co-authoring

Protect an Excel file

Save or convert to PDF

Comments and notes

Convert text to an Organization data type

Specify Organization data types with the Data Selector

Use Organization data types to view and insert data

Import data from the web

Import from an Excel Table

Set up your header row

Convert a data type

Filter unnecessary rows

Split data into multiple columns

Create a column from an example

Charts
Charts help you visualize your data in a way that creates maximum impact on your audience.

Pivot Tables
A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. PivotTables work a little bit differently depending on what platform you are using to run Excel.

Share & Co Author
Share a workbook with others, right within Excel. You can let them edit the workbook or just view it.