Monthly Archives: April 2013

Home/2013/April

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
Dashboard:
Executive dashboard to understand the overall data at one glance


Related pages


sas interview questions on macrosdelete empty rows in excelvba excel cells.findhow do you delete duplicates in excelhow to use userform in excelhow to use pivot table in excel 2010 with examplereplace formula in excelexcel formulas list 2007best excel vba bookconvert excel columns to rowsautofiltermode vbaexcel templates dashboardsetting up a pivot tableexcel carriage returnproject planning spreadsheetcombo box excel 2007nested if then statements in exceltotal rows and columns in excel 2010using countif function in excelsas programming tutorial for beginnerspassword spreadsheet templateexcel macro input boxvba cell valuecopy folder vbscriptexcel rtrimhyperlink to file in excelexcel macro loopaccess vba read text filewriting macros excelhow to do multiple if statements in excelcells.select vbams excel lookupexcel vba sortselect sheet excel vbavlookup code in vbaunlock macro excelexcel vba userform to input dataprint vba coderowcount vbahow to create drop down list in excel 2007vba declare global variableexcel 3d bubble chartaria charts 2010insert row excel macrovba autofitremove duplicates excel 2013excel vba vbyesnocsv to xml excelvba worksheet deletevisual basic worksheetdashboards for excelexcel find duplicate rowsexcel macro create foldershortcut excelrange in vba excelexample for vlookuphyperlink excel vbacreate userform in excelhow to do pivot table in excel 2007excel formula to hide rowsexcel proposal templateexcel formulas lookupexcel scripting tutorialexcel vba on errorhow to apply autofit in excel 2013excel lookup examplesremove duplicates from excel columnexcel advanced filter criteria range examplesvba runtime error 1004 application defined or object defined errorunhide columns vbahow to highlight duplicates in excelexcel macro sheetsdata validation vbamultiselect exampleopen and activate workbook vbasql ddl commandsconvert excel column width to inches