MS Excel

Microsoft Excel - Excel from Beginner to Advanced 

Udemy

Course Level: Beginner

Rating: 4.7

Description: Master MS Excel skills from Beginner to Advanced; Build a solid understanding of the Basics of Microsoft Excel.

Excel Skills for Business: Essentials 

Coursera

Course Level: Beginner 

Rating: 4.9

Description: Learn how to perform basic calculations with formulas and functions, professionally format spreadsheets, and create data visualisations through charts and graphs.

Using Basic Formulas and Functions in Microsoft Excel 

Coursera

Course Level: Beginner 

Rating: 4.7

Description:  Write formulas to perform simple calculations like addition, subtraction, multiplication, and division; Use the SUM and SUMIF functions to analyse data; Calculate averages and percentages.

Data Visualization with Advanced Excel 

PwC

Course Level:  Beginner 

Rating: 4.8

Description:  Learn to use PowerPivot to build databases and data models; Perform simulation analysis using Excel built-in tools; Learn how to visualise data, tell a story, and explore data by reviewing core principles of data visualisation and dashboarding. 

Excel Tips and Tricks

Great Learning

Course Level: Beginner 

Rating: 4.62

Description: Learn advanced MS Excel techniques and best practices, including advanced formulas and functions, data analysis and modelling, charting and graphing, and macros and automation.

Microsoft Excel - Advanced Excel Formulas & Functions

UDEMY

Course Level: Advanced 

Rating: 4.2

Description: Learn how to use the advanced MS Excel formulas and functions 

Basic Formulas/Functions (SUM, AVERAGE, MIN, MAX)

Complex formulas and functions (VLOOKUP, INDEX, MATCH) 

Mastery of array formulas and dynamic arrays 

Advanced PivotTable (slicers, calculated fields) 

Power Pivot for data modelling and DAX formulas 

Integration with external data sources (SQL, Power BI) 

Automation with VBA and complex macros 

Advanced charting and data visualisation techniques

Advanced data analysis with Power Query

Password protection, Workbook automation, Error handling

• Workbook: An Excel file containing one or more worksheets.
• Worksheet: A single spreadsheet within a workbook consisting of cells arranged in rows and columns.

• Cell: The basic unit for storing data, identified by a column letter and a row number (e.g., A1).
• Row: A horizontal group of cells identified by a number.
• Column: A vertical group of cells identified by a letter.

• Formulas: Expressions used to perform calculations on data in cells, starting with an equals sign (e.g., =A1+B1).
• Functions: Predefined formulas that simplify complex calculations (e.g., SUM, AVERAGE).

• Allows users to change the appearance of data in cells, including font size, colour, cell borders, and background colour, to improve readability and presentation.
• Automatically format cells based on your specified criteria, such as highlighting cells with values above a certain threshold.

• Visual tools that represent data graphically, such as bar charts, line graphs, and pie charts, help to illustrate trends and patterns.

• PivotTable is a powerful feature for summarising, analysing, exploring, and presenting large amounts of data. 
• PivotTables can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarised data.

Sorting and Filtering

• Sorting refers to when a user rearranges data in a specific order, either ascending or descending.
• Allows the display of only the rows that meet specific criteria, hiding the rest.

• Ensures the integrity of your data by setting rules that dictate what data can be entered into a cell.

• Features that allow you to protect your data from unauthorised access or alterations. 
• Includes locking cells to prevent editing and password-protecting your workbooks.

• We can use it for free just by having a Microsoft Account, and it also allows us to save all our documents in the cloud so that they will be protected, and we can access them from anywhere.

• Google Drive is the successor to Google Docs, Google's office suite in the cloud. Within Drive, we can access Google applications completely free of charge, just like with Excel online.
• All the documents we make will be saved in the Drive cloud, thus always being safe.

• LibreOffice is the closest open-source alternative to Office. This office suite, developed by The Document Foundation, allows most users to replace Office with a completely free alternative that has practically the same functions and features as the Microsoft suite.
• LibreOffice Calc is fully compatible with spreadsheets created with Office, so you shouldn't have a problem switching from one application to another.

• Zoho Sheet is an excellent alternative for small businesses and end-users.
• It focuses on group work on the cloud and is free for a maximum of 25 users.  

• OnlyOffice is 100% compatible with Office and is open source. This suite has a free version, aimed at users, and a paid version, hosted on its servers, focused on companies.
• This way, users can choose the edition that best suits them based on their needs. Among its features, we can highlight data security, the administration of all corporate documents, and a large number of productivity functions.

Project Manager

INR 4.2 - 30 LPA

INR 2.9 - 20 LPA

Bridging the gap between IT and the business using data analytics to assess processes, determine requirements, and deliver data-driven recommendations.

INR 2.4 - 9 LPA

Finance and Banking

• Financial analysis
• Modelling
• Budgeting
• Risk management

Accounting

• Managing financial records
• Creating balance sheets, income statements, and cash flow statements
• Auditing
• Ensuring compliance with financial regulations

Marketing

• Market analysis
• Budgeting
• Campaign performance tracking
• Customer data analysis

Human Resources

• Employee data management
• Payroll management
• Performance tracking
• Resource planning

Manufacturing and Engineering

• Project management
• Inventory tracking
• Quality control
• Engineering calculations

Healthcare

• Patient records management
• Medical billing
• Clinical data analysis
• Scheduling

Education and Research

• Student data compilation
• Academic scheduling & budgeting
• Managing educational resources.

Marketing Analyst