Questions covered in this video: How to Import Transactions Data into Excel: 00:22 What is Conditional Formatting in Excel 04:15 How to remove duplicates in Excel 06:27 How to Sort and Filter Data in Excel 14:00 What are the differences between Excel 2019, Excel 365 and Excel Online 15:37
Microsoft Visio is one of the Office tool and it helps professionals to create Diagrams. From flow charts to floor plans, there isn’t much it can’t handle. Visio can be used to create simple or complicated diagrams. It offers a wide variety of built-in shapes, objects, and stencils to work with. You can also make your own shapes and import them if you’re willing to do all that extra work. The driving idea behind Visio is to make diagramming as easy as possible for the user. There are different types of diagrams you can do with Visio: flowcharts, org charts, building plans, floor plans, data flow diagrams, process flow diagrams, business process modeling, swimlane diagrams, 3D maps, and many more. It’s a Microsoft product, sold as an addition to MS Office. Visio 2016, the latest version, comes in three editions: Visio Standard, Visio Professional, and Visio Pro for Office 365.
Refresh your Excel skills and learn how to get ready for excel interview and pass excel assessment test for job application. In this tutorial you will learn 20 typical assessment exercises, asked during Excel interview assessment test: