Excel

Home/Excel

Microsoft Excel is a spreadsheet application, it helps to perform various calculations and create reports, dashboards and applications.

Adding Chart Title in Excel

Adding chart title in excel is a good practice while representing your data in graphical manner in Microsoft Excel 2003,2007,2010,2013. Readers can easily understand what is the particular chart is for. We will see the different ways of adding charts in excel. For example we can add the chart title from chart tools, we can

By |April 20th, 2014|Excel|0 Comments

Align Chart Title in Excel

We can change the Excel title position and align the chart title in the Excel charts as per our requirement. By default chart title will align top-center of the chart in Excel 2003,2007,2010,2013. We can place the chart title any where in the chart title. We can place left corner of the chart. We can

By |April 20th, 2014|Excel|0 Comments

Chart title background color in Excel

We will see how to change the background color of the chart title in this topic. We can change the chart fill color to match with the chart colors. We can use chart formatting tools to change the chart fill color. Chart title background color in Excel - Step by Step Learning Now we will

By |April 20th, 2014|Excel|0 Comments

Chart Title Border Style and Color in Excel

Changing Chart Title Border Style and Color in Excel will make your chart looks great. You change the chart title border colors and styles to match your chart layouts in Microsoft Excel 2003,2007,2010,2013. Chart Title Border Style and Color in Excel - Step by Step Learning Follow the below steps to change the Chart Title

By |April 20th, 2014|Excel|0 Comments

Format Chart Title in Excel

We will see how to format chat titles in Excel in this topic. The default chart titles in Microsoft Excel 2003,2007,2010,2013 are plain and will not have any background colors. There are lot of tools and options available in Microsoft Excel. We see how to use the built-in tools to change the chart title properties.

By |April 20th, 2014|Excel|0 Comments

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

Related pages


how to protect formulas in excel 2007excel data mining tutorialhide formulas in excel 2007how to create a pie chart in excel 2007excel iteration exampleexcel ribbon menusql questions and answers for written testvb programming examplescombo box vba excelfte analysis templateconnect excel to sqldml ddl dcl and tcl in sqlcreate pivot chart excel 2010excel vba message box yes novba excel valueexcel vba delete rowshow to delete duplicate rowsvba macros examplesvba case statement accessvba print pdfhow to use the sumif function in microsoft excel 2010useful excel spreadsheetsdelete empty cells in excelinsert chart title excelexcel vba copy and pastevba create command buttonexcel vba delete columnexcel worksheet activateexcel vba enduse of excel formulas with exampleexcel function substituteexcel scheduling templatecheckbox syntaxhow to add developer tab in powerpoint 2010alternative to vlookupexcel coding basicsexcel vba vlookup exampleexcel macro delete rowms excel 2007 formulas with examplesexcel remove duplicate datadim fsoexcel vba errvba examresource planning spreadsheet exceltick box in excel 2010excel vba columnsexplain activex controlinsert copied cellsrept excelcoding macros in excelwhat is ado connectionms access vba open formremoving duplicates in excel 2003merge cells excelhow to create excel macrosvba inserthow to find duplicates in an excel columnworkbooks excelexcel workbook examplesmicrosoft excel sql querybubble chart template exceltcl databasehow to use excel lookup functionmacros vbaadvanced sql interview questions and answersunlock excel worksheet without passwordexcel interesting trickshow to do a vlookup for dummiesvba commands excelvlookup explained in simple termsvba sql serverwhere is the developer tab in excelworksheet name in vbamacro buttonsascending in excelnaming a range in excelexcel copy cell contentshow to unprotect a password protected excel sheetformulas in vbaunlock password protected excel 2010open xlsx in excel 2003unlock password in excel