• Courses
  • Profile
  • Become an instructor
  • Blog
  • About
  • Contact Us
  • Affiliate
Have any question?

(+234)9059531604
support@aqskill.com
RegisterLogin
AQskillAQskill
  • Courses
  • Profile
  • Become an instructor
  • Blog
  • About
  • Contact Us
  • Affiliate

Data Analysis

  • Home
  • All courses
  • Data Analysis
  • Data Analysis with Microsoft Excel – Complete Course

Data Analysis with Microsoft Excel – Complete Course

Admin bar avatar
AWESOME EMMANUEL
Data Analysis
₦15,000 ₦3,300
news-data-analyst
  • Overview
  • Curriculum
  • Instructor
  • Reviews

https://www.aqskill.com/wp-content/uploads/2021/04/Data-Analysis-with-Microsoft-Excel-–-Complete-Course-716-X-1280-.mp4

DESCRIPTION

This course consist of  3 distinct classes; The Beginners Class, The Advance Class and The Application Class with a total of 31 well simplified detailed lessons.

 

What you will be learning in this course:

  • The basics of Microsoft Excel from the Beginners level to its Application level.
  • The most common Excel functions used in the Office
  • How to maintain large sets of Excel data in a list or table
  • How to create dynamic reports.
  • Pure practicals

 

Tutored by a Professional Trainer with years of Excel training experience.

As you take part in each of the the 3 categories (classes) you will master Excel tools that will clear away the pain of your daily voluminous tasks. You will start with the basics, building a solid foundation that will give you further knowledge and ease the journey to add up more, as you progress into intermediate and advanced level topics.

 

FREQUENTLY ASKED QUESTIONS

Are the videos downloadable ?

The videos are highly compressed and downloadable.

 

What are the course requirements?

Access to a laptop or computer.

Will certificate be issued?

Yes, certificate of completion will be issued at the end of the course.

 

What will i be able to do after taking this course?

With the knowledge of this course;

 

  • Design a simple automated calculator for a shopping mall.

 

  • Apply the skills in data analysis, grade responses or polls and prepare results.

 

  • Perform basic financial analysis as an accountant/finance secretary

 

  • Design utility models such as Automated Quiz Scoring Board, Digital clock etc

 

  • Simplify voluminous entries using automated forms.

 

  • Secure a lucrative job as a Data analyst.

 

  • Become a Microsoft Excel Instructor.

 

  • Stand out among your peers in the world of data science.

 

In conclusion, This 7 hours Microsoft Excel MasterClass will furnish you to become a competent and professional data analyst.

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor I will use my 5+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

Don’t let this opportunity slip,
Enroll now and take the next step in mastering Excel. Be more PROFESSIONAL

Course Features

  • Lectures 31
  • Quizzes 0
  • Duration 7hours 10minutes
  • Skill level All levels
  • Language English
  • Students 80
  • Certificate Yes
  • Assessments Yes
CoursesData AnalysisData Analysis with Microsoft Excel – Complete Course
  • Beginners Class 12

    • Lecture1.1
      INTRODUCTION 09 min
    • Lecture1.2
      FORMULAS AND FUNCTION 1 22 min
    • Lecture1.3
      FORMULAS AND FUNCTIONS 2 12 min
    • Lecture1.4
      DATA VALIDATION AND DROP DOWN LIST 10 min
    • Lecture1.5
      HEADER AND FOOTER 11 min
    • Lecture1.6
      FORMATTING 12 min
    • Lecture1.7
      PROTECTING SHEET 08 min
    • Lecture1.8
      AUTOMATED CALCULATOR 08 min
    • Lecture1.9
      CONDITIONAL FORMATTING 1 09 min
    • Lecture1.10
      CONDITIONAL FORMATTING 2 05 min
    • Lecture1.11
      CONSOLIDATION 12 min
    • Lecture1.12
      CHARTS 12 min
  • Advance Class 14

    • Lecture2.1
      FILTERING DATA 12 min
    • Lecture2.2
      ADVANCE FILTER 16 min
    • Lecture2.3
      LOGICAL FUNTION (AND) 09 min
    • Lecture2.4
      LOGICAL FUNTION (TEXT) 22 min
    • Lecture2.5
      VLOOKUP 11 min
    • Lecture2.6
      HLOOKUP 06 min
    • Lecture2.7
      PIVOT TABLE 1 22 min
    • Lecture2.8
      PIVOT TABLE 2 08 min
    • Lecture2.9
      PIVOT TABLE 3 05 min
    • Lecture2.10
      POWER QUERY(TEXT, NUMBERS AND WORKING DAYS) 23 min
    • Lecture2.11
      POWER QUERY (FINANCE AND AGE) 29 min
    • Lecture2.12
      DATA ANALYSIS 11 min
    • Lecture2.13
      PIVOT TABLE AND PROGRESS CHARTS 1 26 min
    • Lecture2.14
      PIVOT TABLE AND PROGRESS CHARTS 2 08 min
  • Application Class 5

    • Lecture3.1
      SCORE ANALYSIS 12 min
    • Lecture3.2
      AUTOMATED SCORING BOARD 20 min
    • Lecture3.3
      AUTOMATED DATA ENTRY FORM 06 min
    • Lecture3.4
      SALARY SHEETS 22 min
    • Lecture3.5
      DIGITAL CLOCK 09 min
