Exceed expectations Tips and Traps.


72 views
Uploaded on:
Category: People / Lifestyle
Description
Right mouse click on far right bolt catch. You now get rundown of ... double tap on outline, then right mouse tap the line, bar, and so on you need to ...
Transcripts
Slide 1

Exceed expectations Tips and Tricks Jon Paul Progressive System Solutions, Inc. 847-295-7179 jpaul@mba1980.hbs.edu (Note-this was delivered in 1997 for the 97 rendition of Excel)

Slide 2

How Cold Was It? So icy I know somebody who laid down with 16 sheets on their bed!

Slide 3

Just Open 1 Sheet! Select Tools from Menu Bar Select Options Select General Sheets in new exercise manual change to 1

Slide 4

Moving Between Worksheets Find bolt catches in lower left hand side of screen Right mouse click on far right bolt catch You now get rundown of sheets If extensive number of sheets, select more sheets on the base Scroll down to discover the sheet you need Click OK-away you go!

Slide 5

Moving or Copying a Worksheet Right mouse click on worksheet name Select move or duplicate Choose an exercise manual you need to send it to chooses current exercise manual as a matter of course Select where in the exercise manual you need it Check Create a duplicate on the off chance that you need to duplicate it Otherwise you could be moving and not be expecting it!

Slide 6

Inserting or Deleting a Worksheet Right mouse click on any worksheet name in your exercise manual Select Insert Double tap on Worksheet to add a clear worksheet to your exercise manual Can utilize same system to include outline Deleting-take after same steps just select Delete as opposed to Insert-be cautious!

Slide 7

Driving With Half a Windshield Give yourself a full perspective of your worksheet One approach to demonstrate the entire width-discover Zoom box-on toolbar and therapist rate Even better way-highlight each segment in your worksheet go to Zoom box on toolbar pick Selection will naturally resize worksheet for you Just changes size of perspective, not section size

Slide 8

Your Car Has More Than One Window-So Can Your Worksheet Window menu-select New Window Gives you a second perspective of your present exercise manual Second window is not measured If about-facing to one window, ensure you are finishing off the second Windows will be distinguished by :1 or :2

Slide 9

Do You Leave Your Doors Unlocked? No But How About Your Spreadsheets Is Your Neighborhood Safe?

Slide 10

Protect Your Work! Securing a Worksheet First open cells you would prefer not to shield, for example, info cells Then from Tools menu, select Protect Worksheet Decide in the event that you need Password assurance not required if simply ensuring against information blunders Remember your secret key, or your work goes to spreadsheet paradise

Slide 11

Add the Club to Your Workbook Protect Your Whole Workbook In Tools menu, select Protection Then select Protect WorkBook Decide on the off chance that you need watchword insurance Structure-avoids adjusting structure Windows-averts opening, shutting windows

Slide 12

You "Auto" Save This One! Ever have your PC crash Ever killed your PC too rapidly And You neglected to spare your record!

Slide 13

Your Insurance-AutoSave To empower AutoSave Go to the Tools menu Select Add-ins The Add-in discourse box shows up Check AutoSave and click on OK

Slide 14

AutoSave Options AutoSave is presently in your Tools menu Go to Tools and select AutoSave The AutoSave exchange seems Select your decisions spare naturally or brief you how frequently to spare open exercise manual or all exercise manuals

Slide 15

Painting Your House With a Small Paintbrush? Exceed expectations\' Paintbrush-like a force sprayer Select scope of cells with configuration you like Click on the Paintbrush catch Click the cells you need to reformat When you discharge, cells are reformatted If you double tap on Paintbrush catch, you can choose non adjacient cells

Slide 16

Wrap That Text! Put long strings of content together conveniently in your sections without having to: Run over to the following segment Make your segment super wide Select the phone or range, (for example, segment) Go to Format menu and select Cells Go to Alignment Tab Click in Wrap Text box

Slide 17

Does Your Data Make \'Pennies\'? Does anybody have $0.50 that I can obtain for the pop machine? No, yet I may have 50 pennies.

Slide 18

Custom Formats-Adding Cents Select a cell you need to arrange From the Format menu select Cells Choose Number and after that Custom Select an organization for the number bit Go to the sort box and the right hand side For the penny image, hold Alt key and sort 0162-you see penny image on the screen For the penny name, sort a space and pennies

Slide 19

The Lawyers are Coming! © SM TM

Slide 20

Make Your Lawyer Happy! Copyright-sort ( c ) and enter

Slide 21

Your Lawyer Is Getting Happier! Supersript sort SM highlight SM in equation bar select arrangement check Superscript chop down size of text style

Slide 22

Now Your Lawyer Wants You to Train Their Staff! Trademark-much less demanding sort ( t m ) and enter no spaces inbetween

Slide 23

