Microsoft Excel from Beginner to Advanced.

Name: Microsoft Excel from Beginner to Advanced.
Rating: 4.4 (3 reviews)

Microsoft Excel 2013, 2016.Including Microsoft Excel ShortCuts file.Performed many Excel Formulas to get Expert.

Created byZohaib Khan .

Last updated 1/2021

English

What you'll learn

After completing this course,students will be able to use Microsoft Office 2013/2016 professionally.
Students will be able to apply different formats to their data.
Students will be able to apply conditional formatting to make their data more impressive and professional.
Students will be able to Create advanced calculations.
Students will be able to present their data in tabulated form.
Students will able to calculate long data entries within seconds using Pivot Table.
Students will able to analyze data using different charts formats.
Students will able to implement advanced functions to solve problems in Microsoft Excel Workbook.
Students will able to track records from long data entries using Filtering and Advanced Filtering.
Students will able to Sort data professionally.
Students will able to Protect Active Excel Workbook and Create Password Protected Microsoft Excel file.

Course content

14 sections • 87 lectures • 8h 9m total length

Welcome to Digital World1:08
In this introduction,Students will learn about myself and valuable Course Content of Microsoft Excel.
Introduction to Microsoft Excel15:36
In this introduction,Students will learn about Microsoft Excel features that will help them in the future to make their data more Impressive and Professional.
Announcement0:15
Don’t forget to check my course contents every 3 or 4 days.I will keep update my course after every 3 or 4 days.Stay updated,Stay Learn,Stay Save,Stay HAPPY

Opening a Microsoft Excel file.1:37
In this video,students will learn how to open saved Microsoft Excel file.
Creating and Saving Workbook1:20
In this video,students will learn how to create and save Microsoft Excel File
Customizing quick access toolbar4:56
In this lecture,Students will learn about Customize quick access tool bar in order to access functions quickly.This is very powerful feature in Microsoft Excel to accelerate your work in Microsoft Excel Workbook.
Insert and Delete Rows and Columns4:17
In this lecture,students will create and delete rows and columns.
Data Entry and edit data8:46
In this lecture,data entry activity will be demonstrated.We can enter any type of data whether text,numbers,symbols,pics etc.
Simple Mathematical Calculations11:46
In this lecture,students will do some basic mathematical calculations in Microsoft Excel spreadsheet.
Undo Redo feature in Microsoft Excel.3:56
In this lecture,students will perform undo redo operation in Microsoft excel workbook,
Hide Ribbon1:01
In this lecture,students will learn how to hide or unhide Ribbon in Microsoft Excel workbook.
Convert xlsx into PDF format1:11
Students will convert xlsx into PDF format using save as option.
Percentage3:00
In this lecture,students will learn how to calculate percentage from a table or data.
Division6:13
In this lecture,students will learn how to calculate value using division.
Export Microsoft Excel File2:23
In this lecture,Students will learn how to export Microsoft Excel file

Applying boarders4:07
In this lecture,students will learn how to apply boarders to your tabulated data to make your data more impressive and professional.
Formating Numbers13:34
In this lecture,students will learn how to format numbers.
Formatting Table10:18
In this lecture,students will learn how to apply different formats to the data.
Format Painter4:54
In this lecture,students will learn how to apply format painter to multiple data in different sheets.
Insert and delete Comments in Microsoft Excel workbook.4:11
In this lecture,students will learn how to insert and delete comments
Text Orientation and merge cells5:21
In this course,students will apply text orientation and also merge cells in Microsoft Excel workbook.
FreezePanes7:30
In this lecture,you will apply Freeze Panes on Top row and first column at Left side in Microsoft Excel Workbook.
Paste Special9:12
In this lecture,students will learn how to paste data in different formats using Paste Special feature in Microsoft excel Workbook.