Admin bar avatar
AWESOME EMMANUEL
    My name is Awesome Emmanuel. I'm an Academic and ICT Instructor based in Lagos. Working presently with one of the best private schools in Nigeria with International recognition, I'm also a resourceful ICT Instructor, providing soft and digital ICT skills.

    Reviews

    Average Rating

    5
    2 ratings

    Detailed Rating

    5
    100%
    4
    0%
    3
    0%
    2
    0%
    1
    0%
    • Olowe oluwaseun

      Data Analysis with Microsoft Excel - Complete Course

      thank you Mr Awesome, I am loving every bit of the course..

    • Iwasanmi Igbagbo

      Data Analysis with Microsoft Excel - Complete Course

      Mr Awesome, you are truly awesome and amazing. I enjoyed every bit of the lesson. I recommend to anyone that wants to acquire skill on this direction. I wish there are courses on Excel VBA, I will love to purchase. Thank you and God bless.

    • Overview
    • Curriculum
    • Instructor
    • Reviews
    ₦15,000 ₦3,300
    • Share:

    You May Like

    Blogging Masterclass – From Amateur to Pro Blogger Read More
    Admin bar avatar
    Jesse Kanadi

    Blogging Masterclass - From Amateur to Pro Blogger

    17
    ₦8,000 ₦2,900
    The Complete Mobile app development, Mobile graphics design, Animation, video editing and Logo creation Read More
    Salami Lukeman Sunday

    The Complete Mobile app development, Mobile graphics design, Animation, video editing and Logo creation

    209
    ₦12,000 ₦2,900
    Forex Trading from Beginner to Advance Read More
    Admin bar avatar
    NELSON ERIRIOMA

    Forex Trading from Beginner to Advance

    145
    ₦15,000 ₦3,900
    Online Store Website Development Course (Practicals) Read More
    Admin bar avatar
    Michael Ndefo

    Online Store Website Development Course (Practicals)

    63
    ₦10,000 ₦2,900
    Complete HTML, CSS & JAVASCRIPT Frontend Web Development Course Read More
    Admin bar avatar
    Michael Ndefo

    Complete HTML, CSS & JAVASCRIPT Frontend Web Development Course

    64
    ₦16,000 ₦3,900

      2 Comments

    1. Anas Yakubu
      06/04/2021
      Reply

      I enjoy the program very well I will try to invite most of my friends to enroll for it.

      • Admin bar avatar
        AWESOME EMMANUEL
        06/04/2021
        Reply

        My pleasure, Thanks for trusting AQskill

    Leave A Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    Latest Courses

    Data Analysis with Microsoft Excel – Complete Course

    Data Analysis with Microsoft Excel – Complete Course

    ₦15,000 ₦3,300
    Blogging Masterclass – From Amateur to Pro Blogger

    Blogging Masterclass – From Amateur to Pro Blogger

    ₦8,000 ₦2,900
    The Complete Mobile app development, Mobile graphics design, Animation, video editing and Logo creation

    The Complete Mobile app development, Mobile graphics design, Animation, video editing and Logo creation

    ₦12,000 ₦2,900
    Forex Trading from Beginner to Advance

    Forex Trading from Beginner to Advance

    ₦15,000 ₦3,900
    • I want to say thank to this platform. After my class i was able to design and develop –>anamfoundation.org

      SAMUEL KAYODE

      WEB DEVELOPER
    • AQskill has been good to me in all ways, have learnt so many things that even 40 thousand Naira won’t have taught when taking me through the class . AQskill is the right choice for anyone who has no knowledge for building games and applications from scratch.

      Oladepo Monsurudeen Ayinde

      SOFTWARE DEVELOPER.
    • I’m glad i bought the web development course.Finally decided to start building websites after 7years of blogging and it’s worth it. Kudos to you guys . See you at the top. God bless AQskill abundantly

      OLUYINKA SOYEMI

      WEB DEVELOPER,BLOGGER
    • I really enjoyed the website development course, it was so inspiring. Thank you!

      Michael

      WEB DEVELOPER
    • The tutorials are very pratical, simple and straightforward.

      Idara Fidelis Ibah

      SOFTWARE DEVELOPER
    • I have registered for different online classes. But AQskill is different

      Ijaogbomo Emmanuel

      SOFTWARE DEVELOPER
    • The course has been very interesting . Everything is well explained.

      Ahmad khalid

      SOFTWARE DEVELOPER
    • Am seriously impressed with AQskill, truly AQskill stands out . Most people don’t like going through programming details like the way AQskill does.

      Shadrach Peter

      SOFTWARE DEVELOPER

    Get our mobile app

    Keep In Touch

    Facebook-f
    Instagram
    Telegram

    Trending Courses

    • Data Analysis
    • Forex Trading
    • Web development

    Join Us

    • Tutor Request
    • Affiliate Program

    About Us

    • About
    • Blogs

    Company

    • Contact Us
    • Privacy Policy

    © 2021 AQskill Technology Systems

    Login with your site account

    Lost your password?

    Not a member yet? Register now

    Register a new account

    Are you a member? Login now