Get $1 credit for every $25 spent!

The Microsoft Suite Pro User Bundle

Ending In:
Add to Cart - $45
Add to Cart ($45)
$654
93% off
wishlist
(27)
Courses
5
Lessons
400
Enrolled
269

What's Included

Product Details

Access
Lifetime
Content
19.5 hours
Lessons
95

The Ultimate Microsoft Access 2013 Training

Become A Data Management Expert with Over 19 Hours of Microsoft Access Training

By SimonSezIT | in Online Courses

Microsoft Access 2013 is a database management system that can be optimized to capture and synthesize information with custom web apps and desktop databases. With the popularity of the new Access 2016, this bundle containing over 19 hours of instruction, is your ticket to efficiently analyzing large, complex data sets. The modern workplace requires you be able to work with information fast, and by course's end you'll be an expert in this powerful software and ready to adapt to Access 2016.

  • Access 95 lectures & 19.5 hours of content 24/7
  • Add & delete records to your database
  • Create desktop databases & apps for multiple users
  • Build forms to capture information online
  • Implement pre-designed templates that track project, employee, issue, or task details
  • Use macros, tables, forms, queries & other tools to create a professional, working database
  • Learn to create & maintain macros, then see how to effectively link to other data sources
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 70+ courses and 3,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free e-learning and enhanced employee productivity – whether you’re implementing new software or a technological upgrade for your workplace. With over 225,000 Udemy students in over 180 countries, Simon Sez IT is the preferred e-learning choice for individuals and businesses everywhere.

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required

