3.5  1 reviews on Udemy

Excel's Basics

At the end of this course, you’ll easily using excel faster and more efficiently than ever before.
Course from Udemy
 3 students enrolled
 en
How to use Text to Columns
How Remove Duplicates
How to use Concatenate
How to use Average/Sum/Median/MAX/MIN
How to create Conditional Formatting
How to use VLOOKUP
How to create and use Pivot Tables
Freezing top rows and first columns or both together
Creating a graph/chart
Creating a graph with a secondary axis

Microsoft Excel is used by millions of people around the world every day. It is an extremely powerful tool that allows individuals and businesses to easily sort, search, and review large sets of data.


While there are endless possibilities for how to use Excel, there are a number of basic formulas and built-in tools that everyone should know. You can learn these basic tips in under an hour and once you’ve mastered them you’ll be using Excel faster and more efficiently than ever before.


In this course I’m going to show you how to use the following:


  • Section 1: Must Know Formulas

    • Text To Column: Split the text into multiple columns based on pre-determine break points

    • Remove Duplicates: Easily clean up large lists and columns.

    • VLOOKUP: For a specified value, the function finds (or 'looks up') the value in one column of data, and returns the corresponding value from another column

    • CONCATENATE: link (things) together in a chain or series

    • Average/Sum/Median/Max/Min: Quickly get basic information about your data

    • COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS: Easily count different kinds of cells, such as blanks or non-blanks, with number, date or text values, containing specific words or character, etc.

  • Section 2: Conditions

    • Create a Pivot Table to better view large sets of data

    • Use Conditional Formatting to visualize your data

    • Freeze Top Row and First Column or Both Together

  • Section 3: Making a Chart

    • Create your basic chart with a Secondary Axis to compare two sets of data at once



This course is perfect for those looking to get a leg-up on their peers, those who use Excel for any function, and those looking to better understand how to take control of their data.



Excel's Basics
$ 19.99
per course
Also check at

FAQs About "Excel's Basics"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.

SOCIAL NETWORK