Get $1 credit for every $25 spent!

The Complete Microsoft Office Certification Bundle

Ending In:
Add to Cart - $19
Add to Cart ($19)
$2,980
99% off
wishlist
(117)
Courses
4
Enrolled
1,168

What's Included

Product Details

Access
12 months
Lessons
36

Microsoft Excel for Beginners

Build Simple Spreadsheets & Workbooks with this Introductory Course to Microsoft Excel

By 1337 Institute of Technology | in Online Courses

Microsoft Excel is the premiere software for creating spreadsheets and workbooks. In this beginner course you'll learn how to use Excel to organize an array of data types. Whether you're trying to improve your own personal accounting or looking for a professional career in bookkeeping and data analytics, this course is an essential foundation.
  • Access 7 hours of content 24/7
  • Create worksheets, workbooks & learn how to populate cells
  • Use common functions like Average, Max, Min & Count
  • Learn how to format worksheets for specific purposes
  • Discover how to protect workbooks by adding, hiding & deleting comments
  • Understand the best printing techniques for multiple worksheets
iCoursetraining specializes in technology training courses by providing online classes for students of all skill levels and experience with busy schedules. Our online classes allow students to take courses at their own pace and schedule with step by step tutorials. Our courses offer high quality video based training presented in an easy to learn format. For more details on this course or instructor, click here.

Details & Requirements

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

Course Outline

  • Module 1: Getting Started
    • Lesson 1: Course Introduction and Agenda
    • Lesson 2: What is Excel?
    • Lesson 3: Using the Ribbon
    • Lesson 4: Spreadsheet Terminology
    • Lesson 5: Overview of the Excel Interface
    • Lesson 6: Workbook and Worksheet Views and Zoom
  • Module 2: Basic Worksheet Skills
    • Lesson 1: Creating Worksheets and Workbooks
    • Lesson 2: Using Templates and Importing Files
    • Lesson 3: Copying and Moving Worksheets
    • Lesson 4: Selecting a Range, Columns, Rows and Non-Contiguous Cells
    • Lesson 5: Formatting Cells and Ranges
    • Lesson 6: Order and Group Cells and Ranges and Using Autofill
    • Lesson 7: Customizing Options Working with Print and Save Commands
  • Module 3: Working with Formulas
    • Lesson 1: Order of Operations and Using Formulas
    • Lesson 2: Common Functions: AVERAGE, MAX, MIN, COUNT
    • Lesson 3: Working with Date Arithmetic and Currency Formatting
    • Lesson 4: Relative vs. Absolute Cell Addressing
    • Lesson 5: Conditional Logic in Formulas: SUMIF, AVERAGEIF, and COUNTIF
    • Lesson 6: Format and Modify Text using Formulas: RIGHT, LEFT, MID, TRIM, UPPER, LOWER, CONCATENATE
  • Module 4: Editing Workbooks
    • Lesson 1: Deleting a Range and Using Undo and Redo Commands
    • Lesson 2: Using Cut, Copy, and Using Paste Options
    • Lesson 3: Using the Clipboard, and Find and Replace Commands
  • Module 5: Formatting Worksheets
    • Lesson 1: Inserting, Deleting and Adjusting Columns and Rows
    • Lesson 2: Changing Numeric Formats Using the Format Cells Dialog Box
    • Lesson 3: Changing Text Formats and Aligning Date using Borders and Shading
    • Lesson 4: Using the Format Painter
    • Lesson 5: Working with Themes and using Cell Styles
  • Module 6: Multiple Workbooks
    • Lesson 1: Using the Zoom Feature and Splitting the WIndow
    • Lesson 2: Tilling Multiple Workbooks, Synchronous Scrolling, and Working with Freeze and Unfreeze Panes Options
  • Module 7: Protecting Workbooks
    • Lesson 1: Adding, Hiding, Deleting Comments, and Working with Locking and Unlocking Cell Ranges
  • Module 8: Printing and Page Setup
    • Lesson 1: Using Page Break Preview, Print Preview, and Changing Page Orientation
    • Lesson 2: Changing the Margins, and Adding Headers and Footers
    • Lesson 3: Setting Sheet Options, Setting Print Titles and Areas Using the Page Layout Tab
  • Module 9: Charts and Objects
    • Lesson 1: Creating and Formatting Charts and Graphs
    • Lesson 2: Insert and Formatting Objects
  • Module 10: Projects
    • Lesson 1: Consolidating several worksheets into one
    • Lesson 2: Creating Tables and Charts
    • Lesson 3: Working with Formulas

