Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
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.
Introduction to Excel
In this blog, we will learn about excel, the need to use it, advantages, disadvantages, features, ribbon, and much more.
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.
Top Careers in MS Excel
In this article, we will talk about the top careers in MS excel and how you can achieve them.
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.
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.
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.
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.

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.
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.
Multilevel Pivot Table in Excel
This article will discuss how to create a Multilevel Pivot Table in excel.
Frequency Distribution using Pivot Table
This article discusses how to form a frequency distribution of excel data using a pivot table.
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.
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.
Calculated Field and Calculated Item EASY
In an Excel pivot table, calculated fields and calculated items are custom formulas.
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.

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.
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.
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.
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.
Chart Axes
In this article, we will discuss chart axes in excel.
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.
Error Bars
Error bars in Excel are graphical representations of data variability.
Sparklines EASY
This article incorporates Sparklines in excel, followed by detailed, frequently asked questions.
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.
Gauge Chart
A gauge chart shows the minimum, the maximum and the current value depicting how far you are from the maximum.
Gantt Chart EASY
In this article, we will learn how to insert Gantt charts in Excel
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.

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.
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.
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.
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.
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.
Variables EASY
In this blog, we will be studying the declaration and initialization of variables in Excel VBA.
If Then Statement EASY
In this blog, we will be studying the use of the If-Then statement in Excel VBA.
Loop EASY
In this blog, we will be studying different types of loops in Excel VBA.
Using Macro Errors in VBA EASY
This blog will go through various strategies for using debugging errors and macros in Excel VBA.
Using Strings in VBA EASY
In this blog, we will take a look at how strings and their operations are used in Excel VBA.
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.
Events in Excel EASY
In this blog, we will learn events in excel with different examples and scenarios like DoubleClick event, creating a footer, highlighting the active cell, and some applications in problems.
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.
Functions and Sub in Excel
This blog discusses functions and sub, including the difference between these and how we deal with them in excel VBA.
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.
ActiveX Controls
In this blog, we will learn about ActiveX Controls like text boxes, command buttons, list boxes, etc., with the proper method to set them up and use them with code in VBA. To sum up, we will also learn how to make a loan calculator.
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.
Web Scraping with VBA EASY
This blog will contain the Web Scraping technique with VBA in detail.