Microsoft Excel - Intermediate Level

  • 0 ratings

COURSE DESCRIPTION

··      We all need to be proficient in use of Excel in most working environments.

·      This Microsoft Excel course provides Intermediate level  learnings with practical examples

·      The course assumes basic Excel knowledge, we recommend you also take the Excel Beginners course provided by SourceTheCpourse

·      The course is delivered by a highly experienced professional trainer with strong skills in Excel.

 

The course will cover the following seven topics:

1.     Introductions to Fill Techniques, Reports, Short cuts

2.     Freeze Panes: how to lock headings, rows and columns

3.     If Function: it is part of a group of Logical functions used to various conditions

4.     Vlookup function: these are most commonly used functions in excel, looking for certain value to search functions

5.     Conditional formatting: it is a Combination of IF function and Formatting. Display the result in language of colours, used extensively for reporting

6.     Tables: it is a specific structure that converts items into tables with functions and features

7.     Pivot tables: are specialized tables that gives you a lot of flexibility when it comes to calculations, representations of information and analysis

 

 

.

COURSE Goal

  • Learn Fill Techniques, Reports, IF functions, V-Look functions, Conditional formatting, Tables & Pivot tables

COURSE Audience

  • Almost all of us need proficiency in Excel

COURSE Requirements

  • Basic Excel knowledge

Course Features

  • Sections 1
  • Lectures Quizzes 1
  • Quizzes Questions 0
  • Skill level All level
  • Students 4
  • Certificate No

Course Curriculum

Start Here

  • Fill Techniques, Reports, Short cuts
    00:29:02
  • IF Functions
    00:24:02
  • V-Lookup Function
    00:28:22
  • Conditional Formatting
    00:26:13
  • Pivot Table and Conclusion
    00:36:33

more course by SourceThe Course

  • No reviews found