ADVANCE EXCEL T RAINING IN CHANDIGARH
What is an advanced chart? An advanced chart is a chart that goes beyond the basic charts created by Excel. Let's say you have more than one set of data that you would like to compare on the same chart, you can create your basic chart with one set of data then add more datasets to it and apply other items i.e. formatting to the chart. This is what advanced charts are all about.
The importance of advanced charts â—? â—?
They provide consolidated information in a single chart that makes it easier to compare more than one data set and make decisions quickly They allow us to customize the look and feel of the charts
Step by step example of creating advanced charts In this tutorial exercise, we will assume that we run a blog and have software that gives us the number of monthly visitors. We would like to see the relationship between the numbers of articles published per month vs the total month traffic. We will work with the following data set.
Explain few useful functions in Excel. Following are the functions available in Excel for manipulating the data: ● ● ● ● ●
Math and Financial Functions – SQRT, DEGREE, RAND(), GCD Logical Functions – IF, AND, FALSE, TRUE Date and Time functions – NOW(), DATEVALUE(), WEEKDAY(NOW()) Index Match – VLOOKUP and INDEX MATCH Pivot tables
Explain pivot tables and its uses. A pivot table is a tool that allows for quick summarization of large data. It automatically performs a sort, count, total or average of the data stored in the spreadsheet and displays result in another spreadsheet. It saves a lot of time. Allows to link external data sources to our Excel. What are three report formats that are available in Excel? Following are the types of report formats ● ● ●
Compact Report Tabular
SCO 23-24-25, Sector 34A Chandigarh, IN 160022 (+91) 9988741983 counselor.cbitss@gmail.com
WEBSITE;_ http://cbitss.co.in/quickbooks-training-in-chandigarh.html
THANK YOU