Learn everything about Analytics

Setting Up a Database in Excel 2013 – Lynda

Lynda
0-6 MonthOnline
IntermediateContact Institute
OnlineBusiness Intelligence
Online Self Paced975
Rate this post
DescriptionProgram StructureToolsFacultyContact

Excel isn’t just for flat files. You can use it to create a simple database and get even more insights into your data. Join author Dennis Taylor and learn how to create a simple database. The course explains the limits of Excel as a data-management tool and spells out the design considerations for creating a database with it. Dennis also shows how to simplify database creation with tables and manage data with the Form and Data Validation tools.

Course Program:

  • Understanding database-design concerns like large lists
  • Converting data into tables
  • Working with formulas
  • Using slicers to facilitate table filtering
  • Using the Form tool to build and view data
  • Using data validation to restrict data entries

Fees:

INR 15, 00 (assuming $ = INR 60)

Duration:

49 minutes 24 Seconds

  • Excel
  • Dennis Taylor
Name :
Email :
Contact Number :
Message :
Code :

Leave A Reply

Your email address will not be published.

Join 100000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:




 P.S. We only publish awesome content. We will never share your information with anyone.

Subscribe!