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

Sorry! ONLINE DELIVERY VIA EMAIL - Microsoft Excel Advanced Online Study Material is sold out.

Compare Products
Clear All
Let's Compare!

ONLINE DELIVERY VIA EMAIL - Microsoft Excel Advanced Online Study Material

This product has been sold out
(1.0) 1 Rating Have a question?

We will let you know when in stock
notify me

Featured

Highlights

  • Delivery via E-mail
    Non-Cancellable
    No Physical Dispatch
  • Disclaimer:Online Delivery via E-mail. No Physical Dispatch. Non-Cancellable Product
  • Stream:MS Office
  • Certification:Yes
  • Language:English
  • Format:Online Study Material
  • Type:Online Fulfillment
  • Duration:6 Months For queries and concerns drop an email to learning@snapdeal.com
  • SUPC: SDL525339834

Description


Product Description

These Four Courses are in this combo :

1. Learn Excel® 2007 – Advanced Online Certification Course from World’s Top Expert 37 lecture with 04 hours  duration  This course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you learn how to analyze and manage your data. You will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and Pivot Charts and record basic macros.
2. Learn Excel® 2007 – Essential Online Certification Course from World’s Top Expert 25 lecture with 4 hours  duration  Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers. This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time! 
3. Microsoft® Excel® 2010 - Advanced Online Certification Course from World’s Top Expert 35 lecture with 9.5 hours  duration  Microsoft has added very powerful tools to Excel over previous versions. Understanding these tools will save you time and energy combing through information. Learn how to create eye-catching charts and graphs (formatting axes and gridlines, showing basic trends, complex trends, even trends over time). Learn the differences between the various types of charts, relationships in data, and ways to show differences.
4. Microsoft® Excel® 2010 - Essentials Online Certification Course from World’s Top Expert 30 lecture with 6 hours  duration 

This course will take you through Microsoft Excel 2010 from starting the program and using the Ribbon to creating Pivot Tables and summarising your data.


You will be able to create spreadsheets and workbooks that add up. Use more complex functions such as If Statements and present your data in a visually pleasing way.
You can take the course in the order it is set out or jump in and learn the lessons you need when you need them.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1. Microsoft Excel 2007 Essential

Microsoft Excel is a mainstay for many Office users. Unfortunately, many people know the BASICS of spread sheets but they never get to the next level, integrating and advancing basic skills to escalate worksheets to elegant, powerful solutions.

In this series, new and long-time Excel users will learn how to take core skills to the next level by exploring advanced functions and chart features, connecting to external data, utilizing data tools, leveraging auditing features and gaining insight with what-if features.

You'll also learn how to create macros and work with basic VBA code to customize and automate your work. Does EVERY Excel user need to know these skills? No. But if you want to use Excel beyond simple data entry and calculations to its fullest potential and therefore be able to reach your own full potential, this series will help get you there.

Highlights

Take basic Excel skills to the next level by integrating and extending basic skills to create elegant solutions

See how advanced functions and data tools automate routine tasks and provide easy answers to not-so-easy questions

Discover the power of simplifying complex data through advanced charts and pivot tables

Audit calculations, manage errors and ask find answer to your "what if..." questions

Import & connect to external data

Create macros and make simple edits using VBA to automate routine tasks

2. Microsoft Excel 2007 Advanced

Now that you got your feet wet learning the new features in Microsoft Excel 2007 in the first video series, Total Training for Microsoft Excel 2007: Essentials, you're ready to dive into the advanced capabilities.

While creating pivot tables and macros seems daunting, you'll be at ease learning some new techniques that will streamline your next data analysis project. Sit back and discover how to unleash the power of Excel with this in-depth video series.

Highlights

Learn how to sort and filter data faster in Excel 2007. You can even sort or filter by color.

Master pivot tables to summarize a million rows of transactional data into a flexible summary without writing a single formula.

Reduce repetitive tasks to a single mouse click by creating a macro. Plus, find out why most recorded macros don't work and the one setting to change to allow many recorded macros to work.

See how to use the three new charting ribbon tabs to quickly format a chart or how to use the dialog boxes to coax charts out of Excel that don't look like Excel charts. You'll discover how to make charts in your company's colors with one keystroke.

Create a report for every customer or department with a couple of mouse clicks. Learn five ways to summarize data and when to use each method.

3. Microsoft Excel 2010 Essential

This series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you've never used Excel, this is your starting point. No prior experience is necessary. If you've used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate.

If you've used previous versions of Excel (prior to Office 2007) then there are a lot of features and changes you need to be aware of to fully utilize this software. In this course we take you from start to finish including entering data, configuring workbooks, working with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work.

These are the skills every Excel user needs to know no matter how new or how experienced you may be!

Highlights

Break down Excel into its component parts to make it more manageable and less overwhelming

Use common, understandable names to replace confusing cell references

Apply traditional formatting, create custom formats and apply formatting that automatically changes based on conditions you designate

Truly understand how formulas and functions work, no matter how seemingly simple or complex

Learn the Commandments of Excel Usage™ to ensure your work is efficient and accurate

Embrace the power of tables to sort, filter and manage data more easily

4. Microsoft Excel 2010 Advanced

Microsoft Excel is a mainstay for many Office users. Unfortunately, many people know the BASICS of spreadsheets but they never get to the next level, integrating and advancing basic skills to escalate worksheets to elegant, powerful solutions. In this series, new and longtime Excel users will learn how to take core skills to the next level by exploring advanced functions and chart features, connecting to external data, utilizing data tools, leveraging auditing features and gaining insight with what-if features.

You'll also learn how to create macros and work with basic VBA code to customize and automate your work. Does EVERY Excel user need to know these skills? No. But if you want to use Excel beyond simple data entry and calculations to its fullest potential and therefore be able to reach your own full potential, this series will help get you there.

Highlights

Take basic Excel skills to the next level by integrating and extending basic skills to create elegant solutions

See how advanced functions and data tools automate routine tasks and provide easy answers to not-so-easy questions

Discover the power of simplifying complex data through advanced charts and pivot tables

Audit calculations, manage errors and ask find answer to your "what if..." questions

Import & connect to external data

Create macros and make simple edits using VBA to automate routine tasks

Note: Learner will receive the course completion certificate and have to apply for the certification separately.


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.