Trending
  Cloud  Microsoft Introduces Python in Excel
Cloud

Microsoft Introduces Python in Excel

adminadmin—August 24, 20230
PinterestLinkedInTumblrRedditVKWhatsApp


Some members of the Microsoft 365 Insiders program can now try out the combination of Python’s data analysis and visualization libraries, Excel’s features and the Anaconda Python repository.

Microsoft Excel spreadsheet program on display screen of a laptop.
Image: wachiwit/Adobe Stock

Python in Excel is now available on a rolling basis for Microsoft 365 Insiders program beta channel members, the Redmond tech giant announced on Tuesday. This change allows those Excel users to execute Python analytics within their worksheets. It pairs Python’s data analysis and visualization libraries with Excel’s features, plus the ability to call Python analytics from Anaconda’s enterprise-grade Python distribution hub.

More information about when Python in Excel will be generally available is expected soon.

Jump to:

What is Python in Excel?

With Python in Excel, users will be able to type Python code directly into an Excel cell. The Python calculations will run on Microsoft’s cloud servers and be delivered back to the Excel sheet.

Python plots and libraries will be capable of manipulating and exploring data in Excel. From there, users can apply Excel’s formulas, charts and PivotTables to the data they have calculated in Python (Figure A).

Figure A

A screenshot of Python calculation in a Microsoft Excel cell.
A demonstration of Python calculations typed into an Excel cell. Image: Microsoft
More stories

With its Anaconda Distribution for Python running in Azure, Python in Excel will call common Python libraries, including pandas (data manipulation), statsmodels (advanced statistical modeling), and Matplotlib and seaborn (data visualization).

“The ability to run Python in Excel simplifies McKinney’s reporting workflows,” said Greg Barnes, executive director of data and analytics at McKinney, in Microsoft’s blog post about this news. “We used to manipulate data structures, filter, and aggregate data in a Jupyter Notebook and build visuals in Excel. Now we can manage the entire workflow in Excel.”

Teams and Outlook users will be able to view Python calculations from Excel

Microsoft Teams and Microsoft Outlook will also have newfound Python functionality; both can be used to share workbooks and Python analytics with Python in Excel. If you’re collaborating with a teammate who doesn’t have Python in Excel, they’ll still be able to see the analytics and comment on the data in Teams or Outlook.

SEE: Microsoft’s generative AI assistant, Copilot, may be the next big thing in the 365 suite. Here are all the applications it will touch. (TechRepublic)

Limitations of Python on Excel

There are limitations to running Python in Excel. Because the Python calculations are done in Microsoft’s cloud, any customizations a user may have made to their local Python installation will not be automatically applied to Python in Excel. Like most collaborative applications of this type, Python in Excel can only be used with an internet connection.

How to get Python in Excel

To sign up for the Public Preview, you need to join the Microsoft 365 Insiders program Beta Channel; you also need to be running Excel for Windows build 16818 or later. Some members may not see Python in Excel as an option yet; Microsoft stated this beta will be rolled out in waves.

Users with the Public Preview will be able to see Python in the Excel ribbon menu. Those users can bring external data into Python using Power Query and built-in Excel workflows.

While Python in Excel is in beta, members of the Insider community may expect to see fixes and tweaks to the following:

  • Enhanced editing features like autocomplete and syntax highlighting.
  • Default repairs.
  • Updated error behaviors.
  • Improved help menus and documentation.

Microsoft expects Python in Excel to be expanded to platforms beyond Excel for Windows, such as Excel for the Mac or for mobile devices, at a later time.

How to use Python in Excel

If you have the latest build of the Insider version of Excel installed, take the following steps to open Python in Excel:

  1. Open a blank workbook.
  2. Navigate to Formula in the ribbon menu.
  3. Choose Insert Python.
  4. Choose the Try button when a dialogue box appears.

There is an alternate way to open Python in Excel.

  1. Enter =PY into an Excel cell.
  2. Select PY from the function AutoComplete menu.
  3. Enable the preview using the dialogue box.



Source link

PinterestLinkedInTumblrRedditVKWhatsApp

admin

CNN news is coming to Warner Bros. Discovery streaming service Max
Apple backs California right-to-repair bill in major policy shift
Related posts
Load more

Whoops, you're not connected to Mailchimp. You need to enter a valid Mailchimp API key.

Leave a Reply
Read also
Load more

Boosting Cybersecurity for Small Businesses: Effective Strategies for Task Automation

Small businesses face increasing cyber threats that can jeopardize their sensitive data, finances, and reputation. While implementing robust cybersecurity measures is crucial, small business owners often struggle with limited resources and expertise. However, with the advancements in automation technology, small businesses can leverage automated tools and processes to enhance their cyber defense. This article explores the best ways for small businesses to automate cybersecurity tasks, empowering them to safeguard their digital assets effectively.

Employing Automated Threat Detection

One of the primary challenges in cybersecurity is the timely identification and response to potential threats. Small businesses can automate threat detection by deploying security information and event management (SIEM) or intrusion detection and prevention systems (IDPS). These tools analyze network traffic, log files, and system events, promptly alerting business owners to suspicious activities or potential breaches. Automating threat detection reduces the burden of manual monitoring and ensures faster incident response.

Implementing Patch Management Systems

Cybercriminals often exploit software vulnerabilities to illicitly gain access to systems. Small businesses can automate the patch management process to keep their software and systems current. Patch management tools can scan the network, identify outdated software, and deploy necessary updates automatically. By automating patch management, businesses can significantly reduce the risk of exploitation through known vulnerabilities.

Enabling Multi-Factor Authentication (MFA)

Weak or stolen passwords are often responsible for security breaches. Small businesses can enhance authentication security by implementing multi-factor authentication (MFA) systems. MFA adds a layer of protection by requiring users to provide multiple credentials, such as a password, a unique code generated by a mobile app, or a biometric scan. By automating MFA, businesses can fortify access controls and prevent unauthorized access attempts.

Automating Security Auditing and Compliance

Compliance with industry regulations and standards is crucial for small businesses, as non-compliance can lead to severe penalties. Automating security auditing and compliance processes can help small businesses meet these requirements efficiently. Utilizing automated tools that scan systems for vulnerabilities, assess configurations, and generate compliance reports simplifies the auditing process. This automation ensures that businesses can identify security gaps and address compliance issues promptly.

Deploying Automated Data Backups and Recovery

Data loss can have catastrophic consequences for small businesses. Automating regular data backups and implementing disaster recovery solutions is essential. Cloud-based backup services can automatically back up critical data, minimizing the risk of data loss due to hardware failures, cyberattacks, or natural disasters. Automated backups ensure that businesses can quickly restore their systems and operations in the event of a breach or data loss incident.

Educating Employees with Security Awareness Training

Cybersecurity incidents are often attributed to human error, making them a prominent contributing factor. Automating security awareness training can help small businesses educate their employees and cultivate a strong security culture. Deploying automated training modules or simulated phishing campaigns can teach employees about common threats, safe browsing practices, and incident reporting procedures. Automating these training initiatives ensures consistent and ongoing education for all staff members.

As cyber threats continue to evolve, small businesses must adopt proactive cybersecurity measures to protect their sensitive data and operations. By embracing automation, small businesses can effectively enhance their cyber defense capabilities. From automated threat detection and patch management to multi-factor authentication and data backups, these automation strategies provide small businesses with robust security solutions despite limited resources. Small businesses can mitigate risks, safeguard their digital assets, and focus on growth and innovation by automating cybersecurity tasks.

What Is Ethical Hacking? Unraveling the Enigma of Cybersecurity's Guardians

In the vast realm of cyberspace, where shadows dance and digital footprints intertwine, the concept of hacking often conjures up images of malicious cyberattacks and occult breaches. But hidden within this landscape, some cybersecurity professionals use their skills to protect and defend. They are known as ethical hackers, the unsung heroes of our technology-driven world.

The Vital Role of Ethical Hackers in Cybersecurity

The role of an ethical hacker is vital within the cybersecurity industry. Armed with a wealth of knowledge and experience, these experts embark on a noble quest: to uncover vulnerabilities and safeguard the integrity of digital systems. Their mission? To perform risk assessments and test the foundations of security in organizations.

To achieve their goal, ethical hackers immerse themselves in the expanse of security breaches, exploits, and vulnerability scenarios. They leave no stone unturned. Their goal is to protect organizations from malicious attacks, ensuring that the digital fortress remains untouchable.

Don't underestimate the importance of ethical hacking. As the world becomes increasingly interconnected, cybersecurity has never been more pressing. According to a report by Emergen Research, the cybersecurity industry is expected to expand at a compound annual growth rate (CAGR) of 12.0% to 13.4% from 2022 to 2030. This surge in demand reflects the critical importance of ethical hackers in fortifying digital infrastructure against the relentless onslaught of cyber threats.

Embracing the Journey: Continuous Learning and Certification for Ethical Hackers

Becoming an ethical hacker requires diverse skills and knowledge. Understanding the types of hackers is crucial, as it provides insights into how they operate. Armed with this knowledge, ethical hackers delve into cutting-edge tools and techniques. They leverage their skills to identify vulnerabilities and devise countermeasures.

The responsibilities of an ethical hacker transcend merely identifying weaknesses. They also recommend solutions and implement robust security measures. Their expertise helps organizations fortify their defenses, minimize breaches, and protect sensitive data from falling into the wrong hands.

The Tools of Ethical Hacking

