Become A Spreadsheet Guru By Mastering Google Sheets And Microsoft Excel

Administrative duties in an office, general office management, project management, event and film productions — these common careers and industries are some of the countless examples of those that depend on advanced spreadsheet software. Ask anybody, and their go-to software is either the classic Microsoft Excel or the newer and equally effective Google Sheets.

One might think that spreadsheets can only serve a handful of functions, and therefore mastering software might not seem like such a big deal. However, if you’ve had any experience, you know that there are endless formulas, functions, and capabilities that these programs offer businesses of all sizes to help them perform at optimal levels. To learn all of that and more, check out this sale on The Premium Google Sheets & Microsoft Excel Certification Bundle, now available for only $39.99 (reg. $2,200).

After subscribing, you can begin your journey to become a master of sorting, analyzing, and reporting data. The bundle features 11 courses and 18 hours of content on Google Sheets, Microsoft Excel, Power BI, and SQL. One example of a well-reviewed class is Master Reporting Automation with Google Sheets, which will help you build a completely automated reporting tool and solve any business modeling task you might ever experience. Its instructed by Mariel Aim, who is the head of business at a high-growth technology firm, and who has earned a 4.7/5 star instructor rating.

Some other examples of insightful and helpful courses included in this bundle include: Dynamic Quiz App Using Google Sheets as a Source Google Script, which helps you create web apps with JavaScript and Google Script, and Go Fast with Google Sheets, which shows you how to up your efficiency for a shorter day with 1 hour of instruction on Google’s alternative to MS Excel.

Don’t miss your chance to grab The Premium Google Sheets & Microsoft Excel Certification Bundle for just $39.99 (reg. $2,200).

DokeV’s Trailers Showed Less Than 10% of its Entire Open World

Last month, we got a long look at DokeV, the open-world action-adventure game from the studio behind Black Desert Online that’s full of monster catching, goofy minigames, and exploration of what sounds like quite a sizable open world.

Speaking to IGN, lead producer Sangyoung Kim gave a rough idea of the full scope of the world in comparison to its trailer from the PlayStation Showcase.

“Including White Whale Town, there are two towns shown in the video,” he said. “I’m not sure how to express the island’s magnitude, but you can think of it like this: the parts of town you’ve seen in the trailer are less than 10% of the actual island. The map is large enough to keep you entertained just by walking around and exploring the open world.

“We actually rode the skateboard, drifted, and boosted around the island in the game engine, but it took quite a while to do a full trip around it.”

The skateboards Kim is referring to are shown in the trailer alongside a number of other interesting traversal methods, such as jet skis, rideable alpacas, umbrellas (used like gliders), bicycles, cars, skateboards, and plenty more. And Kim added that those methods aren’t the only ways you can travel — there are plenty more that haven’t been shown yet, which players will be able to use to “explore freely.”

Plus, Kim said that the world will incorporate day and night cycles, seasons, and weather as well — though he noted that it’s still in development and that’s subject to change.

Kim also mentioned that it’s possible the game gets even bigger, though it’s not clear for now whether that means in geographical size or just in terms of things to do. Kim confirmed that Pearl Abyss will continue to add new content after the launch, noting that DokeV is ultimately “all about adventure and exploration of the open-world.”

Unfortunately, we’re still waiting for a release window for now.

“We are focusing on the development right now and I think there will be a time we can reveal more about when players can expect to play our game,” Kim said. “However, what we can promise is we will do our best to make a great game.”

Kim shared a few other details as well, such as the nature of DokeV’s multiplayer elements, and a little about the different kinds of activities players can participate in with their Dokebi beyond just battling and exploring, so there’s plenty more to unpack while we wait to learn more about Pearl Abyss’ upcoming open-world action-adventure and its cast of colorful monsters.

Rebekah Valentine is a news reporter for IGN. You can find her on Twitter @duckvalentine.

Dive Deep Into Machine Learning With Over 75 Hours Of Expert Led Training

As we push forward into the future, it seems more and more certain that artificial intelligence and machine learning are going to be massive pieces of our collective future. Continuously producing and conceiving countless breakthroughs, new technologies, and industry-changing developments — the world of AI and machine learning is rife with potential for new minds to help build and shape tomorrow. If you’d like to join the party, there’s a lot to learn.

One way to dive deep into these pivotal technologies is to take advantage of this deal on The Premium Machine Learning Artificial Intelligence Super Bundle, which is on sale for $36.99 (reg. $2,388). This nearly 80-hour collection of courses and lessons breaks down fundamental lessons on deep learning, machine learning, Python, and other development tools used to help grow these sections of the tech industry.