Course Outline

  • Chapter 1: Introduction
    • Acquiring Access 2013; Course Overview (14:31)
    • What's New in Access 2013 (9:26)
    • Course Exercise Files
  • Chapter 2: Using Touch
    • Overview of Principles (5:53)
  • Chapter 3: Getting Started
    • Database Templates; Creating, Opening and Saving Databases (11:26)
    • Workspace and Backstage View (10:31)
  • Chapter 4: Help
    • Online, Offline and Contextual Help (5:49)
  • Chapter 5: Keyboard Shortcuts and Key Tips
    • Finding Keyboard Shortcuts and Key Tips (5:57)
  • Chapter 6: Access Options
    • Customizing the Settings and Use of Access 2013 (11:23)
  • Chapter 7: The Ribbon and Toolbars
    • The Ribbon (11:22)
    • Quick Access Toolbar (4:48)
  • Chapter 8: Status Bar
    • Customizing the Status Bar (3:42)
  • Chapter 9: Database Basics
    • Overview of the Main Features of Access Database (16:43)
    • Web App Basics (10:42)
  • Chapter 10: Tables
    • Creating Tables - Part 1 (15:29)
    • Creating Tables - Part 2 (14:46)
    • Relationship between Tables - Part 1 (14:32)
    • Relationship between Tables - Part 2 (8:37)
  • Chapter 11: Datasheet View
    • Inserting and Formatting Fields; Field Validation; Navigation Buttons (12:19)
    • Sorting, Filtering and Finding Data (13:21)
    • Entering Data; Changing the Order of Columns, Field Width and Height (8:00)
  • Chapter 12: Table Design
    • Design View; Field Properties (13:36)
    • Saving Data; Data Types, Attachments and Field Size (14:06)
    • Input Masks; More on Field Properties (15:06)
  • Chapter 13: Forms
    • Creating Forms; Form Wizard (14:36)
    • Single Forms; Insert, Delete, Modify, Sort and Filter Records (12:35)
    • Layout View; Adding Existing Fields (15:55)
    • Design View; Arranging Fields (16:27)
    • Controls (14:06)
    • Form Design (13:25)
  • Chapter 14: Queries
    • Query Design (15:30)
    • Joins and Query Wizard (15:03)
    • Query Types (13:51)
    • Operators and Expressions - Part 1 (12:00)
    • Operators and Expressions - Part 2 (7:32)
    • Operators and Expressions - Part 3 (15:04)
    • Subforms (12:32)
  • Chapter 15: Reports
    • Report Wizard; Previewing a Report (9:41)
    • Report Design (13:57)
    • Grouped and Summary Reports; Modifying a Report (15:26)
    • Adding Subreports (11:40)
  • Adding Subreports
    • Documenter; Print Properties and Options (9:20)
  • Chapter 17: Importing and Exporting Data
    • Import and Append; Copy and Paste; Export Access Database (13:45)
  • Chapter 18: Templates and Application Parts
    • Database Templates and Application Parts (14:21)
  • Chapter 19: More on Forms
    • Navigation Form (10:45)
    • Modal Dialogs - Part 1 (11:52)
    • Modal Dialogs - Part 2 (13:33)
    • Modal Dialogs - Part 3 (9:39)
  • Chapter 20: Macros and VBA
    • Actions; Example of VBA; Creating AutoExec Macro (15:25)
  • Chapter 21: Additional Topics
    • More Access Options (8:45)
    • Info Tab (11:49)
  • Chapter 23: Security
    • Trust Center (12:58)
  • Chapter 23: Conclusion
    • Updates; Closing (2:21)
  • Chapter 1: Introduction
    • Pre-requisites and Basic Knowledge of Access 2013 (9:10)
    • Course Exercise Files
  • Chapter 2: Indexes
    • Indexes and Introduction to the Movies Database (14:36)
  • Chapter 3: Datasheet View
    • Basics in Working with Datasheet View (10:29)
    • Controlling the Display and Advanced Sorting and Filtering in Datasheet View (15:21)
  • Chapter 4: Linking Access Databases
    • Linking to Other Access Database Tables (14:41)
  • Chapter 5: ODBC and SQL Server
    • How to Install SQL Server Express (14:49)
    • Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server (16:50)
  • Chapter 6: Splitting an Access Database
    • Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end (15:18)
    • Consequences of the Split; Moving a Database; Adding a Trusted Location (16:07)
  • Chapter 7: Multi-user Aspects
    • Access Options relating to Multi-user Issues; Record Locking (14:58)
  • Chapter 8: Macros
    • Basics of Macros and Properties of Macro Editor (14:23)
    • Examples of Macros; Autoexec (14:29)
    • More Autoexec (14:43)
    • Macro Security (8:37)
  • Chapter 9: The Ribbon
    • Customizing the Quick Access Toolbar and the Ribbon (15:17)
  • Chpater 10: Visual Basic for Applications
    • Convert Macro to VBA; VBA Editor (14:13)
    • Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes (14:27)
    • Modules, Subs, Options Explicit, and Variables (15:58)
    • Scope of Variables (16:13)
    • Branch and Loop (14:38)
  • Chapter 11: Events
    • Customizing Events (15:08)
    • Responding to Events and Developing Error Handles (13:59)
    • More on Events (14:11)
    • Getting Help with Events (8:24)
  • Chapter 12: Forms
    • Basics of Forms: Review and Tips and Tricks (15:39)
    • Advanced Features of Forms - Part 1 (17:19)
    • Advanced Features of Forms - Part 2 (14:32)
    • Advanced Features of Forms - Part 3 (14:49)
    • Advanced Features of Forms - Part 4 (15:19)
  • Chapter 13: SQL
    • Basics of Queries: Review (13:57)
    • Main Features and Syntax of SQL Statements (15:53)
    • Use of Multiple Criteria of a Where Clause (12:55)
  • Chapter 14: Joins
    • How Joins Look in SQL Statements and using Query Grids (15:49)
  • Chapter 15: Action Queries
    • Update Query (15:42)
    • Delete and Make Table Queries (12:20)
    • Append Query (7:12)
  • Chapter 16: Packaging your Application
    • Protecting your Database and Codes (15:08)
    • Making your Database More User-Friendly (7:23)
  • Chapter 17: Web Apps
    • Setting up an Access Web App (16:33)
    • Building Basic Web Apps (16:48)
  • Chapter 18: Conclusion
    • Closing (0:44)
  • Bonus Material
    • Access 2013 Keyboard Shortcuts

View Full Curriculum


Access
Lifetime
Content
19 hours
Lessons
100

The Ultimate Microsoft Excel 2013 Training

Become a Master of This Essential Office Software

By Simon Sez IT | in Online Courses

Microsoft Excel is the far and away leader in spreadsheet software and is used by all types of businesses throughout the world. Knowing Excel basics is perhaps one of the most essential modern computing skills, while become a real master of this software will allow you to solve complex number problems and manage data with ease.

  • Access over 100 lectures & 19 hours of content 24/7
  • Understand data entry, cell formatting, working w/ multiple worksheets & the "Ribbon" interface
  • Gain tips for mouse & touch screen use
  • Implement graphs & charts using templates or custom designs
  • Use SkyDrive & other tools for sharing work
  • Work w/ flash fill, dates & times
  • Learn how to calculate averages, percentiles, depreciation & LINEST functions
  • Practice your Excel expertise w/ included exercise files
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 70+ courses and 3,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free e-learning and enhanced employee productivity – whether you’re implementing new software or a technological upgrade for your workplace. With over 225,000 Udemy students in over 180 countries, Simon Sez IT is the preferred e-learning choice for individuals and businesses everywhere.

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels

Compatibility

  • Internet required
  • Microsoft Excel 2013 required

Course Outline

  • Chapter 1: Introduction
    • Introduction to Excel 2013 (9:12)
    • What's New (7:31)
    • Excel 2013 Beginner-Intermediate Course Exercise Files
  • Chapter 2: Using Touch
    • Overview of Principles (3:39)
  • Chapter 3: Getting Started
    • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns (11:20)
    • Templates; Creating, Opening, and Saving a Workbook (10:54)
  • Chapter 4: Help
    • Online, Offline, and Contextual Help (8:00)
  • Chapter 5: Settings and Preferences
    • Excel Options (11:22)
  • Chapter 6: The Ribbon and Toolbars
    • Ribbon Interface (15:00)
    • Quick Access Toolbar (8:03)
    • Mini Toolbar (2:58)
  • Chapter 7: Backup and Recovery
    • Create Backup Option; Auto-Recover and Autosave (6:54)
  • Chapter 8: Entering and Deleting Data
    • Entering Text and Numbers (15:15)
    • Date Formats (15:57)
    • Formatting Cells; Editing and Deleting Data (15:15)
    • Fill (12:51)
    • Flash Fill (5:08)
  • Chapter 9: Formatting a Worksheet
    • Themes and Cell Styles (14:01)
    • Inserting, Deleting, Hiding and Adjusting Rows and Columns (13:28)
    • Wrap Text and Alignment (15:02)
    • Merging Cells; Applying Themes and Styles (11:36)
    • Borders (9:25)
  • Chapter 10: Copy, Paste and Paste Special
    • Copy, Cut and Paste (17:06)
  • Chapter 11: Proofing
    • Spell checking (11:57)
  • Chapter 12: Managing Worksheets
    • Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets (14:51)
  • Chapter 13: Comments
    • Inserting Comments (6:54)
  • Chapter 14: Viewing and Printing
    • Workbook Views, Zoom and Freeze (11:17)
    • Printing; Headers, Footers and Margins (12:57)
  • Chapter 15: Formulas and Functions
    • Overview of Formulas and Functions (14:08)
    • Cell References (14:50)
    • Names (15:38)
    • Finding Errors; New Excel Functions (14:13)
  • Chapter 16: Working with Workbooks
    • Multiple Workbooks and Windows; Comparing Workbooks (10:39)
  • Chapter 17: Find and Replace
    • Go to; Find and Replace Options (11:14)
  • Chapter 18: Conditional Formatting
    • Applying, Clearing and Managing Rules (15:35)
  • Chapter 19: Graphing and Charting
    • Chart Types; Chart Recommendation (13:35)
    • Basic Formatting (14:41)
    • Selecting Data, Positioning and Printing Charts (15:47)
  • Chapter 20: File Types
    • Saving Workbooks; PDF and CSV Formats (11:21)
  • Chapter 21: Managing Data
    • Sorting (9:06)
    • Filtering (10:43)
    • Tables (12:25)
  • Chapter 22: Functions Case Study
    • VLOOKUP (12:58)
    • Text Function (5:17)
    • Date and Time Functions (5:32)
    • Logical Functions (18:31)
  • Chapter 23: Analyzing Data
    • Financial Analysis Case Study - Part 1 (16:03)
    • Financial Analysis Case Study - Part 2 (9:23)
    • Quick Analysis Tool (7:57)
  • Chapter 24: Shapes and Pictures
    • Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt (14:26)
  • Chapter 25: Sharing and Protecting
    • Protecting Worksheets (7:42)
    • Protecting Workbooks (10:02)
    • Sharing and SkyDrive (14:24)
  • Chapter 26: More Backstage View Options
    • Trust Center; Export; Inspect Workbook (5:33)
  • Chapter 27: Closing
    • Summary; More Help (1:49)
  • Chapter 28: Course Quiz
    • Quiz - Learn Microsoft Excel 2013 Beginners Course
  • Chapter 1: Introduction
    • Pre-requisites of Excel 2013 Advanced Course (9:55)
    • Excel 2013 Advanced Course Exercise
  • Chapter 2: Functions
    • List of Functions; Common Types of Arguments; Basic Use of Functions (13:38)
    • Advanced Aspects of Functions; Searching for a Function (11:00)
    • Autosum (6:18)
  • Chapter 3: Personal and Professional Financial Functions
    • Payment (12:48)
    • Future Value (11:17)
    • Principle Payment (12:01)
    • Depreciations (13:25)
  • Chapter 4: Date and Time Functions
    • How Dates and Times are Stored (11:57)
    • Dates and Times Calculation (12:45)
    • Exercise on Date and Time Functions; Date and Time Settings (7:25)
  • Chapter 5: Statistical Functions for Description, Prediction and Interference
    • Average (13:05)
    • Percentile (10:21)
    • Regression (14:02)
    • LINEST Function (9:49)
    • Example of Functions for Inferential Statistics (12:39)
  • Chapter 6: Text Functions
    • Text Function Case Study - 1 (14:26)
    • Text Function Case Study - 2 (10:35)
  • Chapter 7: Lookup Functions
    • Lookup and Reference Functions (15:43)
  • Chapter 8: Logical Functions
    • Logical Functions (15:59)
  • Chapter 9: Connecting to External Data
    • Connecting to Other Workbooks (16:04)
    • Connecting to Access Data (14:11)
    • Connecting to Web Data (10:18)
  • Chapter 10: Tables
    • Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row (13:48)
    • Inserting Columns and Rows; Resizing Tables (15:02)
    • Table Reference (9:18)
    • Table Styles (7:07)
    • Table Selection (4:08)
  • Chapter 11: Pivot Tables
    • Basic Principles of Pivot Tables (14:58)
    • Presentational Side of Pivot Tables (15:40)
    • Filtering in Pivot Tables; Slices (14:06)
  • Chapter 12: Data Analysis
    • What if (15:32)
    • Scenario Manager (14:06)
    • Goal Seek (7:51)
    • Solver (14:38)
  • Chapter 13: Charts
    • Area Charts (10:39)
    • Surface Charts (7:40)
    • Stock Charts - Part 1 (12:27)
    • Stock Charts - Part 2 (12:47)
    • Radar Charts (5:08)
    • Bubble Charts (10:20)
  • Chapter 14: Graphs
    • Regression and Scatter Chart (7:00)
  • Chapter 15: Pivot Charts
    • Creating Pivot Charts (12:32)
  • Chapter 16: Sparklines
    • Using Sparklines (15:30)
  • Chapter 17: Web App
    • Creating Workbooks using a Web App (15:15)
    • Sharing your Workbook (10:00)
  • Chapter 18: Conclusion
    • Closing (0:19)
  • Chapter 19: Course Quiz
    • Quiz - Microsoft Excel 2013 Advanced
  • Bonus Materials
    • Excel 2013 Keyboard Shortcuts
    • Course Transcript for Excel 2013 Beginners Course
    • Course Transcripts for Excel 2013 Advanced Course
    • MP3 Excel 2013 Audio Files
    • MP3 Excel 2013 Advanced Audio Files

View Full Curriculum


Access
Lifetime
Content
6 hours
Lessons
77

Master Microsoft PowerPoint 2016 the Easy Way

Start Creating Powerful, Illustrative Presentations In No Time

By SimonSezIT | in Online Courses

Microsoft PowerPoint is the premiere presentation program and by far the most popular in the world. PowerPoint can be useful for a range of purposes, from a presentation at work, to creating slideshows for photos. This comprehensive course will get you up to speed on all the PowerPoint basics you need to start working efficiently.

  • Access 77 lectures & 6 hours of content 24/7
  • Create, edit & show illustrative presentations & attention-grabbing slides
  • Combine text, 3D graphics & multimedia to support your presentation-making needs
  • Explore the new features in PowerPoint 2016
  • Make presentations w/ alternative forms, styles & custom layouts
  • Practice what you've learned w/ included exercise files
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 70+ courses and 3,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free e-learning and enhanced employee productivity – whether you’re implementing new software or a technological upgrade for your workplace. With over 225,000 Udemy students in over 180 countries, Simon Sez IT is the preferred e-learning choice for individuals and businesses everywhere.

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner

Compatibility

  • Internet required

Course Outline

  • Course Introduction
    • Welcome and Overview (2:09)
    • New Features in PowerPoint 2016 (7:57)
    • New features in PowerPoint 2016 for MAC (4:19)
    • Course Exercise Files
  • Overview
    • Navigate a PowerPoint Presentation (7:42)
    • Overview of the Desktop Screen and Views (9:51)
    • Exercise 01 (0:35)
  • Getting Started
    • Presentation Tips and Guidelines (6:11)
    • Creating a New Presentation (2:58)
    • Working with Slides (7:00)
    • Saving a Presentation (2:54)
    • Exercise 02 (1:30)
  • Text and Bullet Editing Options
    • Formatting Text (10:27)
    • Working with Bullets (9:03)
    • Exercise 03 (1:18)
  • Adding Graphics to Your Presentation
    • Inserting Shapes (9:36)
    • Inserting Graphics (4:11)
    • Inserting Pictures (6:29)
    • Exercise 04 (1:32)
  • Working with Objects
    • Selecting Objects (3:31)
    • Editing Objects (5:28)
    • Formatting Objects - Part 1 (11:05)
    • Formatting Objects - Part 2 (8:39)
    • Arranging Objects (8:10)
    • Grouping Objects (4:04)
    • Exercise 05 (1:23)
  • Preparing a Presentation for Delivery
    • Picture Options (5:37)
    • Cropping Pictures (5:14)
    • Formatting Pictures (5:39)
    • Things You Can Do with Pictures (7:56)
    • Exercise 06 (0:56)
  • Working with SmartArt
    • Creating SmartArt (6:55)
    • Modifying SmartArt (4:05)
    • Writing Math Equations (2:02)
    • Exercise 07 (1:11)
  • Working with Tables
    • Creating Tables (7:09)
    • Formatting Tables (5:36)
    • Inserting Tables (5:46)
    • Exercise 08 (1:17)
  • Working with Charts
    • Adding Charts (6:15)
    • Formatting Charts (9:04)
    • Inserting Charts from MS Excel (4:45)
    • Exercise 09 (1:57)
  • Masters
    • Using Masters (5:32)
    • Changing Master Slides (9:55)
    • Creating a New Master Design Template (8:24)
    • Exercise 10 (1:53)
  • Working with Media
    • Adding Audio to a Presentation (6:06)
    • Adding Video to a Presentation (4:58)
    • Exercise 11 (1:03)
  • Transitions
    • Applying Transitions (4:28)
    • Transition Options (5:16)
    • Exercise 12 (1:11)
  • Animation
    • Animating an Object (8:39)
    • Effect Options (5:34)
    • Working with the Animation Pane (4:42)
    • Motion Paths (6:16)
    • Triggers (8:04)
    • Exercise 13 (1:24)
  • Hyperlinks and Action Buttons
    • Working with Action Buttons (5:53)
    • Working with Hyperlinks (5:31)
    • Exercise 14 (1:06)
  • Slideshow Options
    • Onscreen Presentation Options (5:50)
    • Hiding Slides (2:40)
    • Changing the order of slides (1:40)
    • Copying slides (1:35)
    • Slideshow Options (6:53)
    • Exercise 15 (1:45)
  • Preparing a Presentation for Delivery
    • Rehearse Timings (5:44)
    • Recording a Presentation (2:37)
    • Slide Show Settings (2:58)
    • Creating a Custom Slide Show (3:13)
    • Exercise 16 (1:16)
  • Other PowerPoint Features
    • Exporting options (6:08)
    • Working with the Backstage View & Customization Options (3:42)
    • Customizing the Ribbon (4:16)
    • Printing a presentation (5:20)
    • Exercise 17 (1:44)
  • Conclusion
    • Conclusion (0:44)

View Full Curriculum


Access
Lifetime
Content
9 hours
Lessons
65

Microsoft Excel 2016 for Beginners

Master the Essentials of Microsoft Excel 2016 in This Easy-to-Follow Course

By SimonSezIT | in Online Courses

Microsoft Excel 2016 is the newest, most advanced version of the world's leading spreadsheet software. This course assumes you have never worked with any version of Excel, and will take you from a complete beginner to a wizard with the most up-to-date features available. By course's end, you'll have a valuable new bullet point on your resume.

  • Access 65 lectures & 9 hours of content 24/7
  • Install & run Microsoft Excel 2016 for the first time
  • Use Touchscreen, open a Workbook, & use Help to get additional answers when you need them
  • Personalize Excel for your own use
  • Discuss all Ribbons & Toolbars, entering & editing data, backup & recovery, & more
  • Practice w/ included exercise files
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 70+ courses and 3,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free e-learning and enhanced employee productivity – whether you’re implementing new software or a technological upgrade for your workplace. With over 225,000 Udemy students in over 180 countries, Simon Sez IT is the preferred e-learning choice for individuals and businesses everywhere.

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner

Compatibility

  • Internet required

Course Outline

  • Introduction
    • Acquiring Excel 2016 and Information on Installation and Upgrade (12:02)
    • Exercise Files (2:28)
    • Course exercise files
    • Course demo files
  • What's New
    • New and Improved Features in Excel 2016 (2:55)
  • Using Touch
    • Overview of Principles of Using Touchscreen (5:36)
  • Getting Started
    • Creating and Saving a Workbook (15:16)
    • Opening a Workbook (10:13)
  • Using Help
    • Online Help and Contextual Help (6:27)
  • Excel Options
    • Personalizing your use of Excel (10:50)
  • The Ribbon and Toolbars
    • Basics of using the Ribbon (14:56)
    • Quick Access Toolbar (5:45)
    • Tell Me Feature (6:49)
    • Mini Toolbars and Contextual Menus (3:47)
    • Status Bar (5:02)
  • Entering and Editing Data
    • Basics of Entering and Editing Data in a Workbook (13:29)
    • Exercise 01 (1:50)
    • Formatting Dates (12:36)
    • Formatting Numbers (13:48)
    • Exercise 02 (1:43)
  • Backup and Recovery
    • AutoSave, Recover Unsaved Workbook, and Create a Backup Copy (7:35)
  • Fill and Series
    • Working with Fill and Series (9:09)
    • Flash Fill (4:04)
  • Viewing and Printing
    • Workbook Views, Zoom, and Freeze (8:41)
    • Printing (14:30)
    • Exercise 03 (2:56)
  • Cut, Copy, and Paste
    • Methods of Cutting, Copying, and Pasting (13:32)
  • Formatting a Worksheet
    • Delete and Clear (13:45)
    • Insert, Hide, Column Width and Row Height, and Merge (12:46)
    • Alignment (12:05)
    • Themes and Styles (11:19)
    • Exercise 04 (1:44)
  • Formulas and Functions
    • Basics of Fomulas and Functions (11:15)
    • Complex Examples of Formulas (13:36)
    • Exercise 05 (3:26)
  • Managing Worksheets
    • Rename, Insert, Move, and Reference a Worksheet (8:40)
  • Working with Multiple Workbooks
    • Working with Multiple Workbooks (15:48)
  • Saving Workbooks
    • Saving in Different File Types (12:59)
  • Proofing
    • The Spell Checker (13:11)
  • Inserting Comments
    • Inserting Comments (4:54)
    • Exercise 06 (3:02)
  • Basic Functions in Excel
    • The VLOOKUP Function (14:07)
    • Text Functions (8:17)
    • Date and Time Functions (6:47)
    • Logical Functions (15:51)
  • Graphs and Charts
    • Creating Graphs and Charts (12:10)
    • Customizing a Cluster Column Chart (15:42)
    • Customizing a Pie Chart (13:36)
    • New Chart Types in Excel 2016 (2:01)
    • Exercise 7 (2:28)
  • Sorting and Filtering Data
    • Managing Data by Sorting (9:39)
    • Managing Date by Filtering (11:59)
    • Customizing Tables (13:23)
  • Shapes and Pictures
    • Inserting Shapes and Pictures (15:00)
    • Exercise 08 (0:47)
  • Formatting Cells Based on Content
    • Conditional Formatting (15:32)
  • Protection and Security
    • Protecting Worksheets (9:36)
    • Protecting Workbooks (10:21)
  • Naming Items
    • Giving Items Names (6:31)
    • Exercise 09 (0:47)
  • Finding and Replacing Words
    • Find and Replace (7:10)
  • Borders
    • Adding Borders (10:44)
  • Workbook Inspection
    • Inspecting a Workbook (6:08)
  • Privacy Options
    • Trust Center Privacy Options (5:46)
  • Sharing Options
    • Sharing a Workbook (8:30)
  • Conclusion
    • Course Conclusion and Closing (0:56)
  • Course Quiz
    • Microsoft Excel 2016 Quiz