Curious about the tools an ethical hacker uses? They have access to a diverse range of tools. These tools allow them to probe and analyze digital systems, uncover weaknesses, and assess the resilience of security measures. While the specific tools vary based on the objectives and preferences of individual ethical hackers, there are several standard tools they employ. 

One such tool is the ever-popular Nmap (Network Mapper). Nmap is a powerful network scanning and mapping tool that allows ethical hackers to examine hosts and services on a network. It helps identify open ports, detect potential entry points, and provides a comprehensive overview of the network's structure. By leveraging Nmap's capabilities, ethical hackers gain valuable insights into the system's vulnerabilities, enabling them to devise targeted strategies for fortification.

Another essential tool in the ethical hacker's arsenal is Metasploit. Metasploit is an open-source framework that facilitates penetration testing and vulnerability assessment. It offers a wide range of exploits, payloads, and auxiliary modules, empowering ethical hackers to simulate real-world attack scenarios. Employing Metasploit's extensive collection of exploit codes, ethical hackers can uncover weaknesses, gain unauthorized access, and assess the system's defenses against potential threats.

WireShark, a network protocol analyzer, is another indispensable tool for ethical hackers. It allows them to capture and examine network traffic, providing deep insights into the packets traversing the network. With WireShark, ethical hackers can scrutinize individual packets, analyze network protocols, and identify suspicious or malicious activity. This tool enables them to detect anomalies, trace the origin of potential security breaches, and assess the security posture of the network.

Additionally, Burp Suite, a web application security testing tool, plays a significant role in the ethical hacker's toolkit. Burp Suite allows hackers to intercept, analyze, and modify HTTP/S traffic between web browsers and servers. It helps uncover vulnerabilities in web applications, including SQL injection, cross-site scripting (XSS), and CSRF (Cross-Site Request Forgery). Ethical hackers can use Burp Suite to identify weaknesses in web applications, effectively fortify defenses, and protect against potential attacks.

These are just a few examples of the standard tools ethical hackers use. Ethical hacking is constantly evolving, and new tools and techniques regularly emerge to adapt to the ever-changing threat landscape. Ethical hackers leverage these tools to assess and strengthen the security posture of organizations, helping safeguard sensitive information, protect against cyber threats, and ensure the resilience of digital systems in an increasingly interconnected world.

Ethical Hackers Need Ongoing Education

For aspiring ethical hackers, continuous learning and certification awaits. Acquiring industry-recognized certifications not only validates their skills, but also opens doors to a myriad of career opportunities. Certifications such as Certified Ethical Hacker (CEH), Offensive Security Certified Professional (OSCP), and Certified Information Systems Security Professional (CISSP) provide the credentials to excel in this demanding and ever-evolving field.

Conclusion

The expertise of digital hackers safeguards digital life, upholding the principles of integrity, confidentiality, and trust. The growth of the cybersecurity industry reflects the need for ethical hackers, stressing the ever-present demand for their unique skills. So, acknowledge and appreciate these unsung heroes, the vanguards of cybersecurity who tirelessly battle in the shadows to preserve the sanctity of the digital realm -- and be glad they're there. 

References:

"Cybersecurity Market, By Component (Hardware, Solution, Service), By Security Type, By Solution, By Application (IT & Telecom, Retail, BFSI, Healthcare, Defense & Government, Manufacturing, Energy, Others), By Region Forecast to 2032". Www.Emergenresearch.Com, 2023, https://www.emergenresearch.com/industry-report/cyber-security-market. Accessed 25 May 2023.

Cyber Insurance: Why Every Business Needs Coverage

Businesses in all industries are heavily reliant on technology. Unfortunately, this also makes companies a prime target for a variety of cyber attacks. Despite the best efforts in cybersecurity, no company is entirely immune to these risks. One way to help limit these concerns is to purchase cyber insurance for your business. Often overlooked or deemed unnecessary in the past, cyber insurance is quickly becoming a business necessity, providing a safety net for whenever things go wrong.

The Ever-Present Threat of Cybercrime

Cybercrime remains a big threat in the digital landscape. The lucrative nature of these attacks makes businesses of any size a top target of cybercriminals. The cost of a data breach can often cost millions of dollars, which is why it's essential for companies to take additional steps to protect themselves. Cyber threats are also becoming much more sophisticated and more difficult to avoid.

A cybersecurity incident isn't just about financial loss. One incident can also lead to reputational damage, loss of customer trust, regulatory fines, and even business closure. Developing a robust cybersecurity system is crucial, but it's not foolproof. Investing in cybersecurity insurance for your business can give you much-needed protection against these threats.

Cyber Insurance: An Essential Safety Net

Like any insurance, cyber insurance covers financial losses related to cyber incidents. This can include costs associated with data recovery, notification of affected parties, legal fees, public relations efforts, business interruption, and even extortion payments demanded by hackers. In essence, cyber insurance is designed to help a company recover from a cyber attack by mitigating the financial impact. It provides an essential safety net that can make the difference between a company going out of business and staying afloat after a cyber-attack.

Coverage Tailored to Your Business

One of the key advantages of cyber insurance is that it can be tailored to fit the specific needs and risk profile of your business. Different businesses have different cyber risks. For example, a healthcare provider may need coverage for patient data breaches, while a retail business might require protection against credit card fraud. Cyber insurance policies can be customized to provide the coverage your business needs most.

The Rising Importance of Cyber Insurance

Cyber insurance is growing in importance as businesses become more digital and data-driven. It's not just about whether your business will experience a cyber-attack, but when it will happen. Data privacy laws are becoming more stringent, which means businesses can face hefty fines for failing to adequately protect customer data. Cyber liability insurance can provide coverage for these regulatory fines.

Cyber Insurance - An Investment Worth Making

Investing in cyber insurance is like putting on a seatbelt while driving. It doesn't prevent an accident, but it can significantly mitigate the damage if one occurs. Cyber insurance is an essential part of a comprehensive risk management strategy, providing financial protection and peace of mind in a digital age fraught with cyber threats. Regardless of your business size or industry, having cyber insurance can help you navigate the aftermath of a cyber-attack by protecting your financial resources.

PSL’s Easy Guide to Understanding Cybersecurity

The world of cybersecurity can often feel like a maze of technobabble and obscure acronyms. Yet in an era where our lives increasingly depend on digital infrastructure, it's important to have a basic understanding of the terminology involved. Learning about cybersecurity can help you avoid common mistakes and limit the chance of becoming a victim of these crimes.

Here is an overview of common cybersecurity terms.

1) Cybersecurity

Let's start with the basics. Cybersecurity is simply the defense against digital attacks that target computers, mobile devices, networks, and servers. These attacks are typically aimed at accessing, changing, or destroying sensitive information, extorting money from users, or interrupting normal business processes.

2) Malware

Malware is any malicious software that can damage or infiltrate computers without the user's consent.

Here are the most well-known types of malware.

Virus

Like a biological virus, a computer virus attaches itself to a host (in this case, a file), and spreads when the file is shared, infecting other files and systems.

Worm

A worm is a standalone type of malware that will replicate itself to easily spread to other computers through a network.

Trojan

Named after the Greek myth, the Trojan horse, a Trojan is a form of malware that attempts to disguise itself as a normal program or file to trick users into either downloading or installing it.

Ransomware

This type of malware encrypts the user's files and demands payment to unlock them.

Spyware

Spyware is malware that's specifically designed to spy on user activity without their knowledge.

3) Phishing

Phishing is a common attack that tries to gain personal information by using deceptive emails and websites. The attacker, masquerading as a trustworthy entity, uses a variety of strategies to trick the victim into opening an instant message, email, or text message.

4) Firewall

A firewall is an IT security tool that controls network traffic using predetermined security rules. Think of it as a digital barrier limiting unauthorized access to your network or computer.

5) VPN (Virtual Private Network)

A VPN masks your internet protocol (IP) address to make your online actions nearly untraceable. VPN services establish encrypted connections to provide much greater privacy while using the internet.

6) Encryption

Encryption converts data into a code to prevent unauthorized access. When data is encrypted, it appears as gibberish unless you have the decryption key to convert it back to its original form.

7) Two-Factor Authentication (2FA)

2FA is a common security process in which users must provide two different authentication factors to gain access to an account. For example, in addition to a password, you might also need to enter a code sent to your phone.

8) Darknet/Dark Web

The darknet or dark web refers to encrypted online networks that aren't indexed by search engines, and they are often used for illicit activities. You need special software (like Tor) to access it.

9) Data Breach

A data breach happens whenever secure or private information is released into an untrusted environment. This is often due to a cyberattack on a database, leading to sensitive data being exposed, copied, or used.

10) Botnet

A botnet uses a group of private computers that are unknowingly infected with malicious software and are controlled as a group to perform various tasks. Many times botnets are created to send out spam emails or carry out Distributed Denial of Service (DDoS) attacks.

Closing Thoughts

Understanding cybersecurity is not just for the tech-savvy; it's for everyone. We are all potential targets for cyber threats, and comprehension of basic cybersecurity terminology can make a significant difference in safeguarding ourselves and our digital assets.

Employing cybersecurity measures also helps to keep your digital data safe. This might include using a VPN, enabling two-factor authentication, or simply being wary of suspicious emails to prevent phishing attacks.

Ultimately, it's not necessary for everyone to be a cybersecurity expert, but a basic understanding of the key terms can be an empowering first step in better securing your digital life. This newfound knowledge can provide you the confidence to navigate the online world with more safety and assurance.