Upon subscribing and taking advantage of this incredible, you’ll begin with Machine Learning with Python, which is a course that teaches you the fundamentals of machine learning with Python. In this practical, hands-on course you’ll get the foundational lessons and examples on approaching data processing, linear regression, logistic regression, decision trees, and more. This course is taught by Juan E. Galvan, who is a top instructor, digital entrepreneur, and recipient of a 4.4/5 star instructor rating.

These are some of the other courses included in the attractive Premium Machine Learning Artificial Intelligence Super Bundle: The Machine Learning and Data Science Developer Certification Program, The Complete Machine Learning & Data Science with Python A-Z, and Deep Learning with Python. Each of these well-reviewed and well-curated courses will help you on your path to becoming an informed player in the growing world of AI and machine learning.

Don’t miss your chance to grab The Premium Machine Learning Artificial Intelligence Super Bundle for only $36.99 (reg. $2,388).

Sledgehammer Games Teases Call Of Duty: Vanguard Comics

Sledgehammer Games has teased a comic book for New York Comic Con based on the upcoming Call of Duty: Vanguard. Teased in a tweet, Sledgehammer Games wrote “see you at NYCC,” with an image of a comic book cover titled Call of Duty Vanguard.

The comic cover doesn’t include any other text but has an image of Lieutenant Polina Petrova surrounded by dead German soldiers. Petrova, a Russian sniper and one of the four protagonists of the Call of Duty: Vanguard campaign, was also the playable character in the campaign demo shown during Gamescom Opening Night Live 2021.

A follow-up tweet states that people who attend the Sledgehammer Games panel during New York Comic Con will receive an exclusive issue of the Call of Duty: Vanguard comic highlighting how Polina was recruited into the special forces. The panel is called “Navigating a Narrative Minefield: Writing a Call of Duty Story Across Video Games and Comics,” and based on the description, it sounds like Sledgehammer will be releasing comics for all of the protagonists in Call of Duty: Vanguard.

New York Comic Con takes place October 7-10, about a month prior to Call of Duty: Vanguard’s release, so these comics might be released as a build-up to the game’s full release. All of this comes amid an ongoing discrimination lawsuit against Activision Blizzard, alleging the company has a “frat boy” culture.

Call of Duty: Vanguard releases on November 5 on PS4, PS5, Xbox One, Xbox Series X|S, and PC.

GameSpot may get a commission from retail offers.

Upgrade Your Browsing With The World’s Fastest VPN

Today there are many disadvantages to browsing and operating online without the protections and freedoms offered by a strong VPN. From being limited to the geographical restrictions of your country in regards to visiting social media websites or streaming hot new releases to having your data mined by scammers and robocallers — the internet can be a daunting place to surf, browse, and conduct business. But, it doesn’t have to be.

Take your browsing to the next level and save big on a HotSpot Shield VPN Premium 3-Year Subscription, which is on sale now for only $89.99 (reg. $467). The world’s fastest VPN, HotSpot provides military-grade encryption and gives you access to sites and streaming content from over 115 locations around the world. Featured on CNN, TechCrunch, and The Wall Street Journal, HotSpot is a tried and true investment.

In addition to being the top VPN for speed, it’s also #1 for security. HotSpot helps keep you safe and private while you’re online by securing your connection and preventing hackers, malware, and phishing sites from tracking you online. Subscribers can also access websites and streaming content from Netflix, Hulu, Disney+ and other major streamers from all over the world with blazing-fast speeds and with total privacy

The 2-time winner of “world’s fastest VPN” at Ookla’s Speedtest, HotSpot provides subscribers with unlimited bandwidth, which helps ensure speedy performance and totally eliminates buffering. It also helps you search the web anonymously by hiding your IP address and location while also providing unrestricted access to any app or website. This all will also help you avoid throttling, which means that your internet service provider will not be able to see what websites you visit.

Step into the age of online freedom and grab yourself a HotSpot Shield VPN Premium: 3-Year Subscription for $89.99 (reg. $467) for a limited time.

In DokeV, the Dokebi Monsters Are for Far More Than Just Battling

DokeV dazzled at the most recent PlayStation Showcase, where for four colorful minutes it demonstrated a large open world full of goofy monsters, like a bear with boxing gloves and rideable alpacas. But while it seems these monsters are in some fashion capturable and able to stand by the player’s side in battle, that’s not the sole focus on DokeV.

