Tag Archives: formula

Functions Formulas in Excel 10 – Formula Auditing – Find Out Which Cells are Used in Your Formulas

Posted on December 31, 2011 by admin

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Excel video tutorial about formula auditing in Excel and finding out what formulas point to what cells in a worksheet. Specifically this tutorial talks about tracing precedents and dependents in … Continue reading →

Posted in Learn Excel Formulas | Tagged arrows, auditing, dependents, errors, excel, formula, Help, precedents, trace, troubleshooting, workbooks, worksheets | 1 Comment

Excel Magic Trick #126: Macro: Advanced Filter Extract Text

Posted on December 16, 2011 by admin

See how to create a macro that will do an Advanced Filter Movie Title Extract for a Movie Database. See how to create the TRUE FALSE formula for advanced filter before creating a Macro and then adding the Macro to … Continue reading →

Posted in Learn Excel Macros | Tagged Advanced, button, College, Community, excel, Extract, FALSE, filter, formula, Gel, Girvin, Highline, Macro, Mike, text, TRUE | 21 Comments

Excel Formulas solved for you

Posted on December 14, 2011 by admin

Unearth the potential of Excel: At http://www.excel-formulas.com.au you will find the solution to your Excel-Formula problem and much more. Call Jürgen on 1300 66 46 55 to chat about your Excel-issues and get a quote on solving them. Duration : … Continue reading →

Posted in Learn Excel Formulas | Tagged excel formulas, formula, Microsoft Excel | Leave a comment

Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Posted on December 1, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. DAY function 2. TEXT Function to get Day spelled out, like “Monday” 3. TEXT Function to get Month spelled out, like “January” 4. MONTH Function 5. YEAR function 6. Last Day in Month: EOMONTH function 7. … Continue reading →

Posted in Learn Excel Formulas | Tagged .net, 2007, 2010, between, College, Community, Date, Dates, DAY, Days, Dragons, EDATE, excel, excelisfun, first, for, formula, functions, Gel, Girvin, Highline, in, Inclusive, last, Mike, Month, NETWORKINGDAYS, next, Slaying, text, Two, Vest, WEEKDAY, with, Working, Year | 2 Comments

Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Row

Posted on December 1, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Create Logical Formula for Conditional Formatting to highlight the lowest smallest value in the row using the MIN function and Mixed Cell References. 2. Create Logical Formula for Conditional Formatting to highlight the largest biggest value … Continue reading →

Posted in Learn Excel Formulas | Tagged 2007, 2010, AND, biggest, cell, College, Community, conditional, Create, Dragons, excel, excelisfun, for, Format, Formatting, formula, function, functions, Gel, Girvin, Highlight, Highline, how, in, large, Largest, Logical, lowest, Max, Mike, Min, mixed, OR, References, row, See, Slaying, SMALL, smallest, the, to, Top, using, value, values | 2 Comments

Linking Data from Different Excel Sheets and Workbooks

Posted on November 27, 2011 by admin

This video shows how to link data from different sheets and even different workbooks in Excel. It shows the linking notation and how to go about linking without having to write the cell reference by hand. It also shows a … Continue reading →

Posted in Learn Excel Formulas | Tagged computers, excel, formula, formulas, Guide, howto, technology, tutorial | Leave a comment

Excel 2010 Business Math 67: Basic Markup Formula

Posted on November 21, 2011 by admin

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm This is a Business Mathematics Class (Busn Math 135) taught by Mike excelisfun Girvin at Highline Community College. In this video learn how to calculate: 1. Basic Markup Formula 2. Introduction to Markup On Cost 3. Introduction … Continue reading →

Posted in Learn Basic Excel | Tagged 2010, Basic, business, College, Community, Cost, Dragons, excel, excelisfun, formula, Girvin, Highline, introduction, Markup, math, mathematics, Mike, on, Price, Sell, Slaying, to | Leave a comment

Excel Formula Basics: Sumif, Countif, Averageif

Posted on November 17, 2011 by admin

Free articles on learning Excel. Visit http://www.launchexcel.com/ Sumif, Countif and Averageif help you to analyse data in a list that matches the conditions you specify. Named ranges make it simpler to read formulas and easily enter large ranges. Together they … Continue reading →

Posted in Learn Excel Formulas | Tagged AVERAGEIF, computers, COUNTIF, create name from selection, Educational, excel, Excel 2010, Fast, formula, formulas, functions, howto, instructions, map, mind, name manager, named range, Quick, remove duplicates, Software Tutorial, summit, tip, tips & tricks, tutorial | Leave a comment

Excel OR() Function – ExcelVBASql.com 25+ hours of FREE training!

Posted on November 11, 2011 by admin

www.ExcelVBASql.com Duration : 0:23:42 Technorati Tags: Absolute, AND, auto, bar, buttons, cell, column, Copy, cut, drag, excel, Fill, formula, function, functions, Help, interface, Is, keys, Lessons, logincal, Microsoft, ms, Names, OR, past, Reference, Relative, Ribbon, row, shortcut, Special, spreadsheets, status, … Continue reading →

Posted in Learn Excel Formulas | Tagged Absolute, AND, auto, bar, buttons, cell, column, Copy, cut, drag, excel, Fill, formula, function, functions, Help, interface, Is, keys, Lessons, logincal, Microsoft, ms, Names, OR, past, Reference, Relative, Ribbon, row, shortcut, Special, spreadsheets, status, tutorial | Leave a comment

Goal Seek – Function in Excel