Course Description
<ul> <li>Learn the essential Microsoft Office Skills in this three-course bundle: Excel, Word and PowerPoint</li> <li>Discover new and improved features in Excel 2019.</li> <li>Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.</li> <li>Discover how to format dates and numbers in Excel.</li> <li>Learn practical methods to backup and recover your Excel spreadsheets and never lose data.</li> <li>Effectively use autofill and flashfill so you are more productive in Microsoft Excel.</li> <li>Discover the essentials of using formulas and functions</li> <li>Discover how to create stunning charts and graphs in Excel</li> <li>Learn practical methods to sort and filter your data</li> <li>Discover new features in PowerPoint 2019 including Icons and 3D Models</li> <li>Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint</li> <li>Add charts, graphs and tables to present information in a non-text format</li> <li>Wow your audience by adding animations, audio and video</li> <li>Discover practical tips to present your presentation to your audience</li> <li>Learn time saving techniques including how to copy slides, and exporting your presentation</li> <li>Master the most common uses of Microsoft Word</li> <li>How to controlling page appearance including using columns, indents, footers, borders and watermarks.</li> <li>How to create a mail merge in Microsoft Word</li> <li>Learn how to correctly Print envelopes and labels in Word</li> <li>Learn to protect your Word document from changes</li> <li>Insert professional pictures and graphics in your Word document</li> <li>Make your Word documents look amazing by inserting and editing tables</li> </ul>
Curriculum
- Computer Basics
- Basic Computer Skills
- Typing Tutorial
- Computer Science
- Tech Savvy Tips and Tricks
- Internet Basics
- Google Chrome
- Internet Tips
- Internet Safety
- Email Basics
- Gmail
- Beyond Email
- Google Account
- Google Drive
- Google Classroom
- Google Classroom Mobile App
- Word Basics
- Getting Started with Word
- Understanding OneDrive
- Creating and Opening Documents
- Saving and Sharing Documents
- Working with Text
- Text Basics
- Formatting Text
- Using Find and Replace
- Indents and Tabs
- Line and Paragraph Spacing
- Lists
- Links
- Layout and Printing
- Page Layout
- Printing Documents
- Breaks
- Columns
- Headers and Footers
- Page Numbers
- Working with Objects
- Pictures and Text Wrapping
- Formatting Pictures
- Shapes
- Text Boxes
- Aligning, Ordering, and Grouping Objects
- Tables
- Charts
- Collaboration and Reviewing
- Checking Spelling and Grammar
- Track Changes and Comments
- Inspecting and Protecting Documents
- Doing More with Word
- SmartArt Graphics
- Applying and Modifying Styles
- Mail Merge
- Excel Basics
- Getting Started with Excel
- Creating and Opening Workbooks
- Saving and Sharing Workbooks
- Working with Cells and Sheets
- Cell Basics
- Modifying Columns, Rows, and Cells
- Formatting Cells
- Understanding Number Formats
- Working with Multiple Worksheets
- Using Find & Replace
- Checking Spelling
- Page Layout and Printing
- Formulas and Functions
- Intro to Formulas
- Creating More Complex Formulas
- Relative and Absolute Cell References
- Functions
- Working with Data
- Basic Tips for Working with Data
- Freezing Panes and View Options
- Sorting Data
- Filtering Data
- Groups and Subtotals
- Tables
- Charts
- Conditional Formatting
- Doing More with Excel
- Comments and Co-authoring
- Inspecting and Protecting Workbooks
- Intro to PivotTables
- Doing More with PivotTables
- What-if Analysis
- PowerPoint Basics
- Getting Started with PowerPoint
- Creating and Opening Presentations
- Saving Presentations
- Working with Slides
- Slide Basics
- Text Basics
- Applying Themes
- Applying Transitions
- Managing Slides
- Using Find & Replace
- Printing
- Presenting Your Slide Show
- Text and Objects
- Lists
- Indents and Line Spacing
- Inserting Pictures
- Formatting Pictures
- Shapes
- Aligning, Ordering, and Grouping Objects
- Animating Text and Objects
- More Objects
- Inserting Videos
- Inserting Audio
- Tables
- Charts
- SmartArt Graphics
- Review and Collaborating
- Checking Spelling and Grammar
- Reviewing Presentations
- Inspecting and Protecting Presentations
- Customizing Your Presentation
- Modifying Themes
- Slide Master View
- Links
- Action Buttons
- Rehearsing and Recording Your Presentation
- Sharing Your Presentation Online
- Google Docs
- Google Sheets
- Google Slides
- Google Tips
- Google Maps
- Google Hangouts
- Google Meet
- Google Keep
- Digital Photography
- Image Editing 101
- Photoshop Basics
- Beginning Graphic Design
- Design in the World Around Us
- Creativity
- Canva
- Buying Computers
- Buying Other Tech Devices
- Buying Smartphones
- Buying Tablets
- Critical Thinking and Decision Making
- The Now
- Wearables
- Freelance Work
- Sharing Economy
- Adapting to Change
- Learning Tips
- Search Better
- Digital Media Literacy
- Use Information Correctly
- Andriod Basics
- Mobile Device Tips
- Blog Basics
- LinkedIn Basics
- Skype
- Snapchat
- YouTube
- Zoom
- Job Applications
- Resume Writing
- Cover Letters
- Interviewing Skills
- Objective Exam
- Written Exam
