How can I forecast monthly data using Moving Averages on Excel?

Asked by Last Modified  

2 Answers

Learn Microsoft Excel Training

Follow 1
Answer

Please enter your answer

Dheeraj

IT Corporate Trainer with 9 years of experience in Edu tech

First, click on Excel's Data tab. ...In the Analysis section, select Data Analysis. ...From this list, select Moving Average and click OK. ...In the Input Range box, enter the data range you want to analyze.Input your preferred interval into the Interval box.
Comments
Dislike Bookmark

I am online Quran teacher 7 years

First, click on Excel's Data tab. ...In the Analysis section, select Data Analysis. ...From this list, select Moving Average and click OK. ...In the Input Range box, enter the data range you want to analyze.Input your preferred interval into the Interval box.
Comments
Dislike Bookmark

Related Questions

How to write square in excel?
Format > Cells > Font > check Superscript then type '2' which will appear as superscript Format > Cells > Font > uncheck Superscript
Dharmendra
0 0
9
How to use vlookup in excel?
Syntax for using vlookup function is =VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUMBER)
Ankita
0 0
7
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin
What is the major concepts Excel VBA Training teaches?
- Macro programming - The Basics of vba - Variables,constants - Data types - User defined types - Working with operators - Reserved words - Control flow statements (if if else multiple else if select...
Jayant

Use of INDEX in MS Excel?
INDEX function is a powerful tool that allows you to retrieve values from a specified range or array based on row and column numbers. INDEX(array, row_num, ) As it requires row_num and column_num, it is...
Prabhakar
0 0
6

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

VBA Tip: Print Random Numbers In A Selected Range
Let’s say you want to print some random numbers in a selected range then you can use below Macro. Sub Print_Randomnumbers() Dim myrng As Range For Each myrng In Selection myrng.Value = Application.WorksheetFunction.Int(Rnd...

Karthik Dale

0 0
0
Hidden Gems Of MS Excel - Sort (add Multiple Levels to Sort Data)
Please refer following dataset: You would know:- To Sort Month from Oldest → Newest OR Newest → OldestOR- To Sort Region from A → Z OR Z → AOR- To Sort Units Sold from Smallest →...

Ankur Sharma

2 0
0
HERE TODAY WE WILL USE THE SUMIFS FUNCTION.
A B C D 1 NAME PRODUCT NAME TOTAL AMOUNT 2 SAURABH WASHING MACHINE 4165 3 MANIPAL MI PHONE 4803 4 ANJALI SAMSUNG MOBILE 4610 5 UMA NOKIA PHONE 4441 6 SHANKER T.V 3765 7 NARESH ...

Saurabh Sharma

0 0
0
Learning Pivot Table Part-1
You all must have watched movie based on War. One thing you all might have noticed, in most of the movies, armies fought with their enemies hiding inside the bunkers, an army fighting war in open obviously...

Kaustubh Chavan

1 0
0
Generate Employee Payslip using Excel & VBA Macros
yes we can generate the Payslips for each employee from a huge data in the excel. We can generate a separate Excel sheet for each employee and also can create Payslip Excel files with the names of the...

Venkata Seshasai Kanuru

1 0
1

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you