Advance Excel Course

Microsoft Excel Lessons
K 30000
Take This Course
  • Lectures 37
  • Video 0 Min
  • Skill Level Beginner
  • Languages Burmese

Course Description

Microsoft Excel Lessons                                                                                                                                      

What are the requirements?

  •                                                                                                                                                       

What am I going to get from this course?

  •                                                                                                                                                       

What is the target audience?

  •                                                                                                                                                       

Curriculum

Section 1: Advance Excel Course
Unit (1) Overview of Workbook

Unit (1.1) Overview of Workbook

Unit(2) Working with Worksheet and Workbook

Unit (3) Data Entry and Auto Fill Options

Unit (4) Cell References

Unit (5) Understanding Excel Operator Precedence

Unit (6) Excel Database and Working with Table

Unit(7.1) Sorting Data

Unit (7.2) Filtering Data

Unit (8.1) Working with hyperlink in Excel

Unit(8.2) Hyperlink to Existing File

Unit (9.1) Data Validation in Excel

Unit (10) Working with Formula and Function

Unit(11.1) Math & Statistical Functions (SUM Functions)

Unit (11.2) Count Functions

Unit (11.3) AVERAGE Functions

Unit (11.4) Statistical & Round Functions

Unit(12) TEXT Functions

Unit(12.2) TEXT Functions (Exercises)

Unit (13.1) Logical Function

Unit (14.1) Date Functions

Unit (14.2) DATEDIF Function

Unit (15.1) LOOKUP Function

Unit (15.2) LOOKUP & REFERENCE Functions

Unit (16) Advanced Lookup & Array Functions

Unit (17.1) Conditional Formatting

Unit (18) Protection Wroksheet & Workbook

Unit (19) Data Connection in Excel

Unit (19.1) Chart (Design and Format)

Unit (20) Group, Ungroup and Subtotal

Unit (21) Data Connection in Excel

Unit (22.1) Pivot Table & Pivot Chart

Unit (22.2) Pivot Table (Slicer and Dashboard)

Unit (23) Consolidate in Excel

Unit (24.1) Applied Macros & VBA in Excel

Unit (24.2) Advanced Filter with Assign Macro

Unit (25) What If Analysis

Instructor Biography

U Day Day Kyaw (ECTC)
Computer Training Centre

Reviews

Average Rating
5
Details
  1. 1 Stars
    0
  2. 2 Stars
    0
  3. 3 Stars
    0
  4. 4 Stars
    0
  5. 5 Stars
    1
    • ခ်မ္း ေမာင္
    • posted 7 months ago

    good