Power BI, Excel and MS Industry News

Filter by Category or Experience Level:

Advantages of Learning VBA

Excel VBA Microsoft Excel is a benchmark industry tool for financial planning, data entry and budgeting. Using some powerful features and functions, you can analyse and gain insights from your data. Having said that, many of the tasks in Excel are tedious and complex. Creating reports in Microsoft Excel is a task that is entrusted…

Read more

VBA Automation using Macros

VBA Automation – A Case Study VBA is the programming language, which is used for writing macros in Microsoft Excel and all other Microsoft Office applications. Learning VBA code allows users to automate tasks, from simple ones in Excel such as entering and editing cell values, to interacting between other apps. VBA is used within Microsoft…

Read more

Conditional Formatting Basics

What is Conditional Formatting? Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets specific criteria. It serves to highlight important information and allows users to configure specific formatting to cells automatically. Conditional formatting applies sets of rules to cells using basic, intermediate or advanced formulas…

Read more