• Home
  • About Us
  • Contact Us
  • Disclaimer
  • Privacy Policy

Simple MS Office - Learn VBA, Python, Batch Commands, SQL
  • Home
  • Learn Excel
  • _for Beginners
  • Learn Excel VBA
  • Python Scripts
  • SQL for Beginner
  • Batch Commands
  • Guest Post

Monday, March 16, 2020

Excel for Beginner

VLOOKUP Function in Excel with Example

Imran Khan Monday, March 16, 2020
VLOOKUP () This function lookups and retrieves data from a specified column in table. Best view in desktop mode. A ...
Read More
By Imran Khan at Monday, March 16, 2020 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Excel, Excel for Beginner

Wednesday, March 11, 2020

Excel for Beginner

TRUNC Function in Excel with Example

Imran Khan Wednesday, March 11, 2020
TRUNC () This function removes the decimal part of a number. And it is also used to remove time from date-time stamp. Best view in ...
Read More
By Imran Khan at Wednesday, March 11, 2020 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Excel, Excel for Beginner
Newer Posts Older Posts Home

Search Script and Code Here

© Copyright SimpleMSOffice 2019. Powered by Blogger.

Recent

Popular

  • How to Unzip Files Using a Batch File - Simple Step by Step Guide
    How to Unzip Files Using a Batch File - Simple Step by Step Guide
    Suppose you have a single zip file “ RawData.zip ” containing some other files placed in “ Source Folder ” in  C:   drive. And ...
  • How to Run Multiple Batch Files From a Single Batch File - Step by Step Guide
    How to Run Multiple Batch Files From a Single Batch File - Step by Step Guide
    Suppose you have bunch of batch files in ‘ Source Folder ’ like below: unzipfile.bat runpython.bat mergefile.bat     ...
  • How to Run Python Script Using Batch File - Simple Step by Step Guide
    How to Run Python Script Using Batch File - Simple Step by Step Guide
    Condition:  Python should be installed in your system Step 1:  Copy Python Script file in the raw data folder. For exa...
  • How to Merge PDF Files Using Python Script - Step by Step Guide
    How to Merge PDF Files Using Python Script - Step by Step Guide
    Suppose you have bunch of pdf files and you want to merge them in one pdf. So, there are so many online websites and some software to...
  • How to Create List of File Names Using Batch File - Step by Step Guide
    How to Create List of File Names Using Batch File - Step by Step Guide
    In this post, we will provide you multiple batch script codes based on different criteria. We will provide you best and simple...

Comments

All Posts

  • ►  2021 (7)
    • ►  March (1)
    • ►  January (6)
  • ▼  2020 (56)
    • ►  October (5)
    • ►  April (5)
    • ▼  March (19)
      • VLOOKUP Function in Excel with Example
      • TRUNC Function in Excel with Example
      • TEXT Function in Excel with Example
      • COUNTBLANK Function in Excel with Example
      • COUNTIFS Function in Excel with Example
      • COUNTIF Function in Excel with Example
      • COUNTA Function in Excel with Example
      • COUNT Function in Excel with Example
      • DOLLAR Function in Excel with Example
      • RANK Function in Excel with Example
      • INT Function in Excel with Example
      • NA Function in Excel with Example
      • N Function in Excel with Example
      • ROUND Function in Excel with Example
      • CLEAN Function in Excel with Example
      • TRIM Function in Excel with Example
      • LEN Function in Excel with Example
      • NOT Function in Excel with Example
      • AND Function in Excel with Example
    • ►  February (26)
    • ►  January (1)
  • ►  2019 (15)
    • ►  November (1)
    • ►  September (1)
    • ►  August (1)
    • ►  July (4)
    • ►  April (1)
    • ►  March (1)
    • ►  February (2)
    • ►  January (4)

Tags

Batch Commands (5) Excel (63) Excel for Beginner (54) Excel for Intermediate (9) Excel VBA Macro (7) Python Scripts (3) SQL (2)

Total Pageviews

Designed with by Way2themes | Distributed by Blogger Themes