Ending In:
$2,980
99% off
Courses
4
Enrolled
4,536
Courses
4
Enrolled
4,536
What's Included
Microsoft Excel for Beginners
$995 Value
Advanced Microsoft Excel Training
$995 Value
Microsoft PowerPoint Certification Course
$495 Value
Microsoft Access Certification Course
$495 Value
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
- 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
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
- 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
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
- 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
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
- 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
Terms
- Unredeemed licenses can be returned for store credit within 15 days of purchase. Once your license is redeemed, all sales are final.
