Learn Excel
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Excel to your Wishlist.

Add to Wishlist

Learn Excel

Learn Basic Excel and master the art of working with excel Datasets.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1 student enrolled
Created by Jasleen Chadha
Last updated 7/2017
English
Curiosity Sale
Current price: $10 Original price: $25 Discount: 60% off
30-Day Money-Back Guarantee
Includes:
  • 34 mins on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • They will be able to work on excel, manipulate data on excel, work on big data sets, create pivot tables, work on vlookup
View Curriculum
Requirements
  • No prerequisites
Description

Microsoft Excel is a spreadsheet develop

ed by Microsoft for Windows, MacOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

By taking this course, you'll be able to :

  1. MASTER SHORTCUTS, FUNCTIONS AND FORMULAS THAT SAVE TIME AND INCREASE PRODUCTIVITY
  2. LEARN HOW TO PRODUCE PROFESSIONAL-LOOKING CHARTS AND DIAGRAMS FOR REPORTS, PRESENTATIONS AND PRINTOUTS
  3. SHORTEN WORKDAYS USING RECORDED AND PROGRAMMED MACROS
  4. UNDERSTAND THE WORK OF COLLEAGUES AND EXCEL SOLUTIONS FOUND ON THE INTERNET


Who is the target audience?
  • Anyone who wants to learn excel both basic and advanced
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction
12 Lectures 36:47

This video talks about the introduction to excel and getting started with it.

Preview 01:13

Shortcuts are important when working on excel as it makes the task easier. In this video you'll learn about various shortcuts on excel and their significance as well. Keep practicing for better usage of them. I have also added those shortcut list on the article.

Basic keyboard shortcuts
03:13

bar chart or bar graph is a chart or graph that presents grouped data with rectangular bars with lengths proportional to the values that they represent. The bars can be plotted vertically or horizontally. A vertical bar chart is sometimes called a Line graph. To make things easier we can make bars on excel. In this lecture, you'll learn how to make bars on excel.

Preview 03:07

Shortcuts are important when working on excel as it makes the task easier. In this video you'll learn about various shortcuts on excel and their significance as well. Keep practicing for better usage of them. I have also added those shortcut list on the article.

Preview 05:22

Use Excel as your calculator. Instead of reaching for your calculator, use Microsoft Excel to do the math! On a worksheet, you can enter simple formulas to add, divide, multiply, and subtract two or more numeric values.

Preview 03:20

You can hide a row or column by using the Hide command, or by changing the row height or column width to 0 (zero). You can display either again by using the Unhide command.

You can unhide specific rows and columns, or you can unhide all hidden rows and columns at the same time. If you hide the first row or column in a worksheet, you follow a different process, and you'll find that in the last section of the lecture.

How to hide/unhide columns?
02:34

Whenever you're working with a lot of data, it can be difficult to compare information in your workbook. Fortunately, Excel includes several tools that make it easier to view content from different parts of your workbook at the same time, such as the ability to freezepanes and split your worksheet.

Freeze Panes
02:01

You can use the Move or Copy Sheet command to move or copy entire worksheets (also known as sheets), to other locations in the same or a different workbook. You can use the Cut and Copy commands to move or copy a portion of the data to other worksheets or workbooks.

Move or copy worksheet/workbook
03:01

If you're not very familiar with Microsoft Excel, it might seem an intimidating program to use. Fortunately, it's easy to get started. You can type in data, copy and paste it from other documents, and format it with just a few clicks. With a little practice, you'll be able to quickly enter, edit and manage data in Microsoft Excel.

Adding and Editing Data
03:54

If you want to change the way data appears in a cell, you can rotate the font angle or change the data alignment

Merge cells and align data
04:20

This tutorial explains the basics of the Excel number format and provides the detailed guidance to create custom formatting. You will learn how to show the required number of decimal places, change alignment or font color, display a currency symbol, round numbers by thousands, show leading zeros, and much more.

Format number cells
02:18

Use the Format Painter to quickly copy formatting from one thing in a document to another. Just select the thing you like the look of, click Format Painter, and then click the thing you want to change to look the same. Format Painter picks up all the formatting from your first thing, whether it’s a shape, cell, picture border, or piece of text, and applies it to the second. The steps and options vary slightly depending on which app you're using. 

Copy format cells
02:24
About the Instructor
Jasleen Chadha
0.0 Average rating
0 Reviews
1 Student
1 Course
Instructor at Udemy

Hi guys, My name is Jasleen Chadha. I am trained in basic and advanced excel,VBA Macros, SQL , Access, SAS and R programming language and many more to come. I take the classes at home. This is my first tutorial in udemy. I am passionate about working with new software and mostly with data sets. At any point of time, anyone can get help from me with any data sets. In case you have any other video suggestion or requests put that in the suggestions.