Master Advanced Excel - For 2013 and Later Versions

This is a online course is to gain understanding of Excel 2013 Advanced functions. The aim is to learn the advanced features under excel 2013 and how they can be used . The tutorials will help you learn the Data Functions, Functions for Working with Text, arrays, pivot tables, Important Excel Tools, Excel 2013 - Charts & Graphs, preparing Excel Dashboard, Financial functions using Excel.

350

 11h 11m | 137 Videos | 90190 Views |   Expert

About Excel 2013 Advanced Training Course

Microsoft excel is one of most demanding spreadsheet for all people who works on computer in their daily life. Excel is friendly, competent spreadsheet for maintaining data, stock records, and calculation and for any other demonstration purpose. Excel is a vast field and having more knowledge in it will help you to make your work easier and faster. Employees who knows excel thoroughly are always in high demand in workplace. Microsoft 2013 is the advanced excel sheet which will help you to have a detailed knowledge and proficiency in excel.

This course has been designed in a practical way so that you can use your knowledge in real life to maintain the data. In this course you will learn to organize the data, function, techniques, analysis, increase of visibility etc.

Excel 2013 Course Description

Section 1: Introduction to Useful Excel 2013 Functions

The introductory section will make you to get acquainted with Paste Special, Logical functions IF and OR, Arithmetic Functions, Aggregation Functions and Cell Information Functions

Section 2: Data Functions

Here you will learn how to sort your data. You will have through knowledge about Choose Function, Vlookup, Hlookup and Sum product, Match Index, Database Functions, and Forecasting Function

Section 3: What If Analysis

This section will provide you knowledge on One Dimensional Data Table, Two Dimensional Data Tables, Solver, and Goal Seek

Section 4: Arrays

In this section you will learn about various Arrays and its rows, columns, transpose and frequency.

Section 5: Functions for Working with Text

In this section you will have knowledge about Text and String Functions Part 1 and Text and String Functions Part 2

Section 6: Excel 2013 – Pivot Table

You will know all about pivot table such as Data Formatting, Creating Pivot Table, Recommended Data Table, Pivoting Pivot Table, External Data, Consolidation Sheets, and Managing Pivot Table

Section 7: Summarizing Data Using Pivot Table

In this module you will learn about summarizing data using Totals Display, Summary Display, Multiple Data Field, Data Grouping, Drill down Data, Calculated Field

Section 8: Data Filtering

Here you will learn about Pivot Data Sorting, Customized Sorting, Limited Data Display, Rule Based Sorting, Data Slicer, Slicer Formatting, Filter Area, and Removing Filters

Section 9: Basics Pivot Table Formatting

This section will teach you how to Format Pivot Table and Layouts in Pivot Table

Section 10: Advanced Pivot Table Formatting

In this section you will learn about advanced ways of formatting pivot table using Rule Based Conditional Formatting, Top Bottom Rule Based, Data Bars, Adding Color Scales, and Icon Indicators

Section 11: Introduction of Pivot Chart

This module contains- Basic Pivot Chart, Pivoting Pivot Chart, Filter Pivot Chart Data, Formatting Pivot Chart and Different Chart Types

Section 12: How to Print the Pivot Table

You will know about Print Table Part 1, Print Table Part 2, Print Separate and Print Headers

Section 13: Using Macros in Pivot Tables

Here you will learn how to use First Macro and how to execute the Macro

Section 14: Introduction of Power pivot

This module contains details about power pivot. This module contains: Starting With Power Pivot, Why Use Power Pivot, Adding Table To Power Pivot, Relationships Between Tables, Table In Power Pivot, Get External Data In Power Pivot

Section 15: DAX in Power Pivot

In this section you will get a thorough introduction To DAX, get reference to Dax Functions, and know about Adding Calculated Column, Adding Calculated Field

Section 16: Introduction of Power View

Here you will get an introduction To Power View, Data Using Different Controls Part 1, Displaying Data Using Different Controls Part 2, Formatting Of Controls, Filters In Power View,  Display Using Charts In Power View, Data Display Using Maps

Section 17: Names and Dynamic Range

In this section you will learn how to name a Cell and a Range and naming Dynamic Ranges

Section 18: Auditing and Trouble Shooting Formulas

In this phase you will know how to audit Toolbars and how to access watch Window

Section 19: Important Excel Tools

Know more about various excel tools-Text to Columns, Grouping Tabs, Subtotal Function, Hyperlinks, Data Validation Part 1, Data Validation Part 2, Numbers, View, Protecting Worksheet and Workbook

Section 20: Excel 2013 – Charts & Graphs

You will have a though introduction to Excel 2013 Charts and Graphs

Section 21: Chart Concept

This section will highlight on various charts and its usability.

Section 22: Basic Chart

This section will provide you a conceptual theory about Excel Basic Charts and Excel Chart Concepts

Section 22: Basic Chart

To start with charts in this section you will know about basic charts and how to make it.

Section 23: Fine Tuning of Charts

Fine-tuning of Charts in Excel is another best feature which increases the visibility of your data chart.

Section 24: Chart Options

In this section you will learn about Changing Chart Options – part 1 and Changing Chart Options – part 2

Section 25: Format Tab

This section will teach you details about Format Tab Option

Section 26: Adjustment of Specific Chart Types

Making chart and then adjusting it as per requirement is also an art, it must look good while you present. Here you will learn about Column and Line Chart, Pie Diagram, Chart, Doughnut, Bubble and Radar Chart

