€326,40 €244,80
Office 2013 Course E-learning Basics and Intermediate. 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
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
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
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
Theme by InStijl Media