Microsoft® Power Apps®: Building Low-Code Business Apps

Course Number:

094026

Course Length:

1 day

Course Description

 

Overview:

Creating custom applications for specific business processes has evolved from an emerging trend to a standard practice in many organizations. In the past, if employees had an idea for automating or streamlining a business process, they often had to request that IT resources build the application. Today, it is much more common for employees themselves to become what is sometimes called “citizen developers,” who are people with business knowledge who can use app-building tools to create custom business apps. This course introduces building low-code/no-code apps with Microsoft® Power Apps®.

Most out-of-the-box solutions do not meet exact business needs or integrate well with existing business apps. Power Apps eases users into app development with templates, automated app-building tools, and a streamlined programming language to enable any business user to create a custom app.

Course Objectives:

In this course, you will use Microsoft Power Apps to build and deploy low-code business apps. You will:

• Determine how Microsoft Power Apps can meet your business needs.
• Plan and design apps.
• Build canvas apps.
• Build model-driven apps.
• Test and deploy apps.

Target Student:

This course is designed for skilled users of Microsoft Windows® and Office who do not have prior coding or programming experience and who are interested in creating custom business apps quickly and without writing application code.

Course Prerequisites:

To ensure your success in this course, you should have Windows end-user skills and experience with using Microsoft 365 apps, including Word and Excel®. You should also have in-depth knowledge of the organizational business processes for which you intend to build apps.

Course Content

Lesson 1: Getting Started with Microsoft Power Apps

Topic A: Introduction to Microsoft Power Platform

Topic B: Introduction to Power Apps

Topic C: Select App Types to Address Business Needs

Lesson 2: Planning and Designing Apps

Topic A: Plan Apps

Topic B: Design Apps

Lesson 3: Building Canvas Apps

Topic A: Create an App from a Blank Canvas

Topic B: Create an App from a Template

Lesson 4: Building Model-Driven Apps

Topic A: Create Model-Driven Apps

Topic B: Add Visualizations and Reports

Lesson 5: Testing and Deploying Apps

Topic A: Make Apps Available to Other Users

Topic B: Test Apps

Topic C: Revise Apps

 

Excel Level 1

In this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

Course Objectives:

You will:

• Get started with Microsoft Office Excel O365 – Desktop Version.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Course Content

Lesson 1: Getting Started with Microsoft Office Excel O365

Topic A: Navigate the Excel User Interface

Topic B: Use Excel Commands

Topic C: Create and Save a Basic Workbook

Topic D: Enter Cell Data

Topic E: Use Excel Help

Lesson 2: Performing Calculations

Topic A: Create Worksheet Formulas

Topic B: Insert Functions

Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows

Topic B: Search for and Replace Data

Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

Topic A: Apply Text Formats

Topic B: Apply Number Formats

Topic C: Align Cell Contents

Topic D: Apply Styles and Themes

Topic E: Apply Basic Conditional Formatting

Topic F: Create and Use Templates

Lesson 5: Printing Workbooks

Topic A: Preview and Print a Workbook

Topic B: Set Up the Page Layout

Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

Topic A: Manage Worksheets

Topic B: Manage Workbook and Worksheet Views

Topic C: Manage Workbook Properties

 

Appendix A: Microsoft Office Excel O365 Exam 77-727

Appendix B: Microsoft Office Excel O365 Expert Exam 77–728

Appendix C: Microsoft Excel O365 Common Keyboard Shortcuts

Appendix D: Adding Borders and Colors to Worksheets

Appendix E: Basic Excel Customization

This event ticket will close at 12:00 pm the day before the event.

Excel Level 1

In this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

Course Objectives:

You will:

• Get started with Microsoft Office Excel O365 – Desktop Version.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Course Content

Lesson 1: Getting Started with Microsoft Office Excel O365

Topic A: Navigate the Excel User Interface

Topic B: Use Excel Commands

Topic C: Create and Save a Basic Workbook

Topic D: Enter Cell Data

Topic E: Use Excel Help

Lesson 2: Performing Calculations

Topic A: Create Worksheet Formulas

Topic B: Insert Functions

Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows

Topic B: Search for and Replace Data

Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

Topic A: Apply Text Formats

Topic B: Apply Number Formats

Topic C: Align Cell Contents

Topic D: Apply Styles and Themes

Topic E: Apply Basic Conditional Formatting

Topic F: Create and Use Templates

Lesson 5: Printing Workbooks

Topic A: Preview and Print a Workbook

Topic B: Set Up the Page Layout

Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

Topic A: Manage Worksheets

Topic B: Manage Workbook and Worksheet Views

Topic C: Manage Workbook Properties

 

Appendix A: Microsoft Office Excel O365 Exam 77-727

