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

vba datevaluehow do you unprotect an excel spreadsheetexcel 2010 pivot table tutorialcell ranges in exceldim vba excelvalue vba excelloop in excel formulamacro to combine worksheetsunlocking excel workbookexcel vba datesmsgbox inputvba excel select worksheetvba excel sheetaccess vba backcolor codeshow to join cells in excelvba excel sheethow to use sumifs in excelvba filenameunhide lines in exceladd clearing choice buttonif isna formulaexamples of vlookup in excelunprotect excelldata definition language commands in sqlvba code wordremove duplicate data in exceldeveloper tab in excel 2010format excel vbaworksheet unprotectexcel vba database examplesvba white screensas programming tutorial pdfinsert row in exceldynamic array vba excelvba msgbox buttonscells excel vbaexcel vba application.getsaveasfilenamehow to delete macros in exceldynamic named range excel 2010vba select rowsexcel tutorial vbaexcel startup templatevba numericvlookup in excel formulaexcel formula countifexcel 2010 column widthunhide excel worksheetprotect a worksheet in exceliferror vlookup excelhow to write a macro in excelhow to create vlookup in excel 2007how lock excel sheethow to unhide cells in excel 2010what is an operandvba end loopunprotect macroexcel function syntaxexcel tables tutorialexcel vba breakexcel vba import text filehow to dedupe a list in exceladvanced filter excelhow to duplicate a cell in excelexcel construction schedule templateexcel formula hlookupshortcut keys for microsoft excellearn vba macrosshortcut keys for microsoft excelvba mod 2ddl commands in sql with examplesunlock excel file password protecteddcl commands in sql