Advanced MS Excel 2010 Videos Tutorial

As we know excel gives benefit to all fields and improve quality of data and simplify of analyzing data
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.
382 students enrolled
$20
Take This Course
  • Lectures 102
  • Contents Video: 18.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2015 English

Course Description

In Advanced MS Excel 2010 Video Tutorial, I will demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel.

You can also visualize data and get new insights into your information with Excel's charts and graphs. Learn how to create and modify charts, graphs, tables, and SmartArt to enhance your spreadsheets or other Office documents. This course covers all of the essential features needed to get up and running with these valuable Excel tools.

The IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios.

This tutorial has been designed for computer users who are willing to learn Microsfot Excel in simple steps and they do not have much knowledge about computer usage and Microsoft applications. This tutorial will give you enough understanding on MS Excel from where you can take yourself at higher level of expertise.

What are the requirements?

  • Basic Internet Knowledge
  • Basic Math Calculation

What am I going to get from this course?

  • To make you awesome in MS Excel
  • Over 80 lectures and 20 hours of content!
  • Get solid understanding of the more powerful features and functions in Excel
  • Learn to Use Excel in a Professional Environment
  • Learn Excel basics from Scratch using an Excel Case Study Approach

What is the target audience?

  • Users with no knowledge of Excel can also take this course
  • Students and Professionals

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started With This Excel Course
Intro To Excel_ Ribbons, QAT, Worksheets, Workbooks, Calculations
Preview
18:53
Formulas In Excel
Preview
11:36
Stylistic and Number Formatting
Preview
10:46
Range Functions Rule!
Preview
02:49
Don't Get Tricked By Number Formatting (number Formatting As Façade)
15:27
Math Order Of Operations & Formulas In Excel
05:55
How To Search For And Use Excel Functions
10:15
Relative And Absolute Cell References And Fill Handle And Angry Rabbit
14:18
Summarize Formula Inputs, Formulas & Stylistic Number Formatting
06:39
Writing Numbers As Words For Checks
09:14
Section 2: Round By Hand & Amazing Round Function!
Round By Hand & Amazing Round Function! PART - 1
14:07
Round By Hand & Amazing Round Function! PART - 2
14:06
Adding And Subtracting In Excel
12:36
Multiplying And Dividing In Excel
10:48
Exponents In Excel Formulas And Formatting
03:13
Word Application Math Problems In Excel -- 3 Step Method PART - 1
13:33
Word Application Math Problems In Excel -- 3 Step Method PART - 2
13:31
Solve Math Word Problem # 2
11:17
Fractions Types Of Fractions & Fraction Number Formatting
17:52
Reducing Fractions Factors, Products, Prime Numbers PART - 1
11:47
Reducing Fractions Factors, Products, Prime Numbers PART - 2
11:46
Mixed Number To Improper Fraction, Improper Fraction To Mixed Number
07:06
How To Display Fraction That Is Not Reduced
02:09
Convert Decimal To Fraction & Convert Fraction To Decimal
15:18
Adding & Subtracting Fractions Lest Common Denominator Lcm Function PART - 1
13:00
Adding & Subtracting Fractions Lest Common Denominator Lcm Function PART - 2
13:00
Adding & Subtracting Fractions Lest Common Denominator Lcm Function PART - 3
12:59
Fraction Business Math Word Application Problem
14:39
Cancelling Units In Fractions
03:45
Excel Percent Basics
16:47
Percent Conversions By Hand And In Excel PART - 1
Preview
16:11
Percent Conversions By Hand And In Excel PART - 2
Preview
16:07
Rounding Percentages
04:44
Part = Percent Base Solve For Part (PART - 1)
11:47
Part = Percent Base Solve For Part (PART - 2)
11:44
Base = Part Rate Solve For Base (PART - 1)
12:28
Base = Part Rate Solve For Base (PART - 2)
12:26
Rate = Part Base
17:01
Fractional Percentages To Decimals
11:10
Increase Decrease Problems & Rate Of Change 12 Formulas PART - 1
14:47
Increase Decrease Problems & Rate Of Change 12 Formulas PART - 2
14:47
Increase Decrease Problems & Rate Of Change 12 Formulas PART - 3
14:40
Rate Of Change Word Problem
13:00
Markup And Markdown Calculations
03:36
Begin Amount = (amount Of Change) (rate Of Change)
13:37
Memorization Trick For Percentage Math Problems
08:27
Calculating Checking Fees
03:29
Vlookup To Calculating Checking Fees
11:09
Create Checkbook Register In Excel Using If Function
15:36
Calculating Credit Card Fees
07:21
Bank Reconciliation PART - 1
10:47
Bank Reconciliation PART - 2
10:38
Excel Time Number Formatting & Excel Time Math
17:34
Payroll Time Sheets, If Function For Overtime &gross Pay Calculations
19:53
Overtime Calculations 4 Examples
12:35
Calculating Equivalent Earnings For Different Pay Periods
13:52
Incentive Pay Piece Work
02:12
Section 3: Incentive Pay Variable Piece Work Rates
Incentive Pay Variable Piece Work Rates
13:16
Piecework With A Guaranteed Hourly Wage, Max Function
02:41
Overtime Earnings For Piecework (incentive Pay)
01:29
Commission Rates As Incentive Pay, Calculate Commission On Sales
02:41
Variable Commission Rates, Multiple Step Method
12:34
Calculate Gross Pay For Salary And Commissions
01:08
Calculate Social Security And Medicare Deductions
16:16
Federal Income Tax Deduction Wage Bracket Method
08:01
Federal Income Tax Deduction Percentage Method
14:27
Calculating Single Trade Discounts And Net Cost (wholesale Cost)
12:29
Calculating Series Trade Discounts, Net Cost Equivalent, Net Cost
13:12
Shipping Terms
03:08
Sales Tax On Invoices Retail And Wholesale
04:15
Create An Invoice In Excel
17:15
Single Cost Equivalent & Solving For List Price
08:45
Date Math For Invoices
08:35
Calculate Cash Discounts Using Ordinary Dating Method
17:12
Calculating Cash Discounts Eom, Rog, Extra, Boolean Math Formulas PART - 1
Preview
10:51
Calculating Cash Discounts Eom, Rog, Extra, Boolean Math Formulas PART - 2
Preview
10:44
Partial Payments Cash Discounts, Credit Applied & Remaining Balances
07:16
Basic Markup Formula
14:41
Markup On Cost PART - 1
11:54
Markup On Cost PART - 2
11:48
Markup On Sell Price PART - 1
11:22
Markup On Sell Price PART - 2
11:15
Sell Price For Perishable Goods (2nd Example)
05:37
Convert % Markup On Cost To % Markup On Sell Price & Visa Versa
08:14
Formula To Convert Invoice Costs To Sell Price
04:58
Interest On Debt.
07:08
Basic Simple Interest Calculations
05:31
Calculating Fraction Of Year For Simple Interest Calculations
08:45
Simple Interest Calculating Interest, Maturity Value & Maturity Date
11:16
Simple Interest Solve For Principal
08:48
Simple Interest Solve For Rate
06:05
Simple Interest Solve For Time
08:45
Simple Discount Notes Or Interest In Advance Notes
15:40
Compare Simple & Compound Interest & Future Value Calculations PART - 1
10:47
Compare Simple & Compound Interest & Future Value Calculations PART - 2
10:44
Fv Function For Future Value Calculations 5 Examples
16:31
Calculating Interest & Future Value For Bank Daily Interest Accounts
12:36

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Howard Simpson, Designer and Web Developer

