image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

If you are looking for, or already have a job in the insurance industry and want to take your Excel skills from beginner to intermediate, this course is for you! We'll start at the beginning where you'll learn important keystrokes and formulas and then move onto Pivot Tables and graphs. At the end of the course we'll discuss how to apply these skills to create effective and professional exhibits that will impress your colleagues. There are cheat sheets and quizzes included throughout the course to further your knowledge and test your skills. Once you've completed the course and mastered the content, you'll be able to confidently state that you're an intermediate Excel user and begin wowing the crowd with your new Excel skills.
Who this course is for:
This Excel couse is meant for insurance professionals who want to take their Excel skills from beginner to intermediate. This course is probably not for you if you are already an advanced Excel user.

What you'll learn

Navigate quickly through Excel by using keystrokes

Manipulate data using formulas and Pivot Tables

Conduct analyses and create effective visuals using Excel

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Section 1: Introduction
1
1.1-Introduction
2-Section 2: Excel Basics & Starter Formulas
5
2.1-Lecture A: What You See
2.2-Lecture B: Sample Data Description
2.3-Lecture C: Keystrokes to Help Navigate
2.4-Lecture D: Starter Formulas
2.5-Section 2 Quiz
3-Section 3: Intermediate Formulas
5
3.1-Lecture A: If Statements
3.2-Lecture B: VLookups & Hlookups
3.3-Lecture C: Combining Formulas - VLookups and If Statements
3.4-Lecture D: Troubleshooting Formulas
3.5-Section 3 Quiz
4-Section 4: Pivot Tables
5
4.1-Lecture A: How to Create a Pivot Table
4.2-Lecture B: Navigating a Pivot Table
4.3-Lecture C: Formatting a Pivot Table
4.4-Lecture D: Calculated Fields
4.5-Section 4 Quiz
5-Section 5: Graphs
5
5.1-Lecture A: How to Create a Graph
5.2-Lecture B: Different Types of Graphs
5.3-Lecture C: Selecting Data
5.4-Lecture D: Formatting Graphs
5.5-Section 5 Quiz
6-Section 6: Using Tables and Graphs to Convey Your Conclusions
4
6.1-Lecture A: How to Create Easy-to-Understand Pivot Tables and Graphs
6.2-Lecture B: Don't be Afraid of Color
6.3-Lecture C: Clear and Consistent Visuals
6.4-Section 6 Quiz
7-Section 7: Wrap Up & Review
2
7.1-Lecture A: What You've Learned
7.2-Lecture B: How to Apply These Skills in the Real World