Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Database Analysis in MS Excel

( Duration: 1 Day )

In Database Analysis in MS Excel training course, you would learn to understand and use the various database features in Excel to manage databases effectively and create efficient database models.

This Database Analysis in MS Excel class is suitable for those who have good working knowledge and experience in using Microsoft Excel and who want to use Excel database features to manage and analyse information in databases.

COURSE AGENDA

1

Introduction to Excel Database

2

Working with Data Series

3

Working with Databases

4

Importing and Exporting Data

5

Table Formatting

6

Using the Data Form

7

Sorting Records

8

Using AutoFilter

9

Advanced Filter Setup

10

Grouping and Outlining

11

Subtotals

12

Using Database Functions

13

Creating and Revising Pivot Tables

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X