MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Microsoft Excel 2013 - The Best Training On The Web

Course Summary

This Microsoft Excel class will teach you everything you need to learn to become a master of Microsoft Excel.

• +

Course Syllabus

• Course Information
• Screen Settings
• Screen Settings Quiz
• The Quizzes Are Optional
• The Quizzes Are Optional
• Getting Your Certificate of Completion
• Getting Your Certificate of Completion
• Quick Start
• Excel Quick Start
• Relative References
• Absolute References
• Functions
• Creating Charts
• Calculating A Grade Example
• Gathering Data With Google Forms
• Getting Started
• Introduction To Excel
• Introduction To Excel
• Writing Formulas
• Writing Formulas
• Formula Essentials
• Formula Essentials
• Relative, Absolute, & Mixed References
• Relative, Absolute, and Mixed References
• Working With Functions
• Introduction to Functions
• Introduction to Functions
• Payment Function & Loans
• Payment Function & Loans
• Future Value Function & Pensions
• Future Value Function & Pensions
• VLOOKUP Function & Gradebooks
• VLOOKUP Function & Gradebooks
• IF, Concatenate, & Evaluation
• IF, Concatenate, & Evaluation
• Conditional Formatting
• Conditional Formatting
• IFERROR Function & Dynamic Amortization Tables
• IFERROR Function & Dynamic Amortization Tables
• Creating Charts & Graphs
• Visually Representing Data
• Visually Representing Data
• Creating Charts
• Creating Charts
• Formatting Charts
• Formatting Charts
• Scatter Charts
• Scatter Charts
• Combo Charts
• Combo Charts
• Pivot Charts
• Pivot Charts
• Harvesting Data From The Web
• Finding Data
• Finding Data
• Copying Data From The Web
• Copying Data From The Web
• Transposing Data
• Transposing Data
• Copying Data From The Web II
• Copying Data From The Web II
• Parsing Data
• Parsing Data
• Web Scraping Software
• Web Scraping Software
• Manipulating Data
• Freeze Panes
• Freeze Panes
• Filtering Data
• Filtering Data
• Removing Duplicates
• Removing Duplicates
• Sorting Data
• Sorting Data
• Subtotaling Data
• Subtotaling Data
• Data Tables
• Data Tables
• Exploring The Find Function
• Exploring The Find Function
• Exploring Filters Further
• Exploring Filters Further
• The Advanced Filter
• The Advanced Filter
• The Find Function II
• The Find Function II
• Going Pro With Pivot Tables
• Introduction to Pivot Tables
• Introduction to Pivot Tables
• Creating a Pivot Table
• Creating a Pivot Table
• Exploring Pivot Tables
• Exploring Pivot Tables
• Recommended Pivot Tables
• Recommended Pivot Tables
• Grouping in Pivot Tables
• Grouping in Pivot Tables
• Using "Slicers" in Pivot Tables
• Using "Slicers" in Pivot Tables
• Creating Pivot Charts
• Creating Pivot Charts
• Formatting For Impact
• Formatting Your Worksheet
• Formatting Your Worksheet
• Formatting Essentials
• Formatting Essentials
• Formatting Fundamentals
• Formatting Fundamentals
• Design Considerations
• Design Considerations
• Inserting & Deleting Cells, Columns, & Rows
• Inserting & Deleting Cells, Columns, & Rows
• Formatting Options
• Formatting Options
• Formatting Examples
• Formatting Examples
• Formatting Secrets
• Formatting Secrets
• Saving Time With Macros
• Understanding Macros
• Understanding Macros
• Macro Automation
• Macro Automation
• Integrating Word & Excel
• Object Linking & Embedding
• Object Linking & Embedding
• Securing Your Work
• Securing Your Worksheets
• Securing Your Worksheets
• Securing Your Workbooks
• Securing Your Workbooks
• Printing & Sharing Your Work
• Preparing To Print
• Preparing To Print
• Printing & Sharing
• Printing & Sharing
• Enhancing Your Value with Bonus Skills
• Awesome Stuff With Google
• Awesome Stuff With Google
• Google Form Examples
• Google Form Examples
• Hands-On: Creating A Gradebook
• Creating A Gradebook
• Initial Considerations
• Tracking Attendance
• Entering and Adjusting Data
• Entering Formulas and Functions
• Automated Error Checking
• Calculating All Grades
• Looking Up The Letter Grade
• Freeze Panes and Sorting
• Hands-On: Bringing Grades From Blackboard Into Excel
• Importing Data From Blackboard
• Hands-On: Creating A Loan Amortization
• Creating A Loan Amortization Schedule
• Templates
• Templates Shown Throughout Course
• Final Exam
• Final Exam
• Just For Fun!
• Bloopers
• Farewell
• Until We Meet Again!

Course Fee:
USD 10

Self-Study

Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

Microsoft Word

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software