Understanding computers

Views:
 
Category: Education
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

INTRODUCTION : 

By, Ron Wheatley INTRODUCTION Understanding MS Office 2003” “Stuff we skipped, after opening the box”

Helpful tips for the Hotel Business : 

By, Ron Wheatley Helpful tips for the Hotel Business

MICROSOFT WORD : 

By, Ron Wheatley MICROSOFT WORD Open and closing documents Save files you create Tags and help

MICROSOFT WORD : 

By, Ron Wheatley MICROSOFT WORD Correct spelling and grammar usage Apply font and text effects Modify paragraph formats

MICROSOFT WORD : 

By, Ron Wheatley MICROSOFT WORD Header and footer Document layout and page setup options Preview and print documents, envelopes and labels

MICROSOFT WORD : 

By, Ron Wheatley MICROSOFT WORD Save what you made with different means and file form Create modify diagrams and charts Compare and merge documents

MICROSOFT WORD : 

By, Ron Wheatley MICROSOFT WORD Convert documents into Web pages Phishing, ID theft and other scams Apply characters and paragraph styles

MICROSOFT WORD : 

By, Ron Wheatley MICROSOFT WORD Create and format documents sections Create Indexes, table of contents, figures and authorities Move within documents

MICROSOFT WORD : 

By, Ron Wheatley MICROSOFT WORD Use Excel data in tables Perform calculations in word text Create and modify charts using data from other applications

MICROSOFT WORD : 

By, Ron Wheatley MICROSOFT WORD Customize menus and toolbars Insert and modify hyperlinks to other documents and web pages created and edit web documents in Word Create and protect document versions

MICROSOFT WORD : 

By, Ron Wheatley MICROSOFT WORD Attach digital signatures to documents Merge letters with a word, excel, or access data source Use outlook data as a mail merge data source

Slide 12: 

By, Ron Wheatley Start and exit the excel program Open and close an excel workbook Copy workbook files; save workbooks EXCEL

Slide 13: 

By, Ron Wheatley Insert, delete, and move cells Check spelling; find and replace cell data and formats Save workbooks using different names and file formats EXCEL

Slide 14: 

By, Ron Wheatley Apply and modify cell formats Use auto formatted tools to format worksheets Preview and print worksheets and workbooks EXCEL

Slide 15: 

By, Ron Wheatley Insert and delete worksheets Create and revise formulas Create modify, position and print charts EXCEL

Slide 16: 

By, Ron Wheatley Create hyperlinks Import data to excel Create, edit and apply template EXCEL

Slide 17: 

By, Ron Wheatley Create workspaces Use data consolidation Use conditional formats EXCEL

Slide 18: 

By, Ron Wheatley Use named ranges in formulas Create, edit, and run macros Audit formulas EXCEL

Slide 19: 

By, Ron Wheatley Identify dependencies in formulas Use subtotals with lists and ranges Use data validation EXCEL

Slide 20: 

By, Ron Wheatley Create pivot table reports and pivot chart reports Forecast values with what-if analysis Merge workbooks EXCEL

Slide 21: 

By, Ron Wheatley Start Access and open a database Understand database terminology Manage toolbars and understand views; Use the help system ACCESS

Slide 22: 

By, Ron Wheatley Open database objects in multiple views Create and modify tables Create and modify select queries ACCESS

Slide 23: 

By, Ron Wheatley Create and display forms; Modify form properties Enter, edit, and delete records Create queries; Sort records ACCESS

Slide 24: 

By, Ron Wheatley Create and format reports Import data to access; Export data from access Use data validation; Link tables ACCESS

Slide 25: 

By, Ron Wheatley Create lookup fields and modify lookup field properties Specify multiple query criteria; Create and modify reports Use aggregate functions in queries ACCESS

Slide 26: 

By, Ron Wheatley Add sub from controls to access forms Establish one-to-many relationships Establish many-to-many relationships ACCESS

Slide 27: 

By, Ron Wheatley Add sub report controls to access reports Encrypt and Decrypt Databases Replicate a Database ACCESS

Slide 28: 

By, Ron Wheatley Start with PowerPoint Work with objects Get help; save files PowerPoint

Slide 29: 

By, Ron Wheatley Create presentations manually and using automated tools Add slides to and delete slides from presentations Modify headers and footers in the slide master PowerPoint

Slide 30: 

By, Ron Wheatley Import text from Word Insert, format, and modify text PowerPoint ICEBREAKER

Slide 31: 

By, Ron Wheatley Add tables, charts, clip art and bitmap images to slides Customize slide backgrounds Add office Art elements to slides PowerPoint

Slide 32: 

By, Ron Wheatley Apply animation schemes Apply slide transitions Rehearse timing PowerPoint

Slide 33: 

By, Ron Wheatley Rearrange slides Modify slide layout Preview and print slides, outlines, handouts, and speaker notes PowerPoint

Slide 34: 

By, Ron Wheatley Import excel charts to slides Add sound and video to slides Export a presentation as an outline PowerPoint

Slide 35: 

By, Ron Wheatley Set up slide shows Deliver presentations Use pack and go PowerPoint

Slide 36: 

By, Ron Wheatley Set up a review cycle Review presentation comments Publish presentations to the web PowerPoint