Curs 50450 – Curs Excel Creating and Analyzing Database Using Microsoft Excel

Working with Databases

This module explains how to make use of Excel to create a sample database format.

• Creating a Database
• Modifying a Database
• Sorting Records by Multiple Fields
• Using Data Validation
• Validating Data using a List
• Creating a Custom Error Message
• Removing Data Validation
• Creating Subtotals in a List
• Removing Subtotals from a List

Using AutoFilter

This module explains how to use AutoFilter to get their desired details from Excel List.

• Enabling AutoFilter
• Use AutoFilter to get their desired details from Excel list
• Clearing AutoFilter Criteria
• Creating a Custom AutoFilter

Working with Advanced Filters

This module explains how to make use of the advanced filter to set criteria range and copy the result to another location in Excel ranges.

• Creating a criteria range
• Showing All Records
• Using an Advanced And Condition
• Using an Advanced Or Condition
• Copying Filtered Records
• Using Database Functions

Lookup Formulas

This module explains how to make use of Vlookup, Hlookup to retrieve desired items in Excel Tables.

• Using VLookup
• Using HLookup

Exporting and Importing Data

This module explains how to import and export Excel data to text formats. It also shows how to import data from the web.

• Exporting Data to Other Applications
• Exporting to XML
• Importing Data from Text Files
• Changing Properties
• Importing Data from Other Applications
• Removing the Query Definition
• Importing Dynamic Data from the Web
• Copying a Table from a Web Page

Exporting and Importing Data

After completing this module, students will be able to:

• Import and export data to Text format
• Import data from other applications
• Import data from the Web

Creating/Revising PivotTables

This module explains how to use determine the source needed to create its PivotTable/PivotChart report

• Creating a PivotTable Report
• Adding PivotTable Report Fields
• Selecting a Page Field Item
• Refreshing a PivotTable Report
• Changing the Summary Function
• Adding New Fields to a PivotTable Report
• Moving PivotTable Report Fields
• Hiding/Unhiding PivotTable Report Items
• Deleting PivotTable Report Fields
• Creating a Page Field Report
• Formatting a PivotTable Report
• Creating a PivotChart Report

Inregistrati-va

Locatia de desfasurare a cursului:

Sediul Learning Solution: Str. Transilvaniei nr. 24, Sector 1, Bucuresti

Cine susține cursul?

Familiarity with Microsoft Office applications – particularly Excel

Curs Creare Dashboards Cu PowerPivot Power View Si SharePoint – Curs 55103
Curs 50450 – Curs Excel Creating and Analyzing Database Using Microsoft Excel
Curs 55084 – Curs Excel 2013 Self-Service Analytics with No Code for the End User
Curs Excel 2013 – Advanced Microsoft Excel 2013
Curs Excel 2013 PowerPivot – PowerBI
Curs 50448 Maximizing PivotTable Microsoft Excel
Curs 55143 Microsoft Office Excel Basic Workbooks Formulas and Functions
Curs Microsoft Excel 2016 – Incepator
Curs Microsoft Excel 2016 – Mediu
Curs Microsoft Excel 2016 – Avansat
Curs Microsoft Excel 2013 – Incepator
Curs Microsoft Excel 2013 – Mediu
Curs Microsoft Excel 2013 – Avansat
Curs Microsoft Excel 2010 – Incepator
Curs Microsoft Excel 2010 – Mediu
Curs Microsoft Excel 2010 – Avansat
Curs Microsoft Excel 2007 – Incepator
Curs Microsoft Excel 2007 – Mediu
Curs Microsoft Excel 2007 – Avansat