Requirements
Have a Computer
Microsoft Excel 2013 or higher
Description
In just 4 Hours learn all the Basics of Microsoft Excel through examples and practice problems that took me Months to learn!!!!!!
This Course is for Complete beginners & people who have some idea of the Excel work interface and are able to carry out simple formula tasks.
If you have lied in your Resume and now you need to learn Excel as fast as possible with proficiency then you have come to the right place!!!
Anyone who completes this course will have knowledge of the following things:
Introduction to interface, view, range, color fill, border, alignment, worksheet, input data, formulas, functions,
Duplicating data & formula, moving & copying data, making copying hiding sheets, sorting, sub
total, grand total, Adding currency sign to data, plotting charts, filter, quick access toolbar, error messages, freezing panes,
Search & find, custom tab, textbox & shape, gridlines, merging cells, find & replace, named ranges, save as types,
Conditional formatting, pictures & icons, number formats, printing area in Excel, custom sorting, Tables,
Text to columns, flash fill.
the formulas that are talked about in this course are:
Sum, average, integer, lookup, maximum, minimum, AutoSum, count, round, if, nested if, count if
Almost every lesson is taught through some example and practice problem for a more clear and advanced understanding of how to use them accordingly.
Also, a few Sheets were developed in this course which will give students of this course an idea of how to make sheets for themselves for their daily work whether it be for personal use or for commercial.
the intro video holds a significant purpose as well the message of that video is:
“Welcome to the Microsoft Excel Full Tutorial series. the intro video is about what to expect from the series and what you can learn from it so you may know what you are getting into and if it’s worth your time or not. I do hope you find the series to be useful for you and decide to see all the lessons I have prepared. and if you think it’s not for you there are other sources you can look from and I am happy that this video saved your time.”
Then the course list of videos will help the students of this course to navigate the course according to their needs. also, the returning students can benefit from the list as well. the list is as follows:
Microsoft Excel Tutorial
Introduction to Interface: get to know the interface
Microsoft Excel Tutorial
View, Range, Color fill, Border: learn about view range color fill and border
Microsoft Excel Tutorial
Alignment In Excel: learn to fix and adjust alignment.
Microsoft Excel Tutorial
Worksheet and Input data: learn about types of data that can be inputted.
Microsoft Excel Tutorial
Introduction to Formula SUM: learn the sum function.
Microsoft Excel Tutorial
Duplicating data & formula: learn about duplicating data and formula.
Microsoft Excel Tutorial
More on Duplicating data & formula
Microsoft Excel Tutorial
moving and copying data in excel: how to copy and move data in Excel
Microsoft Excel Tutorial
Moving around and activating cells using the keyboard in excel.
Microsoft Excel Tutorial
Making a simple Salary sheet in Microsoft Excel: how to do sorting, how to
calculate subtotal and grand total group wise
Microsoft Excel Tutorial
Water bill calculation area-wide with chart: learn to apply charts to display
analysis
Microsoft Excel Tutorial
Making a mark sheet: learn to do average, integer, lookup, and filter
Microsoft Excel Tutorial
QAT (quick access toolbar) in Microsoft Excel: learn all about QAT.
Microsoft Excel Tutorial
Error Messages in Microsoft Excel: learn about Error messages.
Microsoft Excel Tutorial
Freeze panes, Max & Min value, Find in Excel: as the name suggests.
Microsoft Excel Tutorial
Copying worksheets in Excel: copying sheets from workbook to
workbook.
Microsoft Excel Tutorial
How to create a custom Tab in Excel .: make your own personal TAB.
Microsoft Excel Tutorial
Textbox & Shape in Excel: learn to use textbox and shape.
Microsoft Excel Tutorial
How to remove gridlines in Excel .: learn to remove gridlines.
Microsoft Excel Tutorial
Merging cells & AutoSum: learn to merge cells and AutoSum.
Microsoft Excel Tutorial
Count & Round Function in Excel: as the name suggests.
Microsoft Excel Tutorial
Using find and replace: how you can use find and replace.
Microsoft Excel Tutorial
Named ranges in Excel: learn about named ranges.
Microsoft Excel Tutorial
Save as Types In EXCEL: learn about a few save as types.
Microsoft Excel Tutorial
Introduction to if function: we will learn about the if function.
Microsoft Excel Tutorial
Conditional formatting: learn conditional formatting.
Microsoft Excel Tutorial
Using conditional formatting to trace a customers purchase history
Microsoft Excel Tutorial
Insert pictures and icons: learn about inserting pictures & icons.
Microsoft Excel Tutorial
Number formats in Excel: learn about number formats.
Microsoft Excel Tutorial
Print Area in Excel: learn to set up print area.
Microsoft Excel Tutorial
Custom sorting: learn custom sorting.
Microsoft Excel Tutorial
Tables in Excel: all about Tables in excel (probably).
Microsoft Excel Tutorial
Text to Column: learn to spread text.
Microsoft Excel Tutorial
Flash Fill: learn the magic of Flash Fill.
Microsoft Excel Tutorial
Data Validation in Excel: learn the powerful & useful data validation.
Microsoft Excel Tutorial
Data Validation (part 2
Microsoft Excel Tutorial
Nested if: learn to put if inside if!
Microsoft Excel Tutorial
Countif in Excel: learn countif function.
Microsoft Excel Tutorial
Charts in Excel: learn more about charts.
Microsoft Excel Tutorial
Composite chart and Printing charts: as the name suggests.
Microsoft Excel Tutorial
Making a mental math Practice sheet in Excel: practice
whatever you have learned
Who this course is for:
Anyone who wants to Learn
#Microsoft #Excel #Basics #Home #Office #Get this Deal
تخفيضات,كوبونات,كوبون,عروض,كوبون كل يوم
Get this Deal,Get this Deal
udemy sale,udemy for business,udemy discount,udemy gutschein,business administration,discount factor,course deutsch,course catalogue,udemy course discount,javascript courses online,javascript course,freebies,toefl speaking,excel courses online,excel courses,excel templates dashboard,software engineering course online,software engineering course,