View Full Curriculum


Access
12 months
Lessons
33

Advanced Microsoft Excel Training

Master the Art of the Spreadsheet with Over 3 Hours of Advanced Microsoft Excel Training

By 1337 Institute of Technology | in Online Courses

By completing this Excel Advanced Course, you'll be fully prepared to pass the Microsoft Office Specialist in Excel Exam. You'll learn to implement macros and customization into your worksheets, track changes, and understand how to use intermediate and advanced formulas. Through this course, you'll be well qualified for Excel-heavy professional positions or a freelancing career.
  • Access over 7 hours of content 24/7
  • Merge workbooks, identify errors & troubleshoot more effectively
  • Use intermediate functions like IF, AND, OR, SUMIFS, AVERAGEIFS, & COUNTIFS
  • Use advanced functions like VLOOKUP, HLOOKUP, NOW, TODAY, & TRANSPOSE
  • Insert charts, tables & slicers to your worksheets
  • Learn how to apply custom formats & layouts
iCoursetraining specializes in technology training courses by providing online classes for students of all skill levels and experience with busy schedules. Our online classes allow students to take courses at their own pace and schedule with step by step tutorials. Our courses offer high quality video based training presented in an easy to learn format. For more details on this course or instructor, click here.

Details & Requirements

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

Course Outline

  • Module 1: Macros and Customization
    • Lesson 1: Recording and Copying Macros between Workbooks
    • Lesson 2: Customizing Quick Access Toolbar and Ribbon
    • Lesson 3: Wrapping Text within Cells and Creating Named Cells and Ranges
  • Module 2: Intermediate Worksheet Skills
    • Lesson 1: Managing Workbook versions: Auto recover
    • Lesson 2: Copying Styles between Workbooks and Creating Custom Formats
    • Lesson 3: Connecting to External Data
    • Lesson 4: Tracking Changes and Restrict Editing
    • Lesson 5: Removing Metadata and Inspecting Workbook
  • Module 3: Managing Workbooks
    • Lesson 1: Controlling Calculation
    • Lesson 2: Managing Workbook Changes
    • Lesson 3: Merging Workbooks and Identifying Errors
    • Lesson 4: Troubleshooting by using Tracing Module 4: Intermediate Formulas
    • Lesson 1: Creating Form Fields and Inserting Controls
    • Lesson 2: Using the IF, AND, and OR functions
    • Lesson 3: Using the SUMIFS, AVERAGEIFS, and COUNTIFS functions
    • Lesson 4: Calculating Investments: PV, FV, PMT, PPMT
    • Lesson 5: Working with Depreciation: SLN, SYN, DB, DDB, VDB
  • Module 5: Advanced Formulas
    • Lesson 1: Using the VLOOKUP and HLOOKUP functions
    • Lesson 2: Use the NOW, TODAY, and TRANSPOSE functions
    • Lesson 3: COUPDAYS and other Securities Formulas
    • Lesson 4: Using Solver Tool
  • Module 6: Charts, Graphs, and Objects
    • Lesson 1: Adding Trend Lines to Charts
    • Lesson 2: Creating a Dual Axis Chart
    • Lesson 3: Creating Custom Chart Templates
    • Lesson 4: Creating Slicers and Managing Pivot Tables
    • Lesson 5: Creating and Pivot Charts
  • Module 7: Applying Custom Formats and Layouts
    • Lesson 1: Excel Language Options
    • Lesson 2: Creating Functions to Format Cells
    • Lesson 3: Preparing for Internationalization and Accessibility
  • Module 8: Conclusion
    • Lesson 1: Course Conclusion
  • Module 9: Projects
    • Lesson 1: Solving Business Problems - Minimizing Transportation Costs Using Excel
    • Lesson 2: Conducting a Breakeven Analysis Using Template
    • Lesson 3: Automating Workbooks by using Macros

View Full Curriculum


Microsoft PowerPoint Certification Course

Dominate Your Next Office Presentation after Passing This PowerPoint Tutorial

By 1337 Institute of Technology | in Online Courses

