To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.
Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.
Join us and be a Difference Maker! | | 
|
|
Note:
As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be bring and be equipped with a window laptop that able to install Power Automate Desktop and Excel.
This course aims to introduce participants to Power Automate Desktop, a platform to automate simple and repetitive tasks.
In this two-day introduction to Power Automate Desktop, participants will learn to create Flows, which can automate repetitive tasks. Power Automate is a development environment maintained by Microsoft for people who want to be more efficient and effective. It can automate tasks by:
- Interacting with specific software
- Interacting with files and file systems
- Performing recorded actions
- Using AI to recognise different portions of your screen
If you have always wanted to save time and improve your workplace efficiency, this course is for you!
Programme Outline
Participants will first concentrate on the fundamentals of working with Power Automate Desktop. They will get acquainted with the user interface and learn to understand flow diagrams and how they visually represent a task. Through this process they will briefly be introduced to different types of Flows, including the focus of today: Desktop Flows. Then, they will gain hands-on experience creating flows interacting with software and file systems to automate repetitive tasks, such as updating ledgers or collating data.
Introduction to Power Automate
Gain a better understanding of what Power Automate is and how to use Flows
- Understand the difference between Power Automate Web and Desktop
- Learn and navigate the user interface
- Understand Flow diagrams and how they visually represent a task
- Learn about the different types of Flows
- Introduction to Robotic Process Automation
Building Desktop Flows
Introduction to Power Automate Desktop, a non-web version of Power Automate that uses Artificial Intelligence to interact with your screen – just like Excel macros, but for all software on your computer!
- Basics of Building Desktop Flows
- Variables
- Conditionals
- Lists and Loops
- Excel and Datatables (spreadsheets inside Power Automate)
- Hands-on: error-checking ledger data
- Hands-on: merging invoice data
- Using the Recorder to interact with legacy accounting software
- Hands-on: account creation for new customers/suppliers
- Interacting with Files and Folders
- Hands-on: checking for new ledger data (and appending it if needed)
- Hands-on: bulk creation of invoices
- Hands-on: read ledger data and take conditional action
- Interacting with Web platforms
- Intro to HTML and how we interact with it
- Web Scraping
- Hands-on: extracting specific data from the web with regular expressions
- Data in images: using Optical Character Recognition
- APIs and JSON data
Evaluation and Adoption
A realistic look at the viability and steps needed to adopt Power Automate Desktop for individual and enterprise use.
- Adoption Tips
- Hidden costs
- Identifying optimal tasks
- Challenges and potential pitfalls
- Adoption Rate
- The Future of Automation
Training Methodology
This course will alternate periods of lecture with hands-on activities. We believe strongly in differentiated, hands-on learning. For a learner, no amount of listening to lectures about “how to program” can beat the learning experience of putting hands onto keyboards and creating meaningful, tangible projects. We aim to design our lessons and workshops to be hands-on, highly participative, and with tangible, concrete outcomes, so that participants will be engaged at all times: programming, tinkering with hardware, looking up solutions, or trying to solve a problem. Such hands-on workshops are naturally more time-consuming to prepare and more difficult to deliver, but we strongly believe that this is the best way for participants to learn the material effectively, and will elicit the best learning outcomes.
Our goal is to ensure participants have enough skills to embark on future projects of their own, rather than just copying and pasting code to see things work. In our classes, learners will be carefully guided through the basic concepts, before being challenged to apply these concepts to create applications they can be proud of and, more importantly, use for future reference.
Our curriculum is designed by a team of trained teachers with real classroom teaching experience in MOE schools, and taught by trainers who possess actual programming experience from developing electronics and applications for startups and companies. We aim to adapt the best teaching materials available from all over the world, while supplementing them with best practices from our industry experience, to create the most effective programming courses for learners of all levels.
Closing Date for Registration
1 Week before Programme or Until Full Enrolment
Intended For
Accounting professionals looking to add automation to their workplace. This course assumes no prior coding experience. Power Automate is a no-code or low-code tool that is similar to other Microsoft applications (such as Word or Excel). If you’re familiar with these, Power Automate Desktop has the same design and feel, which makes it extremely easy to pick up and get started!
Competency Mapping
Category 5 = 14.00 Hours
Schedule & Fees
Date & Time
09 Sep 2024 (9:00 AM - 5:00 PM)
10 Sep 2024 (9:00 AM - 5:00 PM)
Fee (inclusive of GST)
For Members:
$ 907.97
For Non-Members:
$ 1,078.01
Programme Facilitator(s)
Team of Professionals (Tinker Tanker)
Venue
60 Cecil Street
ISCA House
Singapore 049709
Testimonial
Trainers are excellent. Very helpful and competent in their area of expertise
Past Participant
It helped me to start exploring more about Power automate desktop
Past Participant
Funding
1] NTUC Union Training Assistance Programme (UTAP)
NTUC members enjoy 50% *unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP. NTUC members aged 40 and above can enjoy higher funding support up to $500 per individual each year, capped at 50% of unfunded course fees, for courses attended between 1 July 2020 to 31 December 2025.
*Unfunded course fee refers to the balance course fee payable after applicable government subsidies. This excludes material fees, registration fees, misc. fees etc.
This course is approved for UTAP support for intakes conducted between 08 February 2024 – 31 March 2025.
As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.
- Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
- Course by training provider must be supported under UTAP and training must commence within the supported period and;
- Unfunded course fee must not be fully sponsored by company or other types of funding
- Unfunded course fee must be S$20.00 and above, and;
- Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
- UTAP application must be made within 6 months after course ends.
For more information on UTAP Funding and to submit for UTAP claims, please visit https://www.ntuc.org.sg/uportal/programmes/union-training-assistance-programme. Terms and conditions apply.
Programme Facilitator(s)
Team of Professionals (Tinker Tanker)
Note: The session will be facilitated by either one of the trainers.
Michael Gonsalves
Mike is a curriculum developer and educator with a degree focused in actuarial science, statistics, and mathematics. He has data science experience as an actuarial analyst, computer science experience as a web consultant, as well as over thousands of hours of classroom time teaching programming and technology. He’s taught and developed lesson plans for all ages in topics and tools as diverse as Blockchain, Machine Learning, Data Science, Python, Swift, Minecraft, Azure, IBM Watson, Raspberry Pi, Micro:bit, littleBits, and Scratch.
Kent Tan
Kent is a senior IT and Technologies practitioner and manager of more than 20 years. Passionate in integrating business with technologies for the betterment of human society. He has experience in building and managing IT team in a listed corporation. He oversaw digitalisation roadmap, data protection and IT policies, technologies refresh implementation and business IT continuity plan execution. Currently, he is an associate lecturer in Republic Polytechnic teaching infocomm related courses. He also has hands-on experience and working knowledge in .NET, C#, HTML, CSS, JS, AI/ML, Business Analytics, Python, Flutter, Swift, Xd, UiPath.
John Su
John is an educational coach and the founder of his own education firm, with a degree in psychology and over 8 years of experience in coaching. He has covered a wide range of topics, including data science, programming languages such as Python and Swift, and various educational tools such as Minecraft, Azure, Raspberry Pi, Micro:bit, littleBits, Unity, and Scratch. John is passionate about passing on his knowledge and experience to the next generation and has mentored and trained students in STEM, design thinking, coding, and problem-solving. He is a registered MOE educational coach and has experience in lesson planning and consulting for student projects. John is also skilled in business development, networking, and in-house training programs, having served as the Managing Director and Business Development Manager for different companies.
Akmal Abd Rahman
Akmal runs Tinkercademy for schools and the public, and oversees curriculum design, logistics, manpower, materials, and… everything else, really. He graduated from Cornell University, taught at North View Secondary, and plays indie music nobody else in the office seems to appreciate.
To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.
Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.
Join us and be a Difference Maker! | |
|
|
Note:
As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be bring and be equipped with a window laptop that able to install Power Automate Desktop and Excel.
This course aims to introduce participants to Power Automate Desktop, a platform to automate simple and repetitive tasks.
In this two-day introduction to Power Automate Desktop, participants will learn to create Flows, which can automate repetitive tasks. Power Automate is a development environment maintained by Microsoft for people who want to be more efficient and effective. It can automate tasks by:
- Interacting with specific software
- Interacting with files and file systems
- Performing recorded actions
- Using AI to recognise different portions of your screen
If you have always wanted to save time and improve your workplace efficiency, this course is for you!
Programme Outline
Participants will first concentrate on the fundamentals of working with Power Automate Desktop. They will get acquainted with the user interface and learn to understand flow diagrams and how they visually represent a task. Through this process they will briefly be introduced to different types of Flows, including the focus of today: Desktop Flows. Then, they will gain hands-on experience creating flows interacting with software and file systems to automate repetitive tasks, such as updating ledgers or collating data.
Introduction to Power Automate
Gain a better understanding of what Power Automate is and how to use Flows
- Understand the difference between Power Automate Web and Desktop
- Learn and navigate the user interface
- Understand Flow diagrams and how they visually represent a task
- Learn about the different types of Flows
- Introduction to Robotic Process Automation
Building Desktop Flows
Introduction to Power Automate Desktop, a non-web version of Power Automate that uses Artificial Intelligence to interact with your screen – just like Excel macros, but for all software on your computer!
- Basics of Building Desktop Flows
- Variables
- Conditionals
- Lists and Loops
- Excel and Datatables (spreadsheets inside Power Automate)
- Hands-on: error-checking ledger data
- Hands-on: merging invoice data
- Using the Recorder to interact with legacy accounting software
- Hands-on: account creation for new customers/suppliers
- Interacting with Files and Folders
- Hands-on: checking for new ledger data (and appending it if needed)
- Hands-on: bulk creation of invoices
- Hands-on: read ledger data and take conditional action
- Interacting with Web platforms
- Intro to HTML and how we interact with it
- Web Scraping
- Hands-on: extracting specific data from the web with regular expressions
- Data in images: using Optical Character Recognition
- APIs and JSON data
Evaluation and Adoption
A realistic look at the viability and steps needed to adopt Power Automate Desktop for individual and enterprise use.
- Adoption Tips
- Hidden costs
- Identifying optimal tasks
- Challenges and potential pitfalls
- Adoption Rate
- The Future of Automation
Training Methodology
This course will alternate periods of lecture with hands-on activities. We believe strongly in differentiated, hands-on learning. For a learner, no amount of listening to lectures about “how to program” can beat the learning experience of putting hands onto keyboards and creating meaningful, tangible projects. We aim to design our lessons and workshops to be hands-on, highly participative, and with tangible, concrete outcomes, so that participants will be engaged at all times: programming, tinkering with hardware, looking up solutions, or trying to solve a problem. Such hands-on workshops are naturally more time-consuming to prepare and more difficult to deliver, but we strongly believe that this is the best way for participants to learn the material effectively, and will elicit the best learning outcomes.
Our goal is to ensure participants have enough skills to embark on future projects of their own, rather than just copying and pasting code to see things work. In our classes, learners will be carefully guided through the basic concepts, before being challenged to apply these concepts to create applications they can be proud of and, more importantly, use for future reference.
Our curriculum is designed by a team of trained teachers with real classroom teaching experience in MOE schools, and taught by trainers who possess actual programming experience from developing electronics and applications for startups and companies. We aim to adapt the best teaching materials available from all over the world, while supplementing them with best practices from our industry experience, to create the most effective programming courses for learners of all levels.
Closing Date for Registration
1 Week before Programme or Until Full Enrolment
Intended For
Accounting professionals looking to add automation to their workplace. This course assumes no prior coding experience. Power Automate is a no-code or low-code tool that is similar to other Microsoft applications (such as Word or Excel). If you’re familiar with these, Power Automate Desktop has the same design and feel, which makes it extremely easy to pick up and get started!
Competency Mapping
Category 5 = 14.00 Hours
Programme Facilitator(s)
Team of Professionals (Tinker Tanker)
Note: The session will be facilitated by either one of the trainers.
Michael Gonsalves
Mike is a curriculum developer and educator with a degree focused in actuarial science, statistics, and mathematics. He has data science experience as an actuarial analyst, computer science experience as a web consultant, as well as over thousands of hours of classroom time teaching programming and technology. He’s taught and developed lesson plans for all ages in topics and tools as diverse as Blockchain, Machine Learning, Data Science, Python, Swift, Minecraft, Azure, IBM Watson, Raspberry Pi, Micro:bit, littleBits, and Scratch.
Kent Tan
Kent is a senior IT and Technologies practitioner and manager of more than 20 years. Passionate in integrating business with technologies for the betterment of human society. He has experience in building and managing IT team in a listed corporation. He oversaw digitalisation roadmap, data protection and IT policies, technologies refresh implementation and business IT continuity plan execution. Currently, he is an associate lecturer in Republic Polytechnic teaching infocomm related courses. He also has hands-on experience and working knowledge in .NET, C#, HTML, CSS, JS, AI/ML, Business Analytics, Python, Flutter, Swift, Xd, UiPath.
John Su
John is an educational coach and the founder of his own education firm, with a degree in psychology and over 8 years of experience in coaching. He has covered a wide range of topics, including data science, programming languages such as Python and Swift, and various educational tools such as Minecraft, Azure, Raspberry Pi, Micro:bit, littleBits, Unity, and Scratch. John is passionate about passing on his knowledge and experience to the next generation and has mentored and trained students in STEM, design thinking, coding, and problem-solving. He is a registered MOE educational coach and has experience in lesson planning and consulting for student projects. John is also skilled in business development, networking, and in-house training programs, having served as the Managing Director and Business Development Manager for different companies.
Akmal Abd Rahman
Akmal runs Tinkercademy for schools and the public, and oversees curriculum design, logistics, manpower, materials, and… everything else, really. He graduated from Cornell University, taught at North View Secondary, and plays indie music nobody else in the office seems to appreciate.