Section 27: Changing Chart Sources

In this section you will get knowledge on Paste Chart Data, Multiple Source Data and Table Chart, Basic Dynamic Chart

Section 28: Specialized Charts & Graphs

Excel 2013 can create various specialized charts such as Dynamic Chart with Check boxes, Dynamic Pie Chart, Pareto Chart, Frequency Chart, Chart Filter, Gantt chart, Advanced Dynamic Chart, Calculator Chart, Pivot Chart and Map Chart

Section 29: Excel 2013 – Excel Dashboard

Excel dashboard must be a quiet rare thing for all. In Microsoft excel 2013 you will learn about this.     This section contains introduction to Dashboard and various concepts of Excel Dashboard

Section 30: Creating Basic Charts

Creating charts are one of the main features of excel and in this section you will learn about 3D Charts, Area and Bar Chart, Combination Charts and various other Types of charts.

Section 31: Learning Pivot Table, Pivot Chart and Slicer

You can draw Pivot Table, Pivot Chart and Slicer even in excel and in this section you will learn how to do this. This also helps in demonstrate your statistical study and reviews in any particular field.

Section 32: Using Form Controls

Here you will know about Checkbox, how to do check and Scroll 1 and how to prepare Scroll Chart

Section 33: Basic Macros

This section will provide details about Basic Macro Part 1

Section 34: Assigning Macros to Buttons to Navigate and Dashboard

In this module you will learn about Basic Macro Part 2, Macro Navigation and Dashboard End

Section 35: Financial functions using Excel

In this section you will be taught financial functions using excel.

Section 36: Future Value, SI, CI, PV, NPER, RATE

This section will help you to understanding Future Value, how the Future Value Continues, how to calculate Simple and compound Interest, more information about SI and CI, knowledge to understand PV, how to calculate NPER and RATE and Lender and Borrower FV

Pre-requisites to Advanced training

To enroll and start this course you require nothing except a computer, Microsoft excel 2013 installed in it, internet connect and excellent interest and fresh mind to grab the course.

Target Audience

This training is modeled for people from various phases:

• Professionals from various departments- Accountant, HR, purchase, sales, store, marketing, data analyst.
• Business men
• Students
• Any other person who is interested in features of excel 2013.

FAQs

1. Is it difficult to learn Microsoft excel 2013 advanced training?

No it is not at all difficult. You have to methodical. Our course is provided step by step so that you can understand and grab it properly. Each of our module is provided with certain video so that you can easily remember.

2. Where can be Microsoft excel 2013 applied?

You can apply it anywhere: in your studies, in your office work, in your shop to maintain the inventory, in your daily life. Microsoft excel; makes your life and work easier.  Whatever you want to do- either you want to manage your data, financial records, stock or inventory records you can use excel anywhere.

3. Who can apply for this course?

Students, employees, businessmen – anybody can learn this course. This course is helpful for all. You can easily grab it. Excel 2013 can be used in your daily life to solve various motifs related to data, calculation and formats.

4. What will be expected from me as a trainee?

During the course we provide E- lessons, worksheets etc. during the course. You need to go through these training modules and attend the weekly sessions which will help you to grab and extract the complete course module and you can start applying it in your everyday life. Any doubt or questions keep it for us, we will solve it.

5. What are the basic qualification for this course?

Students who have completed class 12^th can start applying for this course. Candidate does not require any other qualifications. The only thing you must be eager to learn this course.

6. Do you provide any certificate?

Yes on completion of the course we provide proper certificate for the particular course you have attended.

7. Will this course help me in long term?

Yes, excel 2013 can be your all time partner in your office work. You can use it anywhere to sort out your data and financial figures.

Course Testimonials

Ricky Joseph

I have worked in Microsoft 2010 previously, but I was eager to understand the upgraded version, so I got enrolled here. Microsoft excel 2013 is quite easy and exciting. I really loved the latest features which it has!

Mr. Davidson

I am a store manager. I have to manage the whole inventory which arrives to me at my store. Initially it was all maintained in a messy way. I have got things organized. I learnt the advanced training course from educba and I started to apply it in my shop. It made my life easier and now I can really manage the complete inventory.

Ravinder Singh

I work as a teacher in a college in Australia, and I have to maintain lot data regarding students and their scored marks. I learnt from my friend about educba’s advanced training course on Microsoft excel 2013. I took the admission for this and yes, it helped me a lot. I grabbed the course.

Anna D Souza

I work as a receptionist in a nursing home and I have to handle manual register for entry of patients and visitors. At the end of every week I have to send this data to senior authority. It was tough for me to do it as I was not provided with any software. I also had to keep the records of petty cash expense. I started to work on Microsoft excel 2013 and applied it in my job. Now my work got easier. Thank you educba!

Vicky Fernandez

I am an accountant I have to work in tally and excel. We were using excel 2010, which is an old version. I was pretty eager to learn about the new version, so I got enrolled to understand this course. Microsoft excel 2010 is really a great upgraded version, it really made my work more systematic.

Career Benefits of this training

Microsoft excel 2013 is really an upgraded course, which will help you to make your life easier. Excel is a vast thing and having only knowledge in this is not enough. You need to keep on applying this in your daily work life. People who are savvy in excel 2013 they are always demanded in professional life. It is always an add-on to your career. Excel will make your work smooth and systematic, you can maintain any data, records, salary sheet, calculation etc. at one place. Microsoft Excel 2010 is a must learn for all.

Back to top ^