Monthly Archives: April 2013


TIME Function in Excel

What is the use of TIME function? Returns the number that represents the particular time What is the syntax of TIME function? TIME(hour, minute, second) Where hour: It is a number from 0 to 23 representing the hour minute: It is a number from 0 t0 59 representing the minute second: It is a number

Getting Started with Microsoft Excel

In this section I will introduce the basic features of Microsoft Excel, one of the tools in the MS Office Package. It is a spreadsheet application used to enter the data (text, numbers, etc...) to perform calculations, analysis and store it in a file. There are many built-in functions and formulas allow you to perform calculations and you can create attractive, readable presentations and rich visualized dashboards including tables, charts,etc...

By |April 15th, 2013|Excel|1 Comment

Creating Dashboards in Excel – Dashboard Creation Using Sales Data

This is a simple dashboard, I have used a dummy store data for illustration purpose. Read more and learn to build a simple sales performance dashboard. Example dashboard is attched in the post, you can download and have a look into the file. In this dasboard:

Home Tab:
You can see how to prepare a main or home page for your dasboard
Sales By Region Tab:
Understand the sales by Region
Sales By Store Level Tab:
Understand the sales by Store
Executive dashboard to understand the overall data at one glance

Related pages

unprotect excel 2007 workbookhow to find duplicates in excel 2007sum if function in exceldelete doubles in excelconversion of xml file to excelvlookup excel step by stepautomatically insert rows in excelexcel deleting blank rowslogical formulas in excelsql interview question pdfsql identify duplicatescopy data from multiple worksheets into oneexcel monthly schedule templatereverse cell order excelexcel vba beginnervba sheet1iserrorwhere do i find a tick in excelms excel excel saveasdo while loop vba excelvba code snippetsexcel chart bar widthvba display messagemicrosoft word macro exampleswhere are excel macros storedvb source code exampleshow to find difference between two dates in excelmeeting minutes template excelaccess vba color codesexcel delete named rangeunprotecting excel sheetvba loopingadd multiple rows in excelexcel activate macroshow to find duplicates in excel 2013vba delete rowsautofit in excel 2010excel macro delete empty rowsusing excel functions in vbaexcel pie chart templatesformula for duplicates in excelexcel graphs tutorialvba code timervlookup hlookup pivot table tutorialaccess vba updateexcel if cell contains stringsimple gantt chart template excelexcel construction estimate templatevba commands excelexcel formula cell colorhow to write macro program in excelaccess vba insertscripting.filesystemobject delete filevba sheet1lock worksheetexcel 2003 pivot tablesfind duplicate rows excelthissheet vbavisual basic trim functionassign macro to data validation listexcel vba scrollrows excel vbaexcel vba class module examplemeeting schedule template excelexample sumifexcel delete sheetcopy worksheet excelvba outlook applicationmacro in excel tutorial pdfexcel vlookup formulas with examplesvba access databasemacro password excelexcel vba internet explorer