Excel Concepts

Home/Tag:Excel Concepts

Learn Excel to create rich visualized reports and dashboards for data analysis.

Chart Styles Layouts and Templates in Excel

Creating Charts in Excel is very easy, we change the look and feel by working with Chart Styles Layouts and Templates in Excel. Chart Styles, Layouts and Templates in Excel help us to change the look and feel of the charts to create rich visualized charts in excel for your data. Working with Styles in

By |September 24th, 2013|Excel|0 Comments

Create Charts in Excel

Well! we have seen some basics of charts in the previous topic. Now, we will see how to create charts in Excel. In this session I will take your through the step by step to create basic charts in Excel. Then we will see the advanced charts options to customize charts in Excel. Getting Started

By |September 22nd, 2013|Excel|0 Comments

Excel Chart Elements and Chart wizard

Many of our readers asking me to post tutorials to understand Excel Chart Elements and Chart wizard. This is the topic for those who wants to understand and getting started with excel charts. In this topic, We will see what are the different objects or elements related to charts, and how to access chart elements

By |September 22nd, 2013|Excel|2 Comments

Data Validation in Excel – Adding Drop-Down Lists in Excel

Data Validation is a feature available in Excel to define restrictions and what data can enter in a cell. For example,

  1. We can restrict data entry to a certain range of values
  2. User can select a choice form predefined list
  3. We can display a message to provide the instruction to the user
  4. We can display a message when user enter an incorrect value

By |May 12th, 2013|Excel|0 Comments

Introduction to Microsoft Excel and Creating First Excel File

Microsoft Excel is one of the tools in the Microsoft Office Package; it is used to create spreadsheets. It has many in-built functions and tools to work with data and create different type of reports and dashboards. It also provided the feature to the users to work behind the existing tools and can enhance its capabilities. To implement functionality beyond a regular spreadsheet, Microsoft Visual Basic programming environment is provided with Microsoft Office Excel. This programming language is called as Visual Basic for Application (VBA). In This Section:

  • What is Excel?
  • Why is it used?
  • Creating your first excel workbook.

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

15 Must Known Excel Tips for Every Excel User

When we are working with some application, we use same method to finish some task. After sometimes we think for an alternative method to perform our task more faster and easy way. However, it will come with experience and take sometime to know the smarter way of doing the things. Now, its not required years of experince in Excel to work smarter! Spending sometime on reading this chapter will make you to execute the tasks smarterway and it will improve the prductiveit.

By |March 8th, 2013|Excel|4 Comments

Excel Basics Tutorials


Excel Basics tutorials are for beginners with no knowledge of Excel, in this section we cover the introduction to MS Excel, Objects and Tools available in Excel, Data entry and Formatting. By end of this session you will have understanding about Excel and be more confident using Excel to start work with excel.

By |January 1st, 2013|Excel|0 Comments

Related pages

excel vba operatorvisual basic shortcut keyssql programmer interview questionsfso.deletefoldervba sub functionexample sumif excelvba query accessunhide tabs in excelexcel workbook password removerexcel formulas valuedml and ddl commands in sql servercreate a 3d pie chart in excelcombine columns in excel 2007create a checkbox in excelvba user inputselect vba exceldisplay developer tabvba copy rowhow to convert excel to xmlvba last row in rangems excel interview questions and answersexcel vba copy sheetpivot table in sql server 2008 exampleformat vba codevba dashboardhow to cut and paste on excelhow do i find duplicates in excelexcel vba examples codeexcel hide tabshow to find duplicates in excel sheetdelete macro in excelexcel project dashboardexcel vba code examplesexcel chart stylesvariable sheet name in excel formulaconditional statements worksheetsvba code to insert data into access tableexcel sorting macrounprotect excel sheet passwordvba create command buttonexcel hide a columngreater than and less than formula in excelexcel unhide all cellsvba sub functionhow to do drop down list in excel 2007join rows in excelvba chooseexcel vba count rows in rangehide columns vbaopen excel file vbavba code to copy data from one sheet to anotheradodb tutorialunprotect all sheets vbaworksheet cellscopy excel worksheet to another workbookin excel how many rows and columnshow to unprotect a workbook in excel 2010how to arrange cells in excelusing sumif exceluse of offset function in exceldeleting a pivot tablecopy sheet vbaexcel vba columnamazing excel templatesunhide personal workbooksum if function in excelsort excel spreadsheet by columncreate a macro in excelexample of vlookup in excel 2010access 2010 msgboxmerge rows excelexcel vba msgbox vbyesno