1. Creating Your First Spreadsheet – Excel The Missing Manual [Book] – David W. Beskeen

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

At the end of each chapter, a number of activities provide reinforcement and a way for students to apply the skills the have learned. Learn more here: Microsoft Office Introductory. This is a follow up to the Microsoft Office Introductory text listed above.

It builds on the knowledge students have of each Office application and teaches more advanced features and skills. The Advanced text has the same layout with step-by-step instructions and many reinforcement opportunities.

Learn more here: Microsoft Office Advanced. These texts from Pearson Education are available in print or online and encourages student self-directed learning. The instructions include screen shot images of the Office application to help students learn unfamiliar content. After each chapter, there are activities to help reinforce what was learned – as well as electronic Bonus Chapters for even more reinforcement and skill development. It is up to you as the teacher to decide which book or resource is the best fit for you and your students.

A few things to keep in mind as you investigate are:. A great blended learning style will use textbooks, hands-on projects, lecture, online resources, and more. Skip to main content. Categories Follow Us Subscribe.

May 24th, 5 min. Bri Stauffer For nearly 10 years, Bri has focused on creating content to address the questions and concerns educators have about teaching classes, preparing students for certifications, and making the most of the AES curriculum system. This is the ribbon , and it ensures that even the geekiest Excel features are only a click or two away. To accommodate all these buttons without becoming an over-stuffed turkey, the ribbon uses tabs. You start out with seven tabs.

When you click one, you see a whole new collection of buttons Figure When you launch Excel, you start at the Home tab. Now, you have a slew of options for tasks like adjusting paper size and making a decent printout. Excel groups the buttons within a tab into smaller sections for clearer organization.

The ribbon makes it easy to find features because Excel groups related features under the same tab. Even better, once you find the button you need, you can often find other, associated commands by looking at the other buttons in the tab. The ribbon is full of craftsman-like detail. Instead, you see a friendly pop-up box with a mini-description of the feature and often a shortcut that lets you trigger the command from the keyboard. Another nice detail is the way you can jump from one tab to another at high velocity by positioning your mouse pointer over the ribbon and rolling the scroll wheel if your mouse has a scroll wheel.

Top: A large Excel window gives you plenty of room to play. The ribbon uses the space effectively, making the most important buttons bigger. Bottom: When you shrink the Excel window, the ribbon shrinks some buttons or hides their text to make room. Shrink small enough, and Excel starts to replace cramped sections with a single button, like the Alignment, Cells, and Editing sections shown here.

Click the button and the missing commands appear in a drop-down panel. Home includes some of the most commonly used buttons, like those for cutting and pasting text, formatting data, and hunting down important information with search tools. Insert lets you add special ingredients to your spreadsheets, like tables, graphics, charts, and hyperlinks. Page Layout is all about getting your worksheet ready for printing. You can tweak margins, paper orientation, and other page settings.

Formulas are mathematical instructions that perform calculations. This tab helps you build super-smart formulas and resolve mind-bending errors.

Data lets you get information from an outside data source like a heavy-duty database so you can analyze it in Excel. It also includes tools for dealing with large amounts of information, like sorting, filtering, and subgrouping data. Review includes the familiar Office proofing tools like the spell-checker. It also has buttons that let you add comments to a worksheet and manage revisions. View lets you switch on and off a variety of viewing options.

It also lets you pull off a few fancy tricks if you want to view several separate Excel spreadsheet files at the same time; see Viewing Multiple Workbooks at Once. Macro programmers and other highly technical types use the Developer tab. The Add-Ins tab appears when you open workbooks created in previous versions of Excel that use custom toolbars. Most people are happy to have the ribbon sit at the top of the Excel window, with all its buttons on hand.

To collapse it, just double-click the current tab title. Or click the tiny up-pointing icon in the top-right corner of the ribbon, right next to the help icon. Do you want to use every square inch of screen space for your cells?

You can collapse the ribbon as shown here by double-clicking any tab. Click a tab to pop it open temporarily, or double-click a tab to bring the ribbon back for good. Even if you collapse the ribbon, you can still use all its features. All you need to do is click a tab. For example, if you click Home, the Home tab pops open over your worksheet. As soon as you click the button you want in the Home tab or click a cell in your worksheet , the ribbon collapses again. The same trick works if you trigger a command in the ribbon using the keyboard, as described in the next section.

