Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
home
Naukri Code 360
expand-more
Library
expand-more
Microsoft Excel
Last updated: Jul 5, 2022

Microsoft Excel

Microsoft Excel is one of the leading visual and analytics tools in the industry. It has applications in a wide range of fields. This blog provides an in-depth look at Microsoft Excel from ground zero. It guides you through the simple process of updating a spreadsheet to creating complex and visually appealing data representations and computations.

Excel Basics

In this Module, we are going to take a look at what Excel actually is and what it has to offer us along with the possibilities that it could bring for you after mastering it.
Must have Excel Skills
This article discusses everyday MS Excel skills. We will also understand the applications of Excel skills and how powerful of a tool it is.
Author AbhayTrivedi
0 upvotes
Top Careers in MS Excel
In this article, we will talk about the top careers in MS excel and how you can achieve them.
Author Aditya kumar
1 upvote
Data Preprocessing in Excel
In this blog, we will discuss what data preprocessing in Excel is. We will discuss how to preprocess the data in Excel.
Author Ravi Khorwal
2 upvotes
Introduction to Cells
In this blog, we will learn about cells in MS Excel, rows and columns, functions we can perform with cells, features, and properties of cells.
Author Naman Kukreja
1 upvote
Worksheets in Excel
In this blog, we will learn about worksheets in excel, the different operations one can perform on excel worksheets, and the difference between worksheets and workbooks.
Author Naman Kukreja
1 upvote
3D Graphs in Excel EASY
This blog will discuss 3D Graphs in Excel with a step-by-step implementation of an example, some best practices while using them, and some frequently asked questions.
Author Aayush Sharma
1 upvote

Essential Excel Functions

In this module, we discuss some of the most basic and widely used functions available in Microsoft Excel.
Count Function EASY
This article will cover the excel sheet functions along with the examples.
Author Soumya Agrawal
1 upvote
The Sum Function EASY
The SUM function in Excel is mainly used to sum a range of cells. In this article, we will learn about the SUM function, its syntax, and its types in detail.
Author GAZAL ARORA
2 upvotes
Min, Max, and Average EASY
In this blog, we will be studying some essential functions of excel, namely min, max, and average.
Author Prachi Singh
1 upvote
Logical Functions In this Module, we are going to discuss the basic logical operations that are performed in mathematics and how to implement them in Excel.
Date Time Functions In this Module, we are going to discuss the Date and Time time-related functions present in Excel.
Lookup Functions In this module, we are going to discuss the lookup functions present in Excel and their uses in navigating through the data.

Pivot Tables in Excel

In this module, we are going to discuss Pivot Tables a powerful tool to calculate, process, and summarize the data that helps you spot patterns or trends and other useful information.
Introduction to Pivot Tables EASY
This blog will cover the introduction to pivot tables. Moreover, we will see how we can use them with examples.
Author devika varshney
1 upvote
Group Pivot Table Items EASY
This blog will teach us about how to group pivot table items. Furthermore, we will learn how to group products and dates by quarter.
Author devika varshney
0 upvotes
Multilevel Pivot Table in Excel
This article will discuss how to create a Multilevel Pivot Table in excel.
Author apoorv007
0 upvotes
Pivot Charts EASY
This blog will cover the topic of Pivot Charts. Furthermore, we will learn how to represent our data in the Pivot Charts and how we can update pivot charts.
Author devika varshney
0 upvotes
Slicers and Timeline
You can use slicers and timelines to filter your PivotTable data, and at a glance, you can see what filters are applied.
Author Pranay Chauhan
0 upvotes
Calculated Field and Calculated Item EASY
In an Excel pivot table, calculated fields and calculated items are custom formulas.
Author Pranay Chauhan
1 upvote
GetPivotData EASY
This blog covers the concept of the use of Excel GetPivotData function, which is specifically designed to extract data from a pivot table.
Author Pranay Chauhan
0 upvotes

Charts in Excel

