Excel Analyst'S Guide To Access

Afbeeldingen

Artikel vergelijken

  • Engels
  • Paperback
  • 9780470567012
  • 06 april 2010
  • 624 pagina's
Alle productspecificaties

Michael Alexander

Michael Alexander is Professor of English at the University of St Andrews, and translator/editor of Beowulf: A Verse Translation and Beowulf: A Glossed Text, Chaucer's The Canterbury Tales: The First Fragment and The Earliest English Poems.

Samenvatting

The ultimate handbook for Excel analysts who need reporting solutions using Access Excel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions.

Use the right tool for the job

Like many managers, accountants, and analysts, you've been using Excel for data analysis. It's a good tool, but you're beginning to find its limitations frustrating. You're looking for more scalability. More transparency of analytical processes. The ability to separate data from presentation.

Access makes it all possible, and this guide helps you add Access to your analytical toolbox. Learn the essentials of using Access, basic and advanced analysis techniques, how to build reports, and much more. Then you can choose the right tool for every job.

  • Easily move data between Excel and Access

  • Normalize and store Excel data in a structured relational database

  • Use Access to analyze large amounts of data

  • Use Excel pivot tables with Access data

  • Build reports and implement dashboard-style visualizations

  • Report Access data using Excel's presentation layer

  • Automate redundant reporting and analysis using Excel and Access macros

  • Save time and increase productivity by automating redundant processes using VBA

  • Get external data using SQL, ADO, and XML

Productspecificaties

Inhoud

Taal
en
Bindwijze
Paperback
Oorspronkelijke releasedatum
06 april 2010
Aantal pagina's
624
Illustraties
Nee

Betrokkenen

Hoofdauteur
Michael Alexander
Hoofduitgeverij
Onbekend

Overige kenmerken

Editie
1
Extra groot lettertype
Nee
Product breedte
185 mm
Product hoogte
36 mm
Product lengte
231 mm
Studieboek
Nee
Verpakking breedte
189 mm
Verpakking hoogte
40 mm
Verpakking lengte
239 mm
Verpakkingsgewicht
958 g

EAN

EAN
9780470567012

Je vindt dit artikel in

Taal
Engels
Beschikbaarheid
Leverbaar
Boek, ebook of luisterboek?
Boek
Studieboek of algemeen
Algemene boeken
Nog geen reviews

Kies gewenste uitvoering

Prijsinformatie en bestellen

De prijs van dit product is 35 euro en 34 cent.
2 - 3 weken
Verkoop door bol
  • Prijs inclusief verzendkosten, verstuurd door bol
  • Ophalen bij een bol afhaalpunt mogelijk
  • 30 dagen bedenktijd en gratis retourneren
  • Dag en nacht klantenservice