Advanced MS Excel 2010 Videos Tutorial
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.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world 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 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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Started With This Excel Course|
Intro To Excel_ Ribbons, QAT, Worksheets, Workbooks, CalculationsPreview
Formulas In ExcelPreview
Stylistic and Number FormattingPreview
Range Functions Rule!Preview
Don't Get Tricked By Number Formatting (number Formatting As Façade)
Math Order Of Operations & Formulas In Excel
How To Search For And Use Excel Functions
Relative And Absolute Cell References And Fill Handle And Angry Rabbit
Summarize Formula Inputs, Formulas & Stylistic Number Formatting
Writing Numbers As Words For Checks
|Section 2: Round By Hand & Amazing Round Function!|
Round By Hand & Amazing Round Function! PART - 1
Round By Hand & Amazing Round Function! PART - 2
Adding And Subtracting In Excel
Multiplying And Dividing In Excel
Exponents In Excel Formulas And Formatting
Word Application Math Problems In Excel -- 3 Step Method PART - 1
Word Application Math Problems In Excel -- 3 Step Method PART - 2
Solve Math Word Problem # 2
Fractions Types Of Fractions & Fraction Number Formatting
Reducing Fractions Factors, Products, Prime Numbers PART - 1
Reducing Fractions Factors, Products, Prime Numbers PART - 2
Mixed Number To Improper Fraction, Improper Fraction To Mixed Number
How To Display Fraction That Is Not Reduced
Convert Decimal To Fraction & Convert Fraction To Decimal
Adding & Subtracting Fractions Lest Common Denominator Lcm Function PART - 1
Adding & Subtracting Fractions Lest Common Denominator Lcm Function PART - 2
Adding & Subtracting Fractions Lest Common Denominator Lcm Function PART - 3
Fraction Business Math Word Application Problem
Cancelling Units In Fractions
Excel Percent Basics
Percent Conversions By Hand And In Excel PART - 1Preview
Percent Conversions By Hand And In Excel PART - 2Preview
Part = Percent Base Solve For Part (PART - 1)
Part = Percent Base Solve For Part (PART - 2)
Base = Part Rate Solve For Base (PART - 1)
Base = Part Rate Solve For Base (PART - 2)
Rate = Part Base
Fractional Percentages To Decimals
Increase Decrease Problems & Rate Of Change 12 Formulas PART - 1
Increase Decrease Problems & Rate Of Change 12 Formulas PART - 2
Increase Decrease Problems & Rate Of Change 12 Formulas PART - 3
Rate Of Change Word Problem
Markup And Markdown Calculations
Begin Amount = (amount Of Change) (rate Of Change)
Memorization Trick For Percentage Math Problems
Calculating Checking Fees
Vlookup To Calculating Checking Fees
Create Checkbook Register In Excel Using If Function
Calculating Credit Card Fees
Bank Reconciliation PART - 1
Bank Reconciliation PART - 2
Excel Time Number Formatting & Excel Time Math
Payroll Time Sheets, If Function For Overtime &gross Pay Calculations
Overtime Calculations 4 Examples
Calculating Equivalent Earnings For Different Pay Periods
Incentive Pay Piece Work
|Section 3: Incentive Pay Variable Piece Work Rates|
Incentive Pay Variable Piece Work Rates
Piecework With A Guaranteed Hourly Wage, Max Function
Overtime Earnings For Piecework (incentive Pay)
Commission Rates As Incentive Pay, Calculate Commission On Sales
Variable Commission Rates, Multiple Step Method
Calculate Gross Pay For Salary And Commissions
Calculate Social Security And Medicare Deductions
Federal Income Tax Deduction Wage Bracket Method
Federal Income Tax Deduction Percentage Method
Calculating Single Trade Discounts And Net Cost (wholesale Cost)
Calculating Series Trade Discounts, Net Cost Equivalent, Net Cost
Sales Tax On Invoices Retail And Wholesale
Create An Invoice In Excel
Single Cost Equivalent & Solving For List Price
Date Math For Invoices
Calculate Cash Discounts Using Ordinary Dating Method
Calculating Cash Discounts Eom, Rog, Extra, Boolean Math Formulas PART - 1Preview
Calculating Cash Discounts Eom, Rog, Extra, Boolean Math Formulas PART - 2Preview
Partial Payments Cash Discounts, Credit Applied & Remaining Balances
Basic Markup Formula
Markup On Cost PART - 1
Markup On Cost PART - 2
Markup On Sell Price PART - 1
Markup On Sell Price PART - 2
Sell Price For Perishable Goods (2nd Example)
Convert % Markup On Cost To % Markup On Sell Price & Visa Versa
Formula To Convert Invoice Costs To Sell Price
Interest On Debt.
Basic Simple Interest Calculations
Calculating Fraction Of Year For Simple Interest Calculations
Simple Interest Calculating Interest, Maturity Value & Maturity Date
Simple Interest Solve For Principal
Simple Interest Solve For Rate
Simple Interest Solve For Time
Simple Discount Notes Or Interest In Advance Notes
Compare Simple & Compound Interest & Future Value Calculations PART - 1
Compare Simple & Compound Interest & Future Value Calculations PART - 2
Fv Function For Future Value Calculations 5 Examples
Calculating Interest & Future Value For Bank Daily Interest Accounts
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.