Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice realworld skills and achieve your goals.
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 indepth 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 realworld 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.
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.
Section 1: Getting Started With This Excel Course  

Lecture 1 
Intro To Excel_ Ribbons, QAT, Worksheets, Workbooks, Calculations
Preview

18:53  
Lecture 2 
Formulas In Excel
Preview

11:36  
Lecture 3 
Stylistic and Number Formatting
Preview

10:46  
Lecture 4 
Range Functions Rule!
Preview

02:49  
Lecture 5 
Don't Get Tricked By Number Formatting (number Formatting As Façade)

15:27  
Lecture 6 
Math Order Of Operations & Formulas In Excel

05:55  
Lecture 7 
How To Search For And Use Excel Functions

10:15  
Lecture 8 
Relative And Absolute Cell References And Fill Handle And Angry Rabbit

14:18  
Lecture 9 
Summarize Formula Inputs, Formulas & Stylistic Number Formatting

06:39  
Lecture 10 
Writing Numbers As Words For Checks

09:14  
Section 2: Round By Hand & Amazing Round Function!  
Lecture 11 
Round By Hand & Amazing Round Function! PART  1

14:07  
Lecture 12 
Round By Hand & Amazing Round Function! PART  2

14:06  
Lecture 13 
Adding And Subtracting In Excel

12:36  
Lecture 14 
Multiplying And Dividing In Excel

10:48  
Lecture 15 
Exponents In Excel Formulas And Formatting

03:13  
Lecture 16 
Word Application Math Problems In Excel  3 Step Method PART  1

13:33  
Lecture 17 
Word Application Math Problems In Excel  3 Step Method PART  2

13:31  
Lecture 18 
Solve Math Word Problem # 2

11:17  
Lecture 19 
Fractions Types Of Fractions & Fraction Number Formatting

17:52  
Lecture 20 
Reducing Fractions Factors, Products, Prime Numbers PART  1

11:47  
Lecture 21 
Reducing Fractions Factors, Products, Prime Numbers PART  2

11:46  
Lecture 22 
Mixed Number To Improper Fraction, Improper Fraction To Mixed Number

07:06  
Lecture 23 
How To Display Fraction That Is Not Reduced

02:09  
Lecture 24 
Convert Decimal To Fraction & Convert Fraction To Decimal

15:18  
Lecture 25 
Adding & Subtracting Fractions Lest Common Denominator Lcm Function PART  1

13:00  
Lecture 26 
Adding & Subtracting Fractions Lest Common Denominator Lcm Function PART  2

13:00  
Lecture 27 
Adding & Subtracting Fractions Lest Common Denominator Lcm Function PART  3

12:59  
Lecture 28 
Fraction Business Math Word Application Problem

14:39  
Lecture 29 
Cancelling Units In Fractions

03:45  
Lecture 30 
Excel Percent Basics

16:47  
Lecture 31 
Percent Conversions By Hand And In Excel PART  1
Preview

16:11  
Lecture 32 
Percent Conversions By Hand And In Excel PART  2
Preview

16:07  
Lecture 33 
Rounding Percentages

04:44  
Lecture 34 
Part = Percent Base Solve For Part (PART  1)

11:47  
Lecture 35 
Part = Percent Base Solve For Part (PART  2)

11:44  
Lecture 36 
Base = Part Rate Solve For Base (PART  1)

12:28  
Lecture 37 
Base = Part Rate Solve For Base (PART  2)

12:26  
Lecture 38 
Rate = Part Base

17:01  
Lecture 39 
Fractional Percentages To Decimals

11:10  
Lecture 40 
Increase Decrease Problems & Rate Of Change 12 Formulas PART  1

14:47  
Lecture 41 
Increase Decrease Problems & Rate Of Change 12 Formulas PART  2

14:47  
Lecture 42 
Increase Decrease Problems & Rate Of Change 12 Formulas PART  3

14:40  
Lecture 43 
Rate Of Change Word Problem

13:00  
Lecture 44 
Markup And Markdown Calculations

03:36  
Lecture 45 
Begin Amount = (amount Of Change) (rate Of Change)

13:37  
Lecture 46 
Memorization Trick For Percentage Math Problems

08:27  
Lecture 47 
Calculating Checking Fees

03:29  
Lecture 48 
Vlookup To Calculating Checking Fees