If you use the ribbon only occasionally, or if you prefer to use keyboard shortcuts, it makes sense to collapse the ribbon. Even then, you can still use the ribbon commands—it just takes an extra click to open the tab.

The trick is using keyboard accelerators , a series of keystrokes that starts with the Alt key the same key you used to use to get to a menu. Instead, you hit the keys one after the other. The trick to keyboard accelerators is understanding that once you hit the Alt key, there are two things you do, in this order:. Every accelerator requires at least two key presses after you hit the Alt key.

You need to press even more keys to dig through submenus. By now, this whole process probably seems hopelessly impractical. Are you really expected to memorize dozens of accelerator key combinations? Fortunately, Excel is ready to help you out with a feature called KeyTips. Once you hit the corresponding key to pick a tab, letters appear over every button in that tab Figure Once again, you press the corresponding key to trigger the command Figure Sometimes, a command might have two letters, in which case you need to press both keys, one after the other.

To trigger it, press Alt, then H, then F, and then D. You can go back one step in KeyTips mode by pressing Esc. Or, you can stop cold without triggering a command by pressing Alt again.

These are key combinations that start with the Ctrl key. Usually, you find out about a shortcut key by hovering over a command with your mouse. You can then press the S key to choose the Paste Special command. Fortunately, Microsoft went to a little extra trouble to make life easier for longtime Excel aficionados. The result is that you can still use your menu shortcuts, but they work in a slightly different way.

All Excel gives you is the tooltip. Keen eyes will have noticed the tiny bit of screen real estate just above the ribbon. It holds a series of tiny icons, like the toolbars in older versions of Excel Figure Excel provides easy access to these commands because most people use them more frequently than any others.

But it has one other notable attribute: You can customize it. The Appendix of this book Creating Custom Functions shows you how. Microsoft has deliberately kept the Quick Access toolbar very small. Even if you go wild stocking the Quick Access tool bar with your own commands, the rest of the ribbon remains unchanged. And that means a co-worker or spouse can still use Excel, no matter how dramatically you change the QAT. For example, if you save or print a document, the status bar shows the progress of the save operation or print job.

If your task is simple, the progress indicator may disappear before you even have a chance to notice it. The status bar combines several types of information. The leftmost area shows Cell Mode, which displays one of three indicators:. Enter appears when you start typing a new value into a cell. Edit means you currently have the cell in edit mode, and pressing the left and right arrow keys moves through the data within a cell, instead of moving from cell to cell.

You can place a cell in edit mode or take it out of edit mode by pressing F2. Farther to the right of the status bar are the view buttons, which let you switch to Page Layout view or Page Break Preview. These help you see what your worksheet will look like when you print it. The zoom slider is next to the view buttons, at the far right edge of the status bar. You can slide it to the left to zoom out which fits more information into your Excel window or slide it to the right to zoom in and take a closer look at fewer cells.

You can learn more about zooming on Zooming. In addition, the status bar displays other miscellaneous indicators. Scroll mode is a great way to check out another part of your spreadsheet without leaving your current position.

You can control what indicators appear in the status bar by configuring it. To see the list of possibilities, right-click the status bar Figure Table describes the options.

Shows the number of cells that were skipped left blank and the number of cells that were filled after a Flash Fill operation Flash Fill.

Signatures, Information Management Policy, and Permissions. Displays information about the rights and restrictions of the current spreadsheet. These features come into play only if you use a SharePoint server to share spreadsheets among groups of people usually in a corporate environment.

Indicates whether you have Caps Lock mode on. When it is, Excel automatically capitalizes every letter you type. To turn Caps Lock on or off, hit the Caps Lock key. Indicates whether Num Lock mode is on. When it is, you can use the numeric keypad typically on the right side of your keyboard to type in numbers more quickly. To turn Num Lock on or off, press Num Lock. Indicates whether Scroll Lock mode is on. In other words, you can control your scrollbars by just using your keyboard.

You can turn Scroll Lock mode on or off by pressing Scroll Lock. Indicates when Fixed Decimal mode is on. When it is, Excel automatically adds a set number of decimal places to the values you enter in any cell.

For example, if you tell Excel to use two fixed decimal places and you type the number 5 into a cell, Excel actually enters 0. This seldom-used featured is handy for speed typists who need to enter reams of data in a fixed format.

Once you turn this checkbox on, you can choose the number of decimal places displayed the standard option is 2. Indicates when you have Overwrite mode turned on. Overwrite mode changes how cell edits work. When you edit a cell with Overwrite mode on, the new characters that you type overwrite existing characters rather than displacing them.

You can turn Overwrite mode on or off by pressing Insert. For example, hit End and then Home to move to the bottom-right cell in your worksheet. Macros are automated routines that perform some task in an Excel spreadsheet. The Macro Recording indicator shows a record button which looks like a red circle superimposed on a worksheet that lets you start recording a new macro.

Indicates the current Selection mode. You have two options: normal mode and extended selection. When you press the arrows keys with Extended selection on, Excel automatically selects all the rows and columns you cross as you move around the spreadsheet.

Extended selection is a useful keyboard alternative to dragging your mouse to select swaths of the grid. To turn Extended selection on or off, press F8. Show the result of a calculation on selected cells. For example, the Sum indicator totals the value of all the numeric cells selected. Does nothing that we know of. Zoom Slider. Lets you zoom in by moving the slider to the right or out by moving it to the left to see more information at once.

Every item that has a checkmark appears in the status bar when you need it. The text that appears on the right side of the list tells you the current value of the indicator. Your data is the star of the show. To switch to backstage view, click the File button to the left of the Home ribbon tab. This gives Excel the space it needs to display information related to the task at hand, as shown in Figure Or if you want to open an existing spreadsheet, Excel can display a detailed list of files you recently worked on.

When you first switch to backstage view, Excel shows the Info page, which provides basic information about your workbook file, its size, when it was last edited, who edited it, and so on see the column on the far right. The Info page also provides the gateway to three important features: document protection Chapter 21 , compatibility checking page 31 , and AutoRecover backups page To go to another section, click a different command in the column on the far left.

To get out of backstage view and return to your worksheet, press Esc or click the arrow-in-a-circle icon in the top-right corner of backstage view. The key to using backstage view is the menu of commands that runs in a strip along the left side of the window. You click a command to get to the page for the task you want to perform. Excel will launch a new window, with a new, blank worksheet at the ready.

When you click New, you see a page resembling the welcome page that greets you when you start Excel. Work with files create, open, close, and save them with the help of the New, Open, Save, and Save As commands. Print your work Chapter 7 and email it to other people Chapter 25 using the Print and Share commands.

Prepare a workbook you want to share with others. For example, you can check its compatibility with older versions of Excel Chapter 1 and lock your document to prevent other people from changing numbers Chapter You find these options under the Info command. To do this, click the Account command. Configure how Excel behaves. Excel is no exception. Either way, you end up at the Save As page in backstage view Figure The first time you save your spreadsheet, you need to choose where to put it.

The Save As window includes a list of places —locations where you can store your work. This is the most common option. When you click Computer, Excel lists the folders where you recently saved or opened files see Figure , on the right.

To save a file to one of these locations, select the folder. Or, click the big Browse button at the bottom to find a new location. Either way, Excel opens the familiar Save As window, where you type in a name for your file Figure Once you pick a location for your file, you need to give it a name. Excel features some nifty SkyDrive integration features. For example, you can upload a spreadsheet straight to the Web by clicking your personalized SkyDrive item in the Places list, and then choosing one of your SkyDrive folders.

The advantage of putting a file on SkyDrive is that you can open and edit it from another Excel-equipped computer, without needing to worry about copying or emailing the file.

The other advantage is that other people can edit your file with the Excel Web App. Or look up at the top of the Excel window in the Quick Access toolbar for the tiny Save button, which looks like an old-style diskette. Saving a spreadsheet is an almost instantaneous operation, and you should get used to doing it regularly. There are two ways you can do this:. Click one to open a Save As window with that format selected.

Excel lets you save your spreadsheet in a variety of formats, including the classic Excel 95 format from more than a decade ago. If you want to look at your spreadsheet using a mystery program, use the CSV file type, which produces a comma-delimited text file that almost all spreadsheet programs can read comma-delimited means that commas separate the information in each cell.

Modern versions of Excel, including Excel , use the. Microsoft introduced this format in Excel , and it comes with significant advantages:. And even though the average hard drive is already large enough to swallow millions of old-fashioned Excel files, a more compact format is easier to share online and via email. As long as you store the Excel documents in XML format, these companies can create automated programs that pull the information they need straight out of the spreadsheet, without going through Excel itself.

These programs can also generate made-to-measure Excel documents on their own. For all these reasons,. However, Microsoft prefers to give people all the choices they could ever need rather than make life really simple , and Excel file formats are no exception.

In fact, the. If you add macros to a spreadsheet, Excel prompts you to use this file type when you save your work. To use the. You can just create your spreadsheets, save them, and let Excel take care of the rest.

The only time you need to stop and think twice is when you share your work with other, less fortunate people who have older versions of Excel, such as Excel Once you open your spreadsheet in Excel, everything else like scrolling around and performing calculations happens at the same speed. With a little know-how, you can take a look at these hidden files-within-a-file, which makes for a great Excel party trick. Browse to the file using Windows Explorer or your favorite file-management tool.

Change the file extension to. So if you start with BlackMarketDinnerware. Now you can see the files hidden inside your Excel file. Excel organizes them into several folders Figure When you finish, rename the file using the. Inside every. For example, separate files store printer settings, text styles, the name of the person who created the document, the composition of your workbook, and the individual worksheets themselves. As you just learned, Excel uses the same.

However, a few issues can still trip you up when you share spreadsheets between different versions of Excel. Instead of seeing the numeric result you want, your recipient will see an error code mixed in with the rest of the spreadsheet data. To avoid this sort of problem, you need the help of an Excel tool called the Compatibility Checker.

It scans your spreadsheet for features and formulas that will cause problems in Excel or Excel Click the Check for Issues button, and choose Check Compatibility. The Compatibility Checker scans your spreadsheet, looking for signs of trouble. It reports problems to you Figure In this example, the Compatibility Checker found two potential problems. The first affects people using Excel or older, while the other affects people using Excel or older. Problems that affect old—really old—versions of Excel Excel 97 to Excel You can ignore the Compatibility Checker issues, click Find to hunt each one down, or click Help to figure out the exact problem.

This way, you can print it up and review it in the comfort of your cubicle. To get back to the worksheet with your data, click the Sheet1 tab at the bottom of the window. Chapter 4 has more about how to use and manage multiple worksheets. That means you can still open a spreadsheet that uses newer, unsupported features in an old version of Excel.

Optionally, you can set the Compatibility Checker to run automatically for this workbook. Now, the Compatibility Checker runs each time you save your spreadsheet, just before Excel updates the file. But if you want to share your spreadsheet with Excel , follow the instructions in the next section. Sharing your workbook with someone using Excel presents an additional consideration: Excel uses the older. Save your spreadsheet in the old format.

You can save a copy of your spreadsheet in the traditional. If you keep your spreadsheet in Excel and share it with an Excel user, the sheet might look a little different when your recipient opens it. Use a free add-in for older versions of Excel. People stuck with Excel , Excel , or Excel can read your Excel files—they just need a free add-in from Microsoft.

People with past-its-prime versions of Excel can find the add-in by surfing to www. If you save your Excel spreadsheet in the Excel format, make sure to keep a copy in the standard. As you already know, each version of Excel introduces a small set of new features. The differences between Excel and Excel are small, but the differences between Excel and Excel are more significant. Excel tries to help you out in two ways. First, whenever you save a file in.

Second, whenever you open a spreadsheet in the old. While the Compatibility Checker points out potential problems after the fact, compatibility mode is designed to prevent you from using unsupported features in the first place. In fact, compatibility mode is so seamless that you might not even notice its limitations. Instead of seeing something like CateringList.

When you save an Excel workbook in. Instead, you need to close the workbook and reopen it. This saves an Excel version of your file with the same name but with the extension. One way to solve this problem is to save your spreadsheet as a PDF file.

People use PDFs to pass around product manuals, brochures, and all sorts of electronic documents. Unlike a document format like. The best part about PDFs is that you can view them on just about any computer using the free Adobe Reader. The Windows operating systems includes another electronic paper format called XPS, which works just as well as PDF for creating print-ready files.

Excel opens a modified version of the Save As window that has a few additional options Figure You can save PDF files at different resolutions and quality settings which mostly affect graphics in your workbook, like pictures and charts.

Normally, you use higher-quality settings if you want to print your PDF file, because printers use higher resolutions than computers. That way, you can check the result. Finally, if you want to publish only a portion of your spreadsheet as a PDF file, click the Options button to open a window with even more settings. You can publish just a fixed number of pages, just selected cells, and so on. These options mirror the choices you see when you print a spreadsheet Printing.

Excel document properties are discussed in more detail on Document Properties. If your computer is on a network, the solution may be as simple as storing your file in the correct, protected location.

It lets you password-protect your spreadsheets, which means that anyone who wants to open them has to know the password you set. You can prevent others from opening your spreadsheet unless they know the password. This level of security, which scrambles your data for anyone without the password a process known as encryption , is the strongest. You can let others read but not modify the sheet unless they know the password. From the Tools drop-down menu, pick General Options.

The Tools drop-down menu sits in the bottom-right corner of the Save As window, just to the left of the Save button. Type a password next to the security level you want to turn on as shown in Figure , and then click OK. Excel creates a backup with the file extension.

For example, if you save a workbook named SimpleExpenses. You can open the. When you do, you see that it is an exact copy of your work. With this option, Excel displays a message every time you or anyone else opens the file. You can use any sequence of letters and numbers as a password. Passwords are case-sensitive which means that PanAm is different from panam , and masked which means that, when you type in the password, Excel displays just a series of asterisks.

 
 

 

Microsoft office 2013 illustrated introductory first course pdf freefree

 
Caps Lock Indicates whether you have Caps Lock mode on. Excel moves your workbook to the top of the list and pins it in place. Learn more here: Microsoft Office Advanced. To turn Num Lock on or off, press Num Lock. By now, this whole process probably seems hopelessly impractical.

 
 

Microsoft office 2013 illustrated introductory first course pdf freefree. Excel 2013: The Missing Manual by Matthew MacDonald

 
 

Skills are accessible and easy-to-follow thanks to the Illustrated Series’ hallmark 2-page layout, which allows students to see an entire task in one view. New Learning Outcomes outline the skills covered in each lesson, and larger full-color screens represent exactly what students should see on their own computers.

Each unit begins with a microsoft office 2013 illustrated introductory first course pdf freefree overview of the principles of the lesson, and introduces a case study for further application. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Over 2, higly probable test items. The Illustrated Series has been praised by instructors for its concise, focused approach and user-friendly layout, which engages both computer rookies and hot shots in mastering application skills and computer concepts quickly and efficiently. Get inspired to improve business processes in your company by leveraging the available analytical and collaborative features of this environment.

Updated with all new case-based tutorials, New Perspectives Microsoft Office engages you in applying skills to real-world situations, making concepts relevant. A new Troubleshoot type of case problem enhances critical thinking. As always, New Perspectives improves learning outcomes and transference of skills by helping you understand the importance of what you’re learning.

It offers many benefits including security, reliability, compatibility with other products, microsoft office 2013 illustrated introductory first course pdf freefree updates in the cloud that don’t require anything from the user, single sign on for access to everything right away, and so much посетить страницу. Office For Dummies offers a basic overview of cloud computing and goes on to cover Microsoft cloud solutions на этой странице the Office ссылка in a language you can understand.

This includes an introduction to each component which leads into topics around перейти на источник each feature in each application. Get up to speed on instant messaging Use audio, video, and web conferencing Get seamless access to the Office suite with Office Web microsoft office 2013 illustrated introductory first course pdf freefree Access information anywhere, anytime Office is the key to office productivity — and now you can put it to use for you!

However, they microsoft office 2013 illustrated introductory first course pdf freefree often constrained by lack of adequate resources, sound policies, and national support. It is clear that change and advancements, both systematic and scientific, are needed in a number of forensic science disciplines to ensure the reliability of work, establish enforceable standards, and promote best practices with consistent источник. Strengthening Forensic Science in the United States: A Path Forward provides a detailed plan for addressing these needs and suggests the creation of a new government entity, the National Institute of Forensic Science, to establish and enforce standards within the forensic science community.

The benefits of improving and regulating the forensic science disciplines are clear: assisting law enforcement officials, enhancing homeland security, and reducing the risk of wrongful conviction and exoneration.

Strengthening Forensic Science in the United States gives a full account of what is needed to advance the forensic science disciplines, including upgrading of systems and organizational structures, better training, widespread adoption of uniform and enforceable best practices, and mandatory certification and accreditation programs.

While this book provides an essential call-to-action for congress and policy makers, it also serves as a vital tool for law enforcement agencies, criminal prosecutors and attorneys, and forensic science educators. All Rights Reserved.