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


protecting excel spreadsheetmultiple project tracking template exceltask tracking template excelpivotfields vbaif isna vlookuphow to put columns in excelconsolidate excel worksheetsexample of countiftrim function examplehow to unprotect excel 2010excel hide a columncell shading in excelvba dir functionvba active sheetwhat is dml and ddl in sql serversql for begginersexcel vba create text filehiding a cell in excelcell interior color vbajob costing excelvba reference sheet by namegantt chart template wordactivex control examplevba create queryrange cells excel vbaproject tracking dashboard templatesql mcq questions with answers pdfhlookup excel 2010vba excel loopsvba open access database from excelaccess vba sqlexcel 2007 advanced tutorialchange column width in excelmerge cells in excel 2007kpi gauge excelduplicate numbers in excellistbox rowsource vbasum if vbauseful vb scriptshow to use a pivot table in excel 2007merge text files in excelexcel vba & operatorunlock excel macroeasy vlookup tutorialisna vlookup excel 2010vba copy and pasteexcel look up functionsexcel forgot password to unprotect sheetvba class module tutorialmeaning of vlookup and hlookupvba file browservba pop up boxiserror in excelexcel macro offseteasy vlookup stepshighlight duplicate cells in excelmacro open excel filehlookupoffset in vbadaily log template excelhow to make if statements in excelexcel isna functionexcel merge sheets into one workbookhow to connect excel to sql server databasems excel macros tutorialshowalldata vbahow to use pivot in excel 2007vb6 color codesmessagebox exampleunprotect sheet excel vbavba select case truehow to arrange excel sheet in ascending orderhow to dedupe in excel 2010clustered cylinder chart excelcreate excel userforminstr function in excelexcel macro for vlookupvalue excel vbaexcel 2013 pivot table tutorialhighlighting duplicates in excel 2010