Home

Level 2: Intermediate Excel Skills

Level:
Intermediate
Duration:
3 Hours
Award:
Certificate of completion
Price:
K12,000
Register now

What you'll learn

  • Conditional formatting
  • How to use Look-up functions
  • How to use Logical functions
  • Techniques to make spreadsheets easier
  • Techniques to protect your spreadsheets

Description

Enroll now to dive deep into the most popular spreadsheet tool on the market, Microsoft Excel. This course will help you to learn all formulas that could be required for any job, formulas, functions, data visualization and  many more techniques for making working with a spreadsheet easier.

Requirements

  • Have a computer and Microsoft Excel installed on it
  • Basic understanding of your Excel skills

Course Outline

Unit 2.1: Charts and Tables

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

Unit 2.2: Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts

Unit 2.3: Lookup &Reference

Looking up information in a basic table, and more flexibly.

  1. VLOOK UP ()
  2. HLOOK UP ()
  3. INDEX () / MATCH () combination

Unit 2.4: Logical Functions

  • IF, OR, AND

Unit 2.4: Techniques for making working with a spreadsheet easier

  • Freezing Panes, splitting windows and using multiple windows.

Unit 2.5: Protecting and Sharing

  • Protecting Workbooks and when it’s useful or necessary locking cells, Worksheet protection, Workbook protections, allowing users to edit ranges.

Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.
Thanks for your submission
Oops! Something went wrong while submitting the form.

More

Excel

Courses

Level 1: Excel for Beginners

Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Duration:
3 Hours
Price:
K10,000
Level 3: Advanced Excel Skills

Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Duration:
3 Hours
Price:
K15,000