Go to course

Don't have an account with us? Create one it's free!

Description

This course comprises five units that covers basic, intermediate and advanced features and application of Excel in Data Entry, Data Analysis, Data Presentation, Collaboration and Review.

Features

  • Videos
  • Quizzes
  • Practice excercises
  • Forum to collaborate and engage with course contacts and course takers.

Units in Productivity with Microsoft Excel
Unit 0: Microsoft Office Excel
You will become familiar with Microsoft Office Excel Application, you will learn the interface and how to customize and set the application preferences. You will learn about the data matrix, how the Excel workspace is organized to collect data and common tasks in Excel.
  • Starting Microsoft Office Excel
  • The Excel Interface
  • Customizing the features of the Excel Interface
  • The Backstage View
  • The data matrix
  • Working with Cells
  • Common tasks in excel
Unit 1: Data Entry
You will learn how to manage worksheets, collect data of various types and take advantage of the Excel views to work better. You will also learn how to manage connections to external data sources and carry out data cleaning tasks.
  • Worksheets
  • Data types
  • The Excel Views
  • Data entry and editing
  • Data from external sources
  • Sort and filter
  • Data tools
Unit 2: Data Analysis
You will learn how to carry out computation with formulas and functions. You will also learn how to summarize and analyze data using tools like the Data Analysis Tool Pack, Solvers and more.
  • Formulas
  • Functions and the function library
  • Named ranges
  • Formula Auditing
  • Outlining
  • What-if analysis
  • The data analysis tool pack
  • Solver
  • Conditional formatting
Unit 3: Data presentation
You will learn how to slice and dice data and present useful summaries with consistent style and formatting. You will also learn how to manage worksheet layout and printing
  • Cell formatting
  • Tables
  • Charts
  • Pivot tables and charts
  • Slicers and Timelines
  • Sparkline
  • Page layout and printing
Unit 4: Collaborating and Reviewing
You will learn how to create and use Excel forms to collect data and macros to complete repetitive tasks. You will learn how to prepare and share your workbook with a team of collaborators and reviewers. You will also learn how to manage collaboration and review, protect your document and prepare your document for internationalization
  • Form controls
  • Proofing, Language and Comments
  • Protection and track changes
  • Macros
  • Sharing and Collaborating
  • Internationalization
  • Templates

How to enroll


 

Price: ₦ 18,000
Schedule: Open
Venue: Online
Duration: 5 Weeks
Enrollment: 10 Weeks
Certificate: On completion

 

Buy now, save 44%  

Instructor
Instructor: Stephen Sani

I have helped many people learn to use data and related technologies and I am sure this course is a great learning experience with wholesome contents.

Go to course

Don't have an account with us? Create one it's free!