In this Module, we are going to learn how to represent your data in a more visually appealing manner in form of Charts, Graphs, etc.
Pie Chart EASY
This blog will cover the topic of a Pie chart. Furthermore, we will learn to represent our data in the Pie chart.
Author devika varshney
0 upvotes
Bar Chart EASY
This blog will cover the topic of a Bar chart. Furthermore, we will learn how to represent our data in the Bar chart.
Author devika varshney
1 upvote
Area Charts in Excel EASY
This blog covers the concept of area charts in Excel. We will understand how to represent data using area charts in Excel.
Author Sneha Mallik
0 upvotes
Scatter Plot
This article discusses Scatter plots in Excel and their use. We will also understand the applications of Scatter Plot and how powerful of a tool it is for finding correlations between two variables.
Author AbhayTrivedi
0 upvotes
Chart Axes
In this article, we will discuss chart axes in excel.
Author Aditya kumar
1 upvote
Chart Sheet EASY
This article discusses how to generate a chart in an excel chart sheet.
Author Alisha
0 upvotes
Trendline in Excel EASY
This article incorporates understanding and drawing trendlines in excel.
Author Pakhi Garg
0 upvotes
Error Bars
Error bars in Excel are graphical representations of data variability.
Author Pranay Chauhan
0 upvotes
Sparklines EASY
This article incorporates Sparklines in excel, followed by detailed, frequently asked questions.
Author Aditya Singh
0 upvotes
Combination Chart EASY
In this article, we are going to create a Combination Chart that represents two different sets of data on a single chart.
Author Divyansh_4bb5
0 upvotes
Gauge Chart
A gauge chart shows the minimum, the maximum and the current value depicting how far you are from the maximum.
Author Pranay Chauhan
0 upvotes
Pareto Chart EASY
In this article, we will discuss the Pareto chart, what it is, what principle it follows, and how to create a Pareto chart in Excel.
Author Apoorv Dixit
0 upvotes
Special Purpose Charts In this Module, we are going to take a deeper look into some of the Charts such as Heat Maps, Stock Charts, etc. each having a special purpose and how to use them in Excel.

VBA in Excel

In this Module, we are going to take a brief look at VBA which is Microsoft’s Programming Language for excel, and discuss some of the available functions.
Introduction to Excel VBA
In this blog, we will be studying a detailed description of Excel VBA.
Author yuvatimankar
0 upvotes
Introduction to Macro EASY
In this article, we will discuss how to create and perform some other functions on the macro in the Excel sheet.
Author Soumya Agrawal
0 upvotes
MsgBox and InputBox in VBA EASY
In this blog, we will discuss the uses and basic syntax of MsgBox and InputBox functions of Excel VBA along with their differences.
Author Ankit Mishra
0 upvotes
Workbook and Worksheet Object EASY
In this blog, we will discuss the differences between Workbooks and Worksheets and their important methods, in continuation with a discussion of loops and working with files and preparing charts in Excel.
Author Ankit Mishra
0 upvotes
Range Object EASY
The Range object is the most significant object in Excel VBA since it represents cells on your worksheet. In this article, we will learn about the properties and functions of the Range objects.
Author GAZAL ARORA
0 upvotes
Variables EASY
In this blog, we will be studying the declaration and initialization of variables in Excel VBA.
Author Prachi Singh
0 upvotes
If Then Statement EASY
In this blog, we will be studying the use of the If-Then statement in Excel VBA.
Author Prachi Singh
0 upvotes
Loop EASY
In this blog, we will be studying different types of loops in Excel VBA.
Author Prachi Singh
0 upvotes
Using Macro Errors in VBA EASY
This blog will go through various strategies for using debugging errors and macros in Excel VBA.
Author dhruv sharma
0 upvotes
Using Strings in VBA EASY
In this blog, we will take a look at how strings and their operations are used in Excel VBA.
Author dhruv sharma
0 upvotes
Date and Time in Excel
In this blog, we will learn various operations that can perform with date and time in Excel. First, we will learn to print simple dates, then compare them, find weekdays between some dates, delaying, find the frequency of occurring of a particular year, sort birthdays, and all this with examples to understand better.
Author Naman Kukreja
0 upvotes
Array in VBA EASY
In this blog, we have discussed Arrays in VBA, How they are used, and the main differences between the One Dimensional and Two-dimensional arrays, concluding with the Inbuilt array Function and Size of the array.
Author Ankit Mishra
0 upvotes
Application Object
In this blog, we will learn about application object, their different functions, and their different properties like status bar, reading data from text files writing data to the text file, and vlookup. We will understand all these with good examples and pictorial representation.
Author Naman Kukreja
0 upvotes
Userforms
In this blog, we will learn about user forms in excel in VBA, ranges in VBA,  with multiple applications, and all of this with their pictorial representation and proper code.
Author Naman Kukreja
0 upvotes
Web Scraping with VBA EASY
This blog will contain the Web Scraping technique with VBA in detail.
Author Soumya Agrawal
0 upvotes

Miscellaneous in Excel

In this Module, we are going to look over some of the intriguing features that Excel provides its users and how to access them.
Excel vs Google Sheets
This blog will learn about Excel vs Google Sheets and its advantages and disadvantages.
Author Juhi Sinha
1 upvote
Dynamic Array Functions EASY
In this article, we will learn about the Dynamic Array Functions of Excel.
Author Komal Shaw
0 upvotes
How to create Calendar in Excel EASY
In this article, we will learn how to create a calendar in Excel
Author HET FADIA
1 upvote
Chi Square Distribution and f Distribution in Excel MEDIUM
This article Chi Square Distribution and f Distribution in Excel, discusses chi square distribution and f distribution and their functionalities in Excel.
Author abhay_rathi2435
0 upvotes