Essential Skills

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

• Lesson 1 - Excel Basics
• Lesson 2 - Creating a Worksheet
• Lesson 3 - Time-Savers
• Lesson 4 - Relative, Absolute, Mixed, and Circular References
• Lesson 5 - Three-Dimensional Workbooks
• Lesson 6 - Sorting, Subtotaling, and Filtering
• Lesson 7 - Charting Basics
• Lesson 8 - Advanced Charting Techniques
• Lesson 9 - Intro to Excel's Statistical Functions
• Lesson 10 - Financial Functions
• Lesson 11 - Worksheet Automation
• Lesson 12 - Mastering Excel's IF Function

Prerequisites:
There are no prerequisites to take this course.

Hardware Requirements:
This course must be taken on a PC. It is not suitable for Chromebook and Mac users.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Microsoft Excel 2019 (desktop version), available to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
• Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.

Wallace Wang is the author of over 40 computer books including "Microsoft Office 2019 For Dummies." In addition to writing computer books, he has also co-authored "Breaking Into Acting for Dummies" and ghostwritten several books about investing in real estate, day trading stocks, and becoming an entrepreneur.

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $5 billion. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting.

Tracy Loffer holds a Master's degree in Education in Curriculum and Instruction. She has been involved in education for twenty years, as a music educator and technology trainer of students and teachers. She has also worked in the private sector as a trainer of domestic and international technology franchisees as well as a writer and developmental editor of educational technology materials using Office and Publisher.

1. Introduction to Microsoft Excel 2019/Office 365

1. Excel Basics
2. Creating a Worksheet
3. Time-Savers
4. Relative, Absolute, Mixed, and Circular References
5. Three-Dimensional Workbooks
6. Sorting, Subtotaling, and Filtering
7. Charting Basics
8. Advanced Charting Techniques
9. Intro to Excel's Statistical Functions
10. Financial Functions
11. Worksheet Automation
12. Mastering Excel's IF Function

2. Introduction to Microsoft PowerPoint 2019/Office 365

1. The PowerPoint 2019 Interface
2. Creating Presentations
3. Working With Files and Creating and Editing Tables
4. Creating Professional Presentations
5. Working With the Images Group
6. WordArt and the Illustrations Group
7. All About Charts
8. Making Global Changes to a Presentation
9. Creating Links
10. Applying Animation to Slides, Text, and Objects
11. Adding Advanced Animation Effects to Text and Objects
12. Sharing and Saving Your Presentations

3. Introduction to Microsoft Word 2019/Office 365

1. Getting Started
2. Typing and Navigation
3. File Management
4. Editing Text
5. Working With Multiple Documents
6. Text Formatting and Alignment
7. Printing
8. Margins, Tabs, and Page Numbering
9. Paragraph Formatting
10. Language Tools
11. Customizing Word
12. Making a Word Document Pretty and Organized

Prerequisites:
There are no prerequisites to complete these courses.

Hardware Requirements:
This course must be taken on a PC. Macs are not compatible.

Software Requirements:

• PC: Windows 10 or later.
• Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
• Adobe Acrobat Reader.
• Software must be installed and fully operational before the course begins.
• Microsoft Word, Excel, and PowerPoint 2019 (desktop versions) Available to download with a subscription to Microsoft 365, or with Microsoft Office Home and Student 2019. (not included in enrollment)
• Note: The "Starter Version" and "Web App" versions of Microsoft Word, Excel, and PowerPoint will not work with the full versions of the software taught in this course.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.

Learning Outcomes:

• Identify strategies for making professional connections
• Cultivate strong relationships at work
• Consider how to network over the course of a career
• Identify potential resources for networking
• Explain how to use business cards effectively
• Explore the importance of networking during the job search process
• Describe strategies for effective cold call emailing
• Examine networking strategies for introverts
• Consider the role that gender can play in networking
• Describe tips for handling awkward conversations
• Explore strategies for conquering networking anxiety

"I really enjoyed this class. I learned some new tips on how to properly network and cold call and cold email. This is information I can put to use right away. Thank you!"

What are the minimum technical requirements?
Software: 

• Any modern Office suite: Microsoft Office, Apple iWork, OpenOffice, or LibreOffice
• The latest Adobe Reader/Acrobat Reader ( free download available at https://get.adobe.com/reader/ )

Web Browser:

• An updated version of one of the major modern browsers: Chrome, Edge, Firefox, Safari, or Internet Explorer 11
• Cookies must be enabled
• JavaScript must be enabled

Reliable internet connection:
Broadband cable or highspeed DSL is recommended for optimal experience.

Note: Some courses may have additional hardware and/or software requirements. Any additional requirements will be listed in the course description and course syllabus.

What is your refund policy?
You may request a refund up to 7 days from the purchase date. The registration fee will only be refunded if less than 10% of the course has been completed.

How do I contact technical support?
To report technical issues please email us at support@mindedge.com.

What are badges?
We now issue Badges, an online standard to recognize and verify learning, for more than 100 courses and simulations offered here online.

Badges allow students and professionals to publicly share their skills, knowledge, and accomplishments online, which may help with future career and education opportunities. Learners can manage and share badges across the web from their Badgr. (You can set up a free Badgr at https://badgr.com/.)

Learners who successfully complete their course or simulation will earn Badges. They can share their credentials online through social media and display them on resumes and transcripts.

Learning Outcomes:

• Recognize key career development questions to ask before beginning a job search
• Employ a written goal-setting process to establish career development and job search priorities
• Recognize the purpose of tailoring a resume and cover letter
• Develop a more effective resume
• Develop a more effective cover letter
• Identify the five stages of the interview process
• Conduct industry and company research efficiently using web-based resources
• Brainstorm potential interview questions and answers
• Understand what constitutes a good answer in the mind of a hiring manager
• Anticipate some of the most common interview questions
• Explain to a hiring manager how the past successes represented on your resume will translate to future success in your desired position
• Recognize whether a job aligns with your career objectives

"Very well organized, easy for navigating and moving along one step at a time!"

"The course was well put together."

What are the minimum technical requirements?
Software: 

• Any modern Office suite: Microsoft Office, Apple iWork, OpenOffice, or LibreOffice
• The latest Adobe Reader/Acrobat Reader ( free download available at https://get.adobe.com/reader/ )

Web Browser:

• An updated version of one of the major modern browsers: Chrome, Edge, Firefox, Safari, or Internet Explorer 11
• Cookies must be enabled
• JavaScript must be enabled
• Reliable internet connection:
• Broadband cable or highspeed DSL is recommended for optimal experience.

Note: Some courses may have additional hardware and/or software requirements. Any additional requirements will be listed in the course description and course syllabus.

What is your refund policy?
You may request a refund up to 7 days from the purchase date. The registration fee will only be refunded if less than 10% of the course has been completed.

How do I contact technical support?
To report technical issues please email us at support@mindedge.com.

What are badges?
We now issue Badges, an online standard to recognize and verify learning, for more than 100 courses and simulations offered here online.

Badges allow students and professionals to publicly share their skills, knowledge, and accomplishments online, which may help with future career and education opportunities. Learners can manage and share badges across the web from their Badgr. (You can set up a free Badgr at https://badgr.com/.)

Learners who successfully complete their course or simulation will earn Badges. They can share their credentials online through social media and display them on resumes and transcripts.

Learning Outcomes:

• Understand the basic concepts of home computing and networking
• Be empowered to make informed and effective choices regarding products and services
• Utilize different tools and resources to troubleshoot common computing problems
• Identify the key steps to having your own domain for web or email services
• Effectively identify and use cloud computing resources
• Identify common pitfalls and expenses in home technology
• Effectively secure home resources

What are the minimum technical requirements?
Software: 

• Any modern Office suite: Microsoft Office, Apple iWork, OpenOffice, or LibreOffice
• The latest Adobe Reader/Acrobat Reader ( free download available at https://get.adobe.com/reader/ )

Web Browser:

• An updated version of one of the major modern browsers: Chrome, Edge, Firefox, Safari, or Internet Explorer 11
• Cookies must be enabled
• JavaScript must be enabled
• Reliable internet connection:
• Broadband cable or highspeed DSL is recommended for optimal experience.

Note: Some courses may have additional hardware and/or software requirements. Any additional requirements will be listed in the course description and course syllabus.

What is your refund policy?
You may request a refund up to 7 days from the purchase date. The registration fee will only be refunded if less than 10% of the course has been completed.

How do I contact technical support?
To report technical issues please email us at support@mindedge.com.

What are badges?
We now issue Badges, an online standard to recognize and verify learning, for more than 100 courses and simulations offered here online.

Badges allow students and professionals to publicly share their skills, knowledge, and accomplishments online, which may help with future career and education opportunities. Learners can manage and share badges across the web from their Badgr. (You can set up a free Badgr at https://badgr.com/.)

Learners who successfully complete their course or simulation will earn Badges. They can share their credentials online through social media and display them on resumes and transcripts.

Learning Outcomes:

• Recognize when it's appropriate to use an email, a memo, or a letter
• Explain the parts of an email, a memo, and a letter, and format each so that the communication is effective
• Consider primary and secondary uses for the email, memo, or letter
• Explain how to facilitate both primary and secondary uses
• Create a sample email, memo, and letter employing best practices

"This was a wonderful refresher course for those of us who have been in the business world for many years. I would highly recommend this to anyone coming into the workforce or those, like myself, who have been in it a while. It teaches you how to know when to use a letter, a memo, or an email when corresponding with various business associates. It also teaches you when to use and not to use certain salutations and, finally, the proper method of using PS (post script)."

"This course was very informational, and I learned way more than I thought I would. I went in thinking I knew how to write emails, memos, and letters, but I was willing to learn some new tips to make my writing better. I went through the course and found out there was a lot of information I was doing incorrectly and learned many ways to make my writing better!"

What are the minimum technical requirements?
Software: 

• Any modern Office suite: Microsoft Office, Apple iWork, OpenOffice, or LibreOffice
• The latest Adobe Reader/Acrobat Reader ( free download available at https://get.adobe.com/reader/ )

Web Browser:

• An updated version of one of the major modern browsers: Chrome, Edge, Firefox, Safari, or Internet Explorer 11
• Cookies must be enabled
• JavaScript must be enabled
• Reliable internet connection:
• Broadband cable or highspeed DSL is recommended for optimal experience.

Note: Some courses may have additional hardware and/or software requirements. Any additional requirements will be listed in the course description and course syllabus.

What is your refund policy?
You may request a refund up to 7 days from the purchase date. The registration fee will only be refunded if less than 10% of the course has been completed.

How do I contact technical support?
To report technical issues please email us at support@mindedge.com.

What are badges?
We now issue Badges, an online standard to recognize and verify learning, for more than 100 courses and simulations offered here online.

Badges allow students and professionals to publicly share their skills, knowledge, and accomplishments online, which may help with future career and education opportunities. Learners can manage and share badges across the web from their Badgr. (You can set up a free Badgr at https://badgr.com/.)

Learners who successfully complete their course or simulation will earn Badges. They can share their credentials online through social media and display them on resumes and transcripts.

Courses Included in this Certificate

• Effective Business Writing
• Effective Presentations
• Effective Public Speaking
• Communicating Collaboratively
• Effective Emails, Memos, and Letters

"Great learning experience! I have become conscious of avoiding jargon! The presentations were clear and precise! Thank you!"

"This course provided useful information and exercises that aid in grasping key concepts while at the same time being able to apply what was learnt."

What are the minimum technical requirements?
Software: 

• Any modern Office suite: Microsoft Office, Apple iWork, OpenOffice, or LibreOffice
• The latest Adobe Reader/Acrobat Reader ( free download available at https://get.adobe.com/reader/ )

Web Browser:

• An updated version of one of the major modern browsers: Chrome, Edge, Firefox, Safari, or Internet Explorer 11
• Cookies must be enabled
• JavaScript must be enabled
• Reliable internet connection:
• Broadband cable or highspeed DSL is recommended for optimal experience.

Note: Some courses may have additional hardware and/or software requirements. Any additional requirements will be listed in the course description and course syllabus.

What is your refund policy?
You may request a refund up to 7 days from the purchase date. The registration fee will only be refunded if less than 10% of the course has been completed.

How do I contact technical support?
To report technical issues please email us at support@mindedge.com.

What are badges?
We now issue Badges, an online standard to recognize and verify learning, for more than 100 courses and simulations offered here online.

Badges allow students and professionals to publicly share their skills, knowledge, and accomplishments online, which may help with future career and education opportunities. Learners can manage and share badges across the web from their Badgr. (You can set up a free Badgr at https://badgr.com/.)

Learners who successfully complete their course or simulation will earn Badges. They can share their credentials online through social media and display them on resumes and transcripts.