## Advance Excel Online Training Classes Day-1 Basic Knowledge

About this tutorial: Video duration: 27:52 A K SOFTWARES AND SERVICES 43/1, 1ST FLOOR, MAIN EAST AZAD NAGAR, KRISHNA NAGAR, DELHI-110051 Mob – 9310221060, 8750221060, 9136018988, Phone – 011-22007066-22005052 E-mail- aksoftware01@gmail.com Wabsite – www.busyak.in

## BUSY 3

About this tutorial: Video duration: 21:32 A K SOFTWARES AND SERVICES 43/1, 1ST FLOOR, MAIN EAST AZAD NAGAR, KRISHNA NAGAR, DELHI-110051 Mob – 9310221060, 8750221060, 9136018988, Phone – 011-22007066-22005052 E-mail- aksoftware01@gmail.com Wabsite – www.busyak.in

## Macworld Boston 1997-The Microsoft Deal

About this tutorial: Video duration: 12:6 Here we see Steve Jobs & the almost bankrupt at the time Apple Computer making a temporary deal with Bill Gates & Microsoft. The crowd was not too happy about it.

## Mr Excel & excelisfun Trick #4: Comparative Charts

About this tutorial: Video duration: 8:29 See Mr Excel and excelisfun create charts to compare data values: 1) Bar Chart 2) Stacked Column Chart 3) Trendline to predict future data values MrExcel’s Learn Excel #985 – Dueling: Chart Types Excel Basics Chart Basics Highline Excel Class 05: Charts, Page Setup, Data Analysis

## Mr Excel & excelisfun Trick 13: AVERAGE without Zeroes

About this tutorial: Video duration: 5:12 See Mr Excel and excelisfun create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set. See the functions SUM, COUNTIF, AVERAGE / IF array formula and the AVERAGEIF new Excel 2007 function. Also see Mr Excel use Fine and Replace to complete two amazing […]

## Mr Excel & excelisfun Trick 14: Trending Up Down Arrows

About this tutorial: Video duration: 7:29 See Mr Excel and excelisfun create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers. See functions like: SIGN, IF, and CHAR. Related videos: Dueling: Up/Down Symbols – 1035 – Learn Excel from MrExcel

## Mr Excel & Excelisfun Trick 95: Conditionally Format +/- 15% Change Arrows Or Logical Formula?

About this tutorial: Video duration: 7:31 Download from: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to conditionally format end stock values that have increased or decresed by plus or minus 15%. See Mr Excel use the up and down arrows available in Excel 2007 or later and see Excelisfun use TRUE/FALSE Logical Formula to format values with a change […]

## Excel Bangla tutorial Electric Bill sheet Class Lacture

About this tutorial: Video duration: 12:33 Please watch: “Microsoft word tutorial for beginners to advanced Part 1 Office Button মাইক্রোসফট ওয়ার্ড” -~-~~-~~~-~~-~- Calculating Electricity Bill in Excel Microsoft Excel Tutorial for Beginners #1 – Overview Excel 2010 Tutorial: A Complete Guide to Excel for Anyone Excel 2010 Tutorial For Beginners #1 – Overview (Microsoft Excel) […]

## Mr Excel & excelisfun Trick #6: Get Last Value In Row

About this tutorial: Video duration: 7:17 See Mr Excel and excelisfun try and retrieve the last value in a row. See the INDEX, OFFSET, LOOKUP and MAX functions. MrExcel’s Learn Excel #995 – Dueling: Last Entry in Row

## Mr Excel & excelisfun Trick 81: Extract Multiple Records Based on Two Criteria VBA or Formula

About this tutorial: Video duration: 10:21 See Mr Excel and excelisfun Extract Multiple Records Based on Two Criteria using VBA and formula. See the functions AND, SUM, VLOOKUP, ROWS, COLUMNS and more. See a non-array formula for extracting multiple records when there are two criteria. Incoming search terms:excelisfun extract rank multiples

## Mr Excel & excelisfun Trick 20: Summarize Survey Pivot Table

About this tutorial: Video duration: 10:10 See Mr Excel and excel is fun summarize survey data with a Pivot Table (Grouping & Report Filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function. Adding Counting with more than one criteria. Adding Counting with multiple criteria conditions.

## Billing Software-Demo

About this tutorial: Video duration: 8:5 Please find a sample of application for small business at http://techflames.com/techflames-products.html. For a much more refined version please download it from http://www.upskilltechnologies.com/#!excelbilling/qjr0r Here is the demo of a Billing software for small to medium sized firms. Its build on Excel to give the comfort the user to maintain his […]

## Mr Excel & excelisfun Trick 67: Extract Initials From Full Name: VBA or Formula?

About this tutorial: Video duration: 6:29 See Mr Excel and excelisfun Extract Initials From Full Name using: VBA and a Formula. See the Functions TRIM, REPLACE, LEFT, and SEARCH.