Come Together-Merging Text Concatenate-less demanding to use than claim Select cell where you need consolidated content Click on recipe bar or select Insert menu and afterward Function In the Function discourse, pick Text on the left side and Concatenate on the privilege

Slide 24

Concatenating Tips Remember to incorporate clear spaces inbetween things Can allude to cells or put in content, yet not at same time Can duplicate link equations Can utilize content and number results

Slide 25

It\'s Time to Concatenate Save retyping the same thing Allow for programmed redesigns Copying content where just part of the content is the same

Slide 26

If Only the Cubs Could Replace Their Lineup This Quick! Find & Replace Select Edit menu, then pick Replace

Slide 27

Replace Only What You Want To Highlight what you need to change Select Edit menu, then pick Replace Enter what you need to discover and what you need to supplant it with Decide on the off chance that you need to match case or whole cell

Slide 28

Replacing-Finishing Steps-Selective Replacement Choose alternative catch to the right Find Next-when you just need to supplant in certain cases-you control the supplanting Replace-to simply ahead and supplant after you have found a cell you need Click Find Next to locate the following case Click Replace for just those you need Click OK when done

Slide 29

Replacing-Finishing Steps-Automatic Process Use when you are certain you need to supplant each case in the territory you chose Activate by picking Replace All catch in right half of exchange box Replaces everything in the zone you pick cell, cell square, worksheet, exercise manual If you tried too hard, go to the Edit menu and select fix (or snap Ctrl + Z)

Slide 30

Replacing-Some Ways to Use When something new is noticeable all around! Replicating exercise manual, worksheet or equations and utilizing somewhere else Changing connections, content or recipes

Slide 31

Help-I Can\'t Get This Unstuck! It is safe to say that you are utilizing Superglue when customary Elmers will do?

Slide 32

Pick Your "Paste" Use the Paste Special Button To start, same stride as all out duplicate Highlight territory you need to duplicate Go to region you need to glue to Then choose glue unique one of two ways Right mouse snap or Pull down from alter menu Choose the Paste Special Option Click on OK

Slide 33

Paste Special Options Formulas Values Formats All Except Borders Transpose Arithmetic Operation Paste Link

Slide 34

They Have It In Rows, But I Want It In Columns-Transposing Changing from lines to sections Changing from segments to lines When to utilize Change design on new sheet Pull in data from an alternate design (like he has it in segments and I need it in lines!) Converting to database group

Slide 35

I Value Your Information-Paste Special-Value Option You need to catch the quality, however: needn\'t bother with the equation can\'t utilize the recipe since it won\'t work in the new spot

Slide 36

I Like Your Layout-Paste Special-Format Option You have a format you need to duplicate, yet needn\'t bother with the equations or values Particularly great if managing an entire piece of cells Consider the paintbrush catch as another approach to do this Can do with another glue uncommon choice first do the other choice, then do arrange

Slide 37

I Like Your Formula-But Where Did You Get That Layout? Utilize the Paste Special-Formula choice to simply duplicate the recipe Can then organization any way you like Great to utilize when you as of now have your configuration set up in your destination and would prefer not to override it

Slide 38

I Like Your Formula-But Don\'t Box Me In! Glue Special-All Except Borders Pastes equations and arrangements aside from the outskirts Use where you like the recipe and organizations yet have an alternate setup for fringes

Slide 39

Changing Data-We Won\'t Tell Your Boss How Easy It Is Paste Special-Operation choice Fast approach to change information naturally Add, subtract, increase or gap Usually use with the quality choice in Paste Special

Slide 40

How to Operate Put change in discrete idle cell, for example, 1.10 to duplicate by 10% Copy that latent cell Go to where you need to roll out improvements this could be an entire scope of cells Select glue unique and the operation, for example, esteem and duplicate Click on OK to complete Go back and delete the inert cell

Slide 41

How Many Kids Do You Have? We have a normal size family 2.3 children

Slide 42

Get A "Round" to This Round capacities for more important numbers 2 or 3 kids, not 2.3 children Changes to entire number so next figuring additionally bodes well at 10,000 for each child, expense is 20,000 or 30,000 Round, Roundup or Rounddown

Slide 43

Round to Your Size Round-rounds up (5-9) or down (0-4), contingent upon the digits being gathered Roundup-adjusts together, far from zero Rounddown-rounds down, more like zero How to do: = Round(calculation, decimal spots) decimal spots can be negative number substitute Roundup or Rounddown if needed

Slide 44

How Do You Eat at a Buffet? Do You Take Everything They Offer You? Talk Has It That I Do!

Slide 45

You Wouldn\'t Build a House Without These Ceiling-Round up to a closest different, (for example, 10, 25) Floor-Same thing, just now you round down to a closest various

Slide 46

You Don\'t Have to Sum Everything Either SUMIF capacity pick exactly what you need to whole Enter your criteria Click on the

Recommended
View more...