The Complete Microsoft Office Certification Bundle
4906 Enrolled
4 Courses
$19.00$2,980.00
You save 99%
What's Included
$995.00 Value
Microsoft Excel for Beginners
1337 Institute of Technology
36 Lessons
12 months
- Experience level required: All levels
- Length of time users can access this course: 12 months
Course Curriculum
36 Lessons
- Module 1: Getting StartedLesson 1: Course Introduction and AgendaLesson 2: What is Excel?Lesson 3: Using the RibbonLesson 4: Spreadsheet TerminologyLesson 5: Overview of the Excel InterfaceLesson 6: Workbook and Worksheet Views and Zoom
- Module 2: Basic Worksheet SkillsLesson 1: Creating Worksheets and WorkbooksLesson 2: Using Templates and Importing FilesLesson 3: Copying and Moving WorksheetsLesson 4: Selecting a Range, Columns, Rows and Non-Contiguous CellsLesson 5: Formatting Cells and RangesLesson 6: Order and Group Cells and Ranges and Using AutofillLesson 7: Customizing Options Working with Print and Save Commands
- Module 3: Working with FormulasLesson 1: Order of Operations and Using FormulasLesson 2: Common Functions: AVERAGE, MAX, MIN, COUNTLesson 3: Working with Date Arithmetic and Currency FormattingLesson 4: Relative vs. Absolute Cell AddressingLesson 5: Conditional Logic in Formulas: SUMIF, AVERAGEIF, and COUNTIFLesson 6: Format and Modify Text using Formulas: RIGHT, LEFT, MID, TRIM, UPPER, LOWER, CONCATENATE
- Module 4: Editing WorkbooksLesson 1: Deleting a Range and Using Undo and Redo CommandsLesson 2: Using Cut, Copy, and Using Paste OptionsLesson 3: Using the Clipboard, and Find and Replace Commands
- Module 5: Formatting WorksheetsLesson 1: Inserting, Deleting and Adjusting Columns and RowsLesson 2: Changing Numeric Formats Using the Format Cells Dialog BoxLesson 3: Changing Text Formats and Aligning Date using Borders and ShadingLesson 4: Using the Format PainterLesson 5: Working with Themes and using Cell Styles
- Module 6: Multiple WorkbooksLesson 1: Using the Zoom Feature and Splitting the WIndowLesson 2: Tilling Multiple Workbooks, Synchronous Scrolling, and Working with Freeze and Unfreeze Panes Options
- Module 7: Protecting WorkbooksLesson 1: Adding, Hiding, Deleting Comments, and Working with Locking and Unlocking Cell Ranges
- Module 8: Printing and Page SetupLesson 1: Using Page Break Preview, Print Preview, and Changing Page OrientationLesson 2: Changing the Margins, and Adding Headers and FootersLesson 3: Setting Sheet Options, Setting Print Titles and Areas Using the Page Layout Tab
- Module 9: Charts and ObjectsLesson 1: Creating and Formatting Charts and GraphsLesson 2: Insert and Formatting Objects
- Module 10: ProjectsLesson 1: Consolidating several worksheets into oneLesson 2: Creating Tables and ChartsLesson 3: Working with Formulas
Microsoft Excel for Beginners
1I
1337 Institute of TechnologyiCoursetraining 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.Description
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
Specs
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
$995.00 Value
Advanced Microsoft Excel Training
1337 Institute of Technology
33 Lessons
12 months
$495.00 Value
Microsoft PowerPoint Certification Course
$495.00 Value
Microsoft Access Certification Course
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your Cart
Your cart is empty. Continue Shopping!
Processing order...