According to lead producer Sangyoung Kim, DokeV’s monsters, called Dokebi, which are “spirit-like beings” in Korean folklore. Kim told us that actual Dokebi myths are at the heart of many monster designs we’ve already seen.

“We thought of a lot of different ideas with the Dokebi folklore at the center,” he said. “You may have seen the Anteater-like Dokebi in the video, but it’s not actually an anteater. This Dokebi represents an imaginary animal called Bulgasari that takes on the form of a bear (kind of), and it eats iron. Another Dokebi in the video is in the form of a bird wearing a traditional Korean hat; this was drawn from a dark spirit called Eoduksinii in ancient folklore.

“But not all designs take these kinds of things into consideration. There are a lot of other ones that we design freely with whatever comes to mind. Sometimes we cannot apply those to the game. So we put that into the murals in the game. I liked that this sort of inspiration helped create a very rich display of the environment.”

But while the Dokebi are certainly real creatures in the world of DokeV, Kim added that it’s not really like what we’ve come to expect from other monster capture RPGs like Pokemon or Temtem, where fights are at the center of getting the creatures to come along for the ride. In DokeV, not many people don’t know of their existence, or if they do, they don’t believe in them. The main character, he said, is one of only a few people who know of and can see them, and goes on an adventure to search for Dokebi to achieve their dreams.

So while he didn’t give many specific details, there seems to be a lot more to befriending Dokebi than just duking it out until they decide to join the party.

“Dokebi are born from people’s dreams. For example, someone dreams of becoming a boxer but is unable to pursue that dream because of their parents or some other reason. The inability to pursue their desires manifests as a dream, creating the Boxer Dokebi.

“As players progress in the game, they will get several hints about Dokebi, and eventually, befriend them after meeting special conditions using information from these hints and reading through each Dokebi’s unique backstory.

“When there are battles on the course of the adventure, players can fight with the help of Dokebi, but there are many activities where they can use the skillset of Dokebi. Players can achieve dreams and wishes with Dokebi.”

Some of those activities include exploring DokeV’s large island world, fishing, kite flying, and various other minigames, including some of the goofiness we saw in the trailer — and Pearl Abyss plans to continue to add more content post-launch. Plus, there are plans for multiplayer content, both co-op as well as PvP, even though DokeV is no longer classified as an MMORPG.

Rebekah Valentine is a news reporter for IGN. You can find her on Twitter @duckvalentine.

Save iPhone & iPad Space With This Smart Cleaner Subscription

We all have an ever-growing mountain of data taking up space on our phones and tablets. Every day, you accumulate new downloads, messages, videos, and more — and a lot of it, you are not saving on purpose. That’s why, like with any space that accumulates clutter, you need to clean out your iPhone and iPad on a regular basis.

Free up disk space and enjoy your iPhone and iPad’s improved performance with the Smart Cleaner for iOS: Lifetime Subscription, which is on sale for $39.99 (reg. $149). Rated 4.5/5 stars on the App Store, this fast, secure, and easy-to-use cleaning app will change the way you interact and maintain your most essential digital products. Activate it, and begin the process of getting rid of unnecessary pictures, outdated files from old jobs, and other clunky pieces of data that are slowing your device down.

Over 30 million people have downloaded Smart Cleaner because it effectively searches and deletes, screenshots, similar pictures, live photos, burst photos, and videos all in a few taps. A simple and intuitive program, Smart Cleaner cleans your device and also helps organize your contacts, save battery, and keep your files private.

For organizing contacts, the app merges, backs up, and removes identical contacts with speed and precision. It also includes an entire battery section filled with tips on how to make your gadget. This section also comes equipped with cool features like different charging animations, handy widgets for your home screen, and an icon that lets you check your battery level and charging status at a quick glance.

Available now for 73% off the list price, the Smart Cleaner for iOS: Lifetime Subscription can keep you organized and performing well for as long as you have a mobile device. Take advantage and subscribe now for only $39.99 (reg. $149).

Become An IT Pro With This CompTIA Prep Bundle

Everything we do today seems to be built on technology, and when you get down to it — there still seem to be endless IT needs for professionals around the world. Those looking to cut down on costs, and those looking to branch out and become qualified to work in a field that grows every day could benefit from learning the basics of IT, cloud security, networks, and more.

