LONESTAR
ACADEMY
Courses
Log In
Join Free
Home
Courses
IT: Cybersecurity, Web & Productivity
Advanced Productivity and Collaboration
Curriculum
1 Section
74 Lessons
30 hours
Expand all sections
Collapse all sections
Unit 4 — Advanced Productivity and Collaboration
74
1.1
Indenting Paragraphs and First Lines
20 mins
1.2
Aligning Text in Columns and Rows
20 mins
1.3
Proofing Text Written in a Foreign Language
20 mins
1.4
Working with Text Boxes
20 mins
1.5
Churning Out Letters, Envelopes, and Labels for Mass Mailings
20 mins
1.6
Putting Cross-References in a Document
20 mins
1.7
Establishing Data-Validation Rules
20 mins
1.8
Selecting Cells in a Worksheet
20 mins
1.9
Working with Functions
20 mins
1.10
Analyzing Data with PivotTables
20 mins
1.11
Creating New Slides for Your Presentation
20 mins
1.12
Using Master Slides and Master Styles for a Consistent Design
20 mins
1.13
Putting Footers (and Headers) on Slides
20 mins
1.14
Recording a Voice Narration for Slides
20 mins
1.15
Delivering a Presentation When You Can’t Be There in Person
20 mins
1.16
Cleaning Out Your Folders
20 mins
1.17
Handling Files That Were Sent to You
20 mins
1.18
Managing Meetings with the Calendar
20 mins
1.19
Establishing Relationships among Database Tables
20 mins
1.20
Understanding and Using the Layout Guides
20 mins
1.21
Inserting Frames on the Pages
20 mins
1.22
Saving a Chart as a Template So That You Can Use It Again
20 mins
1.23
Changing a Diagram’s Direction
20 mins
1.24
Inserting a 3-D Model
20 mins
1.25
Sharing Files Outside Your Organization
20 mins
1.26
Locking a File with a Password
20 mins
1.27
Getting Word to Read It
20 mins
1.28
Numbering the Pages
20 mins
1.29
Merging and Splitting Cells
20 mins
1.30
Translating Foreign Language Text
20 mins
1.31
Dropping In a Drop Cap
20 mins
1.32
Putting Footnotes and Endnotes in Documents
20 mins
1.33
Deleting, Copying, and Moving Data
20 mins
1.34
A Look at Some Very Useful Functions
20 mins
1.35
Getting a Better View of Your Work
20 mins
1.36
Techniques for Organizing Email Messages
20 mins
1.37
Making Frames Overlap
20 mins
1.38
Chart Tricks for the Daring and Heroic
20 mins
1.39
Choosing a Look for Your Diagram
20 mins
1.40
WordArt for Embellishing Letters and Words
20 mins
1.41
Trusting (or not Trusting) Microsoft with Your “Content”
20 mins
1.42
Entering Information Quickly in a Computerized Form
20 mins
1.43
Putting Headers and Footers on Pages
20 mins
1.44
Repeating Header Rows on Subsequent Pages
20 mins
1.45
Watermarking for the Elegant Effect
20 mins
1.46
Compiling a Bibliography
20 mins
1.47
Handling the Worksheets in a Workbook
20 mins
1.48
Hiding and Displaying the Slides Pane and Notes Pane
20 mins
1.49
All about Email Folders
20 mins
1.50
Inserting, Removing, and Moving Pages
20 mins
1.51
Troubleshooting a Chart
20 mins
1.52
Changing the Appearance of Diagram Shapes
20 mins
1.53
Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects
20 mins
1.54
Adjusting the Space Between Lines
20 mins
1.55
Formatting Your Table
20 mins
1.56
Putting Newspaper-Style Columns in a Document
20 mins
1.57
Keeping Others from Tampering with Worksheets
20 mins
1.58
Selecting, Moving, and Deleting Slides
20 mins
1.59
Yes, You Can Prevent Junk Mail (Sort of)
20 mins
1.60
Creating a Diagram from Scratch
20 mins
1.61
Changing an Object’s Size and Shape
20 mins
1.62
Adjusting the Space Between Paragraphs
20 mins
1.63
Using Math Formulas in Tables
20 mins
1.64
Landscape Documents
20 mins
1.65
Putting Together a Photo Album
20 mins
1.66
Changing an Object’s Color, Outline Color, and Transparency
20 mins
1.67
Creating Numbered and Bulleted Lists
20 mins
1.68
Neat Table Tricks
20 mins
1.69
Printing on Different Size Paper
20 mins
1.70
Hidden Slides for All Contingencies
20 mins
1.71
Moving and Positioning Objects
20 mins
1.72
Working with Tabs
20 mins
1.73
Showing Online Video in a Document
20 mins
1.74
Hyphenating Text
20 mins
This content is protected, please
login
and
enroll
in the course to view this content!
S
Ask SIERA
YOUR DIGITAL ASSISTANT
×
Modal title
Main Content