Microsoft Excel

/Microsoft Excel

Microsoft Excel 2016 – 6 New Chart types

Microsoft Excel 2016 has 6 new charts that are easy to create and gives you the opportunity to do much more to analyze your business data in different scenarios. Waterfall Histogram Pareto Box and Whisker Tree Map Sunburst

By | 2018-04-19T19:55:37+00:00 July 17th, 2017|Categories: Microsoft Excel, Microsoft Office, Office 2016|Tags: , , , , |Comments Off on Microsoft Excel 2016 – 6 New Chart types

Creating open data connection files on Microsoft Excel and using SharePoint

Microsoft Excel is a tool with functionality beyond imagination and ‘data connections’ is one such functionality, which facilitates users with much ease. ‘Data connections’ web part enables storage and maintenance of multiple data connections to rapidly build workbooks. Excel can be effectively used to import data located externally which can be narrowed down using connections [...]

By | 2018-04-19T19:55:43+00:00 May 17th, 2015|Categories: Database, Microsoft Excel, SharePoint|Comments Off on Creating open data connection files on Microsoft Excel and using SharePoint

Familiarizing yourself with Microsoft Excel 2013 formulas

Excel 2013 proves to be a very useful tool but at the same time it can be equally confusing to get your heads around it when you begin. ‘Number Crunching’ remains one of the most exploited strengths of Microsoft Excel 2013 and is something that can be used by a wide range of users. It [...]

By | 2018-04-19T19:55:43+00:00 February 13th, 2015|Categories: Microsoft Excel, Office 2013|Comments Off on Familiarizing yourself with Microsoft Excel 2013 formulas

Microsoft Excel 2010 Tutorial

For quite some time Microsoft has been the leading designer of programs used by computers and similar devices. This is greatly due to the easy usage of the Microsoft Office programs. Excel 2010 is one of the most important Microsoft 2010 Office programs. It enables users to carry out calculations, study information and analyze them [...]

By | 2018-04-19T19:55:44+00:00 September 28th, 2014|Categories: Microsoft Excel, Office 2010|Comments Off on Microsoft Excel 2010 Tutorial

Save time: Using macros in MS Office 2007

The new feature of ‘Macro’ introduced in the 2007 Office Suite by Microsoft can help users save enormous amounts of time wasted in trivial activities by following a simple procedure. Each time the user is about to perform a task that may need to be performed again; it can simply turn on the "Macro Recorder" [...]

By | 2018-04-19T19:55:49+00:00 November 24th, 2012|Categories: Microsoft Excel, Office 2007|Tags: , |Comments Off on Save time: Using macros in MS Office 2007

A quick look into the individual applications of Microsoft Office 2010

The Microsoft Office suite 2010 comes with the standard 5 applications: Word, PowerPoint, Excel, Access , Outlook and OneNote. If you are interested in finding out the new features that Microsoft has included in its package, the following sections will be quite useful: Microsoft Word 2010 Microsoft Word 2010 boasts of an Advanced font pane [...]

By | 2018-04-19T19:55:50+00:00 September 12th, 2012|Categories: Microsoft Access, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Office 2010|Tags: |Comments Off on A quick look into the individual applications of Microsoft Office 2010

Different ways of using Microsoft Access data in MS Excel 2010

How to move data from MS Access to MS Excel 2010? Microsoft Access is the database component in Microsoft Office 2010 software suite. This data is primarily in raw format and for analysis, we need to bring this data into Microsoft Excel 2010. Now there are several ways to do it. One can use the [...]

By | 2018-04-19T19:55:55+00:00 January 9th, 2012|Categories: Microsoft Access, Microsoft Excel, Office 2010|Comments Off on Different ways of using Microsoft Access data in MS Excel 2010

Why You Should Upgrade to Microsoft Excel 2010

If you are a Microsoft Excel user and have not made the switch to Excel 2010, then what’s keeping you from making the switch? Is it the super-sized toolbar? Its mobility? Perhaps, it is the improved PivotTables? Hmmm... These MS Excel 2010 features and others have much to offer the user. So, if you are [...]

By | 2018-04-19T19:55:56+00:00 December 22nd, 2011|Categories: Microsoft Excel, New Features, Office 2010|Tags: |Comments Off on Why You Should Upgrade to Microsoft Excel 2010

Excel 2007 Tutorial – How to use common Excel formulas?

One of the main strengths of Microsoft Excel is “Number Crunching”. It could be something as simple as creating a home budget or as complex as Statistical analysis at work. Excel can do it all as it has a host of built-in mathematical functions. Excel formulas allow you to perform calculations on data that is [...]

By | 2018-04-19T19:56:01+00:00 September 22nd, 2011|Categories: Microsoft Excel, Microsoft Office, Office 2007|Comments Off on Excel 2007 Tutorial – How to use common Excel formulas?