Advanced Spreadsheets
170 views | +0 today
Follow
Advanced Spreadsheets
Useful videos for IT in Business Advanced Spreadsheets
Curated by janice bayne
Your new post is loading...
Your new post is loading...
Scooped by janice bayne
Scoop.it!

Excel 2013 PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013

Download file: http://people.highline.edu/mgirvin/excelisfun.htm Scroll to down to PowerPivot Section. Basics of PowerPivot: Why PowerPivot?, Add to Dat
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

How to protect areas of an Excel Workseet

How to protect areas of an Excel Workseet | Advanced Spreadsheets | Scoop.it
When sharing workbooks with others however, you may in certain instances need to protect areas of your Excel worksheet. Here's how.
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Juan Enriquez: Your online life, permanent as a tattoo

What if Andy Warhol had it wrong, and instead of being famous for 15 minutes, we're only anonymous for that long? In this short talk, Juan Enriquez looks a
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Excel - Time Series Forecasting - Part 1 of 3

Part 2: http://www.youtube.com/watch?v=5C012eMSeIU&feature=youtu.be Part 3: http://www.youtube.com/watch?v=kcfiu-f88JQ&feature=youtu.be This is Part 1 of a 3...
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Excel tutorial: Present value (PV) in excel 2010

Download excel file: http://codible.com/pages/58 Present value (PV) function lets you calculate the present discounted value of a series of future cash flows...
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Excel 2007-2010 Future Value Formula (Investingments).mov

This vide demonstates Microsoft Excel's future value fomrula. This is the formula we would use to calculate the future value of an investment for which we ha...
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Create a one dimensional pivot table report in Excel

Create a one dimensional pivot table report in Excel | Advanced Spreadsheets | Scoop.it
Create a one dimensional pivot table report from a table
janice bayne's insight:

This uses a table which we rarely do but it is still really useful.

more...
No comment yet.
Scooped by janice bayne
Scoop.it!

The Goal Seek function in Excel 2007

This is a short, three minute presentation showing you the Goal Seek function in Excel 2007. This video is for evaluation purposes only, and should not be us...
janice bayne's insight:

Use this with my level 8 class

more...
No comment yet.
Rescooped by janice bayne from EdTech Tools
Scoop.it!

How to Use Excel's VLOOKUP Function

How to Use Excel's VLOOKUP Function | Advanced Spreadsheets | Scoop.it
Excel's VLOOKUP function is an extremely useful tool, and learning how to use it is easier than you think!

Via Patty Ball
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Webinar: Understanding the Excel Data Model - Office Blogs

Webinar: Understanding the Excel Data Model - Office Blogs | Advanced Spreadsheets | Scoop.it
The Excel Data Model is revolutionizing how you can work with data in Excel. In this webinar, guest host Owen Duncan teaches us how Excel Data Models provide lightning fast data analysis and visualizations. Need a 30-second sneak peek? Here’s a 30-second trailer perfect for sharing in social media. What you will learn What an Excel Data Model is How to get data into a Data Model How to create relationships…
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012 - YouTube

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional Development...
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Excel 2007-2010 Goal Seek (Reaching Your Retirement Goals).mov

This video demonstrates Microsoft Excel's Goal seek tool. This is the tool that is used to dynamically change a variable in a formula to result in a desired ...
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional Development...
janice bayne's insight:

I love this but it is a bit too long for my students

more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Excel 2010 & 2007 FREE tutorial video course used by over 2 million students

Excel 2010 & 2007 FREE tutorial video course used by over 2 million students | Advanced Spreadsheets | Scoop.it
Excel 2010 & 2007 FREE tutorial video course used by over 2 million students
more...
No comment yet.
Scooped by janice bayne
Scoop.it!

Scenarios.avi

Basic lesson on increasing income of one specific source of income by 1%, 2% and 3% to see the changes in the Total Income.
more...
No comment yet.