Rating 4.25 out of 5 (2 ratings in Udemy)
What you'll learn- Microsoft Word & Excel tools, tips and shortcuts for administrative staff in schools
DescriptionThis program is designed for administrative staff in schools who want help increasing their productivity with Word &Excel but want it to relate to their specific school environment. It focuses on the elements of Microsoft Word &Excel that administrative staff in schools need to know to get more done with less stress.
With over …
Rating 4.25 out of 5 (2 ratings in Udemy)
What you'll learn- Microsoft Word & Excel tools, tips and shortcuts for administrative staff in schools
DescriptionThis program is designed for administrative staff in schools who want help increasing their productivity with Word &Excel but want it to relate to their specific school environment. It focuses on the elements of Microsoft Word &Excel that administrative staff in schools need to know to get more done with less stress.
With over two hours of content including a downloadable workbook, topics covered are essential skills ALLstaff working in schools need to get their day to day work done.
Topics include:
Microsoft Excel
Shortcuts to select data
Tips for duplicating worksheets (with formatting intact)
How to make global changes to worksheets
Understanding basic Excel formulas and functions
Charts/Graphs
How to print column and row titles on pages
Fast track formatting
Sorting &Filtering Data
Freeze Headings
How to format data that meets a specific criteria
How to print a worksheet on a single page
How to set up headers and footers
How to calculate totals across multiple worksheets in a file
Row to remove duplicates
Tools to tidy up data imported from other programs
Understanding VLOOKUPfunction
Utilizing Hyperlinks
Understanding Pivot Tables
How to Subtotal data lists
Protecting Cells
What macros are and how to create them
Microsoft Word
Setting up defaults
Understanding page breaks
How to copy and paste right every time!
How to use automated features to insert text
Working with headers and footers
Fast tracking formatting
Saving documents as PDF's
Understanding how to utilize bullets
How to insert a file name and path in a document
How to insert a cover page
How to insert page numbers
How to insert one document into another
How to insert an Excel worksheet into a Word document
Working with pictures
Utilizing styles to make data consistent
How to create tables of content
Creating and working with templates
Inserting watermarks
How to use Word to create basic forms
Plus each section has a short quiz to check in on what you have learnt
PLUS- BONUSSection - "how to" video and resource booklet
How to perform a Mail Merge in Microsoft Word using a Microsoft Excel spreadsheet as the data source.
This course is aMUSTfor anyone who working in an administrative role in a school!