Microsoft Powerpoint is used to create attractive, well-formatted presentations that may be incredibly useful in the workplace. In this course, you will learn the fundamentals behind Microsoft Powerpoint 2013 and create slideshows to practice your facility with the software. This is an excellent skill set to add to your professional repertoire!
  • Access 3 hours of content 24/7
  • Understand basic presentation & slide formats, and customizations
  • Learn how to modify shapes & group items to better design slides
  • Work w/ animations & transitions to add flare to your presentations
  • Insert pictures, tables, video & audio to express a point
iCoursetraining specializes in technology training courses by providing online classes for students of all skill levels and experience with busy schedules. Our online classes allow students to take courses at their own pace and schedule with step by step tutorials. Our courses offer high quality video based training presented in an easy to learn format. For more details on this course or instructor, click here.

Details & Requirements

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

Course Outline

  • Module 1: Introduction
    • Lesson 1: Introduction
  • Module 2: Introduction to Slides
    • Lesson 1: Creating Presentations
    • Lesson 2: Format A Presentation
    • Lesson 3: Customize page setup and properties
    • Lesson 4: Working with slide shows
  • Module 3: Insert and Format Shapes
    • Lesson 1: Using templates
    • Lesson 2: Insert and Format Slides
    • Lesson 3: Modifying Shapes
    • Lesson 4: Grouping Items
  • Module 4: Applying Transitions and Animations
    • Lesson 1: Insert Transitions between Slides
    • Lesson 2: Working with animations
    • Lesson 3: Set timing for Transitions and Animations
  • Module 5: Enhancing Presentations
    • Lesson 1: Inserting Pictures and Screenshots
    • Lesson 2: Inserting Tables
    • Lesson 3: Using Screen Recording
  • Module 6: Conclusion
    • Lesson 1: Conclusion

View Full Curriculum


Microsoft Access Certification Course

Build & Query Databases with Ease in Microsoft Access

By 1337 Institute of Technology | in Online Courses

Microsoft Access is a software used to build and run databases. In this course, you will learn to design and create databases and tables, query those tables, and create forms and reports. This is an important program for anybody working with large amounts of data, like address books or finance tables. Mastering Access will be a big resume boost and better qualify you for an array of professions.
  • Access 3 hours of content 24/7
  • Understand how to use Access templates
  • Review a table's anatomy, add records & understand Access options
  • Learn how to create a new table in design view, add fields & enter data
  • Use the Query Wizard to find information in your database
  • Create simple forms & reports
iCoursetraining specializes in technology training courses by providing online classes for students of all skill levels and experience with busy schedules. Our online classes allow students to take courses at their own pace and schedule with step by step tutorials. Our courses offer high quality video based training presented in an easy to learn format. For more details on this course or instructor, click here.

Details & Requirements

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

Course Outline

  • Module 1: Introduction
    • Lesson 1: Introduction
  • Module 2: Introducing Access
    • Lesson 1: Using Templates
    • Lesson 2: Reviewing the Ribbon
  • Module 3: Opening an Existing Database
    • Lesson 1: Access Options
    • Lesson 2: Opening a Database
    • Lesson 3: Reviewing the Anatomy of a Table
    • Lesson 4: Adding a Record
  • Module 4: Creating a New Database
    • Lesson 1: Creating a New Table in Design View
    • Lesson 2: Understanding the Different Data Types
    • Lesson 3: Adding Fields and Entering Data
  • Module 5: Creating a Select Query
    • Lesson 1: Using the Query Wizard
    • Lesson 2: Using the Query Design View
    • Lesson 3: Creating a New Query
  • Module 6: Creating Simple Forms
    • Lesson 1: Creating Simple Forms Using the Form Wizard
    • Lesson 2: Understanding the Form Design View
    • Lesson 3: Selecting, Moving and Resizing Control
  • Module 7: Creating Simple Reports
    • Lesson 1: Creating Simple Reports Using the Report Wizard
    • Lesson 2: Selecting, Moving and Resizing Controls
    • Lesson 3: Customizing and Branding Reports
  • Module 8: Conclusion
    • Lesson 1: Conclusion

View Full Curriculum



Terms

  • Instant digital redemption

15-Day Satisfaction Guarantee

We want you to be happy with every course you purchase! If you're unsatisfied for any reason, we will issue a store credit refund within 15 days of purchase.

×
Your Ad Blocker Is On!
Sadly, recent updates to your Ad Blocker are preventing crucial parts of our shop from loading. Frustrating. We know. We hate to nag, but please turn off your Ad Blocker or whitelist us to continue exploring our shop.