MS Excel (Basic)

Microsoft Excel is the one of the most commonly used Microsoft office applications. It is one of the most-used software programs in the business world and is used to create spreadsheets. These sheets are essential documents in which data is laid out in rows and columns and is also used to analyze numerical data.

The basic excel course involves understanding the basic features and functionalities of Excel, such as creating and formatting spreadsheets, inputting data, using formulas and functions, sorting and filtering data, creating charts and graphs, and performing basic data analysis. This is an entry level for someone who has no idea how MS Excel Works.

What will you learn under the MS Excel course:

• Link and Lock, Freeze, Filter
• Sumif, Sumifs, Sumproduct
• Round, Roundup, Round Down
• Auditing- Dependent, Precedent, Error Tracer
• If and If nested
• Concatenate
• Data Validation
• Vlookup
• Hlookup
• Whatif Analysis
• Pivot Table, Pivot Chart
• Data Consolidation
• Hyperlink
• Data Base
• Fill and Remove Duplicates
• Conditional Formatting
• Printing
• Basic Macro
• Protection
• Paste Special

Who is This Course Designed For?

• College students who want prepare themselves for jobs
• Freshers who do not have much knowledge about excel and need to upskill to get better at their job
• Someone who knows basic excel but wants to learn the advance course and get at using MS excel
• Business owner who wants to entry all business data in a systematic manner
• Anyone who wants to create spreadsheets to make any work they do efficient