Appendix B: Microsoft Office Excel O365 Expert Exam 77–728

Appendix C: Microsoft Excel O365 Common Keyboard Shortcuts

Appendix D: Adding Borders and Colors to Worksheets

Appendix E: Basic Excel Customization

This event ticket will close at 12:00 pm the day before the event.

Excel Level 1

In this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

Course Objectives:

You will:

• Get started with Microsoft Office Excel O365 – Desktop Version.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Course Content

Lesson 1: Getting Started with Microsoft Office Excel O365

Topic A: Navigate the Excel User Interface

Topic B: Use Excel Commands

Topic C: Create and Save a Basic Workbook

Topic D: Enter Cell Data

Topic E: Use Excel Help

Lesson 2: Performing Calculations

Topic A: Create Worksheet Formulas

Topic B: Insert Functions

Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows

Topic B: Search for and Replace Data

Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

Topic A: Apply Text Formats

Topic B: Apply Number Formats

Topic C: Align Cell Contents

Topic D: Apply Styles and Themes

Topic E: Apply Basic Conditional Formatting

Topic F: Create and Use Templates

Lesson 5: Printing Workbooks

Topic A: Preview and Print a Workbook

Topic B: Set Up the Page Layout

Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

Topic A: Manage Worksheets

Topic B: Manage Workbook and Worksheet Views

Topic C: Manage Workbook Properties

 

Appendix A: Microsoft Office Excel O365 Exam 77-727

Appendix B: Microsoft Office Excel O365 Expert Exam 77–728

Appendix C: Microsoft Excel O365 Common Keyboard Shortcuts

Appendix D: Adding Borders and Colors to Worksheets

Appendix E: Basic Excel Customization

This event ticket will close at 12:00 pm the day before the event.

Excel Level 1

In this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

Course Objectives:

You will:

• Get started with Microsoft Office Excel O365 – Desktop Version.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Course Content

Lesson 1: Getting Started with Microsoft Office Excel O365

Topic A: Navigate the Excel User Interface

Topic B: Use Excel Commands

Topic C: Create and Save a Basic Workbook

Topic D: Enter Cell Data

Topic E: Use Excel Help

Lesson 2: Performing Calculations

Topic A: Create Worksheet Formulas

Topic B: Insert Functions

Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows

Topic B: Search for and Replace Data

Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

Topic A: Apply Text Formats

Topic B: Apply Number Formats

Topic C: Align Cell Contents

Topic D: Apply Styles and Themes

Topic E: Apply Basic Conditional Formatting

Topic F: Create and Use Templates

Lesson 5: Printing Workbooks

Topic A: Preview and Print a Workbook

Topic B: Set Up the Page Layout

Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

Topic A: Manage Worksheets

Topic B: Manage Workbook and Worksheet Views

Topic C: Manage Workbook Properties

 

Appendix A: Microsoft Office Excel O365 Exam 77-727

Appendix B: Microsoft Office Excel O365 Expert Exam 77–728

Appendix C: Microsoft Excel O365 Common Keyboard Shortcuts

Appendix D: Adding Borders and Colors to Worksheets

Appendix E: Basic Excel Customization

This event ticket will close at 12:00 pm the day before the event.

Excel Level 1

In this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

Course Objectives:

You will:

• Get started with Microsoft Office Excel O365 – Desktop Version.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Course Content

Lesson 1: Getting Started with Microsoft Office Excel O365

Topic A: Navigate the Excel User Interface

Topic B: Use Excel Commands

Topic C: Create and Save a Basic Workbook

Topic D: Enter Cell Data

Topic E: Use Excel Help

Lesson 2: Performing Calculations

Topic A: Create Worksheet Formulas

Topic B: Insert Functions

Topic C: Reuse Formulas and Functions

Lesson 3: Modifying a Worksheet

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows

Topic B: Search for and Replace Data

Topic C: Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

Topic A: Apply Text Formats

Topic B: Apply Number Formats

Topic C: Align Cell Contents

Topic D: Apply Styles and Themes

Topic E: Apply Basic Conditional Formatting

Topic F: Create and Use Templates

Lesson 5: Printing Workbooks

Topic A: Preview and Print a Workbook

Topic B: Set Up the Page Layout

Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

Topic A: Manage Worksheets

Topic B: Manage Workbook and Worksheet Views

Topic C: Manage Workbook Properties

 

Appendix A: Microsoft Office Excel O365 Exam 77-727

Appendix B: Microsoft Office Excel O365 Expert Exam 77–728

Appendix C: Microsoft Excel O365 Common Keyboard Shortcuts

Appendix D: Adding Borders and Colors to Worksheets

Appendix E: Basic Excel Customization

This event ticket will close at 12:00 pm the day before the event.