Showing posts with label MS_excel. Show all posts
Showing posts with label MS_excel. Show all posts

Monday, 17 February 2014

MS-Excel 2013 from UDEMY.

MS-Excel 2013 from UDEMY.
Beginner Level:

Microsoft Excel 2013 Training Tutorial

Learn Microsoft Excel 2013 with this comprehensive course from TeachUcomp, Inc.Mastering Excel Made Easyfeatures 222 video lessons with over 10 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each Microsoft Excel 2013 lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises.  You will learn how to effectively create and format spreadsheets, charts, pivot tables and much more.
Total learners in this course:4740 +.

click below image to learn the course:


Advanced level:
Take Your Microsoft Excel Skills To The Next Level
In this Excel 2013 tutorial course for Microsoft Excel 2013, an expert author takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft.
You will start with basic Excel operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. The author proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. The course also covers some basic Macro operations within Excel for optimizing your workflow.
By the completion of this computer based advanced Excel training video for Microsoft Excel 2013.
Total learners in this course:21150+.
click below image to learn the course:



Simplified Level :
In this Excel For beginners course, you shall learn how to use Microsoft Excel 2013 from qualified instructors at Quant Master Academy   The Excel 2013 tutorial course is aimed at introducing you to Excel and take it to next advanced level. You shall be learning from very basic of how to create your worksheet. And then slowly we will be introducing advanced topics in excel like advanced formulas, sorting and filtering data in excel. You shall also be learning how to use SkyDrive and collaborate with other people in developing Excel Workbook.
 By the end of the Excel 2013 tutorial course, you shall be very comfortable in using Excel with a lot of ease. We shall be introducing lot of keyboard shortcuts as well to increase efficiency while working with Excel.
Take this Excel for beginners/intermediary course right now and learn Excel 2013.

Total learners in this course:160 +.
click below image to learn the course:


Intermediate level:


A big "thank you" to the course instructor for going straight into the point and showing me how each feature works while elaborating on the use of them in the real world. It was very easy to understand all the lessons which averages only about 5-8 minutes each.
Very good excel course!
The course is well structured, easy to follow, it has good content, nice visuals and practical examples. I recommend it!
Total learners in this course:770 +.

click below image to learn the course:


Delux Edition:

Master Excel essentials with these step-by-step video tutorials, Excel All-in-One For Dummies e-book, Office 2013 cheat sheets, an interactive quiz, an instructional PowerPoint, and more!
This Excel 2013 video training course includes everything you need to go step by step through all the essential tasks involved in using Excel 2013. With over 90 Excel video lessons, you’ll get in-depth video training that provides the show-and-tell, covering the basics of launching and navigating the program, creating and editing spreadsheets, and printing your worksheets. Then you’ll learn how to get organized, analyze your data, create charts and data lists, and share your spreadsheets. You also have access to a customized 800-page e-book along with an array of Office 2013 and Windows 8 cheat sheets to help you learn the quick basics and get you moving along quickly. You will be able to test your knowledge by taking the For Dummies quiz and use the included PowerPoint that includes key instructional information for Excel 2013. In no time, you’ll be an Excel pro!
Total learners in this course:770 +.
click below image to learn the course:

Sunday, 16 February 2014

Learn MS Excel 2013 from Udemy.

Learn Microsoft Excel 2013 - Advanced

Course Description
Master Excel's Powerful Data Functions in this Information-Packed 9-hour Video Training.
·        Personal and Professional Financial Functions
·        Statistical Functions for Description, Prediction and Interference
·        Connecting to External Data
·        Tables, Charts and Pivots
·        Data Analysis
The Versatility of Excel
If you have already been using Microsoft Excel then you know that the calculation, graphing and tables available help you track, manipulate and report important data. There is more to excel than a few SUMs, though, and this is the training course to get you into the advanced uses of Excel so you can really use the data and numbers you are tracking to your advantage.
This course is designed for students that are already familiar with Excel, but wish to improve their skills and open the possibilities with this versatile spreadsheet program. Bring your basic knowledge of Excel 2013 or previous software versions to this class and learn how to reach the next level of database tracking and reporting.
Contents and Overview
Through 52 lectures and over 12.5 hours of content, this course will take you through learning how to use functions in everyday work environments. Personal and professional financial functions are covered including payments, future value and depreciations. Students will learn statistical functions like averages, percentiles, and regression.
In order to improve efficiency, students will also cover concepts for connecting to external data like other workbooks or web data; tables including style, selection and sizing. Pivot tables and data analysis will be key concepts helpful to the work environment.
For help with reporting, students will learn surface charts, stock charts, radar charts and bubble charts and graphs. Lastly, students will cover important web applications.
Upon completion of this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms like tables, graphs and pivot tables in order to show important analysis like depreciation, percentiles and regression for use with strategizing and planning. Students who finish this course will have an advanced knowledge of the versatility of Excel that is immediately applicable to their work with the database.
What are the requirements?
·        Microsoft Excel 2013
What am I going to get from this course?
·        Over 52 lectures and 12.5 hours of content!
·        Working with dates and times
·        Averages, percentiles, and LINEST functions
·        Calculating depreciation
·        Payments
·        Inserting and formatting tables
·        Sparklines and data bars
·        Pivot charts
·        Bonus practice files
What is the target audience?
·        Users with basic knowledge of Excel 2013 and those upgrading from previous software versions

Total learners in this course:5900 +.
Money back guaranty  with in 30 days.


click below image to learn the course: