Home| All Programs| Today added Progs| Download Status| Customers opinion| Helpdesk| Shopping cart| Logout ()

Program Search:

Shopping Cart:




*Note: Minimum order cost: $10
Maximum Total Price: $1000
We Recommend:
Lynda.com Creating Interactive Dashboards in Excel 2013 $15 buy download


2015
Lynda
Nate Makdad
2:34
English

Learn how to explore and analyze your data by creating an interactive dashboard in Excel using pivot tables and a little Visual Basic. Using these lessons, you can create a dynamic template to generate reports for customers and to better understand your own data. Along the way, you'll learn how to import external data, design a template using pivot tables, and add slicers, macros, and action buttons to make the template more interactive. Author Nate Makdad also shares some basic principles of visual design to guide you in developing an easy-to-use and visually appealing report.

Introduction
Welcome
Using the exercise files
1. Introduction to Dynamic Dashboards
Why would you want to create a dynamic dashboard?
Topics in this course
2. Preparing Your Data
Defining your requirements
Selecting your software
Setting up your data
Creating variables
Adding reference tables
Creating action queries
3. Designing Your Visual Layout
Introduction to visual design
Creating hierarchy in the template
Design elements: Color
Design elements: Typography and font size
4. Designing the Report
Importing data using PivotTables
Learning the four dimensions of a pivot table
Inserting slicers
Advanced slicers
Recording a macro
Editing VBA code
Copying VBA code to all macros
Inserting control buttons
Formatting charts
5. Improving User Experience
Definitions and help text
Inserting hyperlinks within a report
Debugging the template
Updating your data
Conclusion
Next steps




Download File Size:438.63 MB


Lynda.com Creating Interactive Dashboards in Excel 2013
$15
Customers who bought this program also bought:
  • Lynda.com Excel 2013 Pivot Tables in Depth $15
  • Excel 2013 For Dummies EPUB, MOBI, PDF eBook $10
  • Udemy Master Excel 2013 Formulas and VBA programming $10

  • Home| All Programs| Today added Progs| Download Status| Customers opinion| Helpdesk| Shopping cart      
    Copyright 2006-2010 ©   LPStore   All Rights Reserved




    Adobe Photoshop CC 2017 18.0 Multilingual x64. Create anything you can imagine. Anywhere you are. The world's best imaging and design app is at the core of almost every creative project. Work across desktop and mobile devices to create and enhance your photographs, web and mobile app designs, 3D artwork, videos and more.
    new Adobe Photoshop CC 2017 18.0 Multilingual x64 $81 REAL PRICE 389,97 $


    Adobe Illustrator CC 2017 21.0.0 Multilingual . Create beautiful vector art. The industry-standard vector graphics app lets you create logos, icons, sketches, typography, and complex illustrations for print, web, interactive, video, and mobile. It's Illustrator like you've never seen it. See how the fastest Illustrator ever helps you go from first idea to finished artwork just like that.

    Illustrator CC (2017)

    Create pixel-perfect artwork Draw paths and shapes that seamlessly align to the pixel grid. Align existing artwork with a single click or by using simple transformations. Preserve Live Shapes and rounded corners, maintain alignment when scaling and rotating objects, and manually nudge segments and end points into perfect alignment.
    REAL PRICE $386 new Adobe Illustrator CC 2017 21.0.0 Multilingual $71


    Cinema Ebooks collection 570 Ebooks PDF eBook. English
    PDF
    Large Books Collection
    Genre: Film, Cinema Related
    new Cinema Ebooks collection 570 Ebooks PDF eBook $21 REAL PRICE 8116,10 $


    Maxon CINEMA 4D Studio R18.028 Retail ISO for Win and Mac (1 dvd). Cinema 4D Release 18 puts powerful new tools in the hands of motion graphics artists, and makes VFX workflows accessible to everyone. Game designers and visualization professionals enjoy new opportunities, and workflow, modeling, animation and shader enhancements help elevate every Cinema 4D artist to a new level.

    Non-Destructive Destruction
    With the new Voronoi Fracture object you can tear down walls. Systematically shatter any object into procedural fragments using virtually anything to control the distribution of the shattered pieces. Create artistic procedural geometry using splines, polygon objects or particles. Fracture Voronoi is always live which means you can change elements at any time. As a native MoGraph object it works seamlessly with Dynamics and all the effectors and falloffs you love.
    REAL PRICE $3,510 new Maxon CINEMA 4D Studio R18.028 Retail ISO for Win and Mac (1 dvd) $75


    Panini World Cup Stickers Albums Collection Multilingual | PDF | Large Collection | 819 MB
    Genre: Stickers Album, Soccer
    Include This Albums:

    World Cup Germany '74
    World Cup Argentina '78
    World Cup Spain '82
    World Cup Italy '90
    World Cup USA '94
    World Cup France '98
    World Cup Japan & Korea '2002
    World Cup Germany '2006
    World Cup South Africa '2010
    World Cup Brasil '2014
    new Panini World Cup Stickers Albums Collection PDF eBook $1 REAL PRICE 100,00 $


    Microsoft Office Professional Plus 2016 16.0.4405.1000 July 2016 x64
    x64
    Office Related | OS: Windows Server/7/8/8.1/10
    Language: English

    Microsoft Office 2016 is the complete, cross-platform, cross-device solution for the modern workplace, with smart tools for individuals, teams, and businesses. It can open your applications, documents anywhere, across multiple devices. Get the installed applications you know and trust – Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access. Always have the latest, full installed versions of Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access and capture your ideas however you work best – using a keyboard, pen, or touchscreen. Microsoft Office 2016 will offer new security, compliance, and deployment features, giving organizations more control over sensitive data and IT more flexibility in deployment and management.
    new Microsoft Office Professional Plus 2016 $50