Careers360 Logo
Interested in this College?
Get updates on Eligibility, Admission, Placements Fees Structure
Compare

Quick Facts

Medium Of InstructionsMode Of LearningMode Of Delivery
EnglishSelf StudyVideo and Text Based

Courses and Certificate Fees

Fees InformationsCertificate AvailabilityCertificate Providing Authority
INR 2436yesCoursera

The Syllabus

Videos
  • Introduction: Excel Course for Professionals
  • Expert Video: Ingeborg Hawighorst - Is Excel the answer?
  • Expert Video: Importance of good input data, and how to check it
  • Expert Video: The importance of Formatting in Excel
  • Expert Video: Why is documentation important?
Readings
  • Introduction
  • 5 Excel Blunders that show how important safe Excel use is
  • Match the correct solution to the problem
  • Testing your input data
  • How to format consistently in Excel
  • The importance of documentation
Practice Exercise
  • A foundation for better spreadsheets

Videos
  • Recap “Fundamentals” and Intro “Functions & Formulas” in Excel
  • Expert Video: Pitfalls of commonly used Functions & Formulas
  • Expert Video: Functions and Formulas
  • Expert Video: Functions and Alternatives
Readings
  • Find & Search Functions
  • Calculation Functions
  • Other Functions

Videos
  • Recap “Functions & Formulas” and Intro “Structure & Flow” in Excel
  • Expert Video: Linear and logical spreadsheet flow
  • Expert Video: Keep it Simple
  • Expert Video: Protection and Hidden Information
Readings
  • Linear and logical spreadsheet flow
  • Keep it Simple
  • Protection & Hidden Information
Practice Exercise
  • Spreadsheet Structure and Logical Flow

Videos
  • Recap “Structure & Flow” and Intro “Finishing Touches” in Excel
  • Charts, Pivot Tables, and Reporting (Gasper Kamensek)
  • Charts, Pivot Tables, and Reporting (Henk Vlootman)
  • Expert Video: Checking, Testing, and Validation
  • Expert Video: Finalization
Readings
  • Charts and Reporting
  • Checking, Testing, and Validation
  • Finalization

Instructors

Back to top