[Udemy] – Excel Crash Course: VLOOKUP, HLOOKUP, and LOOKUP Functions

previous site postsexcellookup functions

Course Preview What you’ll learn Replace lengthy nested IF functions in Excel spreadsheets Return information associated with a lookup value from a table Identify the location of a lookup value within a table  Requirements Basic computer usage skills involving the mouse and keyboard Access to Microsoft Excel version 2013 or newer Minimal proficiency with Excel

[Udemy] – Complete Excel 2016 – Microsoft Excel Beginner to Advanced

previous site postsexcelmicrosoft

Master Microsoft Excel quickly & easily. Microsoft Excel beginner to Excel pro – Excel 2010, Excel 2013, Excel 2016, 365 Created by Steve McDonald Last updated 9/2018 English What Will I Learn? Feel confident using Excel in the workplace. Be able to create and navigate Excel spreadsheets. Be able to create tables, charts, pivot tables and

[Udemy] – MIS Professional – Excel + Macro + Access + SQL

previous site postsAcessexcelMacroMIS Professionalsql

Build Amazon Affiliate Marketing Sites – Niche & Keyword Research, Link Building, Silo Architecture, WordPress SEO Created by The SEO Academy Leaders in SEO education Last updated 9/2018 English What Will I Learn? Expert MIS Level Excel, Macro, Automation, Database and queries knowledge   Requirements Basic Computer Knowledge is must  Description A management information system (MIS) provides organisation with

Microsoft Office Essential Skills

previous site postsexcelMicrosoft officeoutlookpowerpointword

Learn the essential Microsoft Office skills employers want from a Microsoft Certified Trainer! Created by David Millard Last updated 1/2018 English What Will I Learn? Confidently use Microsoft Office in the workplace Understand the essential skills employers expect in Word, Outlook, Excel and PowerPoint Apply best practices to your work Achieve confidence and job satisfaction through

Python Automation : Automate mandane task with python

previous site postsbeautifulsoupexcelmandaneopenpyxlpythonseleniumWeb scraping

Learn python 3 from beginner to expert, openpyxl, excel pdf, Web scraping, selenium, Beautifulsoup, regular expression Created by  Ankit MistryLast updated 7/2018Language: English What Will I Learn? Learn how to import excel workbook in python Learn to create and delete worksheet Read, write individual shell in worksheet Learn how to manipulate excel functionality through automation