Ms Office 2013: 10-In-1 Courses To Maximize Productivity

Comprehensive, all-in-one training to get the most out of Microsoft Office 2013. 10-in-1 courses with 80 hours of video.

What you'll learn
Introductory tutorials for Microsoft Excel 2013
Introductory tutorials for Microsoft Word 2013
Introductory tutorials for Microsoft Outlook 2013
Introductory tutorials for Microsoft PowerPoint 2013
Introductory tutorials for Microsoft Access 2013
Introductory tutorials for Microsoft Publisher 2013
Advanced training for Excel 2013
Advanced training for Access 2013
Essential Visual Basic for Applications (VBA) for Excel
Requirements
Microsoft Office 2013
Description
Unlock the Power Of Microsoft Office and Watch Your Productivity Soar!
Microsoft Office is the #1 office software used by +1 billion people worldwide. While many are familiar with Microsoft Office's basic features, few people know about its more advanced capabilities that are designed to save you time, money, and effort.
Using step-by-step instructions, Simon Sez IT will quickly guide you through the most popular programs of Microsoft Office 2013: Excel, Word, Outlook, PowerPoint, Access, and Publisher. In addition to mastering the basic features, you'll also learn highly useful advanced capabilities of both Excel and Access.
For example, Visual Basic for Applications (VBA) for Excel will show you how to automate repetitive tasks and operations that you perform frequently. This valuable time saving tool and productivity enhancer is a critical tool for anyone who uses Excel frequently.
Work inefficiencies add up quickly over time. If you're always 'learning the hard way' when using Microsoft Office 2013, or under-utilizing its full capabilities, then you'll want to invest in these game-changing courses that include lifetime Udemy access. Let your work productivity soar so that you'll have more time for the other things in life that matter!
**** Updated November 18, 2015: New Course Added: VBA Intermediate Training: Discover Excel Automation Secrets
Contents and Overview
In this 10-in-1 course collection, we'll show you important yet often over-looked or unknown features that will help skyrocket your productivity.
Microsoft Excel 2013 - Introductory: Spreadsheets for data analysis and formulas for tracking expenses.Microsoft Excel 2013 - Advanced: apply functions, filter data, and create advanced spreadsheet visuals. Microsoft Word 2013: Introductory course on creating documents and brochures, embedding videos, and set up for online collaboration.Microsoft Outlook 2013: Introductory course on email efficiencies to help clear the email clutter and gain control of your inbox.Microsoft PowerPoint 2013: Introductory course on how to create dazzling presentations using animation, audio/video, and collaborative tools with minimal time and effort.Microsoft Access 2013 – Introductory: creating and using databases to become a master of data management, tracking customer information and buying patterns.Microsoft Access 2013 – Advanced: improve your database reporting and information security.Microsoft Publisher 2013: Introductory course on print publications to create professional-looking print material that communicates your organization's strengths and purpose.Microsoft Essential VBA for Excel: learn how to automate repetitive and time-consuming Excel procedures and operations for maximum efficiency. VBA Intermediate Training: Discover Excel Automation Secrets: learn
advanced methods for automating tedious Excel jobs, the next step for anyone
who has completed basic VBA.
This Course Includes
10 individual courses80 hours of training tutorialsHundreds of educational videosExercise filesA certificate of completion
Why Take This Course
Most work today happens on a computer – optimize your effort by learning useful software tips and tricks that you'll apply for decades to come! And that will save you valuable time, money and effort.
Want to get noticed by your boss or earn the respect of your colleagues? Become the office superstar by becoming the go-to expert on everything related to MS Office 2013!
Individual video training for these 6 programs would easily cost thousands of dollars, but this 10-in-1 package is available at one unbelievably low price. Tremendous learning at tremendous savings.
What Others Are Saying:
"Goes step by step with clear and simple instructions. Takes time in explaining each set before moving to the next."- Judy Weismann
"Great online tutorial. Instructor goes slowly and uses great visuals. Easy to understand." - Lisa Armstrong
"Instructor's lecture is easy to understand, and he leads at a comfortable pace. His technique of explanation is superior to many other courses I have taken on Udemy thus far."  - Erma Trent
"I feel as though the teacher is talking to me and he explains everything with great clarity. I wish I knew about this course before, I really feel a lot of respect and admiration for how serious he is in explaining every little thing step by step." - A. Shan

Overview

Section 1: Learn Microsoft Excel 2013 Beginner Course

Lecture 1 Introduction

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 Excel 2013 Exercise Files

Lecture 4 Downloadable Course Transcripts

Lecture 5 What's New

Lecture 6 Overview of Principles

Lecture 7 Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns

Lecture 8 Templates; Creating, Opening, and Saving a Workbook

Lecture 9 Online, Offline, and Contextual Help

Lecture 10 Excel Options

Lecture 11 Ribbon Interface

Lecture 12 Quick Access Toolbar

Lecture 13 Mini Toolbar

Lecture 14 Create Backup Option; Auto-Recover and Autosave

Lecture 15 Entering Text and Numbers

Lecture 16 Date Formats

Lecture 17 Formatting Cells; Editing and Deleting Data

Lecture 18 Fill

Lecture 19 Flash Fill

Lecture 20 Themes and Cell Styles

Lecture 21 Inserting, Deleting, Hiding and Adjusting Rows and Columns

Lecture 22 Wrap Text and Alignment

Lecture 23 Merging Cells; Applying Themes and Styles

Lecture 24 Borders

Lecture 25 Copy, Cut and Paste

Lecture 26 Spell checking

Lecture 27 Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets

Lecture 28 Inserting Comments

Lecture 29 Workbook Views, Zoom and Freeze

Lecture 30 Printing; Headers, Footers and Margins

Lecture 31 Overview of Formulas and Functions

Lecture 32 Cell References

Lecture 33 Names

Lecture 34 Finding Errors; New Excel Functions

Lecture 35 Multiple Workbooks and Windows; Comparing Workbooks

Lecture 36 Go to; Find and Replace Options

Lecture 37 Applying, Clearing and Managing Rules

Lecture 38 Chart Types; Chart Recommendation

Lecture 39 Basic Formatting

Lecture 40 Selecting Data, Positioning and Printing Charts

Lecture 41 Saving Workbooks; PDF and CSV Formats

Lecture 42 Sorting

Lecture 43 Filtering

Lecture 44 Tables

Lecture 45 VLOOKUP

Lecture 46 Text Function

Lecture 47 Date and Time Functions

Lecture 48 Logical Functions

Lecture 49 Financial Analysis Case Study - Part 1

Lecture 50 Financial Analysis Case Study - Part 2

Lecture 51 Quick Analysis Tool

Lecture 52 Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt

Lecture 53 Protecting Worksheets

Lecture 54 Protecting Workbooks

Lecture 55 Sharing and SkyDrive

Lecture 56 Trust Center; Export; Inspect Workbook

Lecture 57 Summary; More Help

Section 2: Learn Microsoft Excel 2013 Advanced Training Course

Lecture 58 Prerequisites of Excel 2013 Advanced Course

Lecture 59 WATCH ME: Essential Information for a Successful Training Experience

Lecture 60 Excel 2013 Advanced Exercise Files

Lecture 61 Downloadable Course Transcripts

Lecture 62 List of Functions; Common Types of Arguments; Basic Use of Functions

Lecture 63 Advanced Aspects of Functions; Searching for a Function

Lecture 64 Autosum

Lecture 65 Payment

Lecture 66 Future Value

Lecture 67 Principle Payment

Lecture 68 Depreciations

Lecture 69 How Dates and Times are Stored

Lecture 70 Dates and Times Calculation

Lecture 71 Exercise on Date and Time Functions; Date and Time Settings

Lecture 72 Average

Lecture 73 Percentile

Lecture 74 Regression

Lecture 75 LINEST Function

Lecture 76 Example of Functions for Inferential Statistics

Lecture 77 Text Function Case Study - 1

Lecture 78 Text Function Case Study - 2

Lecture 79 Lookup and Reference Functions

Lecture 80 Logical Functions

Lecture 81 Connecting to Other Workbooks

Lecture 82 Connecting to Access Data

Lecture 83 Connecting to Web Data

Lecture 84 Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row

Lecture 85 Inserting Columns and Rows; Resizing Tables

Lecture 86 Table Reference

Lecture 87 Table Styles

Lecture 88 Table Selection

Lecture 89 Basic Principles of Pivot Tables

Lecture 90 Presentational Side of Pivot Tables

Lecture 91 Filtering in Pivot Tables; Slices

Lecture 92 What if

Lecture 93 Scenario Manager

