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


project timetable template excelvba run subwriting excel macrovlook up function in excelexport access query to excel vbavisual basic command buttonmacro excel insert rowexcel 2010 unhide sheetexcel if statement greater than or equal toprotecting excel filesexcel spreadsheet password protectcreate userformusing pivot in excelfor each in vba excelvba floatexcel find and remove duplicatesexcel lookup exampleadd a developer tab to the ribbonresource planner excelexcel project timeline chartvba double variablecopy paste vba excelmultiple if statements in one cellmacro basics excelcut paste worksheetsvba for loop stepdeleting cells in exceldynamic chart in excelhow to create xml file in excel 2007excel vba open file and copy datarelease plan excel templatehow to put columns in excelwhat is the developer tab in wordunprotect macroinput box vbabasic excel macro exampleshow to delete multiple cells in excelpassword protect excel 2010 workbookaccess vba insert recordexcel vba strproject tracking with excelvba range selectionproject plan template excelhow to unhide tabs in excelhow to get developer tab in word 2007excel odbc sql queryvba color index numbersexcel sumif exampleexcel trim commandunprotect worksheet excel 2010search duplicates in excelvba excel queryvba loopingmonthly schedule template excelvlookup limitationstcl in sql servercolumn method worksheetshow to do a pivot table in excel 2010vba last cellexcel application getopenfilenamerows count vbareturn vbaexcel 2010 developer tabhyperlink shortcut in excelproject progress report template excelvba create formpivot table on excel 2010tick boxes in excelcell address vbavba exampleshow to unhide a sheet in excelchange a row to a column in excelprograming excelvba delete rows based on cell value