Tag Archives: data

Excel 2010 Statistics 09: Proportions, Probabilities and Percentages: Formulas and Formatting

Posted on December 23, 2011 by admin

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Learn about Proportions, Probabilities and Percentages: Formulas and Formatting. 2. See the COUNTIF function and Relative and Absolute Cell References for counting with 1 criteria 3. See how to create a Basic Frequency Table with Qualitative … Continue reading →

Posted in Learn Basic Excel | Tagged 2010, 210, Absolute, analysis, AND, Basic, business, Busn, cell, College, Community, COUNTIF, counting, criteria, data, Dragons, Economics, excel, excelisfun, for, Format, Formatting, formulas, FREQUENCY, function, Gel, Girvin, Highline, Including, Mike, Number, Percentages, Probabilities, Proportions, Qualitative, References, Relative, Slaying, Statistical, Statistics, table, with | 4 Comments

Excel Formatting 101 for Mac

Posted on December 22, 2011 by admin

Learn basic tips for making your data look sexy using Excel for Macs! This tutorial includes how to format as a table, format cells, remove gridlines, and use text and number filters. Duration : 0:10:19 Technorati Tags: analytics, data, excel, … Continue reading →

Posted in Learn Basic Excel | Tagged analytics, data, excel, how to, mac, Microsoft Office, spreadsheets, tips, tutorial | 1 Comment

Refer to an Excel Table Field When Writing Formulas

Posted on December 12, 2011 by admin

If you are using either Excel 2007 or Excel 2010, I encourage you to “format your data range” as an Excel Table. When you do this you can take advantage of several Table Tools: 1) The range references for the … Continue reading →

Posted in Learn Excel Formulas | Tagged business, cell, data, Educational, excel, formulas, functions, in, information, management, Microsoft Excel, Microsoft Office, named, office, range, software, Software Tutorial, tables, technology, training, tutorial | 2 Comments

Use the SumIf and SumIfs Functions in Excel to Analyze Accounts Receivable Status Report

Posted on December 10, 2011 by admin

Watch, as I use both the SUMIF and the (new) SUMIFS functions to analyze an Accounts Receivable Status Report. With the SumIf Function in Excel, you only sum the cells in a range that match the condition that you set. … Continue reading →

Posted in Learn Excel Formulas | Tagged analysis, business, computer software, computers, data, economic, Educational, excel functions, finance, financial, Help, how to, information, instructions, management, Microsoft Excel, New in Excel 2007, office, programs, software, Software Tutorial, SUMIFS Function, Systems, technology, tips, training, tutorial | 4 Comments

How to Work with Array Formulas in Excel

Posted on December 8, 2011 by admin

With an Array Formula, you can frequently create formulas quicker because you can eliminate several intermediate calculations. I begin my introduction to Array Formulas by showing you how to use the SUMPRODUCT Function. Next, I show you two examples of … Continue reading →

Posted in Learn Excel Formulas | Tagged array formulas, business, CSE Formulas in Excel, data, excel, Formula Error Messages, information, management, mobile device, office, software, Software Tutorial, SUMPRODUCT Function, technology, training, work | 2 Comments

Excel Automation From MS Access Using VBA – Showing formating, charting and trends

Posted on November 26, 2011 by admin

I am available for consulting. Call 510-473-2492 10 am to 10 pm Pacific time or eMail via YouTube for more details. This example uses MS Access to launch Excel, create a workbook, add worksheets, format worksheets, write data and add … Continue reading →

Posted in Learn Excel Macros | Tagged 2000, 2007, Access, analysis, automation, call, Center, Chart, charting, charts, data, database, DB, excel, Microsoft, ms, office, OLE, spreadsheet, trending, vba, xp | 6 Comments

Microsoft Excel Repeat (REPT) Function Tutorial

Posted on November 16, 2011 by admin

Visit MotionTraining at http://www.motiontrainingweb.com A look at the Repeat (REPT) function in Microsoft Excel. This tutorial waa made with Excel 2000 but it works just the same in Excel 2003 & 2007 versions. Hope you find it useful! Duration : … Continue reading →

Posted in Learn Excel Formulas | Tagged data, Educational, excel, function, Guide, Help, howto, instructions, Microsoft, ms, Repeat, REPT, software, spreadsheet, technology, tips, tricks, tutorial | 21 Comments

Excel VBA tutorial 25 Arrays.flv

Posted on November 12, 2011 by admin

How to declare and reference elements of an array Duration : 0:9:18 Technorati Tags: business, computer, customer, data, design, excel, information, Macro, management, none, office, software, solutions, system, Systems, technology, training, tutorial, using, vba

Posted in Learn Excel Macros | Tagged business, computer, customer, data, design, excel, information, Macro, management, none, office, software, solutions, system, Systems, technology, training, tutorial, using, vba | 1 Comment

Goal Seek – Function in Excel

Posted on November 11, 2011 by admin

http://www.TeachMsOffice.com How to use the goal seek function in excel. Includes example of income statement with sales. Duration : 0:3:21 Technorati Tags: analysis, data, excel, formula, function, goal, income, Seek, statement

Posted in Learn Excel Formulas | Tagged analysis, data, excel, formula, function, goal, income, Seek, statement | Leave a comment

Microsoft Excel Tutorial for Beginners #3 – Calculations (Formulas)

Posted on October 31, 2011 by admin

Visit MotionTraining at http://www.motiontrainingweb.com Tutorial #3 introduces calculations and explains the basic mathematical operators in Microsoft Excel. Duration : 0:8:39 Technorati Tags: Beginners, calculations, cell, computer, data, excel, formula, function, Guide, Help, Microsoft, Microsoft Excel, ms, Reference, software, spreadsheet, technology, … Continue reading →

Posted in Learn Excel Formulas | Tagged Beginners, calculations, cell, computer, data, excel, formula, function, Guide, Help, Microsoft, Microsoft Excel, ms, Reference, software, spreadsheet, technology, tips, tricks, tutorial | 25 Comments