View Full Curriculum


Access
Lifetime
Content
9.00 hours
Lessons
63

Microsoft Project 2016 For Beginners

Master the Essentials of the World's Most Popular Project Management Software

By SimonSezIT | in Online Courses

Microsoft Project 2016 helps you develop a plan, assign resources to tasks, track progress, manage your budget - everything you need to supervise a project. Used by many organizations across many industries, learning this software will set you apart from other candidates for similar management-minded jobs. This course assumes it's your first time using any version of Microsoft Project, and will take you all the way through to the advanced stages.

  • Access 63 lectures & 9 hours of content 24/7
  • Install your own copy of Microsoft Project 2016
  • Use Touch, Task basics & Project Options
  • Create a Workspace, use Toolbars, Ribbons, & the Status Bar
  • Understand how to track costs, track a project, budget, & report
  • Explore Subtasks, Dependencies, Deadlines, Resources, & more
Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 70+ courses and 3,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free e-learning and enhanced employee productivity – whether you’re implementing new software or a technological upgrade for your workplace. With over 225,000 Udemy students in over 180 countries, Simon Sez IT is the preferred e-learning choice for individuals and businesses everywhere.

Details & Requirements

  • Length of time users can access this course: lifetime
  • Access options: web streaming, mobile streaming
  • Certification of completion not included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner

Compatibility

  • Internet required

Course Outline

  • Course Introduction
    • Introduction (4:36)
    • Course exercise files
    • Course demo files
    • Acquiring Project 2016 (8:59)
    • What's New in Project 2016 (4:25)
  • Workspace, The Ribbon and Help
    • The Project 2016 Workspace (15:11)
    • Online Help (8:15)
    • Ribbon and Toolbars (13:05)
    • Status Bar (4:20)
    • Keyboard Shortcuts and Tips (6:03)
  • Using Touch
    • Overview of Principles (8:51)
  • Project Options
    • Overview of Project Options (15:34)
  • Task Basics
    • Entering Tasks (10:17)
    • Opening and Closing Projects (8:08)
    • Exercise 1 (1:06)
    • Task Properties (8:54)
  • Subtasks
    • Subtasks (14:00)
    • Exercise 2 (1:08)
  • Dependencies, Deadlines and Milestones
    • Linking and Unlinking Tasks (15:21)
    • Setting Constraints and Deadlines (15:31)
    • Setting Milestones (8:29)
    • Exercise 3 (12:04)
  • Resources
    • Filling Up the Resource Sheet (13:52)
    • Resource Assignment Basics (10:24)
    • Adding Resources to Tasks (10:33)
    • The Basics of Scheduling (15:12)
    • Resource Leveling Basics (15:00)
    • Leveling Options (17:10)
    • Exercise 4 (3:50)
  • Views and Timelines
    • Views - Part 1 (13:47)
    • Views - Part 2 (11:06)
    • Timelines (10:07)
  • Costs
    • Setting Cost for Tasks (7:47)
    • Exercise 5 (1:51)
    • Adding Cost Resources (15:57)
    • Setting Up Budget Cost (7:45)
  • Baselines and Critical Paths
    • Measuring a Project Against a Baseline (8:28)
    • Working with Critical Path (9:36)
    • Exercise 6 (1:31)
    • Changing Baselines (11:36)
  • Tables
    • Modifying Task and Resource Tables (11:42)
  • Gantt Chart
    • Formatting a Gantt Chart (13:57)
  • Notes
    • Applying Notes to Tasks or Resources (4:59)
  • Printing and Spellchecking
    • Modifying Print Options and Printing your Current View (9:06)
    • Spellchecking Your Project (5:58)
  • Tracking Progress
    • Tracking Progress - Part 1 (14:16)
    • Tracking Progress - Part 2 (14:43)
    • Exercise 7 (3:14)
  • Reporting
    • Reporting - Part 1 (10:37)
    • Reporting - Part 2 (13:42)
    • Exercise 8 (5:57)
  • Tracking Costs
    • Recording Costs (9:10)
  • The Organizer
    • Using the Organizer to Manage Views (7:00)
  • Saving Projects
    • Save As Options (9:33)
  • Project Security
    • Password Protect an MPP file (7:17)
    • Section 21 Quiz
  • Project Templates
    • Saving your Project as a Template (8:03)
  • Calendars
    • Calendars - Part 1 (14:45)
    • Calendars - Part 2 (7:18)
    • Exercise 9 (5:02)
    • Section 23 Quiz
  • Scheduling Issues
    • Task Inspector (7:45)
    • Task Paths (5:55)
    • Team Planner (6:48)
    • Section 24 Quiz
  • Conclusion
    • Additional Topics and Closing (3:47)

View Full Curriculum



Terms

  • Instant digital redemption