Found 1248 related files. Current in page 9
Imagine examining hundreds of rows of raw data in Excel in an attempt to find a pattern or trend. Thankfully one of the tools we can use in Excel to make this task simpler is Conditional Formatting. Just another way Excel makes your data display, other than a chart. The Conditional Formatting features are color scales, icon sets and data bars to name a few. When to Use Excel’s Conditional Formatting: If you want to be informed in real time Answer questions visually Analyze data: find exceptions, find relationships, find trends, etc Enhance data presentations You can choose from inbuilt Conditional Formatting rules like: Top 10 or Bottom 10 using percentages, average or item Greater than, less than or equal to Text that contains a specific word or phrase A date occurring And even identify duplicate values Or you can insert a formula and create a custom conditional format. Color coding can be simple like font color, font style and cell fill, or more elaborate with icons, color scales or data bars. 1 Conditional Formatting Examples How to Apply Conditional Formatting: Select the range of cells you want formatted. From the Home tab go to the Styles group and select Conditional Formatting. The menu will appear with your formatting options. When you choose one of the options a cascading menu will appear. 2 Depending on which option you choose you will be prompted to make more selections. Note: You can specify a custom format or use one of the default formats. You can choose to format the cell fill, font style, color, size, bold, italic, underline and more. Remove Conditional Formatting Rules: Click the Conditional Formatting command. Select Clear Rules. A cascading menu appears. Choose to clear rules from the entire worksheet or the selected cells.
Documented by. Vincent J. Yanusauskas. Computer Training Coordinator. INTRODUCTION TO MICROSOFT EXCEL 2010. Creating a Basic Spreadsheet ... If you have been using Office 2007, then you are already aware that the Ribbon interface replaced the familiar menus and toolbars with Tabs, Groups, and Commands. Although Excel 2010 retains the same interface it offers: (1) a new Backstage view to manage your documents, (2) the ability to customize the Ribbon with custom Tabs and Groups, (3) an Info tab that displays different commands, properties, and metadata depending on the status and location of the document, and (4) quick access to Recent Workbooks and Recent Places. Backstage View The Backstage view is the place where you manage your Excel workbooks and the related data about them. Click on the File tab to create, save, and send workbooks; inspect workbooks for hidden metadata or personal information. From this view you can access the most recent documents and folders that were opened, set print options, and preview a spreadsheet before printing. Quick access to Recent Workbooks and Recent Places Prior versions of Microsoft Office displayed a set number of the most recent documents accessed as so does Office 2010. The newest version also includes “Recent Places,” shortcuts to folders that you may have accessed within Royal Drive, My Documents, etc. These new and revised navigation shortcuts provide faster retrieval to any file or folder used continually by allowing the user to pin shortcuts to the Recent Screen. How to: 1. Click on the tab File and then Recent. 2. Click on the push pin next to any Recent Documents or Recent Places to pin the desired documents or places to the window. Click the push pin again to remove them from the window.
Enabling MACRO in Excel 2010. 1. Launch Excel and start on a new worksheet. 2. Click File on the menu bar in the upper left hand corner. 3. Select Options ... Enabling MACRO in Excel 2010 1. Launch Excel and start on a new worksheet. 2. Click File on the menu bar in the upper left hand corner. 3. Select Options from the left hand menu. 4. Select Trust Center from the left hand menu. 5. Click on the Trust Center Settings button located on the middle right side of the page. 6. 7. 8. 9. Select Macro Settings on the left hand navigation menu. Select Disable all macros with notification from the Macro Settings list. Click the OK button to apply the change and exit the menu. Exit the menu and get back to the blank worksheet. 10. Open the Fleet Calculator. 11. In the Security Warning bar, click the Enable Content button. 12. In the Security Options dialog box, click the Yes button. Enabling MACRO in Excel 2007 1. Launch Excel and start on a new worksheet. 2. Click the Microsoft Logo on the upper left hand corner. 3. Click the Excel Options button at the bottom of the drop down menu.
Creating an Invoice Template in Microsoft Excel 2010 1. Click the Start button located on the Windows taskbar. (Bottom, left-hand corner of your computer’s desktop or “home” screen) 2. Scroll down to find Microsoft Office Excel 2010 & click to open the program. (The program is located within the Microsoft Office folder) 3. Your screen should resemble Figure 1.1. Now click the File button (highlighted in green, located in the top, left-hand corner of your screen). 4. From the displayed menu on the lefthand side, select New. 5. Check to make sure your screen resembles figure 1.2. Under Office.Com Templates, look for and select Invoices. (Your computer will perform a brief search at Office.Com for a list of available invoice templates) 6. In this tutorial we will be using a Sales Invoice template. Click on the Sales invoices Folder. (Your computer will perform another brief search at Office.Com) 7. Once the new window opens, select Invoice with Tax Calculation. Refer to Figure 1.3. Click the Download button located at the bottom, right-hand side of your screen.
Countries all over the world are facing economic downturn. This leads to a fall in people’s financial resources. People are also getting second jobs to double their income every month. Those who are job seeking, you should make sure that the job they're looking for is in demand, such as bookkeeping. Microsoft Excel course,BookKeeping Training,Book Keeping Courses,Sage Line 50 Training
Quick Start Guide Thank you for choosing the WAP2000 Wireless-G Access Point with Power Over Ethernet. The access point features RangeBooster technology that is compatible with standard 802.11g but with a range up to two times further and throughput up to 35 percent faster. Unlike ordinary wireless technologies that are hampered by wireless signals that reflect off walls, ceilings, and other objects, RangeBooster uses these multiple signals with two smart receivers at each end (router or access point and client adapter) to boost range and throughput speeds. As a result, a RangeBooster solution reduces or eliminates wireless signal dead spots in offices and other buildings so users can connect to the network in more areas. 2 Getting to Know the WAP2000 This section describes the external features of the WAP2000. Front Panel RESET Button—There are two ways to reset the access point to the factory default configuration. Either press the Reset button for more than ten seconds or restore the defaults using the web-based utility of the access point. If you press the Reset button for less than ten seconds, the access point will simply reboot. ETHERNET Port—Connects to Ethernet network devices, such as a switch or router. The access point can be powered using Power over Ethernet. POWER Port—Connects the access point to power using the supplied power adapter. Use this option if your switch or router doesn’t support Power over Ethernet. Wall Mounting The WAP2000 can be mounted either vertically or horizontally. STEP 1 Determine where you want to mount the access point and install two screws (not supplied) into the wall for either vertical or horizontal placement. For horizontal placement, orient the access point as shown: 5-7/8˝ Side Panel This guide describes how to physically install your WAP2000 and how to set up a basic configuration by using the configuration utility. Before You Begin Before you begin the installation, make sure that you have the following equipment and services: Cisco Small Business • Tools for installing the hardware WAP2000 Wireless-G Access Point with Power Over Ethernet • Category 5e Ethernet cable Package Contents • A Cisco Small Business Power over Ethernet (PoE) switch or a switch and a 802.3af compliant power injector • Wireless-G Access Point with Power Over Ethernet • Detachable Dipole Antennas (2) • PC with Microsoft Internet Explorer (6.0 or later) or Mozilla Firefox for using the web-based system management tools POWER—(Green) Lights up when the access point is powered on. PoE—(Green) Lights up when the access point is powered through an Ethernet cable. WIRELESS—(Green) Lights up when the wireless module is active on the access point. The LED flashes when the access point is actively sending or receiving data from a wireless device.
Cisco SRP500 Series Services Ready Platforms (SRP520 Models) Package Contents • Cisco SRP500 Series Services Ready Platform • RJ-45 Ethernet Cable • RJ-11 Telephone Cable • Power Clip and Adapter • Quick Start Guide • Product CD Welcome Thank you for choosing Cisco SRP500 Series Services Ready Platforms. This guide describes how to physically install the SRP and how to use the Setup Wizard to configure it. 1 Before You Begin Before you begin the installation, make sure that you have the following: For Hardware Installation • An active Internet connection. • (Optional) Analog phone line. • (Optional) Telephone handset, fax machine, or PBX line for connecting to the voice ports. • Cables – RJ-45 Ethernet cables (Category 5 or higher) for connecting computers, WAN and LAN interfaces, phones, or other devices. – RJ-11 telephone cable for analog line (FXO) and phone (FXS) connections. – ADSL splitter, if required by your Service Provider. • (Optional) Mobile Broadband USB Modem. For Software Installation: • A computer running: – – 2 Microsoft Internet Explorer 7.0 (or later), or Mozilla Firefox 3.6. Adobe Flash Player with add-on version 10.0.0 or later (needed to to configure your SRP). Cisco SRP500 Services Ready Platforms Quick Start Guide (SRP520 Models) Default Settings Use these default settings when configuring your SRP with the Setup Wizard. See Getting Started with the Configuration, page 11. Parameter Value Device IP 192.168.15.1 Username cisco Password cisco DHCP Range 192.168.15.100 to 149 To configure advanced features (such as wireless, network, and voice settings), log in by using the Administrator account. For more information, see the Cisco SRP500 Series Services Ready Platforms Administration Guide (SRP520 Models) at: www.cisco.com/go/srp500. NOTE If you obtained your SRP from your Service Provider, you might not have access to the Administrator account. Contact your Service Provider for more information. 2 Getting to Know the Cisco SRP500 Series Services Ready Platforms This section lists the available model numbers to help you become familiar with your SRP, and shows the front panel, back panel, side view, and top the unit. NOTE To get started with the installation right away, see Installing the SRP500 Services Ready Platforms, page 8. Cisco SRP500 Services Ready Platforms Quick Start Guide (SRP520 Models)
Nobody likes to spend their vacations sitting home and wasting their time watching television or just roaming around. Everyone wants it to be memorable and long lasting in their life which they would never want to forget
Introduce you to a powerful software tool in order to create clear and meaningful presentations Importance: Microsoft PowerPoint has basically become the industry standard for giving presentations. You will need to become proficient in it during the NASA RISE program in order to give weekly presentations on scientists of color, and a final presentation on the research project that you will be working on. What to hand in: N/A Goals: After this activity, you will be able to: • • • Software: Effectively organize a presentation Create aesthetically pleasing slides Insert images and charts Microsoft PowerPoint SECTION 0: PREPARING FOR A PRESENTATION: Why do we give presentations: The scientific world revolves around sharing information. This can be done in written, graphic, or verbal form. It is ULTRA important that you be able to communicate in all forms. This can make or break your career. You need to understand the factors that influence your preparation. Your purpose, the audience, and the context in which you are to deliver your presentation should determine the content, organization, tone, and the mediums (slides, video, etc...) you use. Figure 1: Factors Affecting Presentation Planning What is critical for success in a good presentation? Good content - If your presentation has the right content, you are half way to making a great presentation. The ability to include the correct content is a strong function: • • How well you know your audience How your presentation is organized. Is it logical? Interest - Is the content worthy of the audience's time? • It is easier to give a presentation to 5 interested people than to 100 people who are bored stiff. Make sure you have targeted the correct audience to avoid this situation. • Even if you "peg" your audience correctly the first time, you should make sure you emphasize the reason(s) why your presentation is important. Clarity - Your ability to explain clearly with words, text, and graphics determines how clearly your message comes across. • Use your storyboard (you will learn about this in a few sections below) to ...
Computers crash and documents are lost all the time, so it is best to save often! Saving Initially Before you begin to type, you should save your document. To do this, go to File > Save As (Figure 2). Microsoft PowerPoint will open a dialog box where you can specify the new file’s name and location where you want it saved. Once you have specified a name and a place for your new file, press the Save button. By default, the format for PowerPoint 2010 is .pptx (Figure 3) not .ppt like in previous versions. Note: If you want to save your document on a Mac and then open it on a PC you must specify a file extension (i.e. .ppt). Usually your computer will do this for you, but if it does not you must do this process while in Save As. Once you have named your document, you change the file extension by clicking Save As Type > PowerPoint 97-2003 Presentation (Figure 4).