Skip to content
Logo aptlearnaptLearn
  • Category
    • App development
    • Cloud Computing
    • Cyber security
    • Data Analysis
    • Digital Marketing
    • Frontend Web Development
    • Machine Learning
    • Non-Technical Courses
    • Product Management
    • Project Management
  • Courses
    • Get Started
    • Cart
  • Teach on aptLearn
    • Write on aptLearn
  • Code
    • Web Code Playground
  • Login
    • Join
  • About
    • Our Blog
    • Download our App
    • Need Help?
    • Contact Us
0

Currently Empty: $0.00

Continue shopping

Download App
Logo aptlearnaptLearn
  • Courses
    • Get Started
    • Cart
  • Teach on aptLearn
    • Write on aptLearn
  • Code
    • Web Code Playground
  • Login
    • Join
  • About
    • Our Blog
    • Download our App
    • Need Help?
    • Contact Us
  • Home
  • Course
  • Full Course on Microsoft Excel Basics Extra

Full Course on Microsoft Excel Basics Extra

  • By Ahmed Oyelowo
  • Data Analysis
  • (0 Rating)
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • Course Info
  • Instructor
  • Reviews
  • More
    • Microsoft Excel is the most used software in the world and possibly beyond (I have a hunch that Angels use Excel Spreadsheets in their daily activities 😁).

      Having Excel skills is super powerful because of the ease. It solves problems that would have taken donkey years or an impossible period of time to solve.

      If you have never formally learnt Excel before, then this is for you. Most people assume they know Excel, whereas they don’t. Check out the first 15 minutes of the course (which is purely beginner’s introduction) and see if you learn anything new. If you do, then you should complete it to become a Super Being.

      In this course, you will learn how to perform basic spreadsheet operations, including:

      • Protecting Workbooks and Worksheets with Passwords
      • Creating Drop Down Lists in Excel
      • Smart ways to Find and Replace data
      • Separating data into different columns
      • Smart ways to Copy and Paste Data
      • Advanced Sorting and Filtering of Data

      See you in the classroom!

      Show More
      What Will You Learn?
      • Protecting Workbooks and Worksheets with Passwords
      • Creating Drop Down Lists in Excel
      • Smart ways to Find and Replace data
      • Separating data into different columns
      • Smart ways to Copy and Paste Data
      • Advanced Sorting and Filtering of Data
      • Using basic aggregator Functions to write formulas

      Course Content

      Simple Excel Operations

      • Introduction
        01:54
      • Prerequisites
        01:21
      • Excel Knowledge Overview
        01:29
      • Understanding the Excel Environment
        05:52
      • Changing Settings in Excel Options
        04:21
      • Saving & Protecting Excel Workbooks
        05:32
      • Navigating Between Excel Worksheets
        01:40
      • Navigating Between Excel Workbooks
        01:52

      Working with Data (1)

      • Intro to Copying and Pasting
        04:31
      • Pasting with other options
        06:00
      • Using the Paste Options Dialog Box
        04:01
      • Pasting from the Clip Board button
        02:49
      • Duplicating Sheet Data with Move or Copy tool
        04:48
      • Intro to Finding and Replacing data values
        03:34
      • Find & Replace options
        03:39
      • Find & Replace unknown with *
        03:32
      • Find & Replace unknown with ?
        03:05
      • Find & Replace based on Cell Format
        02:11
      • Understanding Cells
        02:55
      • Increasing Cell Size, Row/Column Height & Width
        07:43
      • Understanding Excel Data Types
        05:49
      • Dates are treated like Numbers
        04:56
      • Intro to Cell Formatting
        07:17
      • Intro to Cell Formatting (2)
        03:44
      • Intro to Numbers Formatting
        03:55
      • Customizing Numbers Formatting
        04:51
      • Behavior of Text and Numbers Formatting
        07:07
      • Customizing Date Formats
        06:05
      • Cell Formatting Sample
        05:40

      Working with Data (2)

      • Intro to Data Sorting
        02:16
      • Basic Data Sorting
        04:31
      • Sorting Data that has empty rows or columns
        02:59
      • A better way to sort
        04:42
      • More sorting options
        02:44
      • Advanced Sorting options
        06:45
      • Intro to Data Filtering
        04:20
      • Clearing Filters & Using Search for Filtering
        04:44
      • Filtering data based on rules
        04:54
      • Using Advanced Filtering
        02:29
      • Freeze Panes
        03:51
      • Use Outlines for Expand/Collapsible Buttons
        07:37
      • Intro to Autofill and Fill Series
        03:23
      • Using Fill Dialog Box
        03:55
      • Fill Series with Linear & Growth
        02:55
      • Fill Series based on Trends
        01:53
      • Using Flash Fill
        01:29
      • Intro to Data Validation
        04:14
      • Creating Dropdown Lists
        03:20
      • Text to Different Columns with Delimiters
        03:38
      • Text to Columns using Fixed Width
        03:21

      Working with Formulas

      • Introduction to Excel Formulas
        01:24
      • Writing simple formulas with primitive values
        04:17
      • Introduction to Excel Functions
        02:16
      • How to use Functions in Excel
        08:11
      • Adding up with SUM function
        05:15
      • Using Autosum to save time
        06:12
      • Using AVERAGE, MIN, MAX, LARGE and SMALL
        08:25
      • Course Wrap up
        02:13

      This course offers certificate of completion

      Add this certificate to your resume, and be the standout candidate recruiters cannot ignore

      selected template

      A course by

      Ahmed Oyelowo
      Ahmed Oyelowo
      Data Analyst

      Student Ratings & Reviews

      No Review Yet
      No Review Yet

      Course Includes:

      • Price:
        $28.50 Original price was: $28.50.$7.60Current price is: $7.60.
      • Instructor:Ahmed Oyelowo
      • Duration: 3 hours 30 minutes
      • Lessons:58
      • Students:47
      • Level:Beginner
      $7.60 $28.50
      Wishlist
      Hi, Welcome back!
      Forgot Password?
      Don't have an account?  Register Now
       Sign In with Twitter

      Share On:

      Courses You May Like

      ETL, Data Preparation and Data Cleaning with Power Query
      10 hours 20 minutes
      Intermediate
      ETL, Data Preparation and Data Cleaning with Power Query
      (0.0/ 0 Rating)
      $36.10 Original price was: $36.10.$11.40Current price is: $11.40.
      • 41 Lessons
      • 15 Students
      Intermediate
      ETL, Data Preparation and Data Cleaning with Power Query
      (0.0/ 0 Rating)
      $36.10 Original price was: $36.10.$11.40Current price is: $11.40.

      If you work with data in any capacity, you probably know that the most tedious part of all the tasks is getting the data ready....

      • 41 Lessons
      • 15 Students
      Enroll Now
      Top Twenty Water Monster Movies For Kids - 1200 x 600 px
      60 hours
      Beginner
      aptLearn Cyber Security Certification Course
      (0.0/ 0 Rating)
      $32.30 Original price was: $32.30.$5.70Current price is: $5.70.
      • 66 Lessons
      • 244 Students
      Beginner
      aptLearn Cyber Security Certification Course
      (0.0/ 0 Rating)
      $32.30 Original price was: $32.30.$5.70Current price is: $5.70.

      Welcome to our comprehensive Cyber Security course! This course is designed to provide a complete understanding of Cyber Security, from the basics to advanced concepts....

      • 66 Lessons
      • 244 Students
      Enroll Now
      DATA_ANALYSIS_AND_VISUALIZATION_USING_POWERBIW
      14 hours
      Intermediate
      Data Analysis and Visualization Course
      (0.0/ 0 Rating)
      $36.10 Original price was: $36.10.$9.50Current price is: $9.50.
      • 61 Lessons
      • 84 Students
      Intermediate
      Data Analysis and Visualization Course
      (0.0/ 0 Rating)
      $36.10 Original price was: $36.10.$9.50Current price is: $9.50.

      Are you ready to unlock a fast track to career advancement with one game-changing skill? Welcome to the empowering world of Microsoft Power BI! Power...

      • 61 Lessons
      • 84 Students
      Enroll Now
      it-managers-integrate-technologies-into-business-operations-enterprise-it-management-it-software-solutions-enterprise-architecture-concept-illustration_335657-2376
      7 hours 55 minutes
      All Levels
      Cross Platform Android, iOS and Web App Development
      (5.0/ 6 Ratings)
      $47.50 Original price was: $47.50.$9.50Current price is: $9.50.
      • 21 Lessons
      • 50 Students
      All Levels
      Cross Platform Android, iOS and Web App Development
      (5.0/ 6 Ratings)
      $47.50 Original price was: $47.50.$9.50Current price is: $9.50.

      Are you looking to create awesome, cross-platform mobile apps without the stress of learning how to code? Look no further. In this course, you’ll discover...

      • 21 Lessons
      • 50 Students
      Enroll Now
      Project Management Certification Course
      45 hours
      Intermediate
      Project Management Certification in Software Engineering
      (0.0/ 0 Rating)
      $38.00 Original price was: $38.00.$9.50Current price is: $9.50.
      • 148 Lessons
      • 30 Students
      Intermediate
      Project Management Certification in Software Engineering
      (0.0/ 0 Rating)
      $38.00 Original price was: $38.00.$9.50Current price is: $9.50.

      Welcome to the Project Management Course! Whether you're new to managing projects or looking to enhance your skills, this course is designed to equip you...

      • 148 Lessons
      • 30 Students
      Enroll Now
      Complete_cloud_engineering (1) (1)
      20 hours
      Intermediate
      Complete Cloud Engineering Course In Linux
      (0.0/ 0 Rating)
      $38.00 Original price was: $38.00.$9.50Current price is: $9.50.
      • 70 Lessons
      • 67 Students
      Intermediate
      Complete Cloud Engineering Course In Linux
      (0.0/ 0 Rating)
      $38.00 Original price was: $38.00.$9.50Current price is: $9.50.

      Unlock the full potential of Linux with our comprehensive course, "Complete Cloud Engineering Course In Linux": Server Management, Hosting, and Troubleshooting." This course is designed...

      • 70 Lessons
      • 67 Students
      Enroll Now
      aptLearn
      Logo aptlearnaptLearn
      Sign inSign up

      Sign in

      Don’t have an account? Sign up
      Lost your password?

      Sign up

      Already have an account? Sign in