Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Sam Parulekar. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.
This is a very easy to learn course as it is taught in a simple step by step manner.
Example files have been provided for practice.
WIIFM (What's in it for me?)
By the end of this course you would be able to comfortably work in excel, do data analysis and be able to present your data in a presentable format.
Background or Experience requirements.
This course does not expect any previous background of Excel. It starts from scratch and makes you comfortable with Excel.
Who should do this course?
This course is ideal for Data Entry Operators, MIS Executives, MIS Analyst, Data Analyst, Business Analyst any person who wants to enter and maintain his data.
Ideal for Students, Home Makers and Teachers as well.
Contains advance options like Introduction to Macros and Mail merge as well.
How can this course help you?
This course can help you to organize data and perform financial analysis.
It can be used across all business functions and at companies from small to large.
The main areas where this course can help you would include:
Charting and graphing
Introduction to programming
Customer relationship management (CRM)
Almost anything that needs to be organized!
Understanding the Excel Interface
Autofill Series and Flash Fill
Mail Merging with Excel Data
Basic Computer Fundamentals and Terminologies
A Computer with Windows or MAC OS and Excel 2016 installed
Minimum 8 GB RAM
This course will provide you with the requisite understanding and skillsets to utilize Microsoft Excel most effectively. Excel is one of the most popular spreadsheet applications and is a powerful analysis and data visualization tool. To analyze your data, you will use formulas to do complex calculations. With the free Excel course online, you will also learn about concepts like borders, sorting, and filtering data, if-else conditions, dates, and times.
What is Excel?
Excel is a spreadsheet application used by marketers, accountants, data analysts, and other professionals to store, organize, and track data. The application is part of the Microsoft Office suite. Google Sheets and Numbers are alternatives.
What is the purpose of Excel?
The Excel spreadsheet program allows you to organize, filter, and visualize large amounts of data. Excel is most commonly used by accountants for managing large datasets, but it is available to all professionals. Data calculators, budgets, and balance sheets are several examples of Excel applications.
Excel is most commonly used for creating financial documents due to its strong computation capabilities. Accounting offices and teams often use the software to see sums, averages, and totals automatically. It allows them to make sense of business data easily.
Excel benefits professionals in all fields - especially marketers - since it can be used to track any kind of data despite its reputation as an accounting tool. With it, you don't have to spend hours counting cells or copying and pasting performance numbers. Excel often offers shortcuts that speed up the process.
Basics of Excel
We recommend you become familiar with a few basic Excel commands if you're just getting started. These include:
1) Making a new spreadsheet from scratch.
2) Addition, subtraction, multiplication, and division are basic computations.
3) Creating titles and texts for columns.
4) Making use of Excel's auto-fill features.
5) Updating a single column, row, or spreadsheet. Let's talk about adding columns and rows in the following section.
6) When you scroll past column and row titles in a spreadsheet, you will be able to see what data you are entering as you go down the page.
Formulas in Excel
It's easy to get overwhelmed by the wide range of Excel formulas that can be used to make sense of your data. You can use the following formulas to carry out some complex functions in Excel, without adding to the complexity of your learning path.
A formula must begin with an equal sign (=) in the cell where the result should appear.
1) Addition: Use the plus sign (+) to add two or more values. Ex: =C5+D3.
2) The - sign is used to subtract values from two or more cells. =C5-D3 is an example.
3) To multiply two or more values, use the * sign. For instance, =C5*D3.
4) A / sign divides the values of two or more cells. A good example is =C5/D3.
Combining all of these, you can create a formula that adds, subtracts, multiplies, and divides all in one cell. A good example is =(C5-D3)/((A5+B6)*3).
If you have a complex formula, you will need to use parentheses around the expressions to avoid accidentally using the PEMDAS order of operation. Plain numbers are also acceptable in your formulas.