Hello! I’m Howard Simpson, a 25-year-old Electrical & Electronics Engineer, Computer expert, Blogger.

As an Electrical & Electronics Engineer, I have done several simulations and hardware projects. To name a few,

“Portable heart beat calculator” in 2008

“MPPT based solar charge controller” in 2010

"Hybrid & Intelligent Power Supply Unit for PCs" in 2012

Moreover, I helped several students in their projects to write coding for micro-controllers. My areas of interest are 'Applied electronics' and 'Micro-controllers programming and interfacing'.

As a Computer expert, I help people to troubleshoot software issues, repair / replace hardware issues by themselves and to use simple softwares for complex tasks. I’m doing this across oceans from my home using Chrome remote desktop.

As a Blogger I help my followers to manage WordPress blogs, optimize SEO, design logos, create animations, customize the look of their themes, secure their websites and ultimately to monetize them.

As a Chartered Accountant, I have been presenting so many mind-blowing presentations. They used to speak for themselves and that’s my secret of keeping my audience engaged. I'm specialized in 'Financial Management' and 'Indian Taxation'.

Above all I’m a teacher of examples. My teaching style is, breaking-down complex concepts through simple examples and animations. I go deep in whatever I learn & whatever I teach. I derive immense satisfaction in teaching the concepts, I'm expert in.

That’s why, my students call me a VERSATILE teacher! For my consistent support to my students in Udemy, I got "Lightening responder" badge.

Ready to start learning?
Take This Course