Excel 365 - Data Management

Instructor
DB Academy
10 Students enrolled
0
0 reviews
  • Description
  • Reviews
Software,For,Accounting,With,Sheet,,Formula,,Calculators.,Organizing,Accounting,,Financial,

Important to know:
The course video is English with Romanian subtitles and test questions are in Romanian.

Overview

This 8-clip course gives you an in-depth exploration of the tools available for data analysis and examines complex formulas in Excel for Office 365. Students will learn how to use Power Query to transform data to fit in an Excel file. This course demonstrates how Excel allows you to import and edit data in a CSV (comma-separated value) file. Next, you’ll learn how to use the LOOKUP formula to find a value in a double-entry table. This course goes on to show you how to use different formulas to make calculations when multiple conditions are applied. You will examine the IFS and SWITCH functions to test more conditions without embedding the IF function. Next, you’ll learn how to use AVERAGEIF, MINIFS, and MAXIFS. You will learn how to use the NPER (required number of periods) feature to calculate the number of months required to repay a loan. Finally, you will learn how to use the IF and DNA functions for data prediction.

 

Objectives

  • Import, edit, and update data from a text file
  • Import, edit, and update data from a .csv file
  • Use LOOKUP, MATCH, and INDEX functions to extract data
  • Apply multiple conditions without nesting other functions
  • Calculate average values using one or more conditions
  • calculating the smallest and largest number that meet one or more criteria
  • counting cells that meet one or more criteria
  • calculating the periods required to pay off a loan and predict loan approval , which meet one or more criteria
Get Course
Course details
Video 00:40:04
Level Advanced

Related Courses

Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Adding visuals to Excel workshe...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Students will take a closer loo...
Advanced
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Students can explore the use of...
Advanced
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview An image can take up to a thous...
Intermediate
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview A PivotTable is a useful tool f...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Making your data look good is e...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Excel 2016 gives you ...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Excel 2010 Provides multiple fe...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Although it may seem complicate...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview To automate repetitive tasks, E...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Excel 2010  provides a number o...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview As both business and home users...
Introductory
€7.90
Microsoft Excel
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Explore how to use tables in Ex...
Advanced
€6.40
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  In Excel for Office 365, you c...
Advanced
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Students can explore a wide ran...
Advanced
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Excel 2010 provides you with a ...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview This 10-clip course provides st...
Advanced
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Excel 2016 is a very ...
Advanced
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Using the chart feature in Exce...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview The Excel 2010 Function Library...
Introductory
€7.90
Microsoft Excel
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Excel 2016 makes it e...
Introductory
€12.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview You can customize the look and ...
Introductory
€7.90
Microsoft Excel
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Excel 2016 allows you...
Introductory
€12.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview This 8-clip course gives you an...
Advanced
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  This 11-clip course provides s...
Advanced
€7.90
Microsoft Excel
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Excel 2016 provides a...
Intermediate
€12.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  If you use Excel worksheet to ...
Advanced
€7.90
Microsoft Excel
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Using macros in Excel 2016 save...
Intermediate
€12.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Explore ways to analyze trend d...
Advanced
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Formulas are an integral and im...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Explore how to use reference ce...
Advanced
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Excel 2010 is the latest versio...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview The ability to collaborate with...
Introductory
€7.90
Microsoft Excel
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview It’s easy to make your Mi...
Intermediate
€12.90
Microsoft Excel
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview In this 6-clip course, you&#821...
Advanced
€6.40
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview There are a number of methods f...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Excel 2010 provides tools to he...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview One of the great features of Ex...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  Excel 2010 Provides powerful d...
Introductory
€7.90
Microsoft Excel
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview In this 10-clip course, learner...
Advanced
€12.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview The ability to handle data easi...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview This 10-clip course provides st...
Advanced
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview  This 8-clip course explores ho...
Advanced
€7.90
Microsoft Excel
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Microsoft Excel 2016 gives you ...
Intermediate
€12.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Excel 2010 makes it easy for yo...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview One of the most effective tools...
Introductory
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview In Microsoft Excel 2016, PivotT...
Intermediate
€7.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Excel 2010 provides you with th...
Introductory
€7.90
Digital Transformation
€15.90
Acest curs conține exerciții practice despre soluțiile de manipulare a datelor. Vei putea afla din acest curs (cu ajutorul exemplelor 100% practice...
Advanced
7 Lectures
€15.90
Microsoft Excel
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Using tables, charts, and image...
Introductory
€7.90
Individual
Business
Partner

Register as Individual

For those who are individual learners, team members of a business, business professionals.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Register as Business

Business Leaders / HR Responsibilities / Other company representatives who want to upskill employees.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Register as Partner

For companies which want to colobrate with DB Academy and publish educational content for their customers.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Login

Authanticate to DB Academy.

{{this.errorMessage}}

{{this.successMessage}}

New to DB Academy?

Forgot your password?