€345,60 €259,20
Office 2016 Course E-learning Complete Package. Companies Gain Time, Money and Energy. How Much Will You Gain? Start Today! 1 Million+ Students
You need to know: About your word processor Opening a document Overview of the environment Moving around a document Displaying the nonprinting characters You need to know: Text made easy Entering text Managing paragraphs You need to know: Selecting, copying, moving Selecting and deleting text Undoing, redoing, repeating an action You need to know: Saving files Saving a document Creating a new document You need to know: Formatting characters Applying a quick style Applying a theme Formatting characters Character colour Character case Character font and size Paragraph indents Paragraph alignment Paragraph spacing Line Spacing Borders and shading Moving text Copying text Page layout Zoom Printing Page breaks You need to know: Headers and footers Headers and footers Page numbering Setting a tab stop Tab stop with a leader line Managing tab stops Numbered and bulleted lists Customised bulleted list Customised numbered list Different levels in a list List styles Line breaks Hanging indents Using Microsoft Word Help Inserting a document/cover page/blank page Hyphenation Nonbreaking space or hyphen Inserting special characters Character spacing and position Finding text/formatting Replacing text/formatting Copying formats Checking spelling and grammar Managing a custom dictionary AutoCorrect settings Finding synonyms Search and translation functions Views and windows Creating a table Moving around/filling in a table Selecting and inserting rows and columns Deleting rows and columns Table styles Formatting cells Row height and column width Alignment in cells, table alignment Merging or splitting cells Converting text to table, table to text Sorting a table or a list of paragraphs Calculating in a table Drawing an object Sizing/rotating/adjusting a drawing object Moving/copying a drawing object Formatting a drawing object Text in a drawing object/WordArt Formatting text in an object/WordArt Inserting a picture Managing a picture Positioning and wrapping a picture Captions and table of illustrations Document background Charts Inserting objects from other applications Diagrams Creating an AutoText Using an AutoText Managing AutoTexts The computer’s date and time Creating envelopes/address labels You need to know: The mail merge Mail merge: associating document and recipients Inserting mail merge fields Running a mail merge Editing the recipients Adding and deleting recipients Sorting a list of recipients Selecting the records to print Conditional text in a mail merge Printing labels via the mail merge Fields for variable data You need to know: Styles and templates Creating a style Using the Styles pane Modifying a style The Normal style Deleting a style Style sets Displaying formatting details Creating and customising a theme Creating and using a template Modifying and deleting templates Changing the template attached to a document Copying styles to other files Moving around a long document Sections Using different headers and footers Managing automatic page breaks Footnotes/endnotes Managing footnotes/endnotes Hierarchy of titles Outline view Table of contents Bookmarks Cross references Hyperlinks Text in columns Master document Index Citations and bibliography Blog posts You need to know: Import, export and interoperability with Word Transfer, export: PDF, XPS, text, web page, e-mail Comments Tracking changes Managing tracked changes Merging and comparing documents Protecting a shared document Protecting a document with a password Finalising a document Digital signatures Drop caps Managing application preferences Statistics and document properties Macros Converting Word documents Creating a form Protecting and using a form Versions and recovery of files You need to know: Customising the ribbon You need to know: The SharePoint site You need to know: The Microsoft account You need to know: Best practice with a word processor
E-mail working environment Managing panes and folders Reading messages You need to know: Text made easy Creating and sending a message You need to know: Formatting characters Managing text in a message Using recipients from an address book Attaching files to a message Managing attachments to a received message Replying to a message Forwarding a message Printing messages Deleting messages Outlook’s calendar Using the reminders window Outlook contacts Creating tasks Creating a note Managing categories Using help Finding messages Managing mail while you are absent Adding a signature to a message Creating an appointment or event Recurrent appointments or events Customising the calendar Printing the calendar and calendar items Personalising print styles Contact groups Sorting and grouping contacts Managing tasks Managing notes You need to know: Selecting, copying, moving Moving or copying items Sending a contact by e-mail Customising views Recording an item in the journal You need to know: Customising the ribbon You need to know: Best practice with an e-mail application Sorting, grouping and filtering messages Managing folders Search folders Managing outgoing messages Message tracking options Message follow-up flags Message templates (forms) Managing meetings Quick steps Recalling and resending a message Electronic business cards Managing Conversation view Managing general e-mail options You need to know: Internet You need to know: Viruses You need to know: Outlook and OWA Archiving messages Optimising the size of the mailbox Exporting and importing a folder Managing a data file Creating rules Managing rules Managing junk e-mail Sharing a folder Calendar groups Sharing calendars
Overview of the working environment Opening a presentation Views Zoom Moving between slides Creating slides You need to know: Selecting, copying, moving Selecting and deleting slides You need to know: Saving files Saving a presentation You need to know: Text made easy Entering text Undoing and redoing an action Copying and moving slides Selecting and editing text Notes pages Playing the slide show Page setCharacter format Character font Character case Character size and spacing Paragraph alignment and columns Bulleted paragraphs Paragraph spacing and interline Copying formatsup and orientation Print preview and printing Creating a new presentation Themes and layouts Selecting and deleting objects Repositioning objects Grid and guides Drawing shapes Copying and duplicating objects Resizing objects Formatting objects Formatting lines Creating a text box or WordArt object Formatting a text object Text effects Copying an object’s formatting Rotating objects Inserting a picture, saving a picture Formatting pictures Managing pictures Inserting a chart Selecting and deleting chart items Chart data Layout of chart item
Checking the spelling Synonyms and translation Finding and replacing text Rulers Paragraph indents Managing tab stops Managing the outline Repositioning text in an outline Creating a presentation from a Word document Modifying objects Applying effects to objects Aligning and distributing objects Changing the stacking order of objects Grouping/ungrouping objects Formatting a chart Inserting an object from another application Table styles Modifying and formatting a table Managing rows and columns in a table Managing cells in a table Inserting a SmartArt diagram Managing a SmartArt diagram Formatting a SmartArt diagram Creating a hyperlink You need to know: Headers and footers Headers and footers Inserting slides from another presentation Sections Inserting audio/video content Managing audio/video content Associating an action with an object Animating objects Customising animation effects Animating text Running animations automatically Transition effects Advancing the slides automatically Writing on slides during the slide show
Managing chart templates Slide background Customising a theme The slide master Managing layouts Managing placeholders Formatting slide masters Using slide masters The notes master The handout master Custom slide shows Choosing the slides for the slide show You need to know: Styles and templates Creating and using a presentation template Presentation propertiesFinalising presentations Digital signatures You need to know: Versions and recovery of files You need to know: Customising the ribbon You need to know: The SharePoint site You need to know: Sharing a document over the internet You need to know: Best practice with a presentation program Comparing presentations Protecting a presentation with a password
You need to know: About your spreadsheet application Opening a workbook Overview of the environment Moving around a workbook You need to know: Text made easy Entering data You need to know: Selecting, copying, moving Selecting and deleting cells Undoing and redoing an action Column width/row height You need to know: Saving files Saving a workbook Modifying the contents of a cell Creating a new workbook Entering a calculation formula Calculating a sum and other basic functions Calculating a percentage Reproducing data in adjacent cells Simple numerical formats Applying a theme You need to know: Formatting characters Formatting characters Character font and size Aligning cell content Cell colour Cell borders Page layout Print preview and printing Page breaks Print areas You need to know: Headers and footers Headers and footers Using Microsoft Excel Help Checking spelling Find and replace Zoom Inserting/deleting rows columns and cells Moving cells Copying to non-adjacent cells Copying cell format quickly Merging cells Orientation of cell content Cell styles Sorting data Sheet name, tab colour Inserting and deleting sheets, sheet background Moving, copying, hiding sheets Splitting the window, freeze a column/row Repeating rows/columns on printed pages Hiding elements of a sheet Summarising data with an outline
Displaying several lines of data in one cell Absolute reference in a formula Copying values, copying with a link You need to know: Calculating with functions Control date, date formats Simple conditions Custom formats Applying a conditional format Managing conditional formats Naming a range of cells Validation rules Multiple cell ranges and calculations in functions You need to know: Charts Creating and positioning a chart Managing a chart Selecting items in a chart Adding and removing items Formatting chart items Modifying a chart's text items Legend and plot area Printing and page layout of a chart Modifying data labels Data series and chart axes Managing series Chart type options Managing chart templates Creating a sparkline Managing sparklines Creating a drawing object Selecting and deleting objects Copying and moving objects Resizing a drawing object Modifying a text box Modifying a drawing Formatting drawing objects Inserting a picture Managing pictures Rotating and aligning objects Stacking and grouping objects Subtotal rows Creating and managing a table Presenting and sorting data in a table Automatic calculations in a table Automatic filtering Custom filters Blank cells and duplicates You need to know: Advanced filtering with a criteria range Criteria ranges Copying rows filtered using a criteria range Statistics with a criteria range You need to know: Flash Fill You need to know: Pivot tables and pivot charts Creating a pivot table Modifying a pivot table Selecting Defining the layout and the presentation of a pivot table Filtering and searching for data in a pivot table Pivot charts
Converting data Creating a data series Custom views Attaching a comment to a cell Detecting errors Evaluating formulas The Watch Window Lookup functions Text functions Time calculations Date calculations Condition with AND Nested conditions Conditional functions Array formulas Calculating with copied values Consolidation Financial functions Double entry data table Goal seek The Solver Managing scenarios Hyperlinks Creating and customising a theme You need to know: Styles and templates Creating and working with templates Modifying and deleting templates You need to know: Exporting data Diffusing Excel data: PDF Converting Excel files Importing data Updating and managing imported data Workbook properties Protecting workbooks Protecting specific cells Sharing a workbook Tracking changes in a workbook Merging workbooks Finalising a workbook Digital signatures Creating a form Protecting and using a form Macros Versions and recovery of files You need to know: Customising the ribbon You need to know: The SharePoint site You need to know: Office Online and Office 365 You need to know: Best practice with a spreadsheet application You need to know: Sharing a workbook
Theme by InStijl Media