One excellent place to start is The 2021 Complete CompTIA Certification Prep Super Bundle. Valued at $4,400, it’s on sale now for just $69. This bundle features 16 courses and nearly 1,600 lessons that are designed to prepare you for your CompTIA certification. Courses are lead by iCollege, which is a leading organization in Silicon Valley and other tech hubs, where reps train and equip employees to be the best they can be.

The 2021 Complete CompTIA Certification Prep Super Bundle is rated 5/5 stars by verified purchasers. Among the wide variety of courses, there are beginner-level insights in CompTIA IT Fundamentals+, which is designed to help you get to grips with hardware basics, troubleshooting, software installation, security, and networking. When going through the bundle, you’ll also learn a bunch of essential lessons in the CompTIA Security+ course, which is considered the benchmark for best IT security practices. This course covers core cybersecurity knowledge and skills that will help you pursue an IT security career.

Whether you use your love of technology for gaming, web design, or commerce — you need certain IT skills to grow. If you’re on the hunt for a good career and not sure where to start, the world of IT has a lot of variety and will continue to be relevant for a long time to come.

No matter your inspiration, do not sleep on this deal for The 2021 Complete CompTIA Certification Prep Super Bundle, which is on sale for $69 (reg. $4,400).

Battlefield 2042 Delayed Until November

EA has announced that Battlefield 2042 will be delayed until November 19, 2021, pushing the release date by almost a month after its original October 22 release date.

In a press release, DICE GM Oskar Gabrielson cites ongoing complications with the COVID-19 pandemic. “Given the scale and scope of the game, we had hoped our teams would be back in our studios together as we move towards launch. With the ongoing conditions not allowing that to happen safely, and with all the hard work the teams are doing from home, we feel it is important to take the extra time to deliver on the vision of Battlefield 2042 for our players.”

Battlefield 2042 is EA and DICE’s first Battlefield game since 2018’s Battlefield 5, and it is the latest game to be hit by a delay in 2021.

Unlike some other major releases originally planned for 2021, Battlefield 2042 will still launch this year and won’t impact EA’s financial forecast for the fiscal year 2022.

EA also says an update on the Open Beta for Battlefield 2042 will be announced later this month.

Battlefield 2042 will be set in the near future and will include hallmarks of the series such as large-scale battles and huge open maps. In addition, Battlefield 2042 is set during an environmental disaster so players will contend with natural disasters like tornados appearing on the map as well.

A new addition to Battlefield 2042 is a mode called Portal which will let players create custom games using assets from Battlefield 2042, Battlefield 1942, Battlefield Bad Company 2, and Battlefield 3.

Check out IGN’s Battlefield 2042 preview for our take on the next large-scale military shooter.

Matt T.M. Kim is IGN’s News Editor. You can reach him @lawoftd.

DokeV Pivoted From MMORPG to Open-World Action-Adventure, But It Will Still Have Multiplayer

When DokeV got its latest new trailer at the recent PlayStation Showcase, some people (including us!) were initially confused. The game had originally been marketed as an MMORPG, but now all its messaging called it an “open-world action-adventure.” No massive multiplayer online elements in sight.

What happened?

According to Pearl Abyss director of animation and motion capture and DokeV lead producer Sangyoung Kim, it was a simple matter of vision. At one point in its development, an MMORPG like Pearl Abyss’ previous title Black Desert Online made the most sense. Now, it doesn’t.

“We’ve had a lot of discussions about the game’s direction while working on DokeV and as the result, we concluded that making it an open-world action-adventure game allows us to best express our vision for the game,” he said. “Now we are going in the direction of enjoying the diverse gameplay in the vast open world.”

All that said, though, that doesn’t mean the multiplayer components are gone from DokeV. The monster-filled adventure will include both a single-player experience in its main storyline, Kim told IGN, as well as “collaborative multiplayer elements to work on with other players,” such as fighting boss monsters together as a group.

“Of course, there will be a PvP element in the game,” he added. “For those competitive elements, we are developing it with the idea of friendly competition that encourages good sportsmanship. We will come back with more information on this in the future.”

We learned several other tidbits from Kim, including the immense size of its open world, and a little about the different kinds of activities players can participate in with their Dokebi beyond just battling and exploring.

All in all, DokeV is shaping up to be a colorful and exciting undertaking, which explains why we are still, unfortunately, still left hanging on a release window. But given the apparent size and scope of the game we saw last month, it’ll hopefully be worth the wait.

Rebekah Valentine is a news reporter for IGN. You can find her on Twitter @duckvalentine.