11:09  
Lecture 49 
Create Checkbook Register In Excel Using If Function

15:36  
Lecture 50 
Calculating Credit Card Fees

07:21  
Lecture 51 
Bank Reconciliation PART  1

10:47  
Lecture 52 
Bank Reconciliation PART  2

10:38  
Lecture 53 
Excel Time Number Formatting & Excel Time Math

17:34  
Lecture 54 
Payroll Time Sheets, If Function For Overtime &gross Pay Calculations

19:53  
Lecture 55 
Overtime Calculations 4 Examples

12:35  
Lecture 56 
Calculating Equivalent Earnings For Different Pay Periods

13:52  
Lecture 57 
Incentive Pay Piece Work

02:12  
Section 3: Incentive Pay Variable Piece Work Rates  
Lecture 58 
Incentive Pay Variable Piece Work Rates

13:16  
Lecture 59 
Piecework With A Guaranteed Hourly Wage, Max Function

02:41  
Lecture 60 
Overtime Earnings For Piecework (incentive Pay)

01:29  
Lecture 61 
Commission Rates As Incentive Pay, Calculate Commission On Sales

02:41  
Lecture 62 
Variable Commission Rates, Multiple Step Method

12:34  
Lecture 63 
Calculate Gross Pay For Salary And Commissions

01:08  
Lecture 64 
Calculate Social Security And Medicare Deductions

16:16  
Lecture 65 
Federal Income Tax Deduction Wage Bracket Method

08:01  
Lecture 66 
Federal Income Tax Deduction Percentage Method

14:27  
Lecture 67 
Calculating Single Trade Discounts And Net Cost (wholesale Cost)

12:29  
Lecture 68 
Calculating Series Trade Discounts, Net Cost Equivalent, Net Cost

13:12  
Lecture 69 
Shipping Terms

03:08  
Lecture 70 
Sales Tax On Invoices Retail And Wholesale

04:15  
Lecture 71 
Create An Invoice In Excel

17:15  
Lecture 72 
Single Cost Equivalent & Solving For List Price

08:45  
Lecture 73 
Date Math For Invoices

08:35  
Lecture 74 
Calculate Cash Discounts Using Ordinary Dating Method

17:12  
Lecture 75 
Calculating Cash Discounts Eom, Rog, Extra, Boolean Math Formulas PART  1
Preview

10:51  
Lecture 76 
Calculating Cash Discounts Eom, Rog, Extra, Boolean Math Formulas PART  2
Preview

10:44  
Lecture 77 
Partial Payments Cash Discounts, Credit Applied & Remaining Balances

07:16  
Lecture 78 
Basic Markup Formula

14:41  
Lecture 79 
Markup On Cost PART  1

11:54  
Lecture 80 
Markup On Cost PART  2

11:48  
Lecture 81 
Markup On Sell Price PART  1

11:22  
Lecture 82 
Markup On Sell Price PART  2

11:15  
Lecture 83 
Sell Price For Perishable Goods (2nd Example)

05:37  
Lecture 84 
Convert % Markup On Cost To % Markup On Sell Price & Visa Versa

08:14  
Lecture 85 
Formula To Convert Invoice Costs To Sell Price

04:58  
Lecture 86 
Interest On Debt.

07:08  
Lecture 87 
Basic Simple Interest Calculations

05:31  
Lecture 88 
Calculating Fraction Of Year For Simple Interest Calculations

08:45  
Lecture 89 
Simple Interest Calculating Interest, Maturity Value & Maturity Date

11:16  
Lecture 90 
Simple Interest Solve For Principal

08:48  
Lecture 91 
Simple Interest Solve For Rate

06:05  
Lecture 92 
Simple Interest Solve For Time

08:45  
Lecture 93 
Simple Discount Notes Or Interest In Advance Notes

15:40  
Lecture 94 
Compare Simple & Compound Interest & Future Value Calculations PART  1

10:47  
Lecture 95 
Compare Simple & Compound Interest & Future Value Calculations PART  2

10:44  
Lecture 96 
Fv Function For Future Value Calculations 5 Examples

16:31  
Lecture 97 
Calculating Interest & Future Value For Bank Daily Interest Accounts

12:36 
Hello! I’m Howard Simpson, a 25yearold 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 microcontrollers. My areas of interest are 'Applied electronics' and 'Microcontrollers 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 mindblowing 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, breakingdown 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.