What you'll learn

Data visualization in excel

Data sorting in excel

Data cleaning in excel

Data formatting in excel

Making charts in excel

Excel keyboard shortcuts

Power excel Functional

Data filtering in excel

Requirements

Little or no knowledge or experience in excel

A computer system

Description

What is Excel?

Excel is a spreadsheet program from Microsoft and a component of its Office product group for business applications. Microsoft Excel enables users to format, organize and calculate data in a spreadsheet.

By organizing data using software like Excel, data analysts and other users can make information easier to view as data is added or changed. Excel contains a large number of boxes called cells that are ordered in rows and columns. Data is placed in these cells.

Excel is a part of the Microsoft Office and Office 365 suites and is compatible with other applications in the Office suite. The spreadsheet software is available for Windows, macOS, Android and iOS platforms.

Common Excel use cases

Excel is most commonly used in business settings. For example, it is used in business analysis, human resource management, operations management and performance reporting. Excel uses a large collection of cells formatted to organize and manipulate data and solve mathematical functions. Users can arrange data in the spreadsheet using graphing tools, pivot tables and formulas. The spreadsheet application also has a macro programming language called Visual Basic for Applications.

Learn_Excel_From_Scratch_Beginners_to_advance.part1.rar - 995.0 MB

Learn_Excel_From_Scratch_Beginners_to_advance.part2.rar - 482.6 MB