€307,20 €230,40
Office 2013 Course E-learning Intermediate. Companies Gain Time, Money and Energy. How Much Will You Gain? Start Today! 1 Million+ Students
Create a table Creating and filling in tables in Word. 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 Inserting a picture Document background Charts Diagrams Formatting a drawing object Text in a drawing object/WordArt Formatting text in an object/WordArt Managing a picture Positioning and wrapping a picture Inserting objects from other applications Inserting a document/cover page/blank page Hyphenation Inserting special characters Character spacing and position Drop caps Managing a custom dictionary AutoCorrect settings Search and translation functions Statistics and document properties Creating a form Protecting and using a form Views and windows 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
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
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
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
Theme by InStijl Media