Get 'Excel 2019 All-in-One For Dummies' ($24 value) FREE for a limited time
Excel 2019 All-In-One For Dummies offers eight books in one! It is completely updated to reflect the major changes Microsoft made to Office with the 2019 release.
From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions -- including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions.
Get 'Excel Portable Genius' ($12.00 value) FREE for a limited time
Excel Portable Genius covers the key features of Microsoft Excel in a concise, fast-paced, portable format that provides the perfect quick and easy-to-follow reference for novices and experienced users alike.
Written by seasoned tech expert and trainer Lisa A. Bucki, it answers the nine key questions Excel users are most likely to face in their work and adds some hot tips and advice on this incredibly useful -- but sometimes difficult-to-learn -- program's lesser-known features.
Microsoft Office and OneNote now available for Amazon Fire tablets
Earlier today, Amazon revealed its all-new Fire HD 10 and Fire HD 10 Plus tablets. Both are more powerful than their predecessors, but priced from just $149. If you’re in the market for a low cost Android tablet, then they are definitely worth your consideration.
You can also pick up either device as part of the new Fire HD 10 Productivity Bundle which includes a 12-month Microsoft 365 Personal subscription and comes with premium Office apps, and 1TB of OneDrive cloud storage. You don’t need to buy a new tablet though as the Microsoft Office and OneNote apps are now available to install through the Amazon Appstore.
Eight out of 10 businesses struggle with data quality
A new survey carried out by Researchscape for data management company Ataccama reveals that 79 percent of executives and 75 percent of line of business users face problems with data quality.
With 78 percent of organizations relying on data more when compared to the year before the pandemic this is a major problem, as using poor quality data in analytics and AI initiatives can lead to misinformed business decisions.
Get 'Office 365 User Guide' ($23.99 value) FREE for a limited time
Microsoft Office 365 combines the popular Office suite with next-generation cloud computing capabilities. With this user guide, you'll be able to implement its software features for effective business communication and collaboration.
This book begins by providing you with a quick introduction to the user interface (UI) and the most used features of Office 365.
Create your own functions from formulae in Microsoft Excel using LAMBDA
Microsoft has launched a new feature for Excel which it says will revolutionize formulae. Called LAMBDA, the new capability is being made available to Beta users for now, and it introduces the ability to create custom functions using Excel's formula language.
The company points out that Excel formulae are the world's most widely used programming language, and now it has gained the option of defining custom, reusable functions. There's no need to learn a complex programming language, making LAMBDA accessible to all.
Get 'Learn Microsoft Office 2019' ($17.99 value) FREE for a limited time
Learn Microsoft Office 2019 provides a comprehensive introduction to the latest versions of Microsoft Word, Excel, PowerPoint, Access, and Outlook. With the help of illustrated explanations, this Microsoft Office book will take you through the updated Office 2019 applications and guide you through implementing them using practical examples.
You'll start by exploring the Word 2019 interface and creating professional Word documents using elements such as citations and cover pages, tracking changes, and performing mail merge. You'll then learn how to create impressive PowerPoint presentations and advance to performing calculations and setting up workbooks in Excel 2019, along with discovering its data analysis features.
Get 'Microsoft Excel 2019 Bible' ($35.99 value) FREE for a limited time
Whether you are just starting out or an Excel novice, the Microsoft Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers.
Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.
Master Microsoft Excel 2019 with these three free quick reference guides
Excel is a fantastic piece of software, but unlike Word, its Microsoft Office stablemate, it’s not something most people can conquer unaided.
In fact, I’ve seen many people over the years break off from doing something in Excel to add-up figures needed for their spreadsheet using Calculator, which is madness. There are plenty of courses to take, and books to read, which can help you master Excel, but we’ve got an easier route.
Sadly, Money in Excel is not the rebirth of the beloved Microsoft Money
More than a decade ago, we learned Microsoft Money was being canceled. At the time, I worked in banking and many of my clients were upset about it. Believe it or not, many people really depended on Microsoft's financial organization software. It was truly beloved. Why the company canceled it I don't know for sure, but I'd guess the Windows-maker saw the writing on the wall -- the future of money management was mobile apps and web-based account aggregation services, such as Mint.com. Financial software that you install to a PC's storage disk, such as Microsoft Money, was on borrowed time.
Fast forward to 2020, and today, Microsoft announces a new way to manage your money using a PC -- Money in Excel. Sadly, this is not the rebirth of Microsoft Money, but instead, a plugin/template for Excel that allows you to easily import your financial information. This is not really a Microsoft service, either. The Windows-maker has tapped Plaid.com to perform the actual aggregation. Once imported, you can then track your spending, including viewing graphical charts to better understand both where your money is and where it is going.
Excel vulnerability aids delivery of malware
Microsoft office files have long been used as a means of delivering malware payloads and researchers at Mimecast have discovered a rise in LimeRAT malware delivered using an Excel default password.
Excel files are designed to be easily encrypted, which helps attackers evade detection by common malware detection systems when a file is emailed.
Microsoft Excel gets powerful XLOOKUP function
When people ask me what my favorite software of all time is, my answer is always Microsoft Excel. True, I am a proponent of both Linux and LibreOffice, but the fact is, nothing compares to Microsoft Office. If I have to do some serious data analysis and need to work with spreadsheets, I want real Excel. Can I get by with LibreOffice Calc? I mean, yes, but I'd rather not.
When looking to tell stories with data, I often turn to the VLOOKUP function -- one of the most important and powerful tools found in Microsoft Excel. Believe it or not, VLOOKUP may be on its way to extinction, thanks to the release of XLOOKUP, which is basically VLOOKUP on steroids. While Office Insiders have been able to play with this new function, beginning today, it is finally available to all.
Get 'Excel 2019 For Dummies' ($29.99 value) FREE for a limited time
Excel 2019 For Dummies has been updated to reflect the major changes and features made to Excel and covers everything you need to know to perform any spreadsheet task at hand.
It includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing webpage, pivot tables, pivot charts, formulas and functions, Excel data analysis, sending worksheets via e-mail, and so much more.
Useful Excel project management and tracking templates
Managing a project is no easy feat. The immense amount of responsibility and critical decision-making skills required to see a project through can sometimes overwhelm even the most seasoned managers. Just imagine what it would be like for first-timers.
Even experts in the field need all the help they can get. And as always, it’s Excel to the rescue! Whether you’re an experienced project manager or a newbie on the lookout for tools to track and organize tasks, you’ll find Excel to be a valuable ally. To make things more convenient for you, we have compiled some of our favorite Excel templates for project management and tracking.
Millions of Microsoft Excel users vulnerable to remote DDE attack as new exploit is discovered
Security researchers from Mimecast Threat Center have discovered an Excel exploit that could leave 120 million users vulnerable to attack.
The security flaw means that it is possible to use Excel's Power Query tool to dynamically launch a remote Dynamic Data Exchange (DDE) attack on a spreadsheet and actively control the payload. The researchers also found that Power Query could be used to embed malicious code in a data source and spread malware.
Recent Headlines
Most Commented Stories
© 1998-2025 BetaNews, Inc. All Rights Reserved. Privacy Policy - Cookie Policy.