Power Automate Corporate Training in Chennai, Mumbai, Delhi, Bangalore, Hyderabad, Kolkata & Pune
Excel Prodigy is one of the Leading Power Automate Training Company in India. We conducted Power Automate Training for Corporate's in Chennai, Mumbai, Delhi, Bangalore, Hyderabad, Kolkata, Pune and PAN India. Our training methodology is simple and easy to understand. We provide Instructor-led, Interactive and hands-on training with real time examples. Our instructors are knowledgeable, experienced and patient computer training professionals with both Industry Expert and Microsoft Certified Trainers.
Power Platform Training - Power Apps & Power Automate / Microsoft Flow.
Power Automate Course Overview
This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual Work Power Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and Work Power Automate logic for your business Work Power Automates.
Who Should Attend
The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones.
Power Automate Course Objectives
Microsoft Power Automate Course Outline
Excel 2007 & 2010 Quick Overview
Difference between Excel 2003, 2007 and 2010, Use of Excel, its boundaries & features
Basic Formula
Formulae that Add/Subtract/Multiply/Divide • BODMAS/Formula Error Checking • The Sum Function
Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
LOOKUP Functions
The VLOOKUP/HLOOKUP Functions
PivotTables
Creating, Formatting Simple PivotTables • Page Field in a PivotTable • Formatting a PivotTable • Creating/Modifying a PivotChart
Logical Functions
IFs and Nested IF Functions • Using AND/OR/NOT Functions
Statistical Functions
Using The SUMIF/COUNTIF Functions • Using The AVERAGE/COUNT/LARGER/SMALLER Functions
Pivot Tables – Advance
Adding new calculated Fields / Items • Changing the Summary Function • Consolidate Pivot table
LOOKUP Functions – Advance
MATCH with VLOOKUP Functions • INDEX & MATCH Functions • OFFSET/ INDIRECT functions
Logical Functions – Advance
If Loop and Nested IF Loop Functions • Using IF/ISERROR Functions
Chart Data Techniques
The Chart Wizard • Chart Types • Adding Title/Legends/Lables • Printing Charts • Adding Data to a Chart • Formatting/Renaming/Deleting Data Series • Changing the Order of Data Series
Date/Time Functions
Using The Today • Now & Date Functions • Using The Datedif/ Networkdays/ Eomonth Functions • Using The Weeknum Functions • Using The Edate/ Networkdays.Intl/ Weekdays.Intl Functions.
Text Functions Using
The Mid/ Search/ Left/ Right Functions • Using The Trim/ Clean/ Upper/ Lower Functions • Using The Subsitute/ Text Functions • Using The Trim/ Clean/ Proper/ Dollar Function
Validations
Input Messages / Error Alerts/ Drop-Down Lists • Conditional Formatting
Advanced Filters
Extracting Records with Advanced Filter • Using Formulas In Criteria
Advanced Sorting
Sorting by Top to Bottom / Left to Right • Creating / Deleting Custom List • Sort by using Custom List
Hyper / Data Linking
Hyper linking data, within sheet / workbook • Linking & Updating links between workbooks & application
Math & Trigonometry Functions
Using SUMPRODUCT Functions • Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions
Summarizing Data
Creating Subtotals/Nested Subtotals • SUBTOTALS Formula
Outlining
Creating/Working with an Automatic/Manual Outline • Grouping / Ungrouping
Consolidation
Consolidating Data with Identical/Different Layout
Using Auditing Tools
Displaying/Removing Dependent & Precedent Arrows • Evaluate Formula – Step IN/ Step Out
Custom Views
Creating Custom Views • Displaying Custom Views • Deleting Custom Views
Sharing and Protecting Workbooks
Sharing Workbooks & Tracking Changes • Protecting sheets / workbooks / Files
Importing & Exporting Data
Importing Data from Database/ Text Files/ Web • Exporting Data • Changing External Data Range
Drop Email For Corporate Training Across India & International or Call