Lecture 94 Goal Seeker

Lecture 95 Solver

Lecture 96 Area Charts

Lecture 97 Surface Charts

Lecture 98 Stock Charts - Part 1

Lecture 99 Stock Charts - Part 2

Lecture 100 Radar Charts

Lecture 101 Bubble Charts

Lecture 102 Regression and Scatter Chart

Lecture 103 Creating Pivot Charts

Lecture 104 Using Sparklines

Lecture 105 Creating Workbooks using a Web App

Lecture 106 Sharing your Workbook

Lecture 107 Closing

Section 3: Learn Microsoft Word 2013

Lecture 108 Acquiring Word 2013; Information about Installing and Upgrading

Lecture 109 WATCH ME: Essential Information for a Successful Training Experience

Lecture 110 Word 2013 Exercise Files

Lecture 111 Downloadable Course Transcripts

Lecture 112 What's New

Lecture 113 Overview of Principles

Lecture 114 Starting and Exiting; Templates; Creating, Opening and Saving Documents

Lecture 115 Word Workspace; Backstage View

Lecture 116 Online and Offline Help

Lecture 117 Settings and Preferences

Lecture 118 The Ribbon

Lecture 119 Quick Access Toolbar

Lecture 120 Mini Toolbar/Bar

Lecture 121 Setting Up AutoSave and AutoRecover Preferences

Lecture 122 Typing, Editing, and Deleting Text; Customizing Status Bar

Lecture 123 Navigation; Word Wrapping; Making a Selection

Lecture 124 Inserting Symbols, Date and Time, and Document Property

Lecture 125 Various Methods of Copying, Cutting and Pasting

Lecture 126 Uses of Navigation Pane

Lecture 127 Find and Replace; Go to

Lecture 128 Keyboard Shortcuts and Key Tips

Lecture 129 Print Layout, Web Layout and Draft Views; Ruler and Gridlines

Lecture 130 Zoom

Lecture 131 Read Mode

Lecture 132 Spelling and Grammar Errors; Language Settings

Lecture 133 AutoCorrect; Proofing Settings; Spell Checking

Lecture 134 Fonts, Font Size, and Font Colors; Text Effect and Text Highlight

Lecture 135 Alignment; Line and Paragraph Spacing; Indent

Lecture 136 Fill/Shading; Border Tab; Format Painter

Lecture 137 Bulleted, Numbered and Multilevel Lists

Lecture 138 File Formats

Lecture 139 Printing

Lecture 140 Page Layout, Sections and Margins

Lecture 141 Headers, Footers and Page Numbers

Lecture 142 Using Templates

Lecture 143 Using Themes and Styles

Lecture 144 Opening and Editing PDFs

Lecture 145 Creating a Table; Inserting, Selecting and Deleting Rows and Columns

Lecture 146 Formatting Tables

Lecture 147 Inserting, Cropping, Resizing and Positioning Pictures

Lecture 148 Picture Styles; Picture Adjustments, Corrections and Effects

Lecture 149 Online Pictures and Clipart

Lecture 150 Inserting and Formatting Shapes and Textbox

Lecture 151 Smart Art and WordArt

Lecture 152 Screenshots

Lecture 153 Creating Charts

Lecture 154 Resume Reading and Editing

Lecture 155 Object Zoom

Lecture 156 Mail Merge Wizard Part 1

Lecture 157 Mail Merge Wizard Part 2

Lecture 158 Send to Email; Post to Blog; SkyDrive; Invite People

Lecture 159 Restrict Editing, Comments, Simple Markup and Tracking Changes

Lecture 160 Navigation, Headings, Table of Contents, Update Page numbers and Outline View

Lecture 161 Watermarks

Lecture 162 Page Borders

Lecture 163 Types of Hyperlinks

Lecture 164 Inspecting and Protecting Documents

Lecture 165 Microsoft Update; Closing

Section 4: Learn Microsoft Outlook 2013

Lecture 166 Information about Installation and Upgrade

Lecture 167 READ ME: Essential Information for a Successful Training Experience

Lecture 168 Downloadable Course Transcripts

Lecture 169 What's New in Outlook 2013

Lecture 170 Using Touch

Lecture 171 Online, Offline, and Contextual Help

Lecture 172 Outlook 2013 Workspace

Lecture 173 The Ribbon

Lecture 174 Quick Access Toolbar

Lecture 175 Mini Toolbars

