Connect with us

# COVID-19 has affected tech company valuation, but a bounce back is possible

#### More Videos

Data shows a slowdown in acquisitions due to pandemic uncertainty, but as a “new normal” starts to emerge, there are some key ways for ambitious businesses to grow.

It comes as no surprise that COVID-19 has had a negative impact on the economy, and new data finds that it has caused mergers and acquisitions (M&A) to plummet in the tech sector.

PricewaterhouseCoopers (PwC) has released data from the first half of 2020 that shows massive declines in the value and number of large tech acquisitions. M&A deals in the first half of 2020 only amounted to $73 billion, which is the lowest since PwC started tracking the totals in 2016. Some of the large deals so far include Koch Equity buying cloud software company Infor, JustEatTakeaway.com buying GrubHub, and Intuit buying Credit Karma. More shocking than the decline in overall sale value is its ratio to the amount of actual M&A transactions so far in 2020: The amount of deals is only down 6%, but deal value is down 58%. In short, now may not be the best time to sell your startup to a big tech company. A turnaround is expected, and PwC’s US technology, media, and telecommunications leader Marc Suidan said July is already looking up. “With tech companies feeling better about their revenue outlooks, along with strong venture capital funding and vibrant capital markets, we are optimistic that M&A activity will be strong in the second half,” Suidan said. The sectors where tech acquisitions are happening have remained consistent, the report said. Software was the most active sub-sector, which PwC said has been driven by SaaS, cloud, and subscription-based models that have seen increased interest during the pandemic. Video gaming has also seen big growth in 2020 due to people being stuck at home, as have e-commerce and online food delivery platforms, largely for the same reason. ## What fast-growing tech companies can do to stay on top “COVID-19 has had a significant impact on the tech space, accelerating trends that we expect to persist longer term,” the report said. Those results include long-term shifts to remote work, which PwC said will make acquiring small tech companies an appealing prospect to large businesses looking to adapt in a post-pandemic world. Those adaptations “will require rethinking of all aspects of the business from workforce, products and services, end-user experience and how these are all facilitated by a digital platform,” the report said. That’s good news for ambitious tech companies looking to increase their reach, launch an IPO, or be bought out. SEE: IT job and salary guide: Highest tech salaries, top-paying cities, and compensation-boosting tips (TechRepublic Premium) Companies that want to appear appealing, both as a vendor or potential M&A target, should “adopt a structured value creation methodology to identify and articulate the drivers of value created or lost through COVID-19,” PwC said in its report. Big companies, the report concludes, will be taking more deliberate approaches to deal making because COVID-19 responses are still shifting as the pandemic continues to evolve. Tech firms that want to look appealing to acquirers “will need to set up their own virtual process to provide transparency and give buyers comfort in closing the transaction.” 0 Continue Reading ### Technology # Samsung Brings Its Flagship Camera Innovation to Galaxy A Series – Galaxy A71 & A51, to Make Your Social Profile Lit Our social media profiles are reflection of our true personalities. Needless to say, we make that extra effort to make them look and feel special. What helps us in the process is a powerful smartphone that can not only capture stunning photos and videos, but also help us quickly process and share them across to our friends and family members. Samsung’s phones are known for their excellent smartphone cameras. Over the years, the company has been shipping highly innovative and impressive cameras on its flagship smartphones. Samsung is now bringing its innovative flagship camera experiences to its Galaxy A series phones, the Samsung Galaxy A51 and Galaxy A71. These new flagship-level features can help you spice up your social media profiles by capturing and sharing stunning photographs and videos. Let’s take a look at some of the most impressive new camera features in Samsung’s Galaxy A71 and Galaxy A51 smartphones at can help you take your social media posts to the next level: ## Single Take Makes Your Special Moments Extra Ordinary Everything you do is worth sharing on your social media profiles and messaging platforms. Your social profiles help you stay connected to your loved ones by helping you share your most memorable moments. Single Take is a new feature on Galaxy A71 and Galaxy A51 smartphones, which was earlier available only on Samsung’s flagship Galaxy S20 series. Single Take lets you indulge in your special moments, while still capturing the best parts of it. Imagine being at a birthday celebration of a loved one, and wondering about which camera mode to select. Single Take can help you enjoy the moment while still being able to capture all the important details in the form of 10 photos and videos based on the moment and lighting condition. All you have to do is pick Single Take mode, and capture a moment for a few seconds. Your Galaxy A71 or Galaxy A51 phone will be able to deliver stunning photos and videos that ensure you don’t miss out on anything important, and still end up with a bunch of great photos and videos to share on your social media profile. ### Night Hyperlapse to Impress Everyone on Your Feed Out at a party? The new Night Hyperlapse mode can help you capture stunning night-time videos to impress your social media friends and family. The mode helps you capture long-exposure style videos and light trails that are nothing but pieces of pure bliss when you share them on your social media profiles. Your friends and family will nudge you, asking you how you captured these. Night Hyperlapse mode is now available on Samsung Galaxy A71 and Galaxy A51 phones. ### Custom Filters to Add that Special Touch to Your Photos While social media is fun, it’s also filled with a lot of noise. You’re not going to make it if you don’t look different and extra special. Well, Samsung has you covered here as well. The new Custom Filters feature in the Samsung Galaxy A71 and Galaxy A51 can help you create stunning and highly personalized photos using custom-set filters. All you have to do is create a custom filter using any of your existing photos. Custom Filters uses on-device AI to capture the rich colours and vibes of your existing photos. You can then use these filters and apply them on new photos you capture on the Galaxy A71 or Galaxy A51 to create personalized photos. Once you share these on your social media profiles, they’ll look stunning and extraordinary, unlike anyone else’s photos. ### Smart Selfie Angle to Make You and Your Friends Looks Great Selfies are quite an essential part of social media. While everyone is shooting and sharing selfies, not all of them are going to look as good as yours, thanks to this highly innovative camera feature on the Galaxy A71 and Galaxy A51. The new Smart Selfie Angle mode on the Samsung Galaxy A71 and Galaxy A51 help you capture great selfies with your friends. Every time you use the front camera to capture a selfie with your friends, the camera can automatically switch to a wide-angle mode. The mode is built to capture great details when more than one person is involved in a selfie. This means your selfies with your friends are going to look fabulous when you share them on your social media profiles. ### AI Gallery Zoom Adds That Magical Touch to Existing Photos AI Gallery Zoom is a great feature that can help you improve existing photos on your phone. For example, if you get one of your photos from a friend, on a messaging platform, it could turn out to be slightly blurred due to compression systems. This feature ensures those unclear photos look more clear in your Gallery. It can make images look sharper and visually appealing, so you can easily share them on your social media profiles. The feature uses an on-device AI-powered mechanism so your personal data doesn’t leave your phone ever. The feature is also useful if you’re migrating from an older, less powerful smartphone, and are importing photos from it. ### Switch Camera While Recording Is Perfect for Vlogging While most smartphones feature front and rear cameras, they rarely let you capture a single video using both the cameras. Well, Samsung’s Galaxy A71 and Galaxy A51 phones can now let you record videos using both the cameras without stopping recording. It’s an amazing feature that’s perfect while you’re sharing live videos or simply making a quick vlog for your social media profiles. ### Quick Videos Ensure You Don’t Miss Anything Consider this, you come across a really special moment, and by the time you fire up the Camera app on your phone and start recording the video, it’s gone. Samsung Galaxy A71 and Galaxy A51 now come with a new feature called Quick Videos that takes care of this problem. You can now quickly capture a video by long-pressing the shutter button. This way, you can easily record a great video and share it on your social media profile. Quick Videos feature is ideal while you’re at home or on a vacation, and you simply want to capture a quick moment and share it with everyone. ### Samsung Galaxy A71 and Galaxy A51 Are Perfect for Social Influencers What’s stopping you from becoming the next big thing on a major social media platform? It could be your existing smartphone. Switch to the new and powerful Samsung Galaxy A71 or Galaxy A51 and feel the difference today. The smartphones now come with Samsung’s highly innovative and powerful flagship-grade smartphone features that can make your social media posts pop, turning you into a celebrity amongst your fans and followers. Click here to buy now and for more specified details of the latest Samsung Galaxy A51 Click here to buy now and for more specified details of the latest Samsung Galaxy A71 Affiliate links may be automatically generated – see our ethics statement for details. Source link 0 ### Technology # How to copy expressions without changing cell references in Excel Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don’t want to change the cell references. Microsoft Excel has a helpful behavior in regard to copying expressions. After entering a row or column of expressions, you can copy them, and Excel will update the cell references according. Otherwise, you’d have to enter all expressions manually and that would be tedious and open to error. However, it’s not uncommon to run up against a situation when you won’t want to update the references. There’s no easy built-in way to do this. In this article, I’ll show you two quick workarounds for copying expressions without updating the cell references. SEE: 60 Excel tips every user should master (TechRepublic) I’m using Microsoft 365 on a Window 64-bit system, but this works in older versions. You can work with your own data or download the demonstration .xls file. Both methods work in the browser. ## How copy works with expressions in Excel When you copy an expression by using the fill handle, Excel updates relative cell references. For instance, if you copy the simple expression =B3/C3 one cell to the right, Excel will adjust the column reference and enter the expression =C3/D3. If the column reference is absolute ($), Excel will change nothing, and copy =$B3/$C3. However, if you copy the expression down one row, Excel will update the row reference because it isn’t absolute: =$B4/$C4. The same behavior is in play whether you use Ctrl+C to copy the expression or move it. This behavior makes it difficult—impossible—to copy an expression when you don’t want to update the cell references unless all of those references are absolute: =$B$3/$C$3.

SEE: TechRepublic Premium editorial calendar: IT policies, checklists, toolkits, and research for download (TechRepublic Premium)

## The easy way handles a single expression in Excel

If you have only a few expressions to copy, retaining the original references, you can use the formula bar in edit mode. It’s quick, easy and gets the job done. We can illustrate this using the simple data set shown in Figure A as follows:

1. Select D3.
2. Go to the formula bar and highlight the entire expression.
3. Press Ctrl+C.
4. Press Esc.
5. Select the destination cell, F3, and press Ctrl+V.

As you can see in the data set to the right in Figure A, both expressions reference the same cells, B3 and C3. If you’re working in the browser, you’ll need to erase the ‘ character in the destination cell before it will evaluate the expression.

Figure A

This method is quick and easy but works with one or a few expressions. If you have a lot of expressions, this method will take a long time. Now, let’s look at a second method that takes a bit more work but works with lots of expressions simultaneously.

## The hard way handles many expressions in Excel

If you want to make the same change to several instances of the same content, what tool do you usually use? Replace—that’s right! That’s the tool we’re going to use to copy many expressions without changing the cell references at the same time:

• First, we’ll add a special character to the beginning of selected expressions using = as the Find string and # as the replace string Excel will treat the expressions as text
• Then, we’ll copy the expressions to the new destination.
• Finally, we’ll replace the special character we used in step 1 with the = character.

Now, let’s run through a quick example using the expressions in column D:

1. Select D3:D8.
2. Press Ctrl+h or choose Replace from the Find & Select dropdown in the Editing group (on the Home tab)
3. Enter = in the Find what control.
4. Enter # in the Replace with control (Figure B). You don’t have to use #; you can use most any other character but use one that’s not in use or you might get unexpected results. That’s why I chose #. If # is in use, come up with another character or even a string of characters, such as AAA or ZZZ.
5. Click Replace All.
6. Click OK to confirm and Close.

As you can see in Figure C, Excel treats all of the selected expressions as text.

Figure B

Figure C

Using your favorite copy and paste method, copy the contents of D3:D8 to F3:F8. Now, it’s time to replace the # character with the = character. To do so, repeat the above instructions, but in step 3, enter # and in step 4, enter =, reversing the original search strings. When you’re done, you will have matching expressions in columns D and F (Figure D). You can select both sets by creating a non-contiguous selection or you can run the Replace task twice.

Figure D