Windows 10 Advanced: Fast Track Training

"Google Sheets for Data Analysis Workflow Automation" is a comprehensive course designed to equip learners with the skills to use a Google Sheet effectively for analysing data and automating the workflows. This course is ideal for individuals who are new to Google SpreadSheet or those who have some experience in sheets but want to enhance their skills to analyse data more effectively and streamline their workflows.Throughout the course, learners will learn to perform a range of data analysis tasks using Google Sheets, such as cleaning and organizing data, using various functions to analyze the data and implement automation through Google Forms as a bonus package of this course. Learners of this course will be able to work on two real life projects, one on Sales Data Analysis and another on implementing a completely Online Leave Application and Approval workflow by leveraging Google Sheets, Google Forms and Gmail Productivity features in Google Workspace (G Suite).The functions covered in this course include:Mathematical Functions: COUNTIF, COUNTIFS, COUNTUNIQUE, FLOOR, CEILING, ROUND, ROUNDUP, ROUNDDOWN, ISEVEN, ISODD, SUM, SUMIF SUMIFSStatistical Functions: AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT, COUNTA, MIN, MAX RANKText Functions: LEN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, TRIM, REPLACE, SUBSTITUTE, REGEXREPLACE, REGEXMATCH REGEXTRACTLogical Functions: AND, OR, IF, NESTED IF, IFS, SWITCH, IFERROR IFNAFilter Functions: FILTER, SORT UNIQUEDate Time Functions: DATE, ISDATE, DATEDIF, DAY, MONTH, YEAR, DAYS, DAYS360, EDATE, EOMONTH, NOW, TODAY, HOUR, MINUTE, SECOND, WEEKDAY WEEKNUMOther Important Functions in G-Sheets: VLOOKUP, IMPORTRANGE, ARRAYFORMULA, QUERY &n

Learn how to build workflows to automate business processes and tasks across Outlook, SharePoint, and Teams. Would you like to increase efficiency by automating repetitive tasks? Power Automate can help you do that! In this course, Power Apps expert Vicki Drewa will show you how to use the features of Microsoft Power Automate to make your workflow more efficient. After an overview of Power Automate and its purpose, you’ll explore home page options and different types of flows. You’ll learn how to create flows from a template and how to create automated, scheduled, and instant cloud flows. And you’ll learn how to use the mobile app to trigger and create instant flows when you need them. In addition to creating flows, it’s important to know how to handle errors using the flow checker and how to share a flow with others. You’ll also learn how to manage your flows, to edit, rename, and delete flows, and how to view flow analytics. By the end of this course, you will have the necessary knowledge to begin building workflows that will automate your repetitive tasks and increase efficiency! Topics covered include: - Navigating the Power Automate app - Exploring home page options - Identifying types of flows - Creating a flow from a template - Creating automated cloud flows - Editing and renaming flows - Setting up scheduled cloud flows - Creating instant cloud flows - Using the mobile app to trigger and create instant flows - Finding and correcting flow errors - Sharing flows - Managing flows Enjoy high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

This course will go a step further than the standard Excel course and teach tools which are even more advanced and powerful for the serious analyst. With this course you will learn all of Microsoft's most important business intelligence tools Power Query, Power Pivot, DAX Power BI all in a single course. The 8 hours of video content, quizzes, and assignments have been carefully designed to help you progress to a data analyzing wizard in the most logical way possible. The course comes with lifetime access, downloadable materials and 30 day money back guaranteeThroughout the course we will use many data sets as examples and will even conclude by creating a Data Model and Dashboard based on the Microsoft 'Northwind' sales data setYou could be 8 hours away from becoming an Excel expert!ContentsPower QueryPower PivotDAXPower BI

Paperless and Productive, the two biggest benefits you will get from doing this course.OneNote lets you take your work with you, wherever you go, on any device. It syncs automatically so you never have to worry about saving notes when you're on the go.Earn and Excel brings you a course that will teach you everything you need to know about OneNote, and then some.You will be taught by a highly experienced corporate professional and trainer in this courseBy the end of this course your notes will be highly organised, stored in one place and easily accessed from any device.We look forward to transforming you skills and becoming paperless and productive!This is a perfect course for anyone looking to get more productive on a day to day basis and keeping on top of notes with the Microsoft product suite including professionals, students, entrepreneurs and even those looking to note take for personal/leisure purposes!------------------------------------------------ ------------- ------------- -------------- ------------Some of our positive reviews!M. Wright - Very informative. I am excited to use the program I had been overlooking. Easy to follow.A. Hartono - Very Good TutorialN. Rajwade - I learned many functions that I never used before. ThanksG. sharma - Its goodT. Chowdhury - it was amazing learning so far. I really enjoyed the details.A. Sharif - Mind blowing course

INTERMEDIATE - DATA FILTERING, SORTING, SEARCHING EDITING AND EXTRACTIONExcel is not going anywhere, and businesses will continue to use Excel as a primary tool for diverse functions and applications ranging from IT projects to company picnics.A working knowledge of Excel is vital for most office based professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities. Excel is a powerful tool but cannot function alone. It takes a savvy computer user to take advantage of everything Excel has to offer to provide the best results for their company.Need to make informed decisions but feeling overwhelmed with too much information to get through? Excel is geared towards processing large amounts of data with minimal fuss. In this session we empower your decision making by helping you organise and sift through data with efficiency, using an array of formulas, filtering functionality, data searching and extraction tools.The objective of this session is to enable delegates to become comfortable with working with populated Excel sheets and sifting through copious amounts of data, turning data into logical information and performing search queries and only returning desired information. To achieve this, we will cover the following topics:· Data Editing o Sorting o Filtering o Conditional formatting o Data validation o Subtotal formula o Find and replace· Data Searching o Searching within filter o Searching within sheet o VLookUps o CountIf formula o If statements o Basic Data Extraction o Flash fill o Text-to-Columns o Concatenate.

Learn SAP FICO Accounts receivable in a step by step process. Understand business functions and processes A practical with screenshots and concepts explained Tips and tricks based on expert knowledge This comprehensive video course takes you through important concepts in Financial Accounting AR in SAP ERP. Practical Knowledge. Acquire the knowledge behind the powerful actions. Integration with SAP Modules and more.