­

Excel 2010 with Excel Dummies: Learn Excel in less than 2 hrs. Video Tutorials. Excel Basic and Advanced Formulas, Pivot Tables, Sales and Budget Forecast in Excel, Moving Average Forecast, Trend Analysis and Free Spreadsheets. Buy 2 Get 1 Free Limited Time Offer. Money back Guarantee. Find more on http://www.exceldummies.com/

Showing posts with label Online Excel Training. Show all posts
Showing posts with label Online Excel Training. Show all posts
0

Creating Formulas in Excel – Knowing the Basics

Formulas are type of equations which perform different calculations on the given values in worksheet. Creating formulas in Excel is easy once you have learnt the basics. Any Excel formula begins with an equal sign, as, (=).

Example =6+2*5

This formula multiplies 2 with 5 and adds 6 to the multiplication result.

How do Excel Formulas Work?

The Excel formulas work upon the same mathematical basics which everyone is well aware of since school days. For example for addition, you just need two numbers and the + operator or you can use the Excel syntax =SUM (number1,number2) which will add numbers in the given range of cells.  

Different parts for creating formulas in Excel

Creating formulas in Excel make use of some basic but essential parts:

Functions:  This is denoted by closed parenthesis like (). For example, the PI () function provides the pi value as 3.142...

References: For calculating equations, Excel uses the data given in cells. For every equation to be calculated, the cell works as variables and references as well. For Example A6 will return the value given in A6 cell.

Constants: The Constants in creating Excel formula are those text values/numbers which are entered directly ina formula.

Operators:  Operators are just like simple mathematical operators’ symbols which define the type of calculation to be performed. For example:addition (+), subtraction (-) or multiplication (*).

Quickly copying formulas

While creating formulas in Excel you should understand that the similar formula can be entered speedily in a range of cell. You just need to select the range for calculation and type the formula over there. Next, press CTRL+Enter. When we copy any formulas, the reference gets adjusted accordingly.

If you’d like to learn more, click here for Excel online training and free resources.

Monday, 16 April 2012 Labels: , ,
0

How to Forecast Sales in Excel

Every business needs to have a proper future planning in order to grow and prosper in a good manner. Though none of us can have an idea about what lies in future, still making no efforts for future will only lead to a sure failure. Forecasting is used in various departments in the organization such as finance, sales, manufacturing and so forth.Creating forecastscan be very cumbersome process. Unless you have a computer software that automatically forecasts for you, Excel has great features allows you to forecast.

Some of the most important Forecasting Methods Excel Dummies teach are as follows:

1. Traditional Methods: Traditional methods are the most effective methodologies of forecasting. 
  • Annual Forecasting: Variance is spread proportionally on a month to month basis for the remainder of the year. 
  • Monthly Forecasting: Current variances are assumed to be permanent and remain in the predicted figures. 
  • Quarterly Forecasting: Variance is spread proportionally within the quarters in the future. 
  • Run Rate Forecasting: Run rate is basically average and your data is divided by the number of periods.
2. Quantitative Methods: With Time Series Methodslooks at variable and collect the data from different time intervals.
  •  Moving Average: Model moves one period each time and it uses the most recent value.  
  • Exponential Smoothing: Exponential Smoothing is used for short term predictions. More weight is applied to most recent observations. 
  • Linear Trend Analysis: This model simply estimates the future values based on various kinds of trends or seasonal patterns in our data by using best-fit straight line.
When these calculations are done in the right way through right tools, the results are marvelous and accurateforecasts. Please visit Excel Dummies for to learn more about Forecasting Techniques and Data Analysis in Excel.

Tuesday, 28 February 2012 Labels: , , , , , , ,
2

How to Use Pivot Tables in Excel

Although many people know how to use excel, not many people know how to use pivot tables. Pivot table is one of the most powerful tools when doing an analysis in Excel. Pivot Tables allow you to manipulate the data the way you want to see the results.

What is a Pivot Table?

Pivot Tables allow users summarize large data, sort, count, filter items, switch rows and columns, drag and drop fields of the data which is stored in another source – another one table or spreadsheet anything you want. You can arrange the results based on the way you want to display. When you analyze large amounts of data, with Pivot Tables you can look at the same information in many different ways. How you organize and group the data often determines whether you find or overlook important trends.

Excel Dummies covers creating and using a Pivot Table to extract different information from one data sample.

The Steps that are covered are:
As an example, to see the steps for grouping data in all fields, or a single field, please watch the FREE Excel Pivot Table Grouping Data video tutorial by Excel Dummies. The tutorial teaches how to group the dates by month, and again, the grand totals are automatically calculated. Click here.

Excel Dummies tells you about several tips which will assist you in availing better usability and help with Pivot Tables. 

If you’d like to learn more about Pivot Tables, please visit http://www.ExcelDummies.com  for more information.

Monday, 27 February 2012 Labels: , , , , , ,