MS Excel 2019 | Course Outlines | Class 01 part-III

Short Introduction about MS Excel


Hi! dear students and all new visitors. I hope all of you are good. Today is our class 1 part-III. In this class we are going discuses about MS Excel 2019 Course outlines. I already provided you course outlines in previous video named as Class 01 part-I. I hope you must watch your previous videos. I am referring previous classes here because this class also related those classes. In this class we discussed MS Excel 2019 outlines with in detailed. Its most important features are about calculations and graphic tools having other properties.


Its a Surprise for all of you


Dear students this class is a surprised for all of you because in this class I'll show our course outline about MS Excel 2019. These course outlines are designed for beginners to advanced and master level. These outlines are created in a sequence and step by step. Every topic is separated to each other.


About Excel


It features calculation, graphing tools, pivot tables and so more functions. Its purposes are world wide. In every walk of like it uses. Excel application has a huge uses all over the world. You can see its importance in your daily life for example, if you go to shopping, after completing your shopping you relieved a bill from shop keeper that bill actually designed in MS Excel. Its contains on spread sheets. MS Excel is the industry leading spreadsheet program, a powerful data visualization analysis and much more fictional tool. Many other software applications are also used for calculations in our business related field but MS Excel in most commonly used more than other software application on such a wide range. In my view no other application is available to compare this one. You can easily build your charts and spreadsheets to meet your specific needs.


Helpful uses


Dear students and all visitors its an amazing application because if you prepared a document in MS Excel you can easily share by saving to each other. Its files size no more although its files size remains too short even you can easily mail to one place to another.


Excel Outlines


Here your outlines are divided into many topics as mentioned below. Its purpose is that you can understand. Most important purpose of these outlines is that you can easily judge yourself about your course. Through these outlines you can easily imagine what we are going to learn? Through these categories you can easily confirm which topic you are going to cover. You can easily understand how much course you covered and remaining about these outlines.


Here is the image

MS Excel 2019 Outlines

• Basic Terminology of MS Excel
• Creating, Opening, Renaming a document
• Saving and Closing Workbook / Spread Sheet

Editing Functions

• Undo, Redo. Fill, Auto Fill, Delete
• Cut, Copy, Paste, Clear
• Find, Replace and go to commands

Inserting

• Header & Footer
• Cells Rows / Columns
• Add Worksheets

Working with Formulas

• Entering Formula with the help of Formula Bar Entering Formula
• Directly into the cells, sue of Arithmetic and Logical Formulas
• Use of Built- in functions Time and Date Concatenation, Sum if, Nested Max, Min
• Average, Count, Now, Month, Day, Year Upper, Lower, Left & Right

Tools and Date

• Spell Check, Auto Correction, 
• Workbook protection 
• Data Sorting and filtering

Formatting

• Cells and Text 
• Borders and Shading 
• Positioning Cells and Text 
• Auto Format

Categories of numbers

• Cell / Range Referencing 
• Alignment 
• Date & Time

Working with Charts

• Creating Editing and Formatting of various types of Charts

Printing

• Selecting a Printer 
• Print selected areas page selection
• Print Preview
• Page Setup / Page selections

Advance topic

• Sorter View
• Shortcut keys

and a Bonus Class for all.

All shortcut keys and more included that I’ll share time to time

So these are your course MS Excel 2019 outlines. You can view all topics from here. Here you can see all over topic names as mentioned above.

Note

May be some topic missing above mentioned outlines. So don't worry about it as I know I'll put them into our course outlines. Some class also cover more than one topics in one class. Because some topics are short tips and easy to understand. They will easily cover only in one video. But some topics may be lengthy and absolutely required more time and classes like part-I, part-II and part-III and up to so on. But I'll try of my best to cover all topic with in one video. 

Most Import Point

As you know your course MS Office 2019 started here and its class 1 part-III. I would like to say about these courses as I said in previous topic, if you are regularly watching your course video on daily bases then I assured you that I can't disappointed you. But if you miss any video you must watch it carefully. If you face any difficulty in understanding video topics, you can easily contact me through any platform that you like. I am here to teach and serve all of you. I assured you that I'll must solve your problems that you face. But here I am confidently say through these videos your all confusions will solve if you consume your time here. 

Subscribe

If you want to visit my YouTube channel you can easily redirect from here by just clicking on subscribe button. If you really like my YouTube Channel and video please comment, share and subscribe. After subscribe my YouTube channel press bell icon too get latest videos notification.

Just Click on Subscribe button

In the End

I want to clear all your doubt that these videos are also available on my YouTube Channel named as " Xtream Info ". I don't use any other person videos here. Because here I am teaching all of you through this website from my method and I hope you must learn here.

As you know

There is a famous phrase

"God helps those who help themselves" 

and it includes in a motto that emphasizes the importance of self-initiative. 

Just always pray for all. Allah almighty must bless you from success if you try to achieve your goal of life.

Tutor

Shahid Ghafoor