HOT
blank

Mastering Excel: Level two next steps

IT & Software

Rating4
Enroll Now

Mastering Excel: Level two next steps, available at $49.99, has an average rating of 3.95, with 45 lectures, based on 15 reviews, and has 69 subscribers.

You will learn about How to use Microsoft Excel Pivot tables to manage large data sets. Save time with avoid common errors with Excel. Learn how to use subtotals and other database features Understand how to use the IF functions and lookups, such as Vlookup and Hlookup Use conditional formatting to automatically colour up trigger cells Learn how to use named cells and ranges and work with them in formulae Create charts using advanced automated features and functions This course is ideal for individuals who are Microsoft Excel intermediate users, administrators, finance support workers, business owners, training an development creators or Don't miss out, Excel is a great time saver, but if you don't know how to do something, Excel can be a great time waster. It is particularly useful for Microsoft Excel intermediate users, administrators, finance support workers, business owners, training an development creators or Don't miss out, Excel is a great time saver, but if you don't know how to do something, Excel can be a great time waster.

Enroll now: Mastering Excel: Level two next steps

Summary

Title: Mastering Excel: Level two next steps

Price: $49.99

Average Rating: 3.95

Number of Lectures: 45

Number of Published Lectures: 44

Number of Curriculum Items: 45

Number of Published Curriculum Objects: 44

Original Price: £19.99

Quality Status: approved

Status: Live

What You Will Learn

  • How to use Microsoft Excel Pivot tables to manage large data sets.
  • Save time with avoid common errors with Excel.
  • Learn how to use subtotals and other database features
  • Understand how to use the IF functions and lookups, such as Vlookup and Hlookup
  • Use conditional formatting to automatically colour up trigger cells
  • Learn how to use named cells and ranges and work with them in formulae
  • Create charts using advanced automated features and functions

Who Should Attend

  • Microsoft Excel intermediate users, administrators, finance support workers, business owners, training an development creators
  • Don't miss out, Excel is a great time saver, but if you don't know how to do something, Excel can be a great time waster.

Target Audiences

  • Microsoft Excel intermediate users, administrators, finance support workers, business owners, training an development creators
  • Don't miss out, Excel is a great time saver, but if you don't know how to do something, Excel can be a great time waster.

Welcome to the course on Excel level 2. In this course, you will learn how to use advanced features and functions of Excel to create, analyze, and present data. You will also learn how to automate tasks, work with multiple worksheets and workbooks, and use data validation and protection tools. By the end of this course, you will be able to:

– Apply conditional formatting and custom number formats to enhance the appearance of your worksheets.

– Use formulas and functions such as IF, VLOOKUP, SUMIF, COUNTIF, and more to perform complex calculations and data analysis.

– Create and modify charts, sparklines, and slicers to visualize and summarize data.

– Use pivot tables and pivot charts to organize and manipulate large data sets.

– Link, consolidate, and group data from multiple worksheets and workbooks.

This course is designed for intermediate users of Excel who want to enhance their skills and productivity. To enroll in this course, you should have completed Excel level 1 or have equivalent knowledge and experience. You should also have access to a computer with Excel 2016 or later installed.

We hope you enjoy this course and find it useful for your personal or professional goals. If you have any questions or feedback, please feel free to contact us at any time. Thank you for choosing us as your learning partner.

Outline is below:

· Conditional formatting

· Average function/Count

· Maximum function/Sum

· Minimum function/SumIF

· Basic Scenarios

· Sheet Layout and design

· Named Cells/Ranges

· Absolute Referencing/ percentages

· Basic Pivot Tables

· Using 3-D Referencing

· Goal Seek

· Data Tables

· Sheet and cell Protection

· Linking Sheets and Workbooks

· Using Array Formulae

· Using Group and Outline/Saving Views

· Naming Worksheets

· Using the Subtotals Feature

· Creating Templates

· Basic Lookups/Basic IF

Course Curriculum

Chapter 1: Overview presentation

Lecture 1: 0.0 Introduction

Lecture 2: 1.0 Linking sheets and workbooks

Lecture 3: 1.1 Linking Sheets Instructions

Lecture 4: 1.4 Revision exercise Instructions

Chapter 2: Names and Conditional Formatting

Lecture 1: 2.0 Names and named ranges

Lecture 2: 3.0 Conditional Formatting

Lecture 3: 3.0A Automatically highlight weekends

Lecture 4: 3.1 Exercise tracker

Lecture 5: 3.2 Weight Loss tracker

Lecture 6: 3.3 Covid19 Test Monitor

Lecture 7: 3.4 Project Management Heat Map using conditional formatting

Lecture 8: 3.5 The Bradford Factor

Lecture 9: 3.6 Conditional Formatting and names exercise instructions

Chapter 3: 4.0 Grouping, Subtotals, CountIF and forms

Lecture 1: 4.0 Grouping and Outline

Lecture 2: Ratios

Lecture 3: 4.1 Subtotal and CountIF

Lecture 4: 4.2 Basic IF CountIF and SumIF statements

Lecture 5: 4.3 Timesheet with an IF

Lecture 6: 4.4 Exercise Instruction IF SumIF CountiF

Lecture 7: 4.6 Database Forms

Lecture 8: 4.7 Forms Exercise Instruction

Chapter 4: 5.0 Dynamic charts and SmartArt

Lecture 1: 5.0 SmartArt

Lecture 2: 5.1 Dynamic organisation charts

Lecture 3: 5.2 Exercise intructions SmartArt

Lecture 4: QR Codes

Chapter 5: 6.0 Advanced charts

Lecture 1: 6.0 Dynamic Charts

Lecture 2: Gannt Chart with a progress line

Lecture 3: 6.1 Excel Maps

Lecture 4: 6.2 3D Maps

Lecture 5: 6.3 Intermediate charts

Lecture 6: S Curve Chart

Lecture 7: Pareto Analysis chart

Lecture 8: 6.4 Exercise Instruction charts

Chapter 6: 7.0 Vlookup and Hlookup

Lecture 1: 7.0 Vlookup and Hlookup

Lecture 2: 7.1 Exercise Instructions Vlookup and Hlookup

Chapter 7: 8.0 Create an Invoice

Lecture 1: 8.0 Invoice

Lecture 2: 8.1 Invoice exercise instruction

Chapter 8: 9.0 Pivot tables and charts

Lecture 1: 9.0 Pivot tables

Lecture 2: 9.0A Dashboard with Camera

Lecture 3: 9.0B Link Access to Excel

Lecture 4: 9.1 Pivot exercise Instructions

Chapter 9: 10.0 Data Analysis

Lecture 1: 10.0 Data Analysis

Lecture 2: 10.1 Exercise intructions data analysis

Chapter 10: 11.0 Final Exercise

Lecture 1: 11.0 Final Exercise Instructions

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 2 votes
  • 3 stars: 2 votes
  • 4 stars: 4 votes
  • 5 stars: 7 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024

Top 10 Smart Home Technology Courses to Learn in November 2024

Top 10 Agile Methodologies Courses to Learn in November 2024