Excel 2013 - Financial Functions Masterclass
by EDUCBA
This lesson is E-learning lesson.
About the Class
- Class Level: All Levels
What You'll Learn
About Excel 2013 Course – Financial Functions using Excel:
The course is intended to enable its candidates to learn about the various built-in financial functions in Microsoft Excel. These excel functions are great tools in financial analysis. It helps to analyze the financial data and improve the research process. Investment Bankers, Equity Analysts, Private Equity Professionals, Credit Research Professionals and Financial Analysts spend most of their time in Excel. If these professionals do not have a good hold of financial functions in excel, their work increases by manifold.
They need to understand various shortcuts; several regularly used functions and have to be experts on those. This course is perfect for those professionals. This course is ideal for students and professionals looking forward to a great career in the world of Finance. This course can be taken by anyone who wants to enhance their finance knowledge by learning it in excel and work more effectively and efficiently. The Pre-Requisites for this course is Basic knowledge of excel and finance. Participants are going to study various finance functions in excel and its application.
We will be covering the following modules in this online course on Excel 2013:
- Learning the theoretical concept and practical’s of Future Value, Simple Interest, Compound Interest, Present Value, NPER, RATE. Next, we will learn calculation of the value of an investment with multiple cash flows
- Calculating the Rate of Return on investments
- Formulas such as Net present value (NPV, XNPV) and Internal rate of return XIRR
- Analyzing loans and payments
- Bond Valuation
What are the pre-Requisites for Excel 2013 Course?
The only requirements for this course are,
- Basic knowledge of using Microsoft excel and finance concepts
- A Computer with Internet
What are the learning Objectives of Excel 2013 Course?
The learning objectives of the Excel 2013 course are as follows,
- To study various finance functions in excel and its application
- Learn Future Value, SI, CI, PV, NPER, RATE
- Learn how to calculate the value of an investment with multiple cash flows
- Calculating Rate of Return
- Understand the usage of formulas in excel such as NPV, XNPV, XIRR
- Analyzing loans and payments
- Learn Valuation of Bond
Who is the Excel 2013 Course for?
The course has been specially customized for,
- Anyone who wants to enhance their finance knowledge by learning it in excel and work more effectively and efficiently
- Financial Analysts/Finance Professionals
- Investment Bankers/Equity Analysts
- Credit Research Analysts
- Students and Professionals looking for a career in Finance
Fee Includes
Price: $14.00
Usual Price : $42.00
Why Book Through LessonsGoWhere?
- Booking is safe. When you book with us, your details are protected by a secure connection.
- Secure your slot instantly. Book classes with us and your seat is confirmed immediately.
- Earn Reward Points. This class will earn you upto 56 reward points. Points can be used for a discount off your next class!
Questions about this class?
Get help from knowledgeable expert.
Together with eduCBA, we bring you an amazing course on Excel 2013 - Financial Functions Masterclass
This is an online course on Excel 2013 - Financial functions using Excel where you will be learning about what is financial functions, you will learn to calculate Future Value, SI, CI, PV, NPER, RATE, Value of an investment with multiple cash flows, Calculating Rate of Return, Analyzing loans and payments, and also about Bond Valuation.
What is Microsoft Excel?
Microsoft Excel is a sworn by experts to be a great utility tool to crunch data and perform some complex financial functions. The 2013 version capitalizes exactly on these features that Excel is known for and has been built in a way in which it appears simpler and more functional by breaking down complicated functions into elemental steps.
What are the new features in 2013 Excel?
Some of the features that have been touted as providing a better user experience and adding value to the Excel 2013 version are,
- Start Screen
- Backstage View
- Flash Fill
- Recommended Charts
- Chart Tools
- Quick Analysis
- Pivot Tables
- Power Tools
- SkyDrive
- Start Screen: With Excel’s new Start Screen, work gets done a lot faster. The most recently used worksheets are displayed on the left edge and can be pinned to the ‘Recent’ list for easy accessibility. The option is there to access files from drive or cloud through opening the ‘Other Workbooks’ option. The top right-hand side corner shows SkyDrive (or SharePoint).In order to facilitate a quick start to a new project, a range of templates are made available. These can pin as well, or one can search online for other templates. A list of suggested searches appears on screen to help one start
- Backstage View: Introduced in Office 2010, the Backstage View can be accessed from the File menu. A combination of the Open and Recent tabs from Excel 2010, the Open tab in Excel 2013 gives one access to recently used workbooks. One can click Computer to access recently accessed locations or can pin worksheets to this list. Access to the SkyDrive account has also been included, along with the option to set up additional SkyDrive or SharePoint accounts
- Flash Fill: The Flash Fill tool is one of the greatest improvements of Excel 2013. Its predictive data entry can detect patterns and extract and enter data that follows a recognizable pattern. It has been designed to solve some commonly faced problems in an effective manner. One such problem is extracting a person’s first name from a column of full names. One can simply type the first name and then click the Home tab, and select Fill, Flash Fill in a blank column adjacent to the one that contains full names. Immediately, the first names of everyone in the list will appear in the column
- Recommended Charts: Recommended Charts shows only a subset of chart types that are pertinent to the data that has been selected. Inexperienced users can benefit from this as it helps to create charts which explain data and does not confuse the user. In order to use the tool, the data on the chart with which you intend to create the chart is to be selected. Click the Insert tab and select Recommended Charts. A dialog then appears with an array of charts for the user to choose from—the user will then have to click on each in order to see how the data will look plotted on that chart. They will need to select the desired option and click OK. The chart gets created automatically
- Chart Tools: Chart Tools tab displayed three additional tabs: Design, Layout, and Format when a chart was selected in an earlier version of the chart tool. As compared to the previous versions, the interface is much simpler in Excel 2013, with only the Design and Format tabs to choose from
- Quick Analysis: The new Quick Analysis tool can help both new and experienced users find options for working with selected data. In order to use it, the data that is to be analyzed is to be selected. The Quick Analysis icon appears in the bottom-right corner of the selected data. A range of tools for analyzing the data, such as Formatting, Charts, Totals, Tables and Sparklines then appears. On selecting an option, a series of selectable choices appear which can be previewed. Next, click the option one would like to apply on data. This feature speeds up the process of writing formulas, formatting, and charting
- Pivot Tables: Pivot Tables are a powerful tool for analyzing data. Recommended PivotTables helps new users of Excel to create Pivot Tables. To use it, select your data, including headings, and choose Insert, Recommended PivotTables. A dialog appears showing a series of PivotTables with explanations. The user needs to select the appropriate table and PivotTable is automatically drawn
- Power View: Available as an add-in in the previous versions, the Power View is integrated in Excel 2013. Generally, the Power View tool is to analyze a large set of data from external data sources, making it appropriate for businesses. Having been incorporated in Excel, it can be now accessed by anyone
- SkyDrive: To enable working real time within a group scenario, the SkyDrive has been incorporated into Excel. In Excel 2013 you can share and work collaboratively on files with others via SkyDrive with the help of the Excel WebApp.
However, one cannot open a worksheet from SkyDrive in Excel 2013 on the local machine if someone else is currently working on the same worksheet. This protects the worksheet against conflicting changes. Instead, if one person is editing an Excel file that’s stored online, others with permission can view and download it, but they cannot change the original, which is locked until the person working with it is finished.
One can also share Excel workbooks on Facebook and more from Excel 2013. The first step is to save the file on SkyDrive, post which the Post to Social Networks option appears. Any social media account that is linked to one’s Office 2013 account can be used to share the worksheet.
All e-learning lessons bought through LGW will be final and no refund, return, cancellation or exchange will be allowed.
Frequently Asked Questions 
Have a question about LessonsGoWhere? We've collected all your questions and our answers into a convenient list here. If you have any questions, please don't hesitate to email us at info@lessonsgowhere.com.sg
Q: What's LessonsGoWhere?
A: LessonsGoWhere.com.sg (LGW) is Singapore's first online marketplace to list, discover and book in-person courses. You can shop, compare and review lessons on LGW, across areas like Baking, Cooking, Music, Fitness, Yoga and even Exotic lessons!
Q: Are the classes I find on LessonsGoWhere online lessons or are they conducted in real life?
A: All the classes you can find on LessonsGoWhere are lessons that are conducted in real life, by real people. We sincerely believe in the importance of the human touch and that we can build bonds and relationships through shared passions. Would you like to learn SCUBA diving through an online tutorial? We didn't think so.
Q: Who are the teachers in the classes available on LessonsGoWhere?
A: The classes on LessonsGoWhere are taught by professional trainers, instructors, chefs and coaches, as well as passionate individuals who want to share their experience and knowledge. LessonsGoWhere does not restrict lessons from freelancers or other qualified individuals. However, we are very strict on the quality of lessons and if we receive complaints regarding the quality of the lessons from our users, we will not hesitate to take action in removing the lessons and banning the lesson provider.
Q: What types of lessons are offered on LessonsGoWhere?
A: There are a wide range of lessons on various topics and areas of interest on LGW. The main categories right now are Baking, Cooking, Music, Sports, Art, Yoga and Exotic lessons. However, we are always looking out for more lessons to add to the marketplace. If there's a particular category of lessons you'd like to see, please don't hesitate to let us know at info@lessonsgowhere.com.sg
Q: Are the lessons real? Will I get scammed if I book classes on LGW?
A: The lessons are definitely real. All lessons are uploaded and checked by a team of hardworking elves (the founders of LGW) who work tirelessly and through late nights to ensure that the details are accurate. All lesson providers are also contracted with LGW to provide the lessons. We back our lessons up with a 100% Refund Policy. In the scenario that a lesson is cancelled, we GUARANTEE that we will refund you 100% of the fess paid. The security of our customers is our number 1 priority. If you have any queries on the lessons or the security of the website, do not hesitate to email us at info@lessonsgowhere.com.sg
Q: Why do I need to pay immediately?
A: We require that you pay for the lesson in full before you are issued an email confirmation of your booking for the lessons. There will be costs incurred by the instructor before the lesson commences, and your payment not only immediately confirms your booking, but will enable us to pay the lesson provider immediately!
Q: Why should I book and pay for my lessons on LessonsGoWhere.com.sg?
A: In cases of disagreement between you and the lesson provider, LGW will have a copy of your booking details logged with us and can also withhold payment from the lesson provider. Your booking details will be helpful should any disputes arise in terms of bookings and payments. Also, with the wide variety of lessons on LGW, you can immediate compare and choose your choice of classes at your convenience! You can also contribute to the community by reviewing the classes and lessons you've attended, earning you Reward Points, and also helping potential students make better choices and their reviews will benefit you too!
Q: What happens after I've made payment?
A: Once you've confirmed payment for the lessons of your choice, you will receive an email confirmation from us, letting you know the date, time and location of the lesson. On the day itself, simply present the email confirmation to the lesson provider and you will be able to attend the lesson!
Q: What happens if I cannot attend the lesson?
A: In the case that after you have booked your lesson, but are unable to attend, let us know immediately. Email us at info@lessonsgowhere.com.sg. We will try our best to transfer your booking to another time, or if you prefer, to a friend. While we cannot refund your payment if you are unable to attend, let us know and we will try out best to accommodate you!
Q: What if the lesson provider asks for more money when I arrive?
A: The pricing information for each lesson is clearly stated on each listing and will also note what is or is not included. If you encounter a lesson provider who asks for more money on top of the payment you have already made to us, please contact us immediately at info@lessonsgowhere.com.sg and we will try our best to rectify the situation.
Q: Do the fees include equipment and location rentals (if necessary)?
A: While some lesson providers will include equipment and facility bookings with the fee, others might not. Don't worry though, the pricing information is clearly stated on each listing and will also note what is or is not included. If you are still in doubt after checking the listing, you can email us at info@lessonsgowhere.com.sg and we will clarify the issue for you.
Q: What happens if I pay for a lesson and the lesson provider cancels or doesn't respond?
A: Don't worry! If the lesson is cancelled or if you are unable to get a response from the lesson provider, email us at info@lessonsgowhere.com.sg and we will refund you 100% of the fees you paid.
Q: My friend/girlfriend/boyfriend/family member wishes to attend the lesson as well, can I book for them too?
A: Yes! Learning is always an experience best shared. It's also a great activity to bond over! If you have others who are interested in attending the lesson as well, simply book the appropriate number of slots for the lesson and they can accompany you. Book fast though! Most lessons only have a limited number of slots available and if you aren't fast enough, you might not be able to secure the slots for them!
Q: Should I leave a review after I've attended the lesson?
A: Definitely! Not only do other students benefit from your review of the lesson, you will also receive Reward Points for your review! You can use those Reward Points as a discount off your future lessons too! Everyone benefits!
Q: Are the reviews posted on LGW true?
A: Each review posted on LGW will be monitored by our administration team. We try our best to create a helpful and engaging community and we do not like foul language, sexual themes, trolls or spammers. But yes, all reviews are unedited by us and are the opinions of the reviewer.
Q: Are you Baking and Cooking courses Halal certified?
A: Halal certification is a type of certification given only to restaurants. Most of our classes use pork free ingredients. For more information, please get in touch with us to find out more!
Found the answer to your questions? Book your lesson now!
Ready to take this class?
EDUCBA
Reviews of Classes by EDUCBA
Heow P.
15 Mar, 2021
Andy K.
8 Jun, 2020
poor in presentation & speech
Wei Tian Edwin Y.
4 Jun, 2020
Wei Tian Edwin Y.
4 Jun, 2020
Anand K.
12 Apr, 2017