Category: Excel2013

Shortcut Keys Used in PowerPivot

Shortcuts, Excel2013, powerpivot

Howdy,

This article will help you to find the shortcuts used in PowerPivot. But, the tragedy is there is no shortcut to open PowerPivot as of now. (if there is any, please teach me using below comments.) Now, lets go ahead with the shortcuts.

 

Full story »

Difference Between Excel and PowerPivot?

Excel2013, powerpivot

Hi there,

 

In this post, we will know few differences between Excel and PowerPivot. Before we go: Have you enrolled to FREE EXCEL TRAINING here. If not, please do enroll at the earliest.

No Rules.

No Conditions.

No Charges.

 

Now, we will proceed with the topic.

Full story »

Introduction to PowerPivot

Excel2013, powerpivot

Hi there,

 

Today, we will discuss about PowerPivot add-in in Excel 2010 and above versions. Firstly, let's see where is this powerpivot? 

 

By default PowerPivot is enabled in Excel. To enable powerpivot, needs to go to Office Ribbon -->Excel Options -->Add-ins -->Under "Manage"-->Select "COM Add-ins" -->Click on Go

 Introduction to PowerPivot

Here is where you get PowerPivot add-in for Microsoft Excel (just check mark it) and click ok.

 

Now, you will find it next to DEVELOPER tab (if at all it is enabled).

If you still don't find "PowerPivot" here, then you might have not installed this add-in. Please check this link to install PowerPivot Add-in to your excel.


Please make sure before you download this add-in, you need to know your system configuration. You have this information in the link itself. Follow the link to get complete details on Installing PowerPivot without errors.

Full story »

POWERPIVOT ADVANTAGES

Excel2013, powerpivot

Hi there,

In this post, you will learn the advantages of power pivot in Excel. If you are new to PowerPivot here is an introduction to PowerPivot. If you already know then you can continue with the post.

Hoping you know basics of PowerPivot, here are the advantages of using PowerPivot in your daily work. 

 

PowerPivot Icon in Excel 2010 and above


ADVANTAGES OF USING POWERPIVOT:

Full story »

List of Excel Functions (2003, 2007, 2010, 2013)

Formulas, Excel2013

Hi there,

 

When compared to Excel Functions with human parts, we can compare it with Human Brain. See what others are. There are many reasons why I compared and why we can accept. However, lets proceed to see the list of functions in all versions from 2003 to 2013 (461 functions).

 

COMPATIBILITY FUNCTIONS:

BETA.DIST

BETAINV

BINOMDIST

CHIDIST

CHIINV

CHITEST

CONFIDENCE

COVAR

CRITBINOM

EXPONDIST

FDIST

FINV

FTEST

GAMMADIST

GAMMAINV

HYPGEOMDIST

LOGINV

LOGNORMDIST

MODE

NEGBINOMDIST

NORMDIST

NORMINV

NORMSDIST

NORMSINV

PERCENTILE

PERCENTRANK

POISSON

QUARTILE

RANK

STDEV

STDEVP

TDIST

TINV

TTEST

VAR

VARP

WEIBULL

ZTEST

 

Pages: 1· 2· 3· 4· 5· 6· 7· 8· 9· 10· 11· 12· 13

Save Files Faster in Excel 2013

Excel Tips, Excel2013

Hi there,

 

Have you started using Excel 2013 version. I think you are finding difficult to save the files and open the new excel files is a tidious process in Excel 2013, right? To open the excel files or to save the excel files you need to go through more clicks than usual in Excel 2007. 

Save Files Faster in Excel 2013 (more tips on exceltoxl.com)
 

Excel 2013 is really good because of its features like power pivot, power view, flash fill, auto fill options, One Drive, Sky Drive and above all its a cloud based office version. So, we feel Excel is an awesome application by it means. However, save the files and opening the files is really a tidious process here. But to save some clicks to microsoft there is a silent feature in Excel Options window by name "Don't show the backstage when opening or saving file".

Full story »

Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.