Sum5:05
In this lecture,students will learn how to add values in a range of cells or data set.
Product4:12
In this lecture,students will be able to apply product formula.
Average4:25
IFStatement6:22
SumProduct4:57
In this lecture,students will learn how to multiply range of cells and returns the sum of products.
Counta,Count Blank4:05
In this lecture,students will learn how to count numbers,text and symbols in a data set or range.For Count Blank,in this lecture,students will learn how to count empty cells in a data set or range.
Count2:18
In this lecture,students will learn how to count numbers in a data set or range
Countif8:11
Abs4:38
In this lecture,students will avoid Negative sign using Abs function.
Day,year2:47
In this lecture,students will extract Day,year from Original date using Day,year function separately.
Month2:09
In this lecture,students will extract Month from original date using Month function.
Hours,Minutes,Seconds2:33
In this lecture,students will extract Hours,Minutes,Seconds from original Time using Hours,Minutes,Seconds function separately.
Today2:02
In this lecture,students will calculate days passed from previous date using time function.
Max,Min7:32
In this lecture,students will find out Max,Min number within range of cells or data set using Max,Min function.
Find7:52
In this lecture,students will find out position of character in a text string using find function.
Sqrt2:48
Proper,Upper,Lower4:29
In this lecture,students will convert text into proper format,convert lower text to upper text and upper text to lower text.
Dollar5:47
In this lecture,students will convert numbers into dollar format using dollar function.
LCM3:11
In this lecture,students will return the least common multiple from cell using LCM function.
Length3:00
In this lecture,students will find out the length of characters from cell.
Concatenate3:22
In this lecture,students will combine multiple text strings into single text string.
Converts a number into text format using Spellnumber3:28
In this lecture,students will convert numbers into words.
Calculate the age in years using Datedif2:13
Calculate the age in years using Dated if function.
Calculate difference between date of Birth and Today Date using datedif function7:01
In this lecture,students will Calculate difference between Date of Birth and Today Date using dated if function.
Code2:55
In this lecture,students will find out codes from character or text using code function.
Exact3:51
In this lecture,students will check whether two text strings are the same and returns True or False.
Mode4:22
In this lecture,students will learn how to return repetitive values in an array.
NFormula3:17
In this lecture,students will learn how to convert non-number value to a number,dates to serial numbers,True to 1 or False to 0.
Vlookup with Product Function8:39
In this lecture,students will learn how to retrieve data or information organized in a column from a table vertically.
Hlookup9:53
In this lecture,students will learn how to retrieve data or information organized in a row from a table horizontally.
Sumif4:36
In this lecture,Students will learn how to add all the cells within a range but on some criteria.
Large3:12
In this lecture,Students will learn how to Point out Largest values in the data set or range of data.
Trim Function2:12
In this lecture,Students will learn how to remove extra or unwanted spaces using trim function.
Power6:29
In this lecture,Students will learn how to find Power of numbers.

Conditional Formatting with Highlight rules15:30
In this lecturer,students will learn how to indicate greater,lowest,equal or equal to and between values from a table.
Conditional formatting with Databars10:53
In this lecture,students will make how to apply conditional formatting with data bars to mark highest and lowest values.
Conditional Formatting with Duplicate Values6:31
In this lecturer,students will learn how to point out duplicate values from a table.
Conditional Formatting with Unique Values6:30
In this lecturer,students will learn how to point out a unique/single entry values from a table.

Conditional Formatting with Progress bar7:40
In this lecture,students will learn how to mark highest value or lowest value from a table using conditional formatting with Progress Bar.
Conditional Formatting with Two Color Scale3:46
In this lecture,Students will learn how to apply two Color Scale to find out the highest value and lowest value in the table or data set.
Conditional Formatting with Three Color Scale4:16
In this lecture,Students will learn how to apply three Color Scale to find out the highest value,lowest value and midpoint or mid value or Second highest value in the table or data set.

Pivot Table8:21
In this lecture,students will learn how to calculate product and sum of products from a table using pivot table feature.
Insert Background Pic in Microsoft Excel1:32
In this lecture,students will learn how to set background Pic in Microsoft Excel workbook.
Insert Online Pics6:42
In this lecture,students will learn how to download online pics and insert those pics in Microsoft excel Workbook.
Insert Pic3:51
In this lecture,students will learn how to insert Pic in Microsoft Excel workbook.
Take a Screenshot5:26
In this lecture,students will learn how to take a screen shot and insert it in Microsoft Excel Workbook.
Insert symbols4:55
In this lecture,students will learn how to insert Symbols or Special Characters in Microsoft Excel Workbook.
Dictionary2:36
In this lecture,students will learn how to search a meaning for words.

Requirements

A dedication to this course is required.
Students should have a little bit knowledge about Microsoft Excel
Microsoft Office 2013/2016 should be installed.
RAM: 2 Gigabyte (GB)
Processor: 1 gigahertz (GHz) or faster processor or system-on-a-chip (SoC)
Hard disk space: 3 GB for MIcrosoft Office 2016
Graphics card: DirectX 9 or later with Windows Display Driver Model 1.0
Display: 1024 x 768

Description

Excel is a powerful spreadsheet and data analysis application, with many capabilities which will assist you organize and add up of the info and numbers in your life.Excel is a powerful electronic spreadsheet program you'll use to automate accounting work, organize data, and perform a good sort of tasks. Excel is meant to perform calculations, analyze information, and visualize data in a spreadsheet. Also this application includes database and charting features.

A spreadsheet program is one among the staple applications that you simply should have in your computer. And once you talk about spreadsheet applications, the primary thing which will come to your mind is Microsoft Excel. For quite 30 years, this office suite from the software developing giant, Microsoft, has been setting the quality for what a spreadsheet app should be.

Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering, and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives.

Who this course is for:

This course is designed for all levels IT and non-IT students.
A beginner user can easily understand the concept of Microsoft Excel
There is a valuable content for Everyone.
This course is perfect for those IT and non-IT students who want to accelerate their career in Microsoft Excel

Microsoft Excel from Beginner to Advanced.

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 17min

Microsoft Excel Basics12 lectures • 50min

Basic Excel formatting8 lectures • 59min

Microsoft Excel Functions34 lectures • 2hr 34min

Filtering Data in Microsoft Excel workbook3 lectures • 18min

Data sorting1 lecture • 7min

Linking two Excel files1 lecture • 5min

Conditional Formatting4 lectures • 39min

Conditional Formatting with Progress bar3 lectures • 16min

Pivot Table7 lectures • 33min

Requirements

Description

Who this course is for: