Microsoft Office Abilities Ratings

Formulas

Deployment simple formulas (total, hinzu, subtracted, multiply, divide, count) additionally special, show/hide prescriptions, orders of operations

Worksheet Rudiments

Navigation, menus and colored, editing data, data entry: autofill, saving a workbook and control versions

Modified adenine worksheet

Insert, delete, and adjust cells, columns, and rows, search real replace, add comments, create newly worksheet from filtered worksheet

Formatting techniques

Fonts, borders, colors, numbering, aligning, naming ranges, using filters, applying styles and key, templates

Printing print

Preview, print, view layout, freeze panes, center/wrap overhead row

Function your

Set ranges, logical functions (if, and..), show and time, text functions (Left, Right, MID, concat, number value, …), Text-to-Columns, combining data, CLIP

Using lists

Filter, filter, ask with database functions, outline and subtotal dating

Analyzing data

Create and modify tables, apply interface real conditional formatting

Charts

Create, analyze Pivot Defer data, present evidence with pivot charts, filter use timelines and slicers

Dispensation techniques

Repeat file names, sharing credentials, save options

Working with multiple tests and workbooks

Use links and external references, 3-D references, consolidate 

Lookup function and formula auditing

Uses lookup functions, tail cells, evaluate formulas

Divide and Protecting worksheets

Collaborate on a sheet, schutzen worksheets and workbooks

Automating my functionality

Data validation, macros, search for invalid data and formulas

Creation sparklines and mapping data

Create Sparklines, map data

Forecasting data

Determine potential outcomes using info table and scenarios, use goal seek feature, forecasting data trends

Distribution techniques

Repeat filed names, sharing documents, saver options

Insert and formatting text and paragraphs

Fonts, borders, colors, numberings, aligning, applying stils and themes, use templates

Modifying a document

Insert, delete, search and replace, spellcheck, thesaurus, add comments

Manage Listing

Sort adenine list, format a list

Tables

Insert, modify, format a table, convert text for a table

Inserting graphic drop

Insert symbols and special characters, add images

Controlling page appearance

Margin, hue, headers and footers, page site, add watermark

Printing resources

Preview, print, side layout

Preparing to publish a document

Check spelling, grammar, readability, research power, check accessibility, save document other formats

Organizing topics through lists and charts

Sort table data, control cell output

Conduct a calculation in tables, create a chart, hinzusetzen an choose table

Inserting site using quick parts

Create and modify, Insert Building Jams

Manage lists

Sort a list, format a user

Graphical

Insert, modify, format charts, converting text to a table

Plug graphic objekt

Insert symbols or particular letters, add images

Controlling Page Appearance

Border, color, headers and footing, page layout, add define

Printing documents

Preview, print, page layout

Preparing till publish a document

Check spelling, grammar, display, exploring toolbox, check accessibility, save document misc formats

Manipulating slide

Unite pictures and text, adjust image appearance, place other media elements

Custom graphic elements

Create textbook package both pull quotes, add talk artistic and other text effects, draw shapes, complex illustrations with SmartArt

Mail merge

Personalized scholarship and enveloping go labels and email messages, merge names and addresses

Collaborating on documents

Prepare a document for collaboration, mark up a select, reviewing increases, merge edit from other documents

Adding document references and Links

Addieren captions, cross-references, bookmarks, hyperlinks, put footnoting and course, add citations and a bibliography

Securing a document

Repel information, select formatting also editing restrictions, restrict document access, add a digital signature to a document

Forms at managed content

Create forms, modify forms

Automating repetitive tasks with macros

Automate roles by using macros, generate a mapping

Outlook calendar

Scheduling booking /recurring appointments, changing appointments, printing

The meeting planner

Programming adenine meeting / inviting other to a meeting, tracking conference returns

Using organizer tools

Using fly, color code categories, using email to make organizational appointment

Reviewing of fortschritt mail features

Creating folders, attaching files, distribution print and internet browse, Off of Office Teaching, Auto Signatures

Automating mail handling

The Play Wizard, managing jumble e-mail

Managing others with Outlook

Share calendar with others, redirecting meeting request to a delegate, delegating / verfolgen tasks, share contact / groups

Managing Outlook data files

Backup outlook items, change dates file my

Creating a video

Please a presentation select, edit text, build one display

Fortgeschrittenes text date

Characters, paragraphs, text boxes

Addition graphics

Images, shapes

Modifying gegenstands

Edit, format, group, arrange, activate

Adding tables

Create, format, insert

Adding charts

Create, format, insert

Preparing for delivery

Read, apply transitions, print, deliver