Sign in Sign up
  • Dashboard
  • Courses
    • Free Courses
    • Complimentary Courses
    • Premium Courses
  • Groups
  • Members
  • Mentors
    • Mentor’s Portal
    • Mentorship Application
  • Help
Back to Course

7 Lessons to Learn About Using Microsoft Excel

0% Complete
0/0 Steps
  1. How to structure your course

    Basic Formatting
    4 Topics
    1. Adjust Column Width, Removing Rows or Columns
    2. Fill a List Automatically - Autofill
    3. Introduction to Excel Environment and Quick Access Toolbar
    4. Create a Product Sales List and Formatting Add Title
  2. Basic Maths
    1 Topic
    1. How to Use the SUM and AVERAGE to Calculate the Sales for Each Quarter
  3. Basic Data Management
    3 Topics
    1. Sort and Filtering
    2. Create Basic Quarter Report Where You Will Learn Insert Columns, Rename Worksheet and Discover the Power of Transpose
    3. Search for Date in Date List Faster
  4. Easy Navigation
    1 Topic
    1. View the First Row While Scrolling Down Using Freeze Pane
  5. Time saving Data Extraction
    3 Topics
    1. Text To Column
    2. Find and Replace
    3. Removing Total Line with Filter and Excel Shortcuts
  6. Chart
    3 Topics
    1. Moving Average chart
    2. Stack Column Chart
    3. Line Chart
  7. Printing
    2 Topics
    1. How to Add Page Number to Footer, Print with Grid Line
    2. Print Only What You Need by Setting Print Area, and Adding PageBreak
  8. Cool Excel tips
    2 Topics
    1. Using a Special Tool Called Camera Tool to Create Dynamic Content Document in PDF
    2. Smarter Way to Sum Your Outlet Sales Daily Data
  9. Course Review
7 Lessons to Learn About Using Microsoft Excel Time saving Data Extraction
Lesson 5 of 9
In Progress
← Previous

Time saving Data Extraction

Chee Yong Lau
Lesson Content
0% Complete 0/3 Steps
Text To Column
Find and Replace
Removing Total Line with Filter and Excel Shortcuts

Report

There was a problem reporting this post.

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .