Excel Archives - Big Data & ETL

MS Excel VBA: How to add Developer tab in Microsoft Excel?

Post author:adereke
Post published:9 July 2020
Post category:Articles / MS Excel / Programming Languages / Tips
Post comments:0 Comments

Programming in VBA can significantly speed up and facilitate your work. Visual Basic for Applications is a programming language implemented in Microsoft Office programs that you can use to write…

MS Excel – How to create drop-down list in Excel?

Post author:adereke
Post published:29 June 2020
Post category:Articles / MS Excel
Post comments:0 Comments

Manual input of data in MS Excel forms and text cells can lead to many errors and occurrence of dirty records in your data. If the user makes e.g. a…

Photo by Kaitlyn Baker on Unsplash

How to put new line at the same cell in Microsoft Excel file

Post author:adereke
Post published:1 March 2020
Post category:Articles / MS Excel / Tips / Windows
Post comments:0 Comments

When you press the Enter button in Microsoft Excel file, cursor move you to the next cell. If you want add break line between lines or paragraphs of your text,…

Subscribe to be up to date