Transcription
MS OFFICE FULL COURSECourse Overviewwww.gteceducation.com.sgThis course covers Basic to Advanced topics of MS Word, MS Excel, MSPowerPoint and Internet and Emailing.Entry Requirement: Beginners of MS OfficeCourse Duration: 30hrs.Mode of Training: Face to face Instructor led TrainingMaterials: Course books will be provided to each participantCourse ContentMS WINDOWS, COMPUTER BASICS Computer Basic, Creating Folder, PaintDirectories, input units, Output unitCentral Processing Units,What is hard ware, what is Soft wareWindows short cut keysMS WORDModule 1: Text Basics Typing the text, Alignment of textEditing Text: Cut, Copy, Paste, Select All, ClearFind & ReplaceModule 2: Text Formatting and saving file New, Open, Close, Save, Save AsFormatting Text: Font Size, Font StyleFont Color, Use the Bold, Italic, and UnderlineChange the Text CaseLine spacing, Paragraph spacingShading text and paragraphWorking with Tabs and Indents1 Sophia Road, #02-03, Peace Centre, Singapore 228149.Phone: 63360244, 9650 3505, Email: Info.sg@gteceducation.comRegistered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Module 3: Working with Objects Shapes, Clipart and Picture, Word Art, Smart ArtColumns and Orderings - To Add Columns to aDocumentChange the Order of ObjectsPage Number, Date & TimeInserting Text boxesInserting Word artInserting symbolsInserting ChartModule 9: Sharing and MaintainingDocument Changing Word OptionsChanging the Proofing ToolsManaging TemplatesRestricting Document AccessUsing Protected ViewWorking with TemplatesManaging TemplatesUnderstanding building blocksModule 4: Header & FootersModule 10: Proofing the document Check Spelling As You Type. Mark Grammar Errors As You Type. Setting AutoCorrect OptionsInserting custom Header and FooterInserting objects in the header and footerAdd section break to a documentModule 5: Working with bullets andnumbered lists Multilevel numbering and BulletingCreating ListCustomizing List stylePage borderingPage backgroundModule 6: Tables Working with Tables, Table FormattingTable StylesAlignment optionMerge and split optionModule 7: Styles and Content Using Build- in Styles, Modifying StylesCreating Styles, Creating a list styleTable of contents and referencesAdding internal referencesAdding a FootnoteAdding EndnoteModule 8: Merging Documents Typing new address listImporting address list from Excel fileWrite and insert fieldMerging with outlook contactPreview ResultMerging to envelopesMerging to labelSetting rules for mergesFinish & Merge optionsModule 11: Printing Page Setup, Setting margins Print Preview, PrintMS EXCELModule 12: Introduction to Excel Introduction to Excel interfaceUnderstanding rows and columns, Naming CellsWorking with excel workbook and sheetsModule 13:Formatting excel work book: New, Open, Close, Save, Save AsFormatting Text: Font Size, Font StyleFont Color, Use the Bold, Italic, and UnderlineWrap text, Merge and CentreCurrency, Accounting and other formatsModifying Columns, Rows & CellsModule 14: Perform Calculations withFunctions Creating Simple FormulasSetting up your own formulaDate and Time Functions, Financial FunctionsLogical Functions, Lookup and ReferenceFunctions Mathematical FunctionsStatistical Functions, Text Functions.Module 15: Sort and Filter Data with Excel Sort and filtering dataUsing number filter, Text filterCustom filteringRemoving filters from columnsConditional formatting1 Sophia Road, #02-03, Peace Centre, Singapore 228149.Phone: 63360244, 9650 3505, Email: Info.sg@gteceducation.comRegistered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Module 16: Create Effective Charts to PresentData Visually Inserting Column, Pie chart etc.Create an effective chart with Chart ToolDesign, Format, and Layout optionsAdding chart titleChanging layoutsChart stylesEditing chart data rangeEditing data seriesChanging chartModule 17: Analyze Data Using PivotTablesand Pivot Charts Understand PivotTables, Create a PivotTableFramework Using the PivotTable and PivotChartCreate Pivot Chart from pivot Table.Inserting slicerCreating Calculated fieldsModule 18: Protecting and Sharing thework book Protecting a workbook with a passwordAllow user to edit rangesTrack changesWorking with CommentsInsert Excel Objects and Charts in WordDocument and Power point Presentation.Module 19: Use Macros to Automate Tasks Creating and Recording Macros Assigning Macros to the work sheets Saving Macro enabled workbookModule 20: Proofing and Printing Page setup, Setting print area, Print titles Inserting custom Header and Footer Inserting objects in the header and footer Page Setup, Setting margins, Print Preview, Print Enable back ground error checking Setting AutoCorrect OptionsMS POWERPOINTModule 21: Setting Up PowerPointEnvironment: New, Open, Close, Save, Save AsTyping the text, Alignment of textFormatting Text: Font Size, Font StyleFont Color, Use the Bold, Italic, andUnderline Cut, Copy, Paste, Select All, Clear text Find & Replace Working with Tabs and IndentsModule 22:Creating slides and applyingthemes Inserting new slideChanging layout of slidesDuplicating slidesCopying and pasting slideApplying themes to the slide layoutChanging theme colorSlide backgroundFormatting slide backgroundUsing slide viewsModule 23: Working with bullets andnumbering Multilevel numbering and BulletingCreating ListPage borderingPage backgroundAligning textText directionsColumns optionModule 24: Working with Objects Shapes, Clipart and Picture, Word Art, SmartArtChange the Order of ObjectsInserting slide header and footerInserting Text boxesInserting shapes, using quick stylesInserting Word artInserting symbolsInserting ChartModule 25: Hyperlinks and Action Buttons Inserting Hyperlinks and Action ButtonsEdit Hyperlinks and Action ButtonWord Art and Shapes1 Sophia Road, #02-03, Peace Centre, Singapore 228149.Phone: 63360244, 9650 3505, Email: Info.sg@gteceducation.comRegistered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Module 26: Working With Movies andSounds Inserting Movie From a Computer FileInserting Audio fileAudio Video playback and format optionsVideo options, Adjust optionsReshaping and bordering VideoModule 27: Using SmartArt and Tables Working with Tables, Table Formatting Table Styles Alignment option Merge and split optionConverting text to smart artModule 28:Animation and Slide TransitionModule 30: Slide show option Start slide showStart show from the current slideRehearse timingCreating custom slide showModule 31: Proofing and Printing Check Spelling As You TypeSetting AutoCorrect OptionsSave as videoSave as JPEG filesSave as PowerPoint Show filePrint Preview, PrintINTERNET & E-MAIL Default Animation, Custom AnimationModify a Default or Custom AnimationReorder Animation Using TransitionsApply a Slide Transition, Modifying aTransition, Advancing to the Next SlideModule 29: Using slide Master Using slide masterInserting layout optionCreating custom layoutInserting place holdersFormatting place holders What is Internet?, Receiving Incoming MessagesSending Outgoing Messages, Email addressingEmail attachments, Browsing, Search enginesText chatting, Job SearchingDownloading video and MusicUploading Video or Music, Voice chatting,Webcam Chatting etc. Introduction to Blogging, Facebook1 Sophia Road, #02-03, Peace Centre, Singapore 228149.Phone: 63360244, 9650 3505, Email: Info.sg@gteceducation.comRegistered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Student’s TestimonialMS Office-“I will encourage everyone to come for the Ms Office Basic course as the lessons are relevantto work. Teachers are willing to teach until I understood my work”.Odin Marine (Singapore) Pte Ltd, Admin AssistantMS Word-"Next time I want to do another computer course I will definitely consider G-Tec".Homemaker, SingaporeMOS Excel core-"The instructor is friendly and approachable. The course is taught in a detailed andstructured way"Assistant Engineer, SingaporeJava/J2EE Programming Course- “This is the best institution I found in Singapore.Because here thetrainer as well as training was good. The trainers are very good because if we have any doubts they aregiving clarification through mail even after the course completed (Java/J2EE)”.Comdo 2000 Pte Ltd, Software EngineerJava/J2EE Programming Course-“The Java/J2ee course material was well presented and very helpful formy work. I really got a great amount out of it. The one to one training was excellent. It met all myexpectations. I can even try my hand at getting a SCJP cert now. Thanks to GTEC! “.Sylvia Lawrence , IBM , IT Professional.C#.net Programming Course-“G-TEC provides a good trainer qualified. It was a good learningexperience in G-TEC for C#.net”.Emerson Process Management, Software Test Engineer.Our ClientsSingapore Airlines, Bosch, Ministry of Home Affairs, Seagate, Land Transport Authority, NETS , InlandRevenue Authority of Singapore, Tiger Airways, DSO Laboratories, DHL, Changi Airport Group, DBSchenker, National University Hospital,Gemalto, Thales, Housing Development Board,Philips ,Micron,Surbana International Consultants Pte. Ltd., Singapore Polytechnic, ING Bank, Nanyang Polytechnic,Nanyang Technological University, Genetic Technologies Solutions, Singapore Chemical Industry Council(SCIC), State Bank of India , ST Engineering, Emerson Process Management, Keppel FELS , STAerospace, MCI1 Sophia Road, #02-03, Peace Centre, Singapore 228149.Phone: 63360244, 9650 3505, Email: Info.sg@gteceducation.comRegistered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Company ProfileWhat Wedo :Who areourCustomers:Where weare :Our GoalandFocus :G-TEC Computer Education Centre is an Information Technologycompany in the field of Software Training, Technology Resourcingand Knowledge Consulting. We provide Corporate Training, ProjectTraining, and Customized Training, One to One trainings forprofessionals, individuals and students.We have special teaching methodologies to train people indifferent categories ranging from corporate clients to school levelstudents. Over 900000 students are certified by G-TEC all overthe world. We have the privilege of working with some of the mostwell-known companies in the world.G-TEC Computer Education Centre is the largest computereducation networks with more than 510 centers all over the worldand corporate office in Singapore. We are operating in Mexico,Qatar, India, Dubai, Singapore, Kuwait, Srilanka and Iran.Our aim is to make IT education affordable to all sections ofsociety through various projects associating with government’squasigovernment public and private company to reach eachcorner. Our ultimate goal is to achieve cent percentage computerliteracy. We are committed to provide 100% quality training toall; our focus is to provide Quality Education World Wide.Our Location1 Sophia Road, #02-03, Peace Centre, Singapore 228149.Phone: 63360244, 9650 3505, Email: Info.sg@gteceducation.comRegistered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Entry Requirement : Beginners of MS Office Course Duration : 30hrs. Mode of Training : Face to face Instructor led Training Materials : Course books will be provided to each participant Course Overview This course covers Basic to Advanced topics of MS Word, MS Excel, MS www.gteced
