Tuesday, December 18, 2018

Photovisi - Free and Easy Collage Maker - 2017 Tutorial

Advanced Excel - Creating Pivot Tables in Excel Tutorial 2018

AutoRecover

AutoRecover

Excel automatically saves your workbooks to a temporary folder while you are working on them. If you forget to save your changes or if Excel crashes, you can restore the file using AutoRecover.

To use AutoRecover:

  1. Open Excel. If autosaved versions of a file are found, the DocumentRecovery pane will appear.
  2. Click to open an available file. The workbook will be recovered.
    The Document Recovery pane
By default, Excel autosaves every 10 minutes. If you are editing a workbook for less than 10 minutes, Excel may not create an autosaved version.
If you don't see the file you need, you can browse all autosaved files from Backstage view. Just select the File tab, click Manage Versions, then choose Recover Unsaved Workbooks.
Accessing all auto-saved files

Exporting workbooks

By default, Excel workbooks are saved in the .xlsx file type. However, there may be times when you need to use another file type, such as a PDF or Excel 97-2003 workbook. It's easy to export your workbook from Excel to a variety of file types.

To export a workbook as a PDF file:

Exporting your workbook as an Adobe Acrobat document, commonly known as a PDF file, can be especially useful if you're sharing a workbook with someone who does not have Excel. A PDF will make it possible for recipients to view but not edit the content of your workbook.
  1. Click the File tab to access Backstage view.
  2. Click Export, then select Create PDF/XPS.
    Exporting a PDF file
  3. The Save As dialog box will appear. Select the location where you want to export the workbook, enter a file name, then click Publish.
    Exporting a PDF file
By default, Excel will only export the active worksheet. If you have multiple worksheets and want to save all of them in the same PDF file, click Options in the Save As dialog box. The Options dialog box will appear. Select Entire workbook, then click OK.
Exporting the entire workbook
Whenever you export a workbook as a PDF, you'll also need to consider how your workbook data will appear on each page of the PDF, just like printinga workbook. Visit our Page Layout and Printing lesson to learn more about what to consider before exporting a workbook as a PDF.

To export a workbook to other file types:

You may also find it helpful to export your workbook to other file types, such as an Excel 97-2003 workbook if you need to share with people using an older version of Excel, or a .CSV file if you need a plain-text version of your workbook.
  1. Click the File tab to access Backstage view.
  2. Click Export, then select Change File Type.
    Clicking Change File Type
  3. Select a common file type, then click Save As.
    Choosing another file type
  4. The Save As dialog box will appear. Select the location where you want to export the workbook, enter a file name, then click Save.
    Saving as an Excel 97-2003 workbook
You can also use the Save as type: drop-down menu in the Save As dialog box to save workbooks in a variety of file types.
Using the Save As type menu to choose a file type

Sharing workbooks

Excel makes it easy to share and collaborate on workbooks using OneDrive. In the past, if you wanted to share a file with someone you could send it as an email attachment. While convenient, this system also creates multiple versions of the same file, which can be difficult to organize.
When you share a workbook from Excel, you're actually giving others access to the exact same file. This lets you and the people you share with edit the same workbook without having to keep track of multiple versions.
In order to share a workbook, it must first be saved to your OneDrive.

To share a workbook:

  1. Click the File tab to access Backstage view, then click Share.
    Clicking Share
  2. The Share pane will appear. If you have not already done so, you will be prompted to save your document to OneDrive. Note that you may need to navigate back to the Share pane after saving.
    Clicking Save to Cloud
  3. On the Share pane, if your document is saved to OneDrive, click the Share with People button.
    Clicking Share with People
  4. Excel will return to Normal view and open the Share panel on the right side of the window. From here, you can invite people to share your document, see a list of who has access to the document, and set whether they can edit or only view the document.
    The Share panel

Challenge!

  1. Open our practice workbook.
  2. Using the Save As option, create a copy of the workbook and name it Saving Practice Challenge. You can save the copy to a folder on your computer or to your OneDrive.
  3. Export the 

Excel Quick Tip: A Faster Way to Use the Fill Handle

To AutoFit column width:

To AutoFit column width:

The AutoFit feature will allow you to set a column's width to fit its content automatically.
  1. Position the mouse over the column line in the column heading so the cursor becomes a double arrow.
    autofitting the column width
  2. Double-click the mouse. The column width will be changed automatically to fit the content.
    the autofit column width
You can also AutoFit the width for several columns at the same time. Simply select the columns you want to AutoFit, then select the AutoFit Column Width command from the Format drop-down menu on the Home tab. This method can also be used for row height.
autofitting column width for multiple columns

To modify row height:

  1. Position the cur

Friday, December 14, 2018

whatever / not-matter in asl

back.gif (1674 bytes)

whatever / not-matter


WHATEVER / NOT-MATTER / REGARDLESS:



WHATEVER:
This is a sarcastic version that means "So what! I don't care. Get over it."


WHATEVER:  (Variation 3)
I'ved occasionally used this variation in jest.  (Using the pinkies tends to indicate the extreme insignificance of what is being talked about).
An educational interpreter told my wife that she sees this version being used more and more with the youth as their general sign for "whatever."




American Sign Language University ™ ASL resources by Lifeprint.com © Dr. William Vicars
back.gif (1674 bytes)

American Sign Language: "donAmerican Sign Language: "don't care"

American Sign Language: "donAmerican Sign Language: "don't care"


The sign for "don't care" starts as a somewhat flattened "O" hand shape near the nose and then changes into a into a claw hand with relatively straight fingers.

DON'T-CARE:


Memory aid: Think, "I don't give a snot." (heh)




See: DON'T MIND


Want to help support ASL University?'t care"

American Sign Language: "don't care"

American Sign Language: "don't care"


The sign for "don't care" starts as a somewhat flattened "O" hand shape near the nose and then changes into a into a claw hand with relatively straight fingers.

DON'T-CARE:


Memory aid: Think, "I don't give a snot." (heh)




See: DON'T MIND



Want to help support ASL University?

ASL University ► American Sign Language: "increase"


American Sign Language: "increase"


The "increase" sign can be used to mean such things as, "get a raise" or "gain weight."

INCREASE / get a raise / gain weight / go up:


The following sentence has two interpretations:
Interpretation 1: Have you recently gotten a raise?
Interpretation 2: Have you recently gained weight?


Note: If I were asking if someone recently gained weight, I'd also puff out my cheeks a bit while doing the "increase" sign. 

Note: The above version is NOT recommended for use with your wife.  Don't ask me how I know.

You can learn American Sign Language (ASL) online at American Sign Language University ™
ASL resources by Lifeprint.com  ©  Dr. William Vicars

Want to help support ASL University?  It's easy:  DONATE (Thanks!)
(You don't need a PayPal account. Just look for the credit card logos and click continue.)

Another way to help is to buy Dr. Bill's "Superdisk."

Dr. Bill's new iPhone "Fingerspelling Practice" app is now available!   CHECK IT OUT >

Want even more ASL resources?  Visit the "ASL Training Center!"  (Subscription Extension of ASLU)   CHECK IT OUT >

Bandwidth slow?  Check out "ASLUniversity.com" (a free mirror of Lifeprint.com less traffic, fast access)   VISIT >

 
back.gif (1674 bytes)

american Sign Language: "lose" or "lost"

merican Sign Language:  "lose" or "lost"


The right sign for "lose" or "lost" depends on your meaning.  For example: "Did you lose your keys?" uses a different sign for "lose" than the sentence, "Did you lose the game?"  See below for the different versions.

LOSE or "lost" (misplaced)
As in: "I lost my keys."



Make the sign for "more" and then turn both hands palms down while relaxing your fingers.  Pretend you were holding something between your hands and it slipped.  This sign is used when you mean the opposite of found.


LOSE as in "fail a competition, or "We LOST at the track meet."



LOSE or FAIL (animation)
In a message dated 3/29/2005 7:08:56 AM Pacific Standard Time, akarajeurs@_____ writes:
when signing "lose" as in losing a game, u have a "v" handshape go down to your palm. In the handshape's course, does it stop  and turn a little or is the trail one straight line? The animation for "lose" makes it seem as if the handshape stops then goes very quickly.
Reply:  The movement is a straight line that moves down quickly without stopping and smacks into the other hand rather strongly. Think of someone falling to the ground--splat.

Want to help support ASL University?  It's easy:  DONATE (Thanks!)
(You don't need a PayPal account. Just look for the credit card logos and click continue.)