10 Excel Functions You Should Know According to Harvard :
In this video by Kenji , you'll discover how to harness tools like Flash Fill to automate tedious tasks, use INDEX MATCH for advanced lookups, and use shortcuts that make navigating massive datasets a breeze. Whether you're cleaning up messy spreadsheets, performing complex calculations, or simply trying to work smarter, these functions will give you the edge you need. But it's not just about saving time—it's about gaining control, precision, and confidence in your data management. As you explore these techniques, you might find yourself wondering how you ever got by without them. Essential Excel Functions Guide 1. Paste Special: Customize Your Data Transfers
The Paste Special feature allows you to paste specific elements of copied data, such as values, formats, or formulas, giving you greater control over how data is transferred. This is particularly useful when you need to exclude formulas or transpose rows into columns. For example, if you want to copy only the numerical results of a formula without including the formula itself, Paste Special ensures that only the desired values are pasted.
Shortcut: Press Ctrl + Alt + V to instantly open the Paste Special menu and customize your data transfer. 2. Adding and Deleting Rows and Columns: Simplify Structural Changes
Efficiently managing the structure of your spreadsheet is crucial for maintaining organization and clarity. Excel offers quick shortcuts for adding or deleting rows and columns, which can save significant time when working with large datasets. To insert a new row, select a row using Shift + Space , then press Ctrl + Shift + '+' .
, then press . To delete a row or column, select it and press Ctrl + '-' .
These shortcuts streamline structural adjustments, making sure your spreadsheet remains well-organized and easy to navigate. 3. Flash Fill: Automate Data Formatting
Flash Fill is an intelligent tool that recognizes patterns in your data and automates repetitive formatting tasks. For instance, if you have a column of full names and need to separate first and last names, Flash Fill can complete the task after you provide a single example. This feature is particularly helpful for cleaning up or reformatting data quickly.
Shortcut: Activate Flash Fill by pressing Ctrl + E after entering a sample pattern. 4. Index Match: Advanced Data Lookups
The combination of INDEX and MATCH functions provides a more flexible and powerful alternative to traditional lookup functions like VLOOKUP or XLOOKUP. Unlike VLOOKUP, INDEX MATCH can search in any direction and handle multi-criteria lookups. For example, you can retrieve a value based on both a product name and a specific date, making it ideal for complex data retrieval scenarios. This function is particularly valuable when working with large datasets that require precise and dynamic lookups. 5. Sum and Aggregate Functions: Handle Errors with Ease
While the SUM function is a staple for calculating totals, the AGGREGATE function offers advanced capabilities by managing errors in your data. For example, AGGREGATE can ignore errors like #DIV/0! while performing calculations, making sure your results remain accurate and clean. This makes it an essential tool for maintaining data integrity, especially when working with datasets that may contain inconsistencies or incomplete entries. 10 Essential Excel Functions to Save Time and Boost Productivity
Watch this video on YouTube.
Check out more relevant guides from our extensive collection on Excel functions that you might find useful. 6. Undo and Redo: Correct Mistakes Instantly
The Undo and Redo functions are indispensable for reversing or reapplying actions, providing flexibility and control over your workflow. These shortcuts are particularly useful when you need to correct mistakes or revisit previous steps: Ctrl + Z : Undo your last action.
: Undo your last action. Ctrl + Y : Redo the action you just reversed.
Additionally, the Undo dropdown menu allows you to reverse multiple steps at once, offering greater control and efficiency when making adjustments. 7. Removing Duplicates: Ensure Data Integrity
Duplicate entries can compromise the accuracy and reliability of your data. Excel provides tools to identify and remove duplicates effectively: Use conditional formatting to highlight duplicate entries for review.
Use the Remove Duplicates feature in the Data tab to eliminate duplicates entirely.
These tools help maintain a clean and accurate dataset, which is essential for reliable analysis and reporting. 8. Freeze Panes and Tables: Improve Navigation
Navigating large datasets can be challenging, but features like Freeze Panes and tables make it easier to manage and interpret your data. Freeze Panes keeps headers or specific rows and columns visible as you scroll, making sure important information remains accessible. Alternatively, converting your data into a table ( Ctrl + T ) provides dynamic headers, built-in filtering options, and additional formatting features. Both tools enhance readability and organization, making them invaluable for working with extensive spreadsheets. 9. F4 Key: Repeat Actions and Lock References
The F4 key is a versatile tool that simplifies repetitive tasks and formula creation. It allows you to repeat your last action, such as formatting or inserting rows, with a single keystroke. Additionally, when creating formulas, pressing F4 toggles between absolute, relative, and mixed references, making sure your calculations remain consistent and accurate. This feature is particularly useful for complex formulas that require precise reference adjustments. 10. Control and Arrow Keys: Navigate Large Datasets Quickly
Navigating large datasets can be time-consuming, but using Control + Arrow Keys allows you to jump to the edges of data ranges instantly. By combining this with Shift , you can select entire ranges of data efficiently. This shortcut is especially helpful when working with extensive spreadsheets, allowing you to locate and manipulate data with ease. Master These Functions to Work Smarter
By incorporating these ten essential Excel functions into your workflow, you can transform the way you manage and analyze data. Tools like Paste Special, Flash Fill, and INDEX MATCH empower you to handle complex tasks with precision, while shortcuts such as Ctrl + Alt + V and Ctrl + E save valuable time. Whether you're navigating large datasets, performing intricate calculations, or maintaining data integrity, these features enable you to work more efficiently and effectively.
Media Credit: Kenji Explains Filed Under: Guides
Latest Geeky Gadgets Deals
Disclosure: Some of our articles include affiliate links. If you buy something through one of these links, Geeky Gadgets may earn an affiliate commission. Learn about our Disclosure Policy.
Hashtags
Try Our AI Features
Explore what Daily8 AI can do for you:
Comments
No comments yet...
Related Articles
Reuters
an hour ago
- Reuters
Sutskever to lead Safe Superintelligence after Meta poaches CEO Gross in AI talent war
July 3 (Reuters) - Ilya Sutskever has taken over the reins of Safe Superintelligence (SSI), the artificial intelligence startup he launched last year, after losing CEO Daniel Gross to an intensifying talent war in the industry. Gross has joined Meta Platforms (META.O), opens new tab to lead its AI products division, sources told Reuters. The development comes as tech giants such as Meta Platforms (META.O), opens new tab aggressively chase high-profile acquisitions and offer multi-million-dollar pay packages to attract top talent in the race to lead the next wave of artificial intelligence. Meta had also attempted to recruit Ilya Sutskever and acquire SSI, sources familiar with the matter told Reuters. "You might have heard rumors of companies looking to acquire us. We are flattered by their attention but are focused on seeing our work through," Sutskever said in a post, opens new tab on X. SSI raised $1 billion in cash last year to build advanced AI systems designed to safely exceed human intelligence. Gross did not immediately respond to a Reuters request for comment. Meta CEO Mark Zuckerberg has launched a new division, Meta Superintelligence Labs, to unify the company's AI efforts, following setbacks with its Llama 4 model and key staff departures. The unit will be led by former Scale AI CEO Alexandr Wang and ex-GitHub chief Nat Friedman, after Meta invested $14.3 billion in Scale and ramped up efforts to recruit top AI talent. Gross and Friedman are known to be close, having co-founded the venture capital firm NFDG — named after their initials. The firm has backed high-profile startups including Safe Superintelligence, Perplexity and Figma. Apple acquired Gross's startup, Cue, in 2013 for its predictive search and AI technology, after which Gross joined the iPhone maker as a director, overseeing machine learning and artificial intelligence.
Telegraph
2 hours ago
- Telegraph
The hyper-futuristic jet you'll soon be flying on
Some 101 years after the world's first 'blended-wing body' aircraft took flight (before promptly crashing back down to earth), a flurry of major manufacturers are designing planes in the unique aerodynamic style. This week, we gained a fresh look into how one of these planes might take shape. The aviation start-up Natilus has published rendered images of its blended-wing body aircraft, a design concept which would allow for more spacious, fuel-efficient and potentially cheaper flights. Natilus is a San Diego-based startup, co-founded in 2016 by aircraft design engineers Aleksey Matyushev and Anatoly Starikov. The mock-ups show a seating configuration that would see three aisles running through the plane, with futuristic booths allowing for in-flight video conferencing. Aviators have theorised over the potential for a blended-wing body (BWB) jet for more than a century. But in recent years, with a sharpened onus on lowering emissions, airline manufacturers including Airbus, Bombardier and Boeing – plus a suite of start-ups – have begun exploring options for blended-wing designs. A revolutionary design In simple terms, a BWB aircraft has no clear dividing line between the main body and the wings, which are instead smoothly blended together. The result is an aerodynamic shape, which allows for a more fuel-efficient flight. The blended wing differs from the 'flying wing' – the design used for the B-2 Bomber – which sees an aircraft's entire payload within the wing structure. But they are similar, in that they are both tailless. The idea of the BWB was first dreamt up in the 1920s by Russian inventor Nicolas Woyevodsky. The result of his designs was the Westland Dreadnought, a single-engined fixed-winged monoplane. Only one was built, and it crashed on its maiden flight in Yeovil, Somerset, in May 1924, badly injuring the test pilot in the process. Other prototypes were developed in the decades that followed, including designs by Vincent Burnelli, British manufacturer Miles, and a long-range interceptor aircraft called the 'Moonbat'. The latter was designed for the US Air Force, but its production was cancelled after the prototype was destroyed by an engine fire. Video pods and 'club seating' As the decades passed, the BWB design was sidelined in preference of the 'tube and wing' design which Boeing and Airbus have adopted. But now, with airlines under pressure to meet net zero targets by 2050, the fuel-efficient BWB aircraft is back on the table. Natilus is one of the smaller firms in the mix. Its Horizon aircraft will have a range of 3,500 nautical miles with a capacity of up to 196 passengers. This puts this particular BWB in a similar playing field to the Boeing 737-800, which has a capacity of 189 seats and a range of 2,500 to 3,850 nautical miles. But it is the other numbers that will catch the attention of prospective buyers. According to Natilus, the Horizon will reduce operating costs by 50 per cent, and the aircraft is 25 per cent lighter than conventional jets. Natilus says: 'Blended-wing bodyaircraft outperform traditional tube-and-wing aircraft in the areas of efficiency, performance, and environmental impact, resulting in improved fleet operations while protecting our planet for future generations.' At a configuration of 196 passengers, the Horizon would have space for 108 in economy class (at 31in pitch), 48 in economy-plus (34in) and 40 in first class (38in). Natilus renderings show the potential for 'video conference pods', while there are also plans for 'club seating' configurations which would allow groups to sit together during longer flights. Crucially for prospective buyers, Natilus says its planes are being designed in a way that they can use existing airport infrastructure, plus they will use the same engines as conventional aircraft. In a 2024 interview with CNN, co-founder Matyushev said the plan is for the Horizon to go into service in the early 2030s. It appears that another manufacturer might beat them to it. Ambitious competitors California-based startup JetZero has similar ambitions to Natilus. The firm has received the backing of United Airlines, which has pre-ordered 200 of its 250-passenger Z4 plane (which is, as yet, uncertified), which it hopes to launch by 2030. At this size, the aircraft would be bigger than the single-aisle Boeing 737 and Airbus A320, but smaller than their twin-aisle designs, allowing it to fill a vital gap in the market. The managing director of United Airlines's Venture has previously said the Z4's width would create a 'living room in the sky'. But it is not only focusing on producing commercial jets. JetZero received a further boost when the US Air Force put in a $235 million (£172 million) contract for a demonstrator aircraft. This, according to Frank Kendall, the US secretary of the air force, was all about 'maintaining our edge over China'. It could be that these military aircraft are developed first, paving the way for the commercial jets in the future. Other manufacturers are involved in the race. JetZero traces its origins to a Nasa-McDonnell Douglas project in the early 1990s, which culminated in a successful test-flight of a 17ft demonstrator in 1997 (the JetZero co-founder, Mark Page, led this project). Boeing went on to take on the designs after merging with McDonnell, creating the unmanned X-48B and X48-C aircraft, which were tested more than 100 times. But, ultimately, these were never put into service, as other research initiatives took precedence. Airbus has revealed plans for a BWB prototype called Maveric, showcased at a Singapore air show in 2020. While Bombardier is the first business jet manufacturer to explore the potential of the blended-wing design with its 'EcoJet' project. The benefits, analysed Despite Boeing pausing its plans, the blended-wing dream remains alive. Fuel efficiency is the chief reason. Blended-wing jets are considerably more efficient compared with tube-and-wing aircraft, because they can generate more lift at take-off and face less drag as they fly. This means the aircraft is cheaper to run and produces lower emissions. 'They do offer significant fuel savings over conventional aircraft, at least in theory, as they avoid all the common joints and fillets that create form drag, or the loss of energy from wind resistance,' says pilot Brian Smith, who flies for a British cargo airline and has previously flown with Ryanair, Emirates and Air2000 (later, First Choice). From a passenger point of view, there will be exciting bonuses. The interior would be wider and more spacious, given that the plane is not structured around a long, thin tube. This could allow for some game-changing configurations, impossible in a tubular design. Given that the wider cabin design allows for multiple aisles, the boarding and disembarkation process would likely be much quicker and more pleasant for passengers, too. By all accounts, BWB aircraft could be quieter than traditional jets. Because they are more aerodynamically efficient, they will be able to use smaller engines that generate less noise. The location of the engines above the fuselage would also shield passengers from excessive noise. Natilus estimates that its planes would be around 40 per cent quieter than tube-and-wing aircraft. And if, as Natilus suggests, the aircraft can run with 50 per cent lower operating costs, this could also allow airlines flying BWB aircraft to be priced more competitively than traditional tube-and-wing services. Dilemmas and hurdles But there are, inevitably, some downfalls to the BWB design. Due to the plane's wider interior, fewer passengers will have a window seat. There are also concerns that evacuating a blended wing aircraft would be more difficult, given that there would be fewer exit doors available. Another challenge that BWB aircraft face is stability and control, due perhaps to the absence of a traditional tail. To counter this, designers may need to incorporate sophisticated flight control systems. There are also technical challenges around how to manage the pressurisation in a non-cylindrical fuselage. It is generally thought that the traditional tube-shaped design is better equipped to handle this. And last, but certainly not least, is the question of whether such a design would ever pass through regulators. Conventional tube-and-wing aircraft, produced by manufacturers such as Airbus and Boeing which have been building them for more than half a century, must meet strict requirements before they can fly. Sometimes, these checks are so rigorous that they can lead to delivery delays. With a unique design, and chequered 100-year history, it is safe to assume there would be significant regulatory hurdles facing BWB manufacturers before they can safely take flight. Brian Smith is optimistic that airlines could be flying BWB planes in the near future: 'If they can be scaled up and produced in large enough numbers, and prove at least as high a degree of safety as conventional types, then it is likely that they will gain serious attention from airlines, both passenger and cargo,' he says. 'They will certainly be heavily computerised, and may even be the vanguard of pilotless aircraft, but they would be interesting to fly, and no self-respecting pilot would turn down the opportunity to fly one. They'll come too late for me, alas, but I am sure I will see them fly commercially in my lifetime.'
Coin Geek
2 hours ago
- Coin Geek
What is AGI? Artificial General Intelligence
Homepage > News > Business > What is AGI? Artificial General Intelligence Getting your Trinity Audio player ready... In nearly every interview with one of the leading AI tech giants, you hear their teams, usually the CEO, talk about how the company is pursuing Artificial General Intelligence (AGI). Then they typically say something about how AGI is much closer to being delivered than we think. But what actually is artificial general intelligence, and is it truly an innovation coming up the pipeline or simply a phrase designed to generate buzz and raise more money? What is Artificial General Intelligence? Artificial General Intelligence, or AGI, refers to an artificial intelligence (AI) system capable of performing any intellectual task that a human can do. You might be saying to yourself, 'But that sounds a lot like what AI models are currently able to do.' There's some merit, and even some truth, to that thought. However, AGI is technically and functionally different from today's AI systems, which most people call 'narrow AI': artificial intelligence designed to perform specific tasks or a limited range of functions. AI chatbots fall into the category of narrow AI. Narrow AI doesn't actually understand what's going on. It's just very good at recognizing patterns in large datasets, which it uses to produce outputs that appear intelligent. Behind the scenes, no comprehension or reasoning is happening, just data analysis, pattern matching, and predicting the next sequence of words based on the patterns it has learned from the massive datasets it was trained on. By contrast, artificial general intelligence is supposed to resemble human intelligence more closely in how it reasons, learns, and adapts. It's meant to have a deeper level of understanding and the ability to use that to a range of tasks and situations, even ones it has never seen or been trained on, similar to a human thinking on their feet. In perspective, narrow AI is like an autopilot that can follow a programmed route but gets confused if something unexpected happens. AGI would be like having a fully trained driver behind the wheel who can drive anywhere, adapt to the weather, and improvise using everything they know. The advantages of AGI At the moment, AI platforms still need a human somewhere in the loop, prompting the AI, giving it rules, guidelines, and directions, and then making corrections to the outputs to ultimately and eventually produce an acceptable result. On the other hand, AGI doesn't require a human in the loop. An AGI system could learn any skill, 'remember' that skill alongside everything else it knows, and independently connect the dots between those skills and prior learnings to arrive at new conclusions. People are hopeful this means AGI can unlock scientific and technological breakthroughs and lead to innovations at a much faster rate. Having AGI would essentially be like having a researcher who never sleeps, constantly generating and testing hypotheses. For many, that's the vision that makes AGI so compelling, and its supporters remain optimistic about what AI can do in the various industries that are derivatives of science, technology, math, and engineering. The AGI gold rush: Billions spent on a product you may never notice Several tech giants are pouring billions into AGI. OpenAI, Google DeepMind (NASDAQ: GOOGL), and Meta (NASDAQ: META) have all made their intentions to achieve AGI clear; however, each has a different timeline for when they believe AGI will arrive. Some avoid making predictions altogether, while others hint it could be anywhere from a few years to a decade away. Although AGI has mostly been a backdrop to the general conversation about AI and its capabilities, I'd bet it starts playing a bigger, more frequent role in that conversation. For starters, I think this is because AI has plateaued. The topics, promised products, and buzzwords of the past are losing their edge and failing to pick up traction. The industry needs something new and appealing for the world to cling to to keep the AI dream alive, and I feel that 'something new' will be AGI. Beyond that qualitative speculation, there's no question that the promise of delivering AGI helps companies raise money, money they need in massive amounts to keep their AI operations going, especially since profits in this resource-intensive industry have remained elusive. The biggest battle in the war on AI is being fought on the 'model' front. All else being equal, whoever has the best model has the best product and the best platform for consumers to tap into and developers to build on top of. The first company to legitimately create an AGI model will arguably be the 'winner' of the war, at least until other companies catch up and have an AGI of their own that can compete for market share. But all of this raises a crucial question: Although the race to AGI matters on a technical level, will consumers actually feel the difference? I have a feeling that in most cases, the answer is no. Many people probably won't be able to tell narrow AI apart from AGI unless AGI manifests in some kind of hardware (like a lifelike robot) or a platform that's always on, creating the feeling that it's basically another intelligent person in the room with them at all times that makes its presence known. Even then, I suspect consumers will encounter the same problem with new AI products. Many people just don't know how they're supposed to use them or how to get the most out of the AI that is available to them, so they default to treating AI as a search engine, which is a use case that seems to be becoming AI's killer app, with the most obvious path to revenue by way of advertising revenue. The final frontier of AI or another overhyped AI promise? This brings me back to the big question: Is AGI really the next and possibly final frontier of artificial intelligence? Or is it just the next chapter in AI marketing? The grand vision tech giants are promising to deliver, the one that's getting investors excited to open their checkbooks, but that consumers, like they have with other overpromised AI products (think AI agents), don't actually demand, wouldn't know how to use effectively, and ultimately won't be able to differentiate from the systems they already have? It's too soon to know. No company has achieved AGI yet, and the conversations regarding how it will affect consumers haven't kicked off yet either. But as time goes on, AGI will either materialize, or we will realize that AGI is yet another rebranding of neural networks, machine learning, and generative AI that keeps the money flowing into the fundraising rounds from tech giants and keeps the AI dream alive. In order for artificial intelligence (AI) to work right within the law and thrive in the face of growing challenges, it needs to integrate an enterprise blockchain system that ensures data input quality and ownership—allowing it to keep data safe while also guaranteeing the immutability of data. Check out CoinGeek's coverage on this emerging tech to learn more why Enterprise blockchain will be the backbone of AI . Watch: Artificial intelligence needs blockchain title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen> AI Artificial General Intelligence Artificial Intelligence Narrow AI
