Math Student Help

Author/Educator Bill Page discusses worksheets inside the classroom and how sometimes, it’s best to just throw them out.

Duration : 0:6:57

(more…)

How to delete and rename worksheets in Microsoft Excel; learn more about spreadsheet software in this free instructional video.

Expert: Gary Zier
Bio: Gary Zier, originally from Florida, is a systems administrator with 10 years of computer networking experience and an expertise in conditional access security systems.
Filmmaker: Gary Zier

Duration : 0:1:52

(more…)

http://www.TeachExcel.com
How to protect a worksheet and workbook in excel. This will prevent unauthorized people from editing, deleting, or changing data in excel.

Follow along with the spreadsheet used here and get more stuff including templates, macros, keyboard shortcuts, etc. on the website:

http://www.TeachExcel.com

Duration : 0:7:44

(more…)

http://www.FreedomUniversity.tv/mathworksheets

This is part of a series of math videos and worksheets to ensure your successs. This video is about how to figure or calculate percentages or fractions. You can get more videos or multimedia content on other technical topics by contacting me at john@e-liteworks.com.

Duration : 0:3:16

(more…)

When I select all of the worksheets the option to password protect goes away. Is there a code? Thank you!

Try this macro. Change the password to suit, or eliminate if desired.

Open the workbook.

Copy this macro to the clipboard:

Sub Protect_All_Sheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Protect Password:="Your word"
Next ws
End Sub

Select the appropriate worksheet and right click on the sheet tab.

Click ‘View Code’.

Paste the macro into th module area to the right.

Close back to Excel.

Go to Tools > Macros > Macro

Highlight this macro, if it is not already highlighted.

Click ‘Options’

Select a letter to be used as a keyboard shortcut.

Close back to Excel.

Press Ctrl + your letter to protect all sheets.

To unprotect all sheets in the same manner, use this macro and assign a different keyboard shortcut letter.

Sub Unprotect_All_Sheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Unprotect Password:="Your word"
Next ws
End Sub

Use an apostrophe with words to show possession or when using contractions. For the word “it,” do not use an apostrophe to show possession, but do use an apostrophe if it is a contraction. Learn about using apostrophes for plural words that also express possession with information from a writer and English tutor in this free video on grammar and punctuation.

Expert: Heather Kamins
Bio: Heather Kamins has a Master of Fine Arts in creative writing from Mills College in Oakland, Calif. She has taught and tutored English composition at Mills, as well as at the College of Alameda.
Filmmaker: Dimitri LaBarge

Duration : 0:2:16

(more…)

I was wondering how much is the right amount that one should spend on worksheets available online for my own kids and for my class (I’m a teacher)? Also what should I look for before buying any such worksheets?

My recommendation would be to search around for free stuff before spending anything, as there are plenty of good, free worksheets available on the net for kids of all ages and levels that IMO are as good (if not better) than many of the materials I’ve seen offered for sale on the Internet.

If you could provide a bit more information as to the kind of stuff you are after (age/level/subject, etc) I’ll do my best to offer some pointers.

This is Excel 2003. The user will select which worksheets they want the macro to run on. I only want to run the macro once on all of the sheets that they’ve highlighted. Any ideas how to accomplish this?

Thanks!

Will your users group the sheets to run the macro on, or select them one at a time?

James asks how he can combine data from all rows of all worksheets into a single worksheet. 11 Lines of VBA code will do the trick. Episode 636 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Duration : 0:4:29

(more…)

i have several worksheets on excel in 1 file. i want to link the sum of each worksheet onto a chart showing the total amount of each. is it possible to do this if so, how?

Two ways to do this depending on what your need is.

1.) do you want the total from each sheet to be a new data series e.g. if you had three sheets and you want each total to be a separate column in a column chart

2.) do you want the totals from each sheet to be combined into one data series e.g. on a line graph you want to plot the totals from each sheet on one line.

Solutions:
1.) Multiple series of data from different sheets. This is fairly simple to do.
-Create your chart with the data from the first sheet.
-Right click on the chart and select Source Data.
-Select the Series tab.
-Click "Add" series
- In the "Values" text box (or X Values, Y values text boxes depending on the type of chart), select the data from the second sheet.
-Add a new series for each sheet
-OK

2.) Combine data from different sheets into one series.
-Make your chart with the data on the first sheet
-Click on one of the data points on the chart
-In the Formula bar, you should see something like
=SERIES(,,Sheet1!$A$10,1)
-Edit the formula to something like
=SERIES(,,Sheet1!$A$10, Sheet2!$A$10, Sheet3!$A$10,1)
-The link below better describes the Series function.