Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel: 2015 to 2016 Edition
Rating: 3.9 out of 5(345 ratings)
9,127 students

Excel: 2015 to 2016 Edition

The ultimate excel survival guide
Created byAndrew Magdy Kamal, Rucha Prabhune
Last updated 11/2015
English
English [Auto],

What you'll learn

  • Learn about Excel's interface
  • Learn how to use Excel for Finance Sheets
  • Learn the fundamentals of Microsoft Excel

Course content

1 section • 5 lectures • 31m total length

  • Excel Part 015:02

    Explore the basic Microsoft Excel interface, including the ribbon, office and save buttons, undo/redo, formula bar, and sheet management to organize text, numbers, and dates.

  • Excel Part 027:29

    Learn to organize data in Excel by filling columns and rows, aligning and formatting with borders; build an itemized budget, sum expenses with formulas, and convert currencies.

  • Excel Part 034:15

    Explore how to use Excel’s auto fill and sum functions to build a month-by-month budget, categorize expenses (grocery, gas, transport, food, leisure, miscellaneous), and format results as currency.

  • Excel Part 047:13

    Learn to perform simple calculations in Excel, including maximum, minimum, average, and count for October, using correct ranges and formulas, and convert currency to general data.

  • Excel Part 057:16

    Learn to beautify Excel tables with styles, apply conditional formatting to highlight data, and use formulas to calculate age differences and convert results to percent for clearer insights.

Requirements

  • You will need Excel 2015 or 16.

Description

Excel is a complex software that doesn't have to be! This course teaches the basics of Excel's interface in easy to understand tutorials. Perfect for all finance and accounting students, or those who want to manage a mailing list. The lectures are divided into 5 parts and made easy to follow, with high quality videos as well as HD sound. When done with the course you should know the fairly basics, such as: setting up pivot tables, the sum button, Excel's interface, entering data, etc. I promise this is one of the most introductory, yet organized Excel courses you can take.

Who this course is for:

  • Finance and Accounting Students
  • Linear programmers and Web Designers
  • Statistics students

Report abuse