Introducing Macros for Excel

-
Excel has been the core of the companies. Whatever the company is, nothing can be managed without using Excel. There are some scenarios where we perform the same operation on a daily basis using Excel sheets, which can be tedious and hectic and can stop you from doing any productive work. So, In order to overcome it, we are sharing few excel hacks. Most of you might have heard about Macros in Excel. It can be used to simplify your day-to-day tasks. Not only Excel even PPTs can be automated using Macros. So if you are from a Manual background, getting a strong grip on Macros will put you one step ahead of your colleagues.


How to enable developer option in PPT
Before we begin with Macros, we need to enable the Developer tab in Macros which can be configured as Go to File -> Options -> customize Ribbon -> Enable Developer option.

Now after enabling the Developer option, we need to configure Macros settings for that scroll towards Macro security -> Macro settings -> Disable all macros with Notification.

After which save your ppt file having an extension .pptm which is powerpoint macro-enabled presentation. In the case of Excel file, it is .xlsxm

How to add a functioning button in PPT slide
Go to Developer tab -> go to ActiveX controls -> Click on command button -> draw the button and add the desired code in the Visual Studio to get started.





Comments

Post a Comment

Popular posts from this blog

Azure Tutorials Series - Azure Networking

-
Image
In this article, we will learn about Azure networking concepts such as architecture, microservices, virtual networks, VPNs, subnet, VPN gateways and most importantly Network Security Group(NSG). All these terms are to be understood if you appearing for AZ900 Microsoft Azure Fundamentals exam. Azure Networking In previous articles we have learnt about Micro- services and how they work, these are alos loosely coupled architecture. Some of the features includes Independent components interact with each other with the help of queues Can be updated and deployed independently Highly scalable Supports Asynchronous messaging N-tier Architecture Supports loosely coupled architecture Application divided into multiple tiers such that higher tier can access lower tier but not vice versa Tiers are re-usable and can be updated or replaced easily without any hassle. Three-tier in general Web Tier(front end) Application tier(back end) Data tier(Storage) Virtual Network Isolated network shared by few g...
Read more

Testing in CI/CD

-
If you are part of testing fraternity you would have heard CI/CD numerous times by now. It's the talk of the software testing town. In this article, we will cover the basics of CI/CD, what actually it is and how it is implemented in software testing. What is continuous integration? In simple terms, development teams can integrate their code into a shared repository. This helps in maintaining code quality and identifying potential issues with the local version of the code at an early stage. What is continuous delivery? Everything that is being continuously merged by the development team, is continuously deployed to the live environment. Continuous delivery is often coined as ‘Continuous Deployment’ as well. Since most developers work in parallel, continuously integrating their code into one repository would mean that the master branch is continuously updated with new features. In order to ensure that there is no compromise in the code quality with so many changes...
Read more

Azure Tutorials Series - IaaS vs PaaS vs SaaS

-
Image
We already have covered Public vs Private vs Hybrid differentiation in the previous article. In this article we will be covering three categories of cloud computing with relevant examples and details. Most of you might already be using these services in your daily day-to-day tasks unaware of the face that your organisation has already started the transition into the cloud. For an example, Office 365 is a active SaaS(Software as a service) that most of us uses, VMs are examples of IaaS(Infrastructure as a service) and Azure SQL Database is PaaS(Platform as a service). Now how do we differentiate between the three categories as a user? Will cover the details below. Infrastructure as a Service(IaaS) Service provider provides you the hardware User gets some control over the hardware, can customise operating system, storage and VMs. Ensuring service is up and running is shared responsibility While cloud provider makes sure that the hardware is functioning correctly, user needs to make sure ...
Read more