Online Excel 2013 Training Course
by EDUCBA
This lesson is E-learning lesson.
About the Class
- Class Level: All Levels
What You'll Learn
Course curriculum:
Following are the course sections and the videos under each section and its details for the Free Online Excel 2013 Training Course:
Section 1: Introduction to Useful Excel 2013 Functions
- Paste Special
The video explains the following things about Paste Special:
How to go about with Paste Special function
You will also learn how to How to Use Paste Special Function in MS Excel 2013 - Logical functions IF and OR
In this video tutorial on IF and OR function, we will be learning about
How to start If a function in excel 2013 software
Then we will move forward and see the AND function. 3. Get to know about the OR functions - Arithmetic Functions
This Video tutorial of excel 2013 explains about following Arithmetic Functions which we are going to learn in detail. The functions that we are going to see are: ABS, INT, LARGE, MAX, MIN, SMALL, TRUNC - Aggregation Functions
This video explains
How to use the COUNT function in excel 2013
We will also understand the COUNTIF function in detail
Then we will move forward and look at COUNTA and COUNTBLANK functions available in excel 2013 - Cell Information Functions
The video shows various cell information function like
ISBLANK
ISERROR
ISNONTEXT
ISNUMBER
ISTEXT
ISNA
ISREF
Section 2: Data Functions
- Choose Function
The video explains what are the different types of choose functions and how can we use them, all these will be explained with the help of an example - Vlook up
The video shows how we can make use of functions Vlook up, it also tells you when to use it and how to use it to make the work done faster - Hlook up and Sum product
This video explains the Hlook up and the Sum product functions in details. it also tells you when to use the Hlook up and sum product functions and how to use it to make the work done faster - Hlook up and Sum product Continues
In this tutorial, we are going to learn more about the remaining part of Hlook up and Some product functions. Thus you will be able and ready to apply these functions wherever needed or required - Match & Index
This video tutorial will teach you the details of the match index function - Database Functions
In this, we will discuss the most time saving and complex functions provided by Excel that is the Database functions. We will learn the three major database functions like DAVERAGE, DSUM and DCOUNT, Percentages and Absolute References The video explains the concepts of Normal referencing and absolute referencing. It also talks about its use in excel - Forecasting Function
The video explains in detail about the Forecasting function. We are going to see how this forecasting function helps to forecast the future year values by using different formulas and excel 2013
Target Audience
- This Free Online Excel 2013 Training Course is suitable for students of Degree, Diploma, Engineering, commerce and all general studies
- Free Online Excel 2013 Training Course is also very useful for MBA, BBA students from all specializations as excel basic is required for all the specializations
- This course on excel 2013 can also be taken up by the Charted Accountants
- Free Online Excel 2013 Training Course will be very much useful for the Working Finance Professionals in the domain of Investment Banking and Equity Research
- Anyone who wants to work as Finance Analyst, Market Analyst, Research Analyst, Investment Banker can take up this Online Excel 2013 Training Course.
Pre-requisites
- Passion for learning about Microsoft Excel 2013
- A PC with an Internet connection as you need to watch the videos online
- The Free Online Excel 2013 Training Course starts from scratch, hence understanding all the concepts is very easy and no initial knowledge for the same is required.
Fee Includes
Price: $28.00
Usual
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 112 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 Training Course.
This Amazing course is based on Excel 2013. You will learn in detail about Paste Special, Aggregation Functions, Vlookup, Database Functions etc.
About Online Excel 2013 Training Course:
Everyone should have all the knowledge of excel concepts and functions if they want to get their work done faster. Excel is used everywhere, hence we want that everyone should have the knowledge of advanced as well as the basic excel concepts.
Through this training on Free Online Excel 2013 Training Course you will get access to video tutorials, pdf documents, excel sheets on excel 2013. For understanding all the concepts we have taken help of different examples in excel 2013.
Each calculation will be solved in detail and this step by step understanding of the examples after the concepts will help you understand each function and formula in much detail. So before starting with the course let’s see what exactly is Excel 2013 and why we use it and what are the benefits. Microsoft Excel 2013 is thoroughly used in almost all fields be it finance, statistics, marketing, engineering, human resources and hence it is the basic thing that everyone should know. It is especially used for the businesses which deal with large amounts of data (numbers, statistics). Hence getting to know some advanced excel functions will be quite beneficial for anyone who wants to get the work done faster and in the easiest way available. There are various uses of excel 2013, some of which are listed below:
- Storing Data
Microsoft Excel being a spreadsheet program, it is used to store and retrieve numerical data in a grid format of columns and rows. Hence it becomes an ideal option for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. The entered data can be converted easily into a pie chart, bar diagram or a variety of other visual diagrams - Reports
You can use Excel to create company reports. Excel can be used to create monthly sales reports according to customer, manufacturer, salesperson or product using Excel’s data sorting and selection capability which is based on previously defining data by attributes such as department name, manufacturer or acquisition date - Research
What if analysis can be used for research work. It is the major excel tool which is used by various companies. Thus example acts as an important tool for analysis part
Our Online Excel 2013 Training Course is designed in such manner that it will be covering advanced functions and features and any person from any background will be able to apply it to his work. Through this course and the practice material, you will gain proficiency prominent features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table. Thus having detailed knowledge of Excel will be beneficial to as you will be learning in detail about smart features like Charts and Graphs, Dashboard and Financial Functions in this course. This course on Free Online Excel 2013 Training Course is suitable for anyone, whether you are a student, fresher or an employee.
Benefits of the Online Excel 2013 Training Course:
- Learn Excel 2013 basics from Scratch using an Excel examples Approach that will help you to understand each example in a very easy way
- Learn the prominent features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table concepts in Excel
- Get a very good understanding of the smart features like Charts and Graphs, Dashboard and Financial Functions in this course of excel 2013
- Learn to Gain command over powerful features and functions in Excel 2013 through this Free Online Excel 2013 Training Course
- Become Awesome in excel 2013 by this Free Online Excel 2013 Training Course.
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