tutorials

These tutorials are the Learning Keys to each topic, what you learn here is what you should know about that topic. All the topics are based on the questions asked by learners like you. ASK for more Learning Keys on Automation (VBA Automation & RPA) and TechKeys.

Learning Keys

Robotic Process Automation

  1. Robotic Process Automation Tutorial for Beginners
  2. Companies using Robotic Process Automation
  3. Robotic Process Automation Training
  4. RPA Journey (Implementation Steps)

Excel Automation [VBA Codes]

  1. Excel VBA Macros Tutorial for Beginners
  2. VBA Code to Import Access Table /Query data to Excel
  3. VBA Code to Export Excel data to Access
  4. VBA code to Execute Access Query
  5. VBA Code to Protect Worksheet with Password on Close
  6. VBA Code to Open Excel File from Folder
  7. VBA Code to Close all Workbooks in One Go

Access Automation [VBA Codes]

  1. VBA Code to Export Access data to Excel
  2. VBA Code to Execute Access Query

Excel Formulas

  1. Excel Formula to convert dd/mm/yyyy to mm/dd/yyyy
  2. Excel Formula to Sum Cell Values from Multiple Worksheets
  3. Excel Formula to Count Cells between Two Numbers
  4. Excel Formula COUNTIF and IFERROR

Excel Tips

  1. Introduction to ASAP Utilities
  2. How to enable Developer tab in excel 2003, 2007, 2010
  3. Insert button greyed out in Excel Developer tab – 5 Reasons and Solution
  4. How to Strikethrough in Excel 2003, 2007, 2010, 2011, 2013, 2016

R Programming

  1. How to create a directory in R
  2. Command to create a File in R
  3. How to rename a file in R
  4. R Command to check if a file exists in the directory
  5. R Programming command to delete a directory

ThechKeys

  1. jMock for beginners
  2. SAP BusinessObjects Dashboards (Xcelsius) Tutorials
  1. How to Recover Deleted Files from SD Card in 3 Steps
  2. How to do Anonymous Browsing and Downloading Online
  3. How to Find IP Address and MAC Address in Mac OS X
  4. How to Activate/Deactivate DND Service in India
  5. How to surf the web without Internet Connection
  6. How to Watch YouTube Videos Without Internet Connection
  7. How to tumble around/spin Google Search
  8. How to make Windows look like Mac OSX
  9. How to reorder/rearrange email accounts in Thunderbird
  10. How to configure/setup internet connection in Ubuntu
  11. How to Control Facebook Addiction?
  12. How to be more productive at work ‘Rescue Time’ Time tracking software
  13. Break Alert Tool for Computer Users: Awareness
  14. 10 Mandatory Features of Best VPN Products
  15. 10 Most Important Symptoms of Facebook Addiction
  16. YouTube Play Button – 3 Different YouTube Creator Awards
  17. Two Cows of Mike Hosking Explained World Economy Simpler
  18. Download Movies in 3 Steps (with Images) – 100% Legal
  19. WhatsApp New Web Browser Version – WhatsApp Web
  20. What Does WhatsApp Blue Tick Mark Means – Double Tick Mark
  21. Introduction to FightBack Mobile App for Women Safety
  22. Introduction to 4G LTE
  1. Keyword Tips for writing Search Engine Friendly Post
  2. How to Find High PR Links for Free and Building Backlinks
  3. Article Spinning for Beginners – All You Need to Know
  4. Best Amazon Affiliate Link Localizer (Free and Paid)
  5. Affiliate Marketing Success Blueprint – 12 Video Modules
  6. 3 Things To Know Before Starting Any Online Money Making Business
  7. 3 Basic Things For A Successful Blogging Career
  8. How to build your own Online Business
  9. Introduction to Medical Transcription and a List of MT Companies
  10. Introduction to Freelance Work and a list of best Freelance Websites
Pin
Share
Tweet
Share
+1

Comments are closed.