Risk Or Revolution: Will AI Replace Lawyers?
AI legal robots
getty
As artificial intelligence reshapes many industries, the legal field faces its own crossroads. Over the past few years, a growing number of legal professionals have embraced AI tools to boost efficiency and reduce costs. According to recent figures, nearly 73% of legal experts now plan to incorporate AI into their daily operations. 65% of law firms agree that "effective use of generative AI will separate the successful and unsuccessful law firms in the next five years."
Investors have shown strong support for AI-powered legal startups, with funding reaching new record highs in 2024 with total capital investment of $477 million. The appeal for VCs is the potential that 44% of legal work could potentially be automated by emerging AI tools. Startups like Harvey, raised a $100 million Series C round at a $1.5 billion valuation.
We explore the current state of legal automation with Ben Su, Co-founder and Head of Growth of Capita, the world's first AI lawyer, and discuss how this shift towards AI could reshape the delivery of legal services. Carey Lening, a legal-tech consultant and 'recovering' attorney who focuses on privacy and data protection and Jide Afolabi, a probate lawyer, a graduate of Osgoode Law School with over 20 years of experience weigh in on the promises and pitfalls of automation in the legal sector. What are the challenges and criticism facing this change? What are its effects on legal education? What will AI might mean for the future of work?
AI has entered the legal sector with some noticeable force. The billion-dollar valuations experienced by companies like Harvey has created an investment frenzy that saw 58 funded deals in 2024. AI automation to speed up contract analysis, document summarization, and case research means a shift away from the slow, traditional methods that have defined the legal industry for decades, saving 4 hours per week and the opportunity to increase annual billable time per lawyer by $100,000.
Lening, who has 20 years of experience in technology and data protection, disputes the slow pace of technological adoption in the legal sector, 'Back in 2001, when I was working at a law firm, we were already using WordPerfect—not just for basic text processing, but specifically because it supported macros and structured templates. These tools allowed us to automate repetitive tasks and standardize documents, even then. In reality, automation has been part of the legal field for quite some time.'
What has changed is not the existence of automation in the legal field, but rather the sophistication of automation tools now available, as Lening adds, 'The industry has evolved far beyond basic macros and Excel spreadsheets. Today's technology offers entirely new opportunities to automate legal tasks in ways that were previously impossible.'
Afolabi, who holds a master's from the London School of Economics, describes the evolution of legal processes over the past five years, highlighting the shift from paper-based systems to automated ones. He explains that the initial client interaction, where they tell a story and paint a picture remains crucial. However, the method of capturing and analyzing this information has changed significantly.
"Five years ago, that would have been done via paper. You're taking notes," Afolabi states, "now, there's automation for that." He emphasizes that while the core process of asking questions remains, it's now "the machine asking the questions." Automation extends to the initial risk analysis, where the system can contextualize the kind of issues and how to best proceed.
Afolabi stresses that this automation doesn't replace the lawyer entirely: "There's still a lawyer there with the clients, of course." Instead, it enhances the process, making the initial intake and risk analysis more efficient. He describes the document production process as "incrementally automating," but emphasizes a balanced approach: "It's a combination and I'm not entirely leaving it to the machine to do it. But I am cueing to see what the machine can produce for me."
Su, of Capita, challenges this view arguing the sector is entrenched in inefficiencies, "The legal industry's obsession with making lawyers more profitable misses the point. Optimizing broken workflows isn't innovation—it's entrenchment. We need systems that eliminate inefficiencies, not perpetuate them." He maintains that industries like law are stuck in outdated systems designed with human-limitation constraints where inefficiencies aren't just tolerated––they're baked into the business mod, and no one is challenging those existing models.'
Lening asserts there are progressive strides she and her colleagues have made to address AI's potential in the field such as Leonard Park and Dazza Greenwood's use of LLMs for contract analysis, and Michael Bommerito's Kelvin, specialized model trained to handle various legal and financial documents, including SEC filings. She also shares her own experiments:
"I wrote a Python script with ChatGPT to summarize cases. It works—but it took quite a bit of iteration–both of the code itself and the prompts–to get there. The key is knowing how to ask the right questions... 'I'm dubious about statistics like 'AI reduces contract error rates by 90%.' Lawyers need to understand these tools aren't magical oracles. They require precise prompting and context. If you ask an AI to 'find all bad clauses' without defining what 'bad' means, it's useless."
Su went to law school but never planned on settling into a conventional legal career. Instead, he aimed to understand the rules governing business transactions and apply that knowledge to innovate within the legal system. Eventually, Su began practicing law at a boutique firm in Toronto, where he reconnected with a former classmate who shared his vision to use technology to overhaul outdated legal practices. Together, they founded Capita, a company dedicated to automating the legal processes that often slow down startup growth. Their first product streamlined the capital formation process, cutting down on the need for manual legal work and processing transactions at an impressive rate. Within just a few weeks of launch, the company was handling transactions worth thousands of dollars each day.
The promise of AI in legal services goes beyond making lawyers work more productively. Su envisions a system where AI serves as a constant, always-on companion to clients, offering advice and identifying issues before they escalate. "Clients don't care about what tool you're using at the end of the day," Su states, "they care about the outcome and how much you're charging for that outcome." This questions the traditional hourly billing system that has made legal services highly profitable—a consideration for smaller businesses and startup organizations, who often find themselves priced out of traditional legal services.
In Su's model, technology handles the heavy lifting of data processing while human professionals' step in only when their judgment is truly needed. Capita is already making strides. Its products ask detailed questions that mimic the initial discovery process at a law firm. The answers allow the AI to generate tailored legal documents and strategies, speeding up the process while ensuring advice fits each client's needs.
Su believes that automating parts of the legal process can encourage transparent and affordable pricing. Instead of unpredictable hourly bills, clients pay a fixed monthly fee for certain services.
Afolabi agrees that the traditional hourly billing model is outdated but acknowledges that many lawyers prefer this model because "it maximizes value for them." He explains that instead of reducing hours or changing the billing model, some firms might maintain their revenue by inflating billable rates: "What they might do instead of reducing the hours or changing the model entirely is to increase the hourly fee to still get the same amount of billing out of work that may be used to take 100 hours and not take 40 hours because the machine does the rest of it."
What will ultimately drive costs down, he admits, is competition stating, "Like in any other industry, if a few firms in a specialized sector reduce their costs, it will pressure others to follow suit. The first firm to blink will drive the cost down." However, Afolabi notes that the specialized nature of legal services can make price competition challenging. He states, "If you have only seven firms competing for a specialized service, this, in itself, makes it easier for firms to maintain current pricing structures.'
Lening acknowledges Su's advocation for disrupting the current model and points out potential changes in the pricing dynamics of legal services. She suggests that clients may begin to challenge high fees, especially if they suspect that AI tools are being used to perform work traditionally done by lawyers: "There may be some interesting dynamics at play in terms of how much big law firms can charge to their clients.'
Despite its potential benefits, the push toward legal automation has not been without its critics. Many traditional lawyers argue that legal work is too subtle for machines to handle. The worry is that AI systems, which largely rely on predictive text and pattern recognition, may not fully capture the complexities involved in legal agreements.
About one in four legal practitioners view AI as a threat, expressing concerns that reliance on technology could diminish the human judgment needed for complex legal matters. While AI systems can process data and generate drafts at speeds far exceeding manual work, the worry is that an overreliance on automated tools might lead to errors that only a seasoned lawyer can catch. Stats show that AI tools hallucinate in at least 1 out of 6 legal queries. This tension between speed and careful judgment continues to spark debate among those who work in the legal field.
Lening underscores these risks, particularly for non-lawyers: "Consumer-facing legal AI scares me. People lack the 'smell test' to catch nonsense. Look at Joshua Browder's DoNotPay—the FTC fined them for overpromising. Clients don't know what they don't know, and AI can't fill that gap yet." Lening refers to DoNotPay, "the world's first AI-robot lawyer,' founded by Joshua Browder in 2015. Browder's application used chatbots to guide users through legal processes to fight parking tickets, cancel subscriptions, among others with the aim to make legal services more affordable. In September 2024, DoNotPay received a fine from the Federal Trade Commission for falsely advertising their AI services capabilities.
Su is aware of these challenges. He notes that many founders have used generic AI-generated templates with disastrous results: "If you use ChatGPT for specialized legal work, you're guaranteeing a negative outcome. We've fixed countless errors—like founders shutting down startups due to flawed AI-generated equity splits."
Lening critiques the legal industry's reluctance to educate itself: "Many lawyers think AI is a magic box. They'll dump a contract into ChatGPT and call it a day. That's where disasters happen. We need better education on both the capabilities and limitations."
One of the more challenging issues raised by the shift toward AI in legal services is the role of legal education. Su shares his own experience as a law student who, despite strong academic performance, struggled to secure a position after graduation. He criticizes the traditional approach, where the burden of unpaid labor falls on those just starting their careers. 'I think the current system is extremely unfair,' Su remarks, noting that law students are often exploited to provide free labor for law firms.
He challenges the apprenticeship model: " By introducing AI into legal services, there is the potential to reduce the workload on young lawyers and offer more balanced opportunities. With AI handling routine tasks, junior legal staff might have more time to engage in meaningful work that adds real value for clients "
Lening reflects on the evolution of legal education and the impact of technology and acknowledges that while the traditional law school experience, including the Socratic method, can be challenging, it serves a valuable purpose. Lening explains, "It does force you in a very consistent way to think differently about problems, to break things down into discrete things. You learn how to analogize better. You learn how to craft your thoughts in a way that becomes extremely useful and becomes a valuable skill."
However, she advises prospective law students to be more strategic about their decision to pursue a legal education. She states, "I would tell people wanting to go into law school to be far more strategic about why." She emphasizes that the days of entering law school simply because one can't figure out what else to do are over, noting, "It has changed from being a thing that you can do–get out of–and still be fine to something that you really do need to evaluate a little bit more because you happen to test well and you like to argue."
Lening also highlights the changing landscape of the legal profession due to technological advancements. She suggests that these changes will lead to new applications of law degrees, stating, "What these tools and what technology and what the law changes in general are going to continue to manifest is that people are going to be using their law degrees in different ways, in new ways."
Lening calls for updated curricula, emphasizing "Law schools teach analytical thinking, but graduates need technical literacy too. Future lawyers must learn to audit AI outputs, design prompts, and collaborate with engineers." She suggests that while significant changes are happening, many of these shifts have already been underway for some time, and observes, "I think that the existing model that we all, conceptually, have in our minds about working in a big shoe law firm and becoming partner has already started to shift." The traditional career trajectory in prestigious law firms is no longer as straightforward or guaranteed as it once was. However, she acknowledges that there will always be a market for top-tier law firms, noting, "... because people like paying for exclusivity and for what they think is the best."
The debate over legal automation extends beyond the legal field. Similar questions are being asked in industries ranging from manufacturing to healthcare. While new technologies often spark fears of job loss, history shows they also create opportunities—online platforms, for example, have birthed entirely new professions.
Lening compares AI's integration to past technological revolutions: "We're in a 'horse-to-car' transition. Laws and norms will adapt, just as they did for automobiles. AI won't make us lazier—it'll create new problems to solve. That's how progress works."
She remains optimistic stating AI's role and concurs with Su, who emphasized human oversight can mitigate risks, 'AI isn't about eliminating humans—it's about enhancing efficiency.' Lening added, 'the fourth industrial revolution isn't about job loss. It's about redirecting human talent. Let AI handle document review; let lawyers tackle creative disputes or regulatory challenges. That's the future."
While concerns about AI's limitations persist, the consensus is clear: AI-driven services like Capita can make legal services more affordable and accessible without replacing human oversight.
Lening's perspective challenges the future role of lawyers: "Automation isn't about replacing judgment. It's about freeing lawyers to focus on what humans do best: empathy, ethics, and innovation. The future isn't AI versus lawyers—it's lawyers with AI."
Try Our AI Features
Explore what Daily8 AI can do for you:
Comments
No comments yet...
Related Articles
Tom's Guide
5 hours ago
- Tom's Guide
These are the 10 prompts in DeepSeek to help you create a budget
Creating a home budget doesn't have to always involve an Excel spreadsheet and coffee to keep you awake during the process. Instead, AI bots can guide you through a budget and make it much easier to track your income and expenses. I should know — I avoid the topic as much as possible. For years, I calculated most of my expenses in my head and hoped it all worked out. Roughly about 10 years ago, I started relying on apps like Mint to help me and even the tools provided by my bank. Recently, I tried using DeepSeek to guide me through the process. It's amazing how these 10 prompts can help you figure out where all of the money is going. Here are the best ones to try. Before diving into the details of a home budget, you can start by asking DeepSeek which home budget works best for you. Fortunately, this prompt provides a wealth of information, no pun intended. DeepSeek presents several options for home budgets including the popular Zero-Based Budget' that helps you track income, expenses and savings down to the last dollar. In that home budget, you put money into savings first, then allocate money to other things. This prompt really narrows things down, because it means you'll need to budget more aggressively. DeepSeek recommends several budgets but two of them are worth calling out. The first one is a percentage system called an Aggressive Savings plan. 50% goes to needs, 20% to savings, 10% to debt, and 20% to wants. DeepSeek also recommended the zero-based budget, which prioritizes savings even more — but maybe a little too much for me. I decided to try the Aggressive Savings plan because it looked practical and achievable to me. I was impressed with all of the detail DeepSeek provides here, listing a full table of expenditures with suggestions for how much to set aside for groceries, gas, and credit card debt. Using this budget means I could save $192 per week — reaching my $10,000 per year goal. So far the prompts and suggestions have all been generic — they could apply to anyone. I decided to make it more personal. I asked about customizing for my income level and DeepSeek then guided me through the entire budget process. The AI asked for my annual income and expenses including car payments and student loans. DeepSeek also asked where I sometimes slip up — say, by overpaying for Uber Eats. I inputted all of this info. (Truth be told — I made up some details. I am not yet comfortable adding actual data to an AI bot yet.) I noticed my final home budget required saving about $833 per month, which seemed a little high. I asked DeepSeek to adjust my budget to save a little less, and suddenly it all seemed more practical. I was allocating more money to eating out and gas/groceries without having to sacrifice so many things that I'd end up failing. I was happy with the results so far. I knew at this point that a home budget would not be useful if it was just contained within a chatbot. I asked DeepSeek to generate an Excel file and was a little surprised when it generated a CSV file instead. (I'm sure there are copyright issues with providing an Excel file.) No matter — I imported the file into Google Sheets using the comma-separated values. A home budget is not just about the numbers and creating a spreadsheet. What works the best is when you have an action plan each month that helps you adhere to the budget. I was surprised, though, when DeepSeek offered some unusual suggestions to help. The bot said I could consider doing a side gig to help generate more income, which seemed smart. Another surprise is that the bot suggested a temporary pause on some charitable donations. Mint is a popular home finance app and I've used it many times. Ironically, I had never actually important a spreadsheet before and DeepSeek noted that is not even possible. Instead, the chatbot suggested inputting all of the info manually, which seemed clunky. And guess what? The bot actually used that word. DeepSeek said 'If this feels clunky…' to try some competing apps that do support imports. DeepSeek also offered to show screenshots of Mint to help me see where to input the budget info. This process took several minutes, though. And, they were not real screenshots — instead, DeepSeek created text-based guidelines. I asked DeepSeek for more guidance, and the bot covered quite a few practical tips for managing my money — one involved using a cash-based budget where you put money into envelopes for different spending categories. Another tip was to wait 24 hours before spending X amount of money (say $5) if it is an impulse buy. Lastly, I asked DeepSeek to save my home budget and all of the tips. It turns out, DeepSeek can't save anything as a text file, so the bot suggested I copy all of the text and paste it into Google Docs or another word processor. That worked just fine for me! Get instant access to breaking news, the hottest reviews, great deals and helpful tips.
Yahoo
2 days ago
- Yahoo
Microsoft 365
PCMag editors select and review products independently. If you buy through affiliate links, we may earn commissions, which help support our testing. Chances are that you already use and appreciate the power of Microsoft 365. The behemoth of personal expertly facilitates collaborative work, packs tons of class-leading features, and benefits from regular (and substantial) updates. We especially appreciate the flexibility to work across desktop, mobile, and web versions of its apps. The complexity of the suite's feature set can be overwhelming, and some Copilot AI features are more annoying than useful, but Microsoft 365 still easily earns our Editors' Choice award because of its reliable performance and unbeatable functionality across apps. If you prefer not to pay for continuous updates, however, you should check out the standalone version of the suite, Office 2024, another Editors' Choice winner. Microsoft 365 is the latest name for the suite of apps that includes Word, Excel, PowerPoint, Outlook, and more. Microsoft formerly called it Microsoft Office and then Office 365. The company also now maintains an app for desktop, mobile, and web platforms called Microsoft 365 Copilot (formerly Microsoft 365). On all platforms, it provides links to the appropriate versions of the suite apps and lets you ask the Copilot AI assistant questions. Microsoft 365 maintains native apps for every major platform except Linux. Subscription-locked desktop apps are available for macOS and Windows, and you can download free mobile apps for Android, iOS, and iPadOS. Free, web-based versions of the apps allow you to use them practically anywhere, including on Linux. Simply signing up for a Microsoft account gets you 5GB of free storage and access to web and mobile versions of Excel, PowerPoint, and Word. A Microsoft 365 Basic subscription ($19.99 per year) gets you 100GB of OneDrive storage and an ad-free version of Outlook on the web. However, to unlock Microsoft 365's best capabilities, you need to pay more. The Microsoft 365 Personal tier ($99.99 per year) allows a single person to use desktop versions of Excel, PowerPoint, Outlook (you get an email address as part of the subscription), OneNote, and Word on up to five supported devices. This plan also includes 1TB of OneDrive storage, Copilot AI features across the apps, the Microsoft Defender antivirus app, more AI credits for the AI-based Designer app, and premium Clipchamp and features. The more economical Microsoft 365 Family plan ($129.99 for up to six people) unlocks those same features for each person. Both of those rates increased by $30 when Microsoft added Copilot features, much to the dismay of many AI-averse subscribers. The good news is that you can optionally downgrade to the cheaper Microsoft 365 Standard tier ($69.99 per year for individuals, $99.99 for families) if you are an existing subscriber and don't want Copilot features. Microsoft 365 has a business version (starting at $4.75 per user per month, billed annually) and the aforementioned standalone version (starting at $149.99), while college and education students can get the Personal version with Copilot for half off ($59.88 per year). It is a fast-evolving suite that adds new features and interface tweaks every few weeks, so I strongly recommend one of the subscription options. The most popular competitors are the Google Docs Editors (a Gen Z favorite). Available as cloud-connected mobile and web apps, they make collaboration especially easy and bundle more storage (15GB) than Microsoft does at the free level. Apple users might still prefer the suite of Keynotes, Numbers, and Pages. They work on all Apple devices, as well as on the web (with real-time collaboration). Just know that you need to export documents in universal formats to share them broadly. The open-source LibreOffice might appeal for legal reasons, though its desktop-only apps aren't as capable as Microsoft 365's. Other more affordable work-alike desktop apps include ($129.95 for a perpetual license or starting at $29.90 per year) and Kingsoft WPS Office (free for a limited version or starting at $35.99 per year). Only one major office suite doesn't try to imitate Microsoft: Corel WordPerfect (starting at $99.99 for a perpetual license). It uniquely uses a reveal-codes screen that lets you see and completely control and clean up your document's exact formatting. If you purely care about writing text, check out our roundup of the (including some distraction-free options). Below, I detail my experiences with each of the core Microsoft 365 apps: Word, Excel, PowerPoint, and Outlook. You likely already know these apps inside out, so I concentrate on new features and some (admittedly particular) issues. To not leave you in suspense, these are all still the preeminent apps of their type. Yes, annoyances and occasional instability are present, but the apps' benefits far outweigh their downsides. Word is a unique blend of effortless power and occasional frustrations that you have probably learned to live with because it's the only practical choice. It might just be among the most feature-rich apps ever; aside from complex controls over every aspect of document formatting, it offers drawing tools and even integrates Microsoft's translation and research services. Almost all the features in the Windows version of Word are available for the macOS version, too, except the myriad keyboard shortcuts that ease navigation. Word continues to gradually shed its old-style dialog boxes in favor of modern, multi-pane interfaces. For example, you can now use a spacious Navigation pane to search for text instead of the cramped old Find dialog. An Editor pane (formerly the Proofing pane) also replaces the old spell-check dialog, too. If you use a mouse, Word's multiple-pane interface works beautifully. But if you don't want to move your fingers from the keyboard, getting to these panes quickly is a challenge. Pressing the F6 key lets you jump to one of Word's panes from the editing screen or ribbon, but these panes still don't respond to many traditional keyboard shortcuts, such as Alt + Down to open a drop-down menu. Another recent controversial change is the removal of Track Changes balloons in the left margin. If all you need to do is type a report or a letter, then Word's ribbon interface gives you easy access to every feature you need. But if you want to customize formatting or use advanced features like fields that contain variables—which you can change throughout a document with a single command—you might need to customize your keyboard or ribbon with components Word doesn't usually display. Beginners can get started by choosing among hundreds of elegant, downloadable template designs directly from the app's New menu. If you want to concentrate on the text you're writing, a distraction-free Focus mode is available. Just click the Focus button on the toolbar (you might need to enable it from the right-click toolbar) to launch a full-screen editing mode with just a scrollbar and no visible menus. At the same time, advanced users can configure the interface to show a cornucopia of detail. Right-click on the status bar at the foot of Word's window to get an idea of the dozens of things it can tell you about your document. If you haven't spent half a lifetime learning Word, some behaviors might frustrate you. For example, Word adds a horizontal line at the foot of a paragraph if you type a few too many dashes by default, and then doesn't let you easily delete it (you need to use the border drop-down menu in the Paragraph section of the Home tab to remove it). And if you want to change the length of the separator line between text and footnotes, you might not easily guess that you can do so only by switching from the default Page view into Draft view and accessing the drop-down menu in the lower pane of that window. You can stop Word from adding border lines—and other things it does automatically, such as creating numbered lists—by customizing its auto-format features. However, you need to navigate through multiple dialog boxes to find all the options, some of which are inconvenient to manage. For example, you can tell Word not to flag grammar issues as you type, but you can't turn off the distracting grammar-checking in the Editor pane without turning off dozens of individual options, one by one. To help you find features and support topics, Word (and other Microsoft 365 apps) includes a prominent search field in its title bar. For instance, if you can't remember that you need to open the Ribbon menu's Insert tab to edit headers and footers, simply type Insert Header, and Word will bring up the relevant menu. However, this dialog won't tell you where to look on the ribbon for the feature in question or always bring up the correct menu. For example, if you search for the Master Document feature, which lets you build a large document from separately editable chapters, Word takes you to a completely different feature for displaying multiple pages in a single window. The search tool finds the Master Document feature only if you find it first; changing the View setting from Print Layout to Outline causes the Ribbon to show the Master Document menu. Word also sometimes makes formatting errors. For example, while I was working on this review, I also worked on another document containing many book titles. Word suddenly decided to italicize everything in two pages in the middle of the document, not just the book titles. Restoring the correct formatting took more than an hour. The Master Document feature is notoriously unstable, sometimes losing track of which parts of the document belong in the Master Document itself. Unless you're a Word wizard, you might not know that Word stores the formatting of the current paragraph inside the paragraph mark at the end of it—you can't even see this mark until you click the Show/Hide button (which looks like a paragraph mark) on the Home tab. If you delete the invisible paragraph mark between two paragraphs (for example, by backspacing across a paragraph break), the format of one paragraph might change to match the format of the other. I've wasted many hours restoring formatting that Word changed without warning. Word's layout options are sometimes a pain. If you want to change page margins in the middle of a document, you have to create a new section. Doing so, however, disrupts any automatic footnote and endnote numbering. Almost every other modern word processor imitates Word's nonsensical layout rules, except for WordPerfect, which lets you change margins anywhere in a document without affecting anything else. If you or your organization still has Word files from 20 or more years ago, Word now refuses to open them. Why? Because Word's old file formats supported macros that run automatically and can potentially damage your system. Other word processors, such as LibreOffice and WordPerfect, can safely open and import these old documents because they can't run these macros at all. You can persuade Word to open some but not all old documents by changing settings in the Trust Center on the Options menu. Word has the most full-featured programming language support of any word processor, the same Visual Basic for Applications (VBA) as in Excel and PowerPoint. It's not an easy language to grasp, but anyone can learn the basics by recording a macro and then studying the resulting code in Word's built-in Visual Basic editor. LibreOffice and Corel WordPerfect also have powerful macro languages, but Word's is so universal that you can quickly find help online. Mac users can alternatively use the easy-to-learn AppleScript scripting language to automate Word. Excel continues to outclass every other spreadsheet app in terms of speed and power, with the latest version further widening the gap. Google Sheets is almost on par in terms of processing speed, but it lacks a desktop app and isn't as capable. LibreOffice Calc is the best desktop-based rival to Excel, but it's slower and far less feature-rich. Apple's Numbers stands out for its ability to create graphics-rich, easy-to-manage worksheets, but it isn't as powerful or suitable for advanced corporate or financial use. Unlike Word, Excel is low on frustrations and always easy to navigate. It's even beginning to pick up some of the graphics-based features of Apple's Numbers. Excel does have automated formatting and layout features like Word, but these work reliably with the structured data that goes into an Excel worksheet (as opposed to the free-form prose you type into Word). I especially like Excel's Power Query feature, which saves hours of effort by converting raw data from web-based tables or comma-separated data files into a lucidly formatted Excel worksheet, complete with sorting buttons at the top of each column. The same feature exists in both the Windows and macOS versions, but looks better in the latter. Unfortunately, the macOS edition tends to get new features long after the Windows and web-based versions. For example, the Check Performance feature that can clear unused metadata and other unnecessary details isn't in the Mac version yet. But at least it now has the nifty Flash Fill feature that makes it easy to, for example, create a column of full names from separate columns of first names and last names. Among the hottest new features in Excel is a spacious Python Editor pane for modifying any Python code that you enter into cells in your worksheet. You can test your code here before entering it into your worksheet, and even see how it executes, cell by cell, so you can easily debug any problems. If you're ready to try out Python in Excel, you can find it in the Formula tab of the Ribbon or simply press Ctrl+Shift+Alt+F2. Another impressive feature is the ingenious XLOOKUP function that makes it simple to display a value from a large array of data. For example, you might have a column that lists stock symbols and another that lists their current prices. You can then type in a stock symbol somewhere else in your worksheet and assign another cell to display the price of said stock. (You use the XLOOKUP formula in the second cell.) A dynamic array feature lets you create a formula in the first cell of a table that returns data from all the rows in the table, no matter how many rows it contains. That way, you don't have to know in advance how many rows your table will contain. This is an extension of the aforementioned Flash Fill feature. Finally, the app allows you to use a picture as the content of a cell (rather than having it float over the spreadsheet) so that it moves with its row or column of data. You can import pictures from a web address, and the cell's contents will update if the picture on the web changes. Excel now works as well on the web as Google Sheets. It lets you share just part of a workbook, such as a range, table, or chart. Collaborators can edit the data in these specific areas without the ability to share or modify anything else. This is an extension of an earlier feature that let you create a custom sheet view for specific people that shows only what you wanted them to see. Additionally, if you use Microsoft Forms to gather data, Excel can automatically update a live worksheet whenever someone submits a form. Traditional presentations never go out of style, no matter how many people dislike them. PowerPoint keeps adding innovations that make presentations easier to create and watch. A new Presenter Coach feature tells you to summarize your slides instead of simply reading them and alerts you to filler words like 'um.' A Record tab in the ribbon creates a video of you narrating your presentation and lets you read your text in a teleprompter tab at the top of the screen, so you don't have to keep looking down to read what you want to say. The Review tab includes a Check Accessibility function that allows you to test whether your slides have all the information that users who rely on screen-reading software need. PowerPoint's ease of use extends to its ability to add a live camera feed to all slides without inserting the feed into each slide individually. Earlier, it added a feature that records your freehand inking for playback later. If you're creating traditional presentations in Windows, PowerPoint is your only serious choice. Keynote is similarly superb for creating elegant slide decks from an Apple device. But if you're creating something for the web, consider an innovative alternative like , which creates non-linear presentations in which you zoom in and out of a large canvas. The complicated Outlook you know and probably don't love is finally destined for the recycle bin. Microsoft's new Outlook app (see the image below), available as part of Microsoft 365 or from the Microsoft Store for free, also replaces the old default Mail and Calendar apps on Windows. The revised email app does much of what the outgoing one did, but has a refreshingly simpler interface (though you can still switch back to the previous version as of publishing). Many Outlook alternatives are available. Thunderbird for Windows and Mac is free and has the most powerful search features of any mail client. Apple Mail works especially seamlessly within Apple's ecosystem. And of course, Gmail is available on the web and mobile. The latter version is uniquely easy to use and flexible, though the Outlook mobile app is also compact, elegant, and fast. The latest version of Outlook adds S/MIME encryption and lets you manage .PST files from the older app. If you have a Microsoft 365 subscription, Outlook now checks your spelling and grammar in an Editor pane like in Word. However, the translation features from the older Windows version of Outlook aren't available yet. A sidebar in the new Outlook app with Word, Excel, PowerPoint, and OneDrive icons confusingly opens the web versions of the app, which might not even have the files you're looking for. Issues like this mean it still needs more fine-tuning before it can fully replace its predecessor, but it does continue to improve rapidly. The biggest new changes in the Microsoft 365 apps are the Copilot AI features. I especially like Copilot's presence in Excel, where it suggests useful ways of graphing data that would otherwise require some expert programming. Its capabilities in Outlook, PowerPoint, and Word are less impressive, however, and I turned them off after testing. Like rival AI systems from Apple, Google, OpenAI, and others, Copilot is better at organizing existing data than generating new content. Ask it to create a year-to-year percentage change in Excel, and it gets the job done in a few seconds. Ask it to write a Word document about anything that involves human beings and their life or work, and it produces wordy, overenthusiastic prose. At the time of testing, it often 'hallucinated,' meaning it invented facts that vaguely resembled the reality I asked about. If you're tempted to use it, make sure to check everything it says. I don't advise using Copilot to write an email for you in Outlook. It tends to open a message with 'I hope this message finds you well,' a phrase that tends to signal that you used AI to write the message. Every message I asked it to write used too many words to say what a real human being could have said in just a few. Unless you really want Copilot, you should go to the Options menu in Microsoft 365 apps and turn it off. If you don't, Word will open new documents with a prompt to use Copilot, and the Copilot icon will appear in the margin every time you start a new paragraph. If you don't intend to use these features at all and are eligible, you should downgrade to the aforementioned, cheaper, and Copilot-free Microsoft 365 Standard subscription.
Yahoo
2 days ago
- Yahoo
JOB ALERT: Goodwill Industries of East Texas needs a WAT Trainer
Goodwill Industries of East Texas Tyler WAT Trainer Pay: $15 – $18 an hour – Full-time The incumbent in this position is primarily responsible for working with disabled individuals to provide work adjustment training services. The individual must be able to identify appropriate/ inappropriate work behavior by observing, using existing records, DARS data, and or feedback from family members; train consumer on various job duties, workplace policies and procedures/social skills/safe and efficient operation of equipment. Education/Experience: High School Diploma or GED and a Bachelor's degree in a related field, e.g., Education, Sociology, Social Services, or Liberal Arts and one year of full-time experience performing rehabilitation or adjustment; or an AA degree in a related field and 2 years of training/experience; possess computer skills (Microsoft Office Suite, Excel/Outlook). Goodwill Industries of East Texas in Tyler is looking for a WAT Trainer. Apply Here Copyright 2025 Nexstar Media, Inc. All rights reserved. This material may not be published, broadcast, rewritten, or redistributed.
