Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learning Excel from scratch for productivity in office
Rating: 4.1 out of 5(16 ratings)
1,848 students

Learning Excel from scratch for productivity in office

Important aspect of Excel for office work
Created byKingsley Tom
Last updated 12/2021
English
English [Auto],

What you'll learn

  • Create a filter in Excel
  • Create data entry form in Excel
  • Create a primary key in Excel
  • Be able to password your documents against unauthorized access
  • Create a Vlookup in Excel
  • Excel Formulas
  • Excel Functions
  • How to plot eye catching graphs in Excel
  • Application of IF function in Excel
  • How to create a pivot table in Excel

Course content

2 sections • 10 lectures • 2h 42m total length

  • How to create a filter in Excel table17:05

    Create an Excel table, apply a filter to isolate records by year, copy the filtered results, and reset the view for efficient office data analysis.

  • How to create a data entry form in Excel7:13

    Learn to create a data entry form in Excel by adding the form command to the ribbon and using it to enter records with first name and last name.

  • How to password a document in Excel8:42

    Learn to password protect Excel documents by securing workbooks and worksheets, preventing unauthorized access, and applying password protection to protect sheet data and workbook structure.

  • How to create a primary key or unique identifier in Excel16:08

    Create a unique customer id in Excel by adding a new column and using a formula to concatenate first and last names into an auto-generated login password, then fill down.

  • How to create a vlookup in Excel8:02

    Learn to create a Vlookup in Excel to retrieve exact payment amounts from a wide table by setting the table range, defining the column index, and choosing exact-match lookup.

  • Excel Formulas that is enough to make you a pro in Excel.13:21

    Learn seven essential Excel formulas and functions for data analysis, including addition, subtraction, multiplication, division, sum, min, max, count, counta, and average, with lookups and conditional if statements.

  • Excel Functions18:47

    Master essential Excel functions, including concatenate, if, countif, sumif, and lookup, to generate unique identifiers, summarize data, and timestamp payments for effective office productivity.

Requirements

  • You just need a computer system with Microsoft office installed simple

Description

Excel is a very powerful and one of the most used analytical tool. very important questions that recruiters ask during job interviews in Excel are being answered in this lesson. this lesson contain very important aspect that you can't attain higher productivity without the knowledge. This lesson highlights are explained stepwisely without rushing. In this course, the detailed step by step process to doing the following are explained.

* How to create a filter in Excel. Filter in Excel is very important area in Excel that helps to sort out information without stress.

* How to create a data entry form in Excel

* How to password your documents against unauthorized access. This particular aspect is very important. It protects the company's data from unauthorized access that's why big organizations don't joke with it. Because of this, it's always one of the important question asked at Excel job interviews. How to do it is explained in steps in this video.

* How to create a primary key in Excel. Primary key is a unique I dentifier that Identify a particular data in a row of a table. This particular feature is mostly obtained in Microsoft access but in this video it is explained in details how to create a primary key in Excel without stress.

* How to create a Vlookup in Excel. This is also very important question usually ask during job interviews in Excel. It is a very necessary aspect of Excel that is very pertinent for optimum productivity in the office. These are skills that if acquired, you'll sell in the labour market.

* Also in this lesson, seventeen Excel Formulas and functions are explained in details and its usability in order to make data analysis simple, fast and accurate.

* In section two of this lesson, how to plot eye catching graphs in Excel are explained in details. Many other lessons are added everyday. I wish you the best as you keep building your knowledge in Excel also don't forget to rate this course as you enroll on it, thanks.

* Various applications of IF function

* what is pivot table and ow to create a pivot table in Excel

Who this course is for:

  • All categories of persons

Report abuse