Lecture 176 Contextual Menu

Lecture 177 Status Bar

Lecture 178 Customizing Settings and the Use of Outlook

Lecture 179 List of Keyboard Shortcuts; Using Key Tips

Lecture 180 Setting Up an Account

Lecture 181 Sending and Receiving Email

Lecture 182 Creating Appointments and Scheduling Meetings

Lecture 183 Adding Contacts

Lecture 184 Adding Tasks

Lecture 185 Creating Notes

Lecture 186 Managing RSS Feeds

Lecture 187 Printing Emails and Contacts; Print Properties

Lecture 188 Favorites; PST and OST Files; Folder Size

Lecture 189 Setting Up Gmail and POP Accounts

Lecture 190 Adding New Folder, Moving and Deleting Items, and Emptying Folders

Lecture 191 Backup and Restore a PST file

Lecture 192 AutoArchive and Manual Archive

Lecture 193 Import and Export Wizard

Lecture 194 Calendar Options

Lecture 195 Calendar Amendments and Rescheduling

Lecture 196 Calendar Recurrence

Lecture 197 Calendar Attachments

Lecture 198 Calendar Events

Lecture 199 Managing Reminders

Lecture 200 Basics of Search; Searching Contacts

Lecture 201 Search Folders

Lecture 202 Color Categories

Lecture 203 Managing Tasks

Lecture 204 Contacts Options

Lecture 205 Contact Information

Lecture 206 Outlook Social Connector

Lecture 207 Contact Views

Lecture 208 Contact Groups

Lecture 209 Email Options

Lecture 210 Email Send and Receive Settings

Lecture 211 Composing Email

Lecture 212 Email Signatures

Lecture 213 Email Inbox

Lecture 214 Email Actions

Lecture 215 Touch Action Bar

Lecture 216 Junk Email

Lecture 217 Stationery

Lecture 218 Rules

Lecture 219 Quick Steps

Lecture 220 Outlook Journal

Lecture 221 Mail Merge using Word

Lecture 222 Trust Center

Lecture 223 Microsoft Updates; Closing

Section 5: Learn Microsoft PowerPoint 2013

Lecture 224 Acquiring PowerPoint 2013

Lecture 225 WATCH ME: Essential Information for a Successful Training Experience

Lecture 226 PowerPoint 2013 Exercise Files

Lecture 227 Downloadable Course Transcripts

Lecture 228 What's New in PowerPoint 2013

Lecture 229 Using Touch

Lecture 230 PowerPoint Workspace; Opening, Saving and Exiting

Lecture 231 Backstage View; Protecting Presentations; Editing Properties

Lecture 232 Online and Offline Help

Lecture 233 Customize Settings and Preference

Lecture 234 The Ribbon

Lecture 235 Quick Access Toolbar

Lecture 236 Mini Toolbar

Lecture 237 Status Bar

Lecture 238 Backup Files; Adjust AutoSave; Recover Unsaved Presentation

Lecture 239 New Blank Presentation; Slide Size, Orientation and Background

Lecture 240 Adding Contents; Adding and Deleting Slides

Lecture 241 Adjusting View and Adding Notes in Normal View; Promote/Demote

Lecture 242 Moving Slides in Slide Sorter View; Notes Page and Reading View

Lecture 243 Zoom

Lecture 244 Undo and Redo Actions; Set Maximum Number of Undos

Lecture 245 Adding and Formatting Text; Placeholder Textbox

Lecture 246 Manual Textbox; Inserting Symbols

Lecture 247 Using Clipboard and Mini Toolbar; Paste Option

Lecture 248 AutoCorrect and Proofing

Lecture 249 Templates, Slides and Masters

Lecture 250 Background Color, Themes and Layouts

Lecture 251 Header and Footer

Lecture 252 Bulleted and Numbered Lists

Lecture 253 Alignment, Line Spacing, Ruler and Tabs

Lecture 254 Inserting Pictures

Lecture 255 Formatting Pictures

Lecture 256 Photos and Photo Albums

Lecture 257 Clip Art

Lecture 258 Screenshots

Lecture 259 Drawing and Formatting Shapes

Lecture 260 Creating Complex Shapes

Lecture 261 SmartArt

Lecture 262 Save Options, Create PDF/XPS Document, Change File Type

Lecture 263 Creating and Formatting Tables

Lecture 264 Creating Charts using Excel; Editing Data, Chart Type and Chart Element

Lecture 265 Basics of Animation

Lecture 266 Controlling Animation; Motion Path

Lecture 267 Animation of SmartArt

Lecture 268 Printing Slides and Handouts

Lecture 269 Linking to a Webpage and a Slide

Lecture 270 Aligning Objects; Grid and Guides; Nudging

Lecture 271 Spell check; Create Handouts and Videos; Inspect Document; Hide Slide

Lecture 272 Transitions and Timings; Setting up and Recording a Slide Show

Lecture 273 Manual Presentation; Presenter View and Tools

Lecture 274 Comments

Lecture 275 Saving your Presentation on SkyDrive

Lecture 276 PowerPoint Web App; Send Email; Get a Link

Lecture 277 Presenting on the Web

Lecture 278 Inserting and Formatting Video; Adding Audio

Lecture 279 Protecting your Presentation; Trust Center; Closing

Section 6: Learn Microsoft Access 2013 Beginner Course

Lecture 280 Acquiring Access 2013; Course Overview

Lecture 281 WATCH ME: Essential Information for a Successful Training Experience

Lecture 282 Access 2013 Exercise Files

Lecture 283 Downloadable Course Transcripts

Lecture 284 What's New in Access 2013

Lecture 285 Using Touch

Lecture 286 Database Templates; Creating, Opening and Saving Databases

Lecture 287 Workspace and Backstage View

Lecture 288 Online, Offline, and Contextual Help

Lecture 289 Finding Keyboard Shortcuts and Key Tips

Lecture 290 Customizing the Settings and Use of Access 2013

Lecture 291 The Ribbon

Lecture 292 Quick Access Toolbar

Lecture 293 Customizing the Status Bar

Lecture 294 Overview of the Main Features of Access Database

Lecture 295 Web App Basics

Lecture 296 Creating Tables - Part 1

Lecture 297 Creating Tables - Part 2

Lecture 298 Relationships Between Tables - Part 1

Lecture 299 Relationships Between Tables - Part 2

Lecture 300 Inserting and Formatting Fields; Field Validation; Navigation Buttons

Lecture 301 Sorting, Filtering and Finding Data

Lecture 302 Entering Data; Changing the Order of Columns, Field Width and Height

Lecture 303 Design View; Field Properties

Lecture 304 Saving Data; Data Types, Attachments and Field Size

Lecture 305 Input Masks; More on Field Properties

Lecture 306 Creating Forms; Form Wizard

Lecture 307 Single Forms; Insert, Delete, Modify, Sort and Filter Records

Lecture 308 Layout View; Adding Existing Fields

Lecture 309 Design View; Arranging Fields

Lecture 310 Controls

Lecture 311 Form Design

Lecture 312 Query Design

Lecture 313 Joins and Query Wizard

Lecture 314 Query Types

Lecture 315 Operators and Expressions - Part 1

Lecture 316 Operators and Expressions - Part 2

Lecture 317 Operators and Expressions - Part 3

Lecture 318 Subforms

Lecture 319 Report Wizard; Previewing a Report

Lecture 320 Report Design

Lecture 321 Grouped and Summary Reports; Modifying a Report

Lecture 322 Adding Subreports

Lecture 323 Documenter; Print Properties and Options

Lecture 324 Import and Append; Copy and Paste; Export Access Database

Lecture 325 Database Templates and Application Parts

Lecture 326 Navigation Form

Lecture 327 Modal Dialogs - Part 1

Lecture 328 Modal Dialogs - Part 2

Lecture 329 Modal Dialogs - Part 3

Lecture 330 Actions; Example of VBA; Creating AutoExec Macro

Lecture 331 More Access Options

Lecture 332 Info Tab

Lecture 333 Trust Center

Lecture 334 Updates; Closing

Section 7: Learn Microsoft Access 2013 Advanced Training Course

Lecture 335 Prerequisites and Basic Knowledge of Access 2013

Lecture 336 WATCH ME: Essential Information for a Successful Training Experience

Lecture 337 Access 2013 Advanced Exercise Files

Lecture 338 Indexes and Introduction to the Movies Database

Lecture 339 Basics in Working with Datasheet View

Lecture 340 Controlling the Display and Advanced Sorting and Filtering in Datasheet View

Lecture 341 Linking to Other Access Database Tables

Lecture 342 How to Install SQL Server Express

Lecture 343 Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server

Lecture 344 Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end

Lecture 345 Consequences of the Split; Moving a Database; Adding a Trusted Location

Lecture 346 Access Options relating to Multi-user Issues; Record Locking

Lecture 347 Basics of Macros and Properties of Macro Editor

Lecture 348 Examples of Macros; Autoexec

Lecture 349 More Autoexec

Lecture 350 Macro Security

Lecture 351 Customizing the Quick Access Toolbar and the Ribbon

Lecture 352 Convert Macro to VBA; VBA Editor

Lecture 353 Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes

Lecture 354 Modules, Subs, Options Explicit, and Variables

Lecture 355 Scope of Variables

Lecture 356 Branch and Loop

Lecture 357 Customizing Events

Lecture 358 Responding to Events and Developing Error Handles

Lecture 359 More on Events

Lecture 360 Getting Help with Events

Lecture 361 Basics of Forms: Review and Tips and Tricks

Lecture 362 Advanced Features of Forms - Part 1

Lecture 363 Advanced Features of Forms - Part 2

Lecture 364 Advanced Features of Forms - Part 3

Lecture 365 Advanced Features of Forms - Part 4

Lecture 366 Basics of Queries: Review

Lecture 367 Main Features and Syntax of SQL Statements

Lecture 368 Use of Multiple Criteria of a Where Clause

Lecture 369 How Joins Look in SQL Statements and using Query Grids

Lecture 370 Update Query

Lecture 371 Delete and Make Table Queries

Lecture 372 Append Query

Lecture 373 Protecting your Database and Codes

Lecture 374 Making your Database More User-Friendly

Lecture 375 Setting up an Access Web App

Lecture 376 Building Basic Web Apps

Lecture 377 Closing

Section 8: Learn Microsoft Publisher 2013

Lecture 378 Introduction

Lecture 379 WATCH ME: Essential Information for a Successful Training Experience

Lecture 380 Publisher 2013 Exercise Files

Lecture 381 Downloadable Course Transcripts

Lecture 382 Create a New Publication

Lecture 383 Interface Overview: Backstage View

Lecture 384 Interface Overview: The Publisher Application

Lecture 385 Insert, Move, Rename and Delete Pages

Lecture 386 Viewing and Navigating Pages

Lecture 387 Rulers, Measurements, and Guidelines

Lecture 388 Establishing Business Information

Lecture 389 Setting Preferences

Lecture 390 Saving Your Publication

Lecture 391 Inserting a Text Box

Lecture 392 Formatting a Text Box

Lecture 393 Character Formatting Options

Lecture 394 Working with Font Schemes

Lecture 395 Importing Text from Word

Lecture 396 Working with Columns

Lecture 397 Setting Paragraph and Line Spacing Options

Lecture 398 Inserting Hyperlink Text

Lecture 399 Inserting Special and Break Characters

Lecture 400 Performing a Spell Check

Lecture 401 Using Find and Replace Feature

Lecture 402 Paragraph Formatting Options

Lecture 403 Working with Tab Stops

Lecture 404 Working with Styles

Lecture 405 Bitmap vs. Vector Images

Lecture 406 Digital Image File Formats

Lecture 407 Inserting Images and Image Placeholders

Lecture 408 Move, Resize and Crop Images

Lecture 409 Utilizing the Adjustment Settings

Lecture 410 Adding Captions and Alternate Text to Images

Lecture 411 Inserting Page Parts, Borders and Accents

Lecture 412 Inserting a Basic Shape

Lecture 413 Formatting a Shape

Lecture 414 Drawing Lines with Line Tools

Lecture 415 Editing a Shape using Anchor Points

Lecture 416 Comparing Color Models

Lecture 417 Exploring RGB, CMYK, and Pantone Colors

Lecture 418 Using Adobes Kuler Tool

Lecture 419 Creating and Applying Color Schemes

Lecture 420 Tints, Gradients, Textures and Patterns

Lecture 421 Applying Custom Colors

Lecture 422 Utilizing the Scratch Area

Lecture 423 Arranging, Grouping and Ungrouping Objects

Lecture 424 Rotating, Flipping, Nudging and Aligning Objects

Lecture 425 Wrapping Text around Objects

Lecture 426 Utilizing the Format Painter

Lecture 427 Saving an Object as a Building Block

Lecture 428 Inserting a Table

Lecture 429 Inserting and Deleting Rows and Columns

Lecture 430 Formatting a Table

Lecture 431 Working with Master Pages

Lecture 432 Applying a Page Background

Lecture 433 Managing Page Setup Options

Lecture 434 Starting a Mail Merge

Lecture 435 Selecting Mail Merge Recipients

Lecture 436 Inserting Merge Fields

Lecture 437 Previewing and Completing a Mail Merge

Lecture 438 Working with Skydrive

Lecture 439 Running Design Checker and Managing Embedded Fonts

Lecture 440 Printing a Publication

Lecture 441 Additional Saving and Print Options

Lecture 442 Course Summary

Lecture 443 Bonus lecture

Section 9: Essential VBA Training for Excel - Automate Repetitive Tasks

Lecture 444 Introduction to the VBA Course

Lecture 445 WATCH ME: Essential Information for a Successful Training Experience

Lecture 446 VBA Exercise Files

Lecture 447 Getting Started

Lecture 448 The VBA Editor

Lecture 449 First Coding Manipulations

Lecture 450 VBA Syntax, Keywords, and Comments

Lecture 451 Objects and VBA's Intellitext

Lecture 452 Variables and Method Calling Rules

Lecture 453 How to Define and Manage Variables

Lecture 454 Constant Variable Types and Variables through Intellitext

Lecture 455 Subroutines

Lecture 456 Logical Constructs: The Boolean Type

Lecture 457 Logical Constructs: If and Switch Statements

Lecture 458 Methods for Communicating to the User

Lecture 459 Looping: The For and Do While Loops

Lecture 460 Looping: Collections and the For Each Loop

Lecture 461 Functions

Lecture 462 Returning Values from Functions

Lecture 463 Determining Limitations

Lecture 464 Sending Values to Functions

Lecture 465 The Worksheet Function Object

Lecture 466 Completing Exercise 5

Lecture 467 The Range Object

Lecture 468 Writing an Array Formula

Lecture 469 The Application Object

Lecture 470 The Workbook and Worksheet Objects

Lecture 471 Using Errors to Guide You

Lecture 472 The Name and Names Objects

Lecture 473 The PivotTable Object

Lecture 474 The Chart and ChartObject Objects

Lecture 475 The PageSetup Object and Print Ranges

Lecture 476 One Approach To Completing Exercise 8

Lecture 477 Concluding Remarks

Section 10: VBA Intermediate Course

Lecture 478 Course Overview

Lecture 479 WATCH ME: Essential Information for a Successful Training Experience

Lecture 480 Course Exercise Files

Lecture 481 Course Support Files

Lecture 482 Chapter 2 Preview

Lecture 483 Excel File Types

Lecture 484 Code Modules

Lecture 485 Detailed Memory Management

Lecture 486 Code Module Interactions

Lecture 487 The VBA Project Model

Lecture 488 Advanced Parameter Definitions

Lecture 489 What Are Events?

Lecture 490 Pre-Defined Events

Lecture 491 Event Parameters

Lecture 492 A Series Of Example Events

Lecture 493 Application Events

Lecture 494 Chapter Overview + New Keyword

Lecture 495 Creating A Custom Type

Lecture 496 Create a New Class

Lecture 497 Defining a Class

Lecture 498 Practical Example of a Class

Lecture 499 Practice Test of a Class

Lecture 500 Special Class Variables and Components

Lecture 501 Initialization and Termination

Lecture 502 VBA Attributes and Usage

Lecture 503 Inheritance - Defining the Bookmarks Support Class

Lecture 504 Creating a Userform

Lecture 505 Designing a Userform

Lecture 506 Coding a Userform

Lecture 507 Modding the Excel Interface

Lecture 508 UI Interface Scope and Range

Lecture 509 UI Interface Control Options and Access

Lecture 510 What are References? How do they work?

Lecture 511 Course Conclusion

Lecture 512 Reference Object

Lecture 513 Office Libraries

Lecture 514 ADODB Library

Lecture 515 The Scripting Library

Section 11: Extras

Lecture 516 EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic

Lecture 517 EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic

Lecture 518 EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic

Lecture 519 EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic

Lecture 520 EXTRA RESOURCE: The Most Frequently Used Outlook Shortcuts - Infographic

Anyone new to Microsoft Office 2013 or upgrading from a previous version.