Discover the Functional Aspects of MS Excel 2013
3.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
426 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Discover the Functional Aspects of MS Excel 2013 to your Wishlist.

Add to Wishlist

Discover the Functional Aspects of MS Excel 2013

Master in treasure of function with the most powerful features of MS Excel
3.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
426 students enrolled
Created by GreyCampus Inc.
Last updated 1/2016
English
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 2 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand the concepts of cell references
  • Appreciate some of the amazing features of Excel’s Backstage view
  • Utilize the data protection capabilities of worksheets
  • Explore some of the amazing and lesser known functions aimed at providing meaningful information
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
Description

This course familiarizes you with some of the most powerful features of MS Excel, its treasure of functions. Besides explaining the preliminary concepts of cell references, it also covers some of the lesser known utilities.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

  • Understand the concepts of cell references
  • Appreciate some of the amazing features of Excel’s Backstage view
  • Utilize the data protection capabilities of worksheets
  • Explore some of the amazing and lesser known functions aimed at providing meaningful information

Perhaps the closest thing to magic Excel users will ever see in a workbook is Flash Fill. This feature anticipates formatting and data requirements by recognizing patterns so it can finish what you start.  Recommended Charts, but generates a quick PivotTable. It's a great new feature for most users. Quick Analysis offers a second new way to generate appropriate charting for your data. A timeline lets you filter records in a PivotTable—it works similar to a slicer, but you'll filter by dates. 

Who is the target audience?
  • Some of them are Flash fill, timeline feature, Lookup function, Statistical Function and more.
  • These features allow the user to work with data more effectively and efficiently.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
15 Lectures
01:56:43
+
Course Introduction
1 Lecture 01:55
+
Navigating worksheets
1 Lecture 06:10
+
Understanding Cell References
1 Lecture 13:06
+
The Backstage view - Analysis Perspective
1 Lecture 10:36
+
Printing Worksheets - Print Area, Headers /Footers
1 Lecture 05:41
Printing Worksheets - Print Area, Headers /Footers
05:41
+
Excel protection features (password Protecting sheets, and hiding Formula)
1 Lecture 06:29
Excel protection features (password Protecting sheets, and hiding Formula)
06:29
+
Exporting Excel data to other formats - CSV, PDF, and others
1 Lecture 07:06
Exporting Excel data to other formats - CSV, PDF, and others
07:06
+
Useful Text Functions – TEXT, CONCATENATE, INSTR, REPT, etc.
2 Lectures 32:31
Useful Text Functions – TEXT, CONCATENATE, INSTR, REPT, etc.
15:26

Useful Text Functions – TEXT, CONCATENATE, INSTR, REPT, etc. Part 2
17:05
+
Important Date Functions – EOMONTH, NETWORKDAYS, etc.
1 Lecture 11:09
Important Date Functions – EOMONTH, NETWORKDAYS, etc.
11:09
+
Common Financial Functions – NPER, PV, PMT, etc.
1 Lecture 08:59
Common Financial Functions – NPER, PV, PMT, etc.
08:59
5 More Sections
About the Instructor
GreyCampus Inc.
3.9 Average rating
2,093 Reviews
26,081 Students
53 Courses
Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.