Discover Classes. Earn Rewards.

Power Fx: Introduction is unfortunately unavailable

Thankfully we have 59 other Microsoft Classes for you to choose from. Check our top choices below or see all classes for more options.

Azure Administrator

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Learn the essential skills needed to effectively manage and maintain cloud services with hands-on training and real-world scenarios. Stay ahead in the ever-evolving world of technology with this comprehensive course.

(7) All levels 18 and older
$2,395

4 sessions

Gift it!

Microsoft Excel for Windows: Level 2

Los Angeles City College @ 855 N Vermont Ave, Los Angeles, CA

The leader in creating spreadsheets and data presentation, topics include: Basic worksheet navigation Entry techniques Cell references Using the command groups & settings Formulas & Functions Charts & Graphs Simple database operations Continuing classes include a overview of Excel's vast collection of formulas and functions.

(782) Intermediate 18 and older

SharePoint for Power Users

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Unlock the full potential of SharePoint Online with ONLC Training Centers' comprehensive course. Learn how to create and manage sites, collaborate with colleagues, and utilize the latest features and enhancements. Gain the confidence to maximize the impact of SharePoint for your team.

(7) All levels 18 and older
$2,395

4 sessions

Gift it!

Microsoft Power Automate: Introduction for End Users

ONLC Training Centers @ 11400 W Olympic Blvd, Los Angeles, CA

Discover the essential techniques for creating, managing, and initiating automated processes or workflows in Microsoft Power Automate with this comprehensive course from ONLC Training Centers. Boost your efficiency and streamline tasks using Power Automate's powerful features. Perfect for business users familiar with Office 365 applications.

(7) All levels 18 and older
$795

2 sessions

Gift it!

Excel Introduction

ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA

Gain the essential skills needed to create and format spreadsheets in Excel. Learn to enter data, use formulas, and format worksheets with ease in this comprehensive introductory course. Perfect for anyone looking to enhance their ability to create and manipulate basic spreadsheets.

(7) Beginner 18 and older
See all Microsoft classes Los Angeles

Power Fx: Introduction

  • All levels
  • 18 and older
  • $395
  • 10940 Wilshire Blvd, Santa Monica, CA
  • 6 hours & 45 minutes

Start Dates (0)

  • $395
  • ONLC Training Center - LA (West) @ 10940 Wilshire Blvd Ste 600, Santa Monica, CA 90024
  • 6 hours & 45 minutes
  • All classes are live, hands-on training via remote instructor.
Showing 10 of 0

Class Description

Description

What you'll learn in this microsoft training:

Power Fx is a low-code programming language that is designed to be easy to use for non-technical users, allowing them to create custom applications and automate processes using the Microsoft Power Platform.

Power Fx is based on Microsoft Excel's formula language, which is a widely used tool for data manipulation and analysis. It uses a familiar syntax and offers a wide range of functions, making it easy for people to create complex business logic without having to write traditional code.

Who Should Take This Class: Individuals who want to take their Power Apps and Power Automate applications and flows to the next level.

Note: It is best that someone take the Introduction to Power Apps class prior to taking this course.

Course Outline

What is Power Fx?:

  • The benefits of using Power Fx
  • Understanding the Power Platform
  • Building your first app with Power Fx
Creating an app from a template:

  • Adding screens and controls
  • Understanding data sources and data tables
  • Adding formulas to controls
  • Power Fx formulas
Operators and Identifiers:

  • in and exactin operators
  • ThisItem, ThisRecord, and As operators
  • Self and Parent Operators
  • Identifier Names
  • Display Names and Logical Names
  • Name disambiguation
  • Disambuator Operator
Data types:

  • Blank
  • Text, Hyperlink, Image, and Media
  • Image and Media Resources
  • URIs for images and other media
  • Number and Currency
  • Date, Time, DateTime
  • Choices and Yes/No
Tables:

  • Elements of a Table
  • Table Formulas
  • Table Functions and Control Properties
  • Behavioral Formulas
  • Record Scope
  • Disambiguation
  • Record Scope
  • Single Column Tables
  • Inline Records
  • Inline Tables
Variables:

  • Translate Excel into Power Fx
  • Know When to Use Variables
  • Use a Global Variable
  • Types of Variables
  • Create and Remove Variables
  • Variable Lifetime and Initial Value
  • Reading Variables
  • Use a Collection
Error handling:

  • Getting Started
  • Error Propagation
  • Observing Errors
  • Reporting Errors
  • Stopping after an error
  • Working with Multiple Errors
  • Errors in Tables
  • Data Source Errors
  • Creating Your Own Errors
  • ErrorKind Enum Values

Refund Policy

Cancellation / Reschedule by Student

Because we must schedule rooms, ship course materials, assign instructors and provision computer resources well in advance, it is important students alert us ASAP with any cancel/reschedule requests.

Please note the following policies:

  • If requested 16 or more calendar days before the class
    • Cancellation requests made in this timeframe are eligible for refund less 5% cancellation fee.
    • Reschedule requests made in this timeframe will be accommodated if availability exists and will be processed at no additional charge.
  • If requested 15 calendar days or less before the class
    • Cancellation or Reschedule requests made by the student 15 calendar days or less before the class starts will be charged 100% the course fee and are not entitled to a refund.

Substitutions

  • If you are unable to attend your class, a substitute who meets the course prerequisites may attend in your place at no additional charge for the original class title, date and location. If you cannot find a substitute, you will be subject to the class cancellation policy.

Make-up Policy

Students are permitted one (1) Make-Up opportunity to attend an instructor-led class that was paid for but not previously attended for no additional charge.

  • Make-Up class registrations are subject to availability and are not entitled to refund.
  • Students may not reschedule a Make-up class registration.
  • Any no shows or cancellations forfeit their one Make-up opportunity.

Additionally, ONLC reserves the right to retire courses due to lack of demand. Retired classes are not available for Make-Up.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at ONLC Training Centers (7)

Similar Classes

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 3950 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Los Angeles educator.

ONLC Training Centers

ONLC Training Centers

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Microsoft Office Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...