Staff Computer Course Outline - Computing Services Centre. Troubleshoot Problems in Microsoft Word, Excel and Power. Point (CSC3. 07a)Course Outline: Microsoft Word 2. Managing Word Files. Convert files to and from the previous version of Word. Prepare the Document for Sharing. Protect document. Recover unsaved document in Word 2. Recover a document when Word shut down unexpectedly. Recover information from a damaged document. Formatting. Using Quick Cover. Using Quick Parts. Using Quick Styles. Staff Computer Course - Course Outline Troubleshoot Problems in Microsoft Word, Excel and PowerPoint (CSC307a) Course Outline: Microsoft Word 2013. Managing Word Files Convert files to and from the previous version.BCIT's Mining and Mineral Resource Engineering program is designed to allow well qualified students who successfully complete the first year of the Mineral Exploration and Mining Technology Diploma program to apply to complete. Play your favorite games nownews & announcementsupcoming release upcoming event featured events sign up / sign in. Free Download Link: http:// Home Page: http:// To my surprise this SmartPCFixer really helped me! My old computer is running faster and there is no. Casual dining with the freshest locally produced meats, beers, wines and produce. Locations in both Sedona and Cottonwood, Arizona. G low Wellness brings wellness events, wellness programs, wellness retreats and natural wellness spa treatments to help you relax, cleanse and rejuvenate. Let us help you feel better, look better and get. Pesticides can be used to control a variety of pests, such as insects, weeds, rats and mice, bacteria and mold, and more. Find out more about pesticides: What are pesticides? How EPA evaluates pesticide risks; Understanding. And when they sez that the old man--excuse my freedom, but that's the way the boys talk of your father, meaning no harm-- the old man, instead o' trying to corral rich widders--grass or otherwise--to spend their money on the. Immigration lawyer group Siskind Susser is one of the best known immigration law firms in the country. The firm created Visalaw.com, the first immigration law site (founded in 1994), offering immigration solutions for people. Handle page numbering problems. Handling spacing problem. Enable or Disable Auto. Correct. Miscellaneous. Track changes. Footnotes. Spelling & Grammar. Translations with the Mini Translator. Changing Document Default Settings. Word Options - General. Word Options - Proofing. Word Options – Save. Excel 2. 01. 3Managing Excel Files. Convert files to and from the previous version of Excel. Prepare the Workbook for Sharing. Protect Workbook. Protect worksheet. Recover unsaved Workbook in Excel 2. Recover a document when Excel shut down unexpectedly. Share workbook. Recover information from a damaged document. Formatting. Format numbers as text Convert numbers stored as text to numbers. Display leading zero. Format as Table Conditional Formatting and Data Visualization. Data Editing. Handling wrong cell reference after move or copy. What to do when the Find and Replace commands do not find data. Changing Default Settings. Change the default Currency and Date Format. Change View settings. Install Excel Data Analysis Tool. Pak. Functions. Enable Developer tab to record Macro or writing VBACheck Errors in formulas. Power. Point 2. 01. Managing a Power. Point Files. Convert files to and from the previous version of Power. Point. Prepare the Presentation file for Sharing. Protect Presentation files. Recover unsaved Presentation file in Power. Point 2. 01. 3Recover a document when Power. Point shut down unexpectedly. Recover information from a damaged document. Manage presentation section. Formatting a Presentation Files. Miscellaneous. Create & Change Hyperlink in presentation. Handle graphics displayed as red “X” in presentation. Advanced Animation. Video Maker. Open Word document in Power. Point. Duration: One day. Pre- requisite(s): Participants should have a sound working knowledge of MS Office 2. Wireless LAN Access Services for City. U Members (CSC4. 12)Course Outline: Introduction to Wireless. What is Wireless LAN (WLAN)City. U WLAN Service. Eduroam. Wi- Fi at PCCW/Y5. Zone hot spots. Wireless LAN Compliance. IEEE 8. 02. 1. 1a. IEEE 8. 02. 1. 1b. IEEE 8. 02. 1. 1g. Comparsion chart. Secure connection vs insecure connection. What is Wireless LAN Security ? Wireless LAN Security modes. How to switch/select and set default WLAN networks. Setting up your device to access Wireless LANLaptop with Windows 7 Special alert in the credential caching problem while using Windows 7with WPALaptop with Windows Vista. How to identify locations that offer free Wi- Fi access to City. U members. City. U WLAN Coverage. Eduroam. Coverage. Identify locations that offer Wi- Fi access to City U members. Duration: 3 hours. Enhancing Power. Point 2. Presentations with Multimedia Elements (CSC3. The aim of this course is to provide the basic techniques in creating and editing multimedia elements using specialized software for the MS Power. Point presentations. Course Outline: Add audio to your slide show. Video and audio file formats supported in Power. Point. Play music and other sounds automatically when a slide appears. Record and add narration and timings to a slide show. Trim a sound clip. Delete a music clip or another sound. Basic Image Editing Technique on Power. Point. Make a picture transparent. Make a picture transparent and use it as a slide background. Change the brightness or contrast. Adding artistic effects. Recoloring your picture. Changing the color intensity. Adding Smart. Art Graphics. Replace bulleted text with a smart- looking graphical list. Convert slide text to a Smart. Art graphic. Convert pictures on a slide to a Smart. Art graphic. Change the color of a shape, shape border, or entire Smart. Art graphic. Change the style and width of lines connecting Smart. Art shapes. Add alternative text to a Smart. Art graphic. Keyboard shortcuts for Smart. Art graphics. Applying Slide Animation. Apply multiple animation effects to one object. Applying a motion path animation. Change the order of your animation effects. Trigger an animation effect to play. Add a motion path animation. Animate a Smart. Art graphic. Remove an animation effect. Applying Slide Transition. Add or remove transitions between slides. Set the speed and timing of transitions. Remove a transition. Inserting Video & Editing technique. Video and audio file formats supported in Power. Point. Insert or link to a video that is stored on my PCInsert or link to a video on You. Tube. Trim a video. Bookmark points of interest in a video or audio clip. Set the 'Playback' options for a video in your presentation. Add or change the look of a video border. Save your presentation as a video. Inserting Audio & Editing technique. Add audio to your slide show. Play music for the duration of your slide show. Play music and other sounds automatically when a slide appearsloop an audio or video clip in a presentation. Trim a music or sound clip. Voice Narration. Details about recording and using narration in a slide show. Record a narration before or during a slide show. Preview a narration. Record comments on a slide. Set the slide timings manually. Turn the slide timings off> Working with Pictures. Insert a picture. Resize a picture. Apply a style to a picture. Use a picture as a slide background. Reduce the file size of a picture. Change the resolution of a picture. Set default picture resolution for all pictures in a document. Compress a picture. Discard all picture editing data. Crop a picture or place it in a shape. Working with Shapes. Add shapes. Add text to a shape. Change from one shape to another shape. Add multiple shapes to your file. Add a bulleted or numbered list to a shape. Add a shape fill or effect. Add a Quick Style to a shape. Use eyedropper to match colors on your slide. Group or ungroup shapes, pictures, or other objects. Combine shapes to create a custom shape. Delete a shape. Photo Album. Start creating your photo album by adding pictures. Add captions to pictures. Change the look of a picture. Share your photo album with others. Duration: One day. Pre- requisite(s): Completed Microsoft Power. Point 2. 01. 3 Introduction (CSC5. Using Excel Functions Effectively This course delivers the application of the functions below. At the end of the course, students will be able to utilize the calculative functions of Excel. Course Outline: Introduction. Course Objectives. Course Contents. Information Functions. Overview. ISBLANKISNUMBERISERRORIFERRORTYPEDatabase Functions. DSUMDAVERAGEDCOUNT & DCOUNTADMAX & DMINText Functions. LEFTRIGHTMIDLENLOWERSEARCHREPLACEUPPERPROPERSUBSTITUTETRIMLookup and Reference Functions. Using VLOOKUP to Find Data. Limit the VLOOKUP Value for Exact Match. Using the Closest Match for the VLOOKUP Value. HLOOKUPINDEXMatch. Statistical Functions. MEDIANMODEGROWTHLARGESMALLRANKFinancial Functions. PMT, IPMT & PPMTPVFVDBDDBOther Functions. SUMPRODUCTABSINTROUNDROUNDUPROUNDDOWNSUBTOTALTODAYDAYMONTHYEARNETWORKDAYSWEEKDAYWORKDAYIFANDORSUMIFCOUNTIFAVERAGEIFSUMIFSAVERAGEIFSCOUNTIFSDuration: One day. Pre- requisite(s): Completed Microsoft Excel 2. Introduction or with equivalent knowledge. Preparing Professional Reports Using MS Excel (CSC5. This course is designed for advanced excel users to prepare professional reports. After completion of the course, participants will be able to import information into Excel, integrate other office applications using OLE mechanism, produce an interactive report, together with knowledge in choosing suitable formats that best fit the report. Course Outline: Create a Pivot. Table to analyze worksheet data. Using Recommended Pivot. Tables. Sort data in a Pivot. Table. Sort on a column that doesn't have an arrow button. Set custom sort options. About sorting in Pivot. Tables. Filter data in a Pivot. Table. Filter data manually Show specific text, values, or dates only Show the top or bottom 1. Turn filtering options on or off Group or ungroup data in a Pivot. Table report. Group selected items. Ungroup grouped data. Change the data layout of a Pivot. Table. Change how subtotals and grand totals are shown. Change the style of your Pivot. Table. Show banded rows for ease of scanning. Create a Chart. Creating charts from start to finish. Create your chart. Fine- tune your chart. Change the data in your chart. Use your chart in another program. Available chart types. Column charts Line charts Pie and doughnut charts Bar charts Area charts XY (scatter) and bubble charts Stock charts Surface charts Radar charts Combo charts. Analyze trends in data using sparklines. Creating sparklines. Customize your sparklines. Using Conditional Formatting. Learn more about conditional formatting Format all cells by using a two- color scale Format all cells by using a three- color scale Format all cells by using data bars Format all cells by using an icon set Format only cells that contain text, number, or date or time values Format only top or bottom ranked values Format only values that are above or below average Format only unique or duplicate values Use a formula to determine which cells to format Find cells that have conditional formats Clear conditional formats Calculate multiple results by using a data table. Data table basics Create a one- variable data table Add a formula to a one- variable data table Create a two- variable data table Speed up calculation on a worksheet that contains data tables. Duration: One day. Pre- requisite(s): Participants should have a sound working knowledge of the Windows environment. Chinese Input Method - Chang Jie (CSC7. Date: 2. 1 Dec 2. Wed) Time: 1. 4: 1. Find out more about pesticides.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2016
Categories |