Notifications can be turned off anytime from settings.
Item(s) Added To cart
Qty.
Something went wrong. Please refresh the page and try again.
Something went wrong. Please refresh the page and try again.
Exchange offer not applicable. New product price is lower than exchange product price
Please check the updated No Cost EMI details on the payment page
Exchange offer is not applicable with this product
Exchange Offer cannot be clubbed with Bajaj Finserv for this product
Product price & seller has been updated as per Bajaj Finserv EMI option
Please apply exchange offer again
Your item has been added to Shortlist.
View AllYour Item has been added to Shopping List
View AllSorry! ONLINE DELIVERY VIA EMAIL - Microsoft Excel Advanced Online Study Material is sold out.
You will be notified when this product will be in stock
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.
|
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
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace
The images represent actual product though color of the image and product may slightly differ.
Register now to get updates on promotions and
coupons. Or Download App