Excel Spreadsheet Design: Extreme Makeover

Excel Spreadsheet Design: Extreme Makeover

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 0h 45m | 107 MB

Whether you’re working on an Excel file for yourself or one that will be shared with thousands, spreadsheet design is crucial. When a spreadsheet is designed poorly, it’s hard for people to find the data they need, resulting in wasted time. In this hands-on and interactive course, Excel power user Joshua Rischin shares simple design tricks to give your Excel work an extreme makeover. Josh explains how to get the design right, apply finishing touches to your work, and avoid the common pitfalls of Excel workbook design so that you can create captivating spreadsheets that wow stakeholders.

Table of Contents

Introduction
1 Continuous delivery of infrastructure with Argo CD
2 Quick prerequisite technology overview

1. Getting Started with Argo CD
3 GitOps for infrastructure automation
4 Introducing Argo CD
5 Argo CD for continuous integration of infrastructure
6 Creating a local K3s cluster
7 Architectural overview

2. Working with Argo CD on a Local Kubernetes Cluster
8 Installing Argo CD services and the CLI
9 Running the Argo CD web UI
10 Setting up a Git repo with manifest specifications
11 Deploying an application using Argo CD

3. Configuring the Argo CD Application
12 Changing the Argo CD admin password
13 Syncing updated infrastructure manifests
14 Configuring deployments using kubectl
15 Automated sync, automated pruning, and self-healing

4. Deploying Infrastructure to External Kubernetes Cluster
16 Creating an external K3s cluster
17 Creating a new Argo CD project using the CLI
18 Building and registering a custom Docker image
19 Pushing infrastructure specifications to a private Git repo
20 Deploying a Flask application to an external cluster
21 Updating the custom application

5. Deploying Infrastructure to Google Kubernetes Engine
22 Enabling the Kubernetes Engine API
23 Connecting to a GitHub repo using SSH
24 Creating a GKE cluster
25 Setting up Argo CD on GKE
26 Registering the app image with GCR
27 Configuring the image secret with a service account
28 Connecting Argo CD to a private Git repo using SSH
29 Deploying infrastructure to the GKE cluster

Conclusion
30 Summary and next steps

Introduction
1 Wow your stakeholders with an Excel extreme makeover
2 Keeping your audience in mind

1. Getting the Design Right
3 Why is spreadsheet design so important
4 Principles of user-friendly design

2. Performing an Excel Makeover
5 Laying things out the right way
6 Get your data in the right place
7 Remove ambiguity with cell formatting
8 Maintain integrity with once-only data inputs
9 Control inputs with data validation
10 Distinguish results with conditional formatting
11 Bring data to life with charts

3. Applying the Finishing Touches
12 Get the most from tab customization
13 Create safeguards with detailed pagination
14 The big reveal

4. Consolidate Your Expertise
15 When to makeover vs. rebuild a spreadsheet

Conclusion
16 Getting the most from your makeover

Homepage