Brand Waali Quality, Bazaar Waali Deal!
Impact@Snapdeal
Gift Cards
Help Center
Sell On Snapdeal
Download App
Cart
Sign In

Sorry! Microsoft Excel 2013 - Beginner & Advanced (e-Certificate Course)- Online Video Training Material, Technical Support, Verifiable Certificate is sold out.

Compare Products
Clear All
Let's Compare!

Microsoft Excel 2013 - Beginner & Advanced (e-Certificate Course)- Online Video Training Material, Technical Support, Verifiable Certificate

This product has been sold out
(3.5) 19 Ratings 5 Reviews Have a question?

We will let you know when in stock
notify me

Featured

Highlights

  • Delivery via E-mail
    Non-Cancellable
    No Physical Dispatch
  • Stream:MS Excel
  • Certification:Yes
  • Format:Online Study Material
  • SUPC: SDL571096913

Description


 Syste m (Hardware/Software) Requirements
Operating SoftwareWindows XP or Higher
ProcessorMinim um P4 or Higher
RAM1 GB or Higher
BrowserAny
Recommended Internet SpeedMinimum 1MBPS
Supported Browser Plug-ins* Updated Flash Player, * Update Java
Other RequirementsSpeaker or headphone
Prdocut Description
This course starts from scratch. So, even if you are a starter in Excel 2013, you will get it in this course. By the completion of this Comprehensive Microsoft Excel 2013 training, you will be comfortable with most of the powerful features and functions of Excel 2013. Working files are included, allowing you to follow along with the author throughout the lessons.

This course begins with taking care of all excel functions and formulas in a comprehensive manner with lots of examples and case studies. To make you understand the importance of Excel in our day to day life, the course starts with a case study and how that case study is being taken completely on an excel spread sheet. You will learn everything from data entry to calculations to formula, formatting, if, sumif, graphs and charts, sorts, pivot table, freeze and split etc. We will also give you lots of shortcuts in excel to make your life easier. Then, the course will take you through some of the most useful functions of Excel 2013, gradually takes you through prominent features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table. Important functions like Pivot Table has been taken comprehensively for better understanding. We will also be covering other smart features like Charts and Graphs, Dashboard and Financial Functions in this course.

This course is ideal for Students, MBA's, BBA's, Gradates & Post- graduates, Working Professionals from HR, Marketing, Sales and Operation etc., Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker. There is no Pre-requisite to this course. A complete beginner can start with this course. Our objective with this course is to make you understand what excel is and to know its importance in the current business world. The only requirement from you is to be passionate to learn, be committed to the training and invest your time.

We will be covering the following modules in this online course on Comprehensive Microsoft Excel 2013.
  • Overview
  • Getting Started
  • Case Study
  • Data Entry
  • Calculations
  • Formulas
  • Formatting
  • Formatting Table formats
  • Updating a Calculation
  • Percentages & Absolute References
  • Conditional Formatting
  • IF Function
  • COUNTIF
  • SUMIF
  • Graphs & Charts
  • Pie Chart
  • Sorts
  • Filter Function
  • Pivot table
  • Freeze & Split
  • Presentation
  • Print
  • Shortcuts
  • Common errors
  • What If Analysis
  • Arrays
  • Functions for Working with Text
  • Excel 2013 - Pivot Table
  • Summarizing Data Using Pivot Table
  • Data Filtering
  • Basics Pivot Table Formatting
  • Advanced Pivot Table Formatting
  • Introduction of Pivot Chart
  • How to Print the Pivot Table
  • Using Macros In Pivot Tables
  • Introduction of Power Pivot
  • DAX in Power Pivot
  • Introduction of Power View
  • Names and Dynamic Range
  • Auditing and Trouble Shooting Formulas
  • Important Excel Tools
  • Excel 2013 - Charts & Graphs
  • Chart Concept
  • Basic Chart
  • Fine Tuning of Charts
  • Chart Options
  • Format Tab
  • Adjustment of Specific Chart Types
  • Changing Chart Sources
  • Specialised Charts & Graphs
  • Excel 2013 - Excel Dashboard
  • Creating Basic Charts
  • Learning Pivot Table, Pivot Chart and Slicer
  • Using Form Controls
  • Basic Macros
  • Assigning Macros to Buttons to Navigate and Dashboard
  • Financial functions using Excel
  • Future Value, SI, CI, PV, NPER, RATE

    Course Curriculum

    Section1:Introduction to Excel Dashbord

  • Lecture1:Introduction to Dashboard
  • Lecture2:Concepts of Excel Dashboard

    Section2:Excel Functions

  • Lecture3:Vlookup
  • Lecture4:Hlookup and Sum product
  • Lecture5:Hlookup and Sum product Continues
  • Lecture6:Choose Function
  • Lecture7:Lookups Without Solution (DOWNLOAD)
  • Lecture8:Lookups With Solution (DOWNLOAD)

    Section3:Creating Basic Charts

  • Lecture9:3D Charts
  • Lecture10:Area and Bar Chart
  • Lecture11:Combination Charts
  • Lecture12:Different Typs
  • Lecture13:Types of Charts Without Solution (DOWNLOAD)
  • Lecture14:Types of Charts With Solution (DOWNLOAD)

    Section4:Learning Pivot Table, Pivot Chart and Slicer

  • Lecture15:Pivot Table
  • Lecture16:Pivot Chart and Slicer
  • Lecture17:Pivot Charts and Slicer New Without Solution (DOWNLOAD)
  • Lecture18:Pivot Charts and Slicer New With Solution (DOWNLOAD)

    Section5:Using Form Controls

  • Lecture19:Checkbox
  • Lecture20:Check and Scroll 1
  • Lecture21:Scroll Chart
  • Lecture22:Check and Scroll Without Solution (DOWNLOAD)
  • Lecture23:Check and Scroll With Solution (DOWNLOAD)

    Section6:Basic Macros

  • Lecture24:Basic Macro Part 1
  • Lecture25:Macro Example Without Solution (DOWNLOAD)
  • Lecture26:Macro Example With Solution (DOWNLOAD)

    Section7:Assigning Macros to Buttons to Navigate and Dashboard

  • Lecture27:Basic Macro Part 2
  • Lecture28:Macro Navigation
  • Lecture29:Dashboard End
  • Lecture30:Macro chart Example and Navigation Without Solution (DOWNLOAD)
  • Lecture31:Macro Chart Example With solution (DOWNLOAD)
  • Lecture32:Macro Navigation With Solution (DOWNLOAD)

    Benefits

  • eduCBA e-campus
  • Virtual campus powered by robust LMS which enables to study through internet with cutting edge features
  • Online Video Training Material
  • Presentation Slides

    USP of the product

  • * 24 x 7 online access
  • * Learn from tutorials curated by expert industry professionals and trainers
  • * Certificate of Completion
  • * Practical application oriented skills

    How to use? (Steps to use Study Material)

  • Step 1 - eduCBA sends the redemption coupon along with the registration link.
  • Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email id
  • Step 4 - Login using your email id and password and start learning

    To get more information, you may want to watch the video below


    Learn Everything, Anywhere, Anytime
    India's Largest Online Education Marketplace
  • Terms & Conditions

    The images represent actual product though color of the image and product may slightly differ.