Andrew Perez

Andrew Perez

Power Platform Trainer

Meet Andrew Perez

About

Andrew Perez graduated from the University of North Florida with a bachelor’s degree in Transportation and Logistics. He has been working in leadership and management positions since the age of 19, which developed in him a passion for training and helping others to grow. He now puts these skills to work with Pragmatic Works, helping customers bolster their professional skillsets as many mentors have aided him.

Certifications

PL-900: Power Platform Fundamentals

Microsoft

PL-200: Power Platform Functional Consultant Associate

Microsoft

Courses

Course

App in a Day

As a business leader, you want to react quickly to the changing market and cannot stay dependent on developing a software solution to do that. You want the ability to build a solution to meet your business needs swiftly. With the Microsoft Power Platform, you can build great business apps without writing code. - **Digitize business processes, work more efficiently and become more paperless** - With Power Apps, you will enable power-users in line of business roles to easily build and deploy custom business apps in both Canvas and Model-driven style of apps. - **Easily connect all your applications and share data** - With Dataverse, you can easily bring your data together and quickly create powerful apps using a compliant and scalable data service and app platform integrated right into Power Apps. - **Automate and optimize your business processes** - Finally, with Power Automate as your business service, your line of business specialists and IT pros can build automated workflows intuitively. At the end of the training, you will be able to: - Create custom business applications without writing code. - Learn how to build sophisticated business processes and complex data relationships within your applications. - Learn how to connect your app to a variety of data sources to bring it to life. - Share your apps inside your organization securely.

Course

Creating a Google Account

In this course, Andrew Perez walks you through the simple process of creating a Google account. You'll learn how to set up your account step by step, ensuring access to Gmail, Google Drive, and other essential services. Perfect for beginners, this quick guide gets you started in just a few minutes!

Course

Introduction to Google Drive

In this course, Andrew Perez provides a beginner-friendly introduction to Google Drive, Google's cloud-based storage solution. You'll learn how to create, upload, and organize files, as well as how to navigate the Drive interface with ease. Whether you're managing personal documents or collaborating with others, this course will help you get started with confidence. By the end of this course, you'll understand the core functions of Google Drive, including file sharing, access settings, and basic organization techniques. With these skills, you'll be able to store and manage your files efficiently from any device, making your workflow more seamless and accessible.

Course

Introduction to Google Meet

In this course, Andrew Perez introduces you to Google Meet, Google's video conferencing tool designed for virtual meetings, classes, and collaboration. You'll learn how to join and host meetings, adjust settings, and navigate the Meet interface with ease. Whether you're new to online communication or looking for a reliable tool to stay connected, this course is the perfect starting point. By the end of this course, you'll be comfortable using Google Meet for both personal and professional use. You'll understand how to schedule meetings, manage participants, and use key features like screen sharing and chat to enhance your virtual interactions.

Course

Microsoft Outlook Tips and Tricks

In this course, Andrew Perez shares time-saving tips and tricks to help you get the most out of Microsoft Outlook. From smarter inbox management to hidden features you didn’t know existed, this course is packed with practical advice to boost your productivity. Whether you’re new to Outlook or a daily user looking to level up, you’ll walk away with actionable techniques to manage your email, calendar, and tasks more efficiently. These tips will help streamline your communication and organize your day with confidence.

Course

Intermediate Google Sheets

If you’ve got the basics down and are ready to do more with Google Sheets, this course is your next step. In Intermediate Google Sheets, instructor Andrew Perez helps you move beyond simple spreadsheets and into more powerful tools that can save time, clean up your data, and make your work look more polished. You’ll still get clear, easy-to-follow explanations—just with a bit more muscle behind each skill. This course focuses on practical ways to improve how you work in Sheets, from building smarter formulas to using conditional formatting and advanced sorting. Whether you're handling a larger dataset, collaborating with others, or just want to get more done in less time, these lessons will help you feel more confident and capable. It's the perfect bridge between beginner and advanced spreadsheet skills.

Course

Introduction to Google Sheets

Whether you're brand new to spreadsheets or just looking to get more comfortable with Google Sheets, this course is the perfect place to start. In Introduction to Google Sheets, instructor Andrew Perez breaks down the essentials in a simple, approachable way—no prior experience required. You'll learn how to navigate the platform, enter and format data, and start using basic tools that help you stay organized and work more efficiently. Each module builds on the last, giving you hands-on practice with the features you'll use most often in school, work, or personal projects. By the end of the course, you’ll understand not just how to use Google Sheets, but how it can make your everyday tasks faster and easier. Whether you're managing a list, tracking goals, or organizing information, you'll walk away with skills you can use right away.

Course

Introduction to Gmail

Email doesn’t have to be overwhelming—Introduction to Gmail is your easy, step-by-step guide to mastering one of the world’s most popular email platforms. In this beginner-friendly course, instructor Andrew Perez walks you through the essentials of using Gmail, from sending and receiving messages to organizing your inbox and customizing your settings. No prior experience needed—just a desire to feel more confident and in control of your email. Each module focuses on practical tips you can use right away, whether you're using Gmail for work, school, or personal communication. You’ll learn how to stay organized, avoid clutter, and get the most out of Gmail’s powerful tools. By the end of the course, you’ll be able to navigate your inbox with ease and make Gmail work for you.

Course

ZoomIT for Presentations

Want to make your presentations more engaging and easier to follow? In ZoomIT for Presentations, instructor Andrew Perez shows you how to use this free Microsoft tool to enhance the way you present live content on your screen. Whether you're teaching, demoing, or sharing your screen during meetings, ZoomIT gives you simple but powerful features to zoom in, annotate, and control the pace of your presentation. This course walks you through everything from downloading and setting up ZoomIT to using it smoothly during a live presentation. You’ll learn practical techniques to highlight important points, keep your audience’s attention, and stay in control without interrupting your flow. Perfect for educators, trainers, or anyone who shares their screen regularly, this course helps you take your presentation skills to the next level with ease.

Course

Introduction to Google Docs

Whether you're writing an essay, creating a report, or just jotting down ideas, Introduction to Google Docs will help you feel confident using this powerful word processing tool. In this beginner-friendly course, instructor Andrew Perez walks you through the basics of navigating Google Docs, formatting your text, and collaborating in real-time—all from your browser. You'll learn how to create clean, organized documents and take advantage of features that make your work easier and more efficient. With clear, practical lessons, this course is perfect for anyone new to Google Docs or looking for a refresher. By the end, you’ll be ready to write, edit, and share with ease.

Course

Introduction to Google Calendar

Stay on top of your schedule with ease in Introduction to Google Calendar. In this beginner-friendly course, instructor Andrew Perez walks you through how to set up events, manage your time, and stay organized using Google’s free calendar tool. Whether you're planning your day, coordinating with others, or juggling multiple calendars, this course will help you build a routine that works. You'll learn how to create recurring events, invite others to meetings, set reminders, and customize your calendar to fit your life. With simple step-by-step lessons, you’ll quickly gain the skills to manage both personal and professional schedules more efficiently. By the end, you’ll be ready to take control of your calendar with confidence.

Course

Introduction to Google Slides

Present your ideas with confidence using Introduction to Google Slides. In this beginner-friendly course, instructor Andrew Perez teaches you how to create clean, engaging presentations with Google’s free online tool. Whether you're building a school project, a business pitch, or a personal slideshow, this course will help you design slides that are both effective and easy to build. You’ll learn how to choose layouts, add images and videos, format text, and customize your presentation with themes. Andrew also walks you through sharing and presenting your slides, so you're ready to deliver with impact. By the end, you’ll have the skills to create polished presentations that get your message across clearly.

Course

Learn With The Nerds - Revolutionize Your Flows with AI Builder & Generative Prompting

This session is designed to empower participants to enhance their Power Automate flows using generative prompting and AI Builder capabilities. Through guided demonstrations and hands-on walkthroughs, learners will explore how artificial intelligence can streamline decision-making, automate content generation, and extract actionable insights within cloud flows. Topics Covered: - Getting started with AI Builder and generative prompting - Translating text dynamically using AI Builder models - Leveraging generative AI to extract and analyze values - Incorporating AI-powered decision logic into Power Automate flows

Course

API Calls in Power Automate

Make your flows smarter by tapping into the power of APIs—without getting lost in code. In API Calls in Power Automate, Andrew Perez shows how to connect your flows to popular web services so they can look up data, post updates, and trigger actions automatically. You’ll learn the essentials in plain language: what an API is, how HTTP requests work at a high level, and where to use them in real-world automations like sending messages, updating records, or pulling reference data. Then we’ll build step by step. Andrew walks through using built-in connectors, creating custom calls with the HTTP action, and handling inputs and outputs reliably. You’ll see practical tips for authentication basics, testing and troubleshooting, and shaping responses so they’re easy to reuse across flows. By the end, you’ll have a simple, repeatable approach for calling APIs in Power Automate—turning everyday processes into fast, connected workflows.

Course

JSON For Power Automate

In JSON for Power Automate, Andrew Perez walks you through JSON in a practical way by building it from scratch. You’ll start with the basics—what JSON is and why Power Automate uses it—then create your own custom JSON object and learn how to make it usable inside a flow. Step by step, you’ll see how that object turns into something you can reference, map, and reuse, then apply it in a real-world scenario so it feels less abstract and more like a tool you can rely on. From there, you’ll expand into working with arrays and the Select action to shape and transform data for downstream steps. Andrew shows how to take messy or complex data and simplify it into the exact structure your flow needs, whether you’re sending an email, updating a data source, or looping through items. The course wraps with a recap and next steps so you not only understand JSON conceptually, but also feel confident creating, adjusting, and using it in everyday Power Automate solutions.

Course

PowerToys

Learn how to use Microsoft PowerToys to speed up everyday Windows tasks with lightweight, practical utilities. This course walks through the most useful tools for window management, input enhancements, and file workflows so you can work faster with fewer clicks. By the end, you’ll have PowerToys configured and a repeatable set of productivity upgrades you can apply immediately.

Show more

Bootcamps

Boot Camps

Apr 20 Virtual Power Pages Bootcamp

If you are looking to get a deeper understanding of building and designing Power Page sites, then the Power Pages Bootcamp is here to help! This two-day course will take you deeper into the Power Pages designer and explore some of the more robust and advanced features, including parts of the Power Pages Management App. Creating websites no longer has to be a long, arduous process reserved exclusively for those in IT. The class starts at a quick review of Power Page site design and quickly dives into advanced configuration of a site. You’ll learn how to build create and extend lists and forms, set up security for your site and users, utilize Liquid to add details and features to a web page, as well as adding JavaScript and CSS to take your site to another level. You’ll also learn UI best practices for engaging users, as well as the best practices for migrating a site across environments. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

May 18 Virtual Advanced Power Apps Bootcamp

If you are experienced in Canvas and Model-driven applications and looking to take the next step, our 4-day Advanced Power Apps Bootcamp is for you. This comprehensive course will dive deeper into both the Canvas app ecosystem and Dataverse, exploring the more robust and advanced features of each. You'll begin with a quick review of the basics and quickly progress to building advanced solutions. For Canvas apps, you'll learn to use variables, set up security, handle delegation issues, monitor apps, and work with advanced Power FX functions, while also mastering UI best practices and advanced component construction. On the Model Driven side, you'll take a deep dive into building sophisticated apps, learning to fully leverage the Dataverse. Whether you’re focused on Canvas or Model Driven apps, this bootcamp will equip you with the skills to create powerful, reusable applications without the long, arduous processes traditionally reserved for IT professionals. This bootcamp is also available to purchase in 2-day blocks. You can find those listed on our our bootcamps page of our website. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

May 18 Virtual Advanced Canvas Apps Bootcamp

If you are experienced in Canvas applications and looking to take the next step the Advanced Canvas apps course is for you. This two-day course will take you deeper into the canvas app ecosystem and explore some of the more robust and advanced features. Creating applications no longer has to be a long, arduous process reserved exclusively for those in IT. The class starts at a quick review of canvas application basics and quickly dives into advanced solutions. You’ll learn to use variables, set up security, use CoPilot, handle delegation issues, monitor your application, environment variables, and advanced Power FX functions. You’ll also learn UI best practices for engaging users and more advanced component construction for reusability. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Boot Camps

May 20 Virtual Advanced Model Driven Apps Bootcamp

If you are experienced in Model Driven applications and Dataverse looking to take the next step the Advanced Model Driven apps course is for you. This two-day course will take you deeper into the Dataverse ecosystem and Model Driven Apps to explore some of the more robust and advanced features. Creating applications no longer has to be a long, arduous process reserved exclusively for those in IT. With Power Apps you can build beautifully designed applications and solutions on your own, providing instant satisfaction to your needs. This course takes a deep-dive into building model driven applications. Pragmatic Works bootcamps include interactive, hands-on labs that let you apply what you’re learning in real time. With expert instructors available for guidance and support, you’ll build skills by doing—not just watching.

Show more

Popular articles by Andrew Perez

Copilot Studio in Power Apps - Making App Development Even Easier!

BREAKTHROUGH Multilingual Power Apps Feature You Never Knew Existed

What our clients say