Microsoft Excel: Learn Complete Basics, Functions & Formulas

Focused View

Pradeep Raj

2:58:55

139 View

1. INDEX

1. The Excel Course Promo.mp4

00:15

2. How to Get MS Office Application....mp4

03:23

3. Things We Learn From Now....mp4

01:32

2. INTRODUCTION

1. An Introduction to MS Excel Professional Plus 2021.mp4

05:13

2. Knowing Excel Cells, Rows, Columns.mp4

09:16

3. What are Clipboard.mp4

07:50

4. Work On Fonts.mp4

11:33

5. Lets See Alignment.mp4

14:25

6. Shall We Discuss on Numbers.mp4

15:33

7. Look at the Excel Styles....mp4

07:26

8. Lets Talk About Cells.mp4

15:58

9. Will Do Some Editing.mp4

15:16

3. WELCOME TO EXCELL

1.1 Book1.xlsx

1. Basic Arithmetic Operations.mp4

07:59

2.1 ADD.xlsx

2. Working with ADD.mp4

12:46

3.1 Workbook.xlsx

3. Working with FILL.mp4

13:32

4.1 Workbook.xlsx

4. Working with SPLIT.mp4

15:55

5.1 Workbook.xlsx

5. Working with TRANSPOSE.mp4

08:42

6.1 Workbook.xlsx

6. Discussion on SORT and FILTERS.mp4

12:21

Description

Learn all Basics of MS Excel. Expertise your MS Excel Functions & Formulas that Boosts Your Confidence.

What You'll Learn?

Building a strong understanding on the Basics of Microsoft Excel.
Learn ADD, FILL, SPLIT, TRANSPOSE, SORT & FILTER, TABLES, DROP-DOWNS, ANALYZE, CHARTS and PIVOTE TABLES.
Learn multiple methods of basic arithmetic functions like addition, subtractions, multiplications, divisions ect.
Introduction to Functions, Average, Min & Max, Date and Time and Joining Text & Numbers.
Learn IF Statements, VLOOKUP, Conditional Function, Function Wizard and Formula Errors.
Learn Power Query, Pie Charts and Organization Chart from the Data.

Who is this for?

For Beginners or Intermediates in any stream of the education are eligible to learn.

This course is mainly helps to those who are working in Banking or Banking sectors.

School students, College students and all professionals can learn this course and make work life easy.

What You Need to Know?

No prior knowledge of an excel is required, but must know bit about computer typing.

MS Office of any version is installed in your system or PC.

More details

Description
Microsoft Excel: Learn Complete Basics, Functions & Formulas...
Learn all Basics of MS Excel. Expertise your MS Excel Functions & Formulas that Boosts Your Confidence.

Microsoft Office Excel provides powerful tools and features that you can use to analyze, share, and manage your data with ease. The user interface makes it easy for you to work in Microsoft Office Excel. Commands and features that were often buried in complex menus and toolbars are now easier to find on task-oriented tabs that contain logical groups of commands and features. Many dialog boxes are replaced with drop-down galleries that display the available options, and descriptive tooltips or sample previews are provided to help you choose the right option. No matter what activity you are performing in the new user interfaceâ€”whether it's formatting or analyzing dataâ€”Excel presents the tools that are most useful to successfully complete that task.

To enable you to explore massive amounts of data in worksheets, Office Excel supports up to 1 million rows and 16 thousand columns per worksheet. Specifically, the Office Excel grid is 1,048,576 rows by 16,384 columns, which provides you with 1,500% more rows and 6,300% more columns. For those of you who are curious, columns now end at XFD instead of IV. Instead of 4 thousand types of formatting, you can now use an unlimited number in the same workbook, and the number of cell references per cell are increased from 8 thousand to limited by available memory. To improve the performance of Excel, memory management has been increased from 1 GB of memory to 2 GB in Office Excel.

You will also experience faster calculations in large, formula-intensive worksheets because Office Excel supports dual-processors and multithreaded chipsets. Office Excel also supports up to 16 million colors. You can use conditional formatting to visually annotate your data for both analytical and presentation purposes. To easily find exceptions and to spot important trends in your data, you can implement and manage multiple conditional formatting rules that apply rich visual formatting in the form of gradient colors, data bars, and icon sets to data that meets those rules. Conditional formats are also easy to applyâ€”in just a few clicks, you can see relationships in your data that you can use for your analysis purposes.
Who this course is for:
For Beginners or Intermediates in any stream of the education are eligible to learn.
This course is mainly helps to those who are working in Banking or Banking sectors.
School students, College students and all professionals can learn this course and make work life easy.

User Reviews

Rating

average 0

Total votes0

Focused display

I hold degrees in Electronics and Communication Engineering. I am an Electronics and Communication Engineer that specializes in circuit design, hardware design, PCB layout design and PCB Manufacturing. I have written many blogs and articles on the aforementioned subjects and taught Electronics Engineering courses at Swarna Institute of Technology (recognized by Micro Small and Medium Enterprise (MSME), Government of India) as well as online for many years. I also train on many professional skills like Microsoft office (Microsoft Word, Microsoft presentation and Microsoft Excel etc.), Fusion 360 (3D design and Development), Website Design and Development, Digital Marketing and 2D and 3D Animation. I am currently working as 'Training Head' at Swarna Institute of Technology, Bangalore, Karnataka, India.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.