{"id":72,"date":"2018-07-01T12:30:31","date_gmt":"2018-07-01T19:30:31","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/learning-with-mr-dang-transferring-knowledge-1\/"},"modified":"2025-06-11T08:08:01","modified_gmt":"2025-06-11T15:08:01","slug":"learning-with-mr-dang-transferring-knowledge-1","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/learning-with-mr-dang-transferring-knowledge-1\/","title":{"rendered":"Learning with Mr. Dang | Transferring Knowledge from Excel (Part 1)"},"content":{"rendered":"

Do you remember learning a second language in high school? You’d conjugate verbs, decline nouns, and translate sentences. Even though the language was new, you didn’t learn in a vacuum–you had a primary language for comparison. So when you learned about sentence structure, you’d connect similarities from your first language to your second. If you encountered an unfamiliar form, you could recall root words from Latin, Greek, or another parent language to derive its meaning. You took what you knew from one language and applied it to learn another:<\/p>\n

You transferred knowledge.<\/p>\n

If you come to PowerApps from using Microsoft Excel, you bring with you a significant body of knowledge about formulas and table structure that can<\/em> transfer. Don’t let your skills sit idle. You can take an existing spreadsheet-making skill and augment it into an app-building skill. But how do you actually carry it over?<\/p>\n

The Formula Reference<\/h2>\n

If you want to learn something new, look to those who already have. There is at least one thing in common between every member from our community that I’ve met: they had learned how to build canvas apps using the Formula Reference page. And so did I!\u00a0<\/p>\n

So bookmark this page: Formula Reference<\/a><\/p>\n

(Bonus: you can now enjoy it in the dark theme)<\/p>\n

\"\"\"\"<\/p>\n

The reference page is an index of all the functions in PowerApps. Many of the functions will look familiar to an Excel user: If()<\/a>, Sum()<\/a>, and\u00a0Concatenate()<\/a>\u00a0to name a few. Like the other docs from Microsoft, each page contains a definition of the function, its syntax, and samples of how it is used.\u00a0<\/p>\n

The reference on its own is not a teacher though. You don’t learn a second language by reading a dictionary from A to Z.\u00a0Below are concrete steps you can take to transfer your knowledge from Excel to PowerApps and learn the functions in a new context:<\/p>\n

    \n
  1. Start a checklist.<\/li>\n
  2. Take a quick inventory of functions you recognize.<\/li>\n
  3. Build apps and return to the formula reference as needed.<\/li>\n
  4. Search external documentation.<\/li>\n
  5. Revisit the essentials from Excel: If(), LookUp(), and concatenation.<\/li>\n<\/ol>\n

    Since transfer is an involved process, this first part will explore steps 1 and 2. Understand that getting better at using formulas is only one of the many ways to grow as an app maker, not a requirement. Read on to find out how you can carry over this existing skill set.<\/p>\n

    Start a checklist<\/h2>\n

    A checklist allows you to track the progress of what functions you know, and more importantly, what functions you don’t know. When you ‘know what you don’t know,’ you can set goals on what to learn next and when. From the start, you might think of copy pasting the page into OneNote for its excellent checkbox experience.<\/p>\n

    \"\"<\/p>\n

    The list works, but let’s improve upon it. The alphabetical sorting is useful for finding a function on the page, but learning is a process of organizing and connecting content. Let’s group the functions by which category they belong to so that we build more relationships within the content we are learning.\u00a0If you click the fx icon beside the formula bar in PowerApps, you can view predefined categories and which functions fall below them.<\/p>\n

    \"\"<\/p>\n

    To add in the category metadata, copy the same formula reference list into an Excel spreadsheet–you didn’t think we were only going to be working in PowerApps did you? Insert\u00a0a column where you type in the categories as they’re grouped in PowerApps or type in your own categories for more personalized learning.<\/p>\n

    \"\"<\/p>\n

    You can filter the rows by category and copy each group into OneNote so you can get a nifty checkbox again. Your checklists are ready.<\/p>\n

    \"\"<\/p>\n

    Learning is a process and I encourage you to make this checklist yourself as an exercise and to get a first look at all the functions. I’m also sharing my checklist (Excel<\/a>\u00a0| OneNote<\/a>), so you can skip to the next section. Note that as new functions come along, you’ll need to update your checklist for your own records.<\/p>\n

    Take an inventory<\/h2>\n

    In this step, you’ll quickly glance at your checklist to check off all the functions that are familiar to you. You can do this alphabetically among the categories, but let’s be purposeful again. If you view my checklist<\/a>, you’ll see that I’ve applied yet another layer of organization to it so that each category of functions is placed in a strategic location.<\/p>\n

    Each row signifies a level of transferability–how faithfully does a function transfer from Excel to PowerApps:<\/p>\n