Become "the Excel person" in your office – without taking a long course.
Most people waste hours clicking around Excel and guessing formulas. This short, no-fluff guide shows you the tiny set of functions that actually matter in real office work.
Inside this book, you’ll learn how to:
- Clean messy names and text with PROPER and TRIM
- Combine pieces of text (like first and last names) with simple formulas
- Pull data from other sheets using XLOOKUP instead of clumsy VLOOKUP
- Add numbers only when conditions are met with SUMIFS (for example, Sales by John)
- Automatically label rows with IF (for example, Bonus vs No Bonus)
- Work with dates using TODAY and DATEDIF for real-world reports
- Follow a simple 7-day practice plan so the formulas actually stick
You don’t need to become an Excel expert. You just need to master the 20% of formulas that do 80% of the work.
Read this in about an hour. Keep it on your desk as a quick-reference cheat sheet. Use it to finish your spreadsheets faster and look like a pro at work.
"synopsis" may belong to another edition of this title.
Seller: Grand Eagle Retail, Bensenville, IL, U.S.A.
Paperback. Condition: new. Paperback. Become "the Excel person" in your office - without taking a long course.Most people waste hours clicking around Excel and guessing formulas. This short, no-fluff guide shows you the tiny set of functions that actually matter in real office work.Inside this book, you'll learn how to: - Clean messy names and text with PROPER and TRIM- Combine pieces of text (like first and last names) with simple formulas- Pull data from other sheets using XLOOKUP instead of clumsy VLOOKUP- Add numbers only when conditions are met with SUMIFS (for example, Sales by John)- Automatically label rows with IF (for example, Bonus vs No Bonus)- Work with dates using TODAY and DATEDIF for real-world reports- Follow a simple 7-day practice plan so the formulas actually stickYou don't need to become an Excel expert. You just need to master the 20% of formulas that do 80% of the work.Read this in about an hour. Keep it on your desk as a quick-reference cheat sheet. Use it to finish your spreadsheets faster and look like a pro at work. This item is printed on demand. Shipping may be from multiple locations in the US or from the UK, depending on stock availability. Seller Inventory # 9798278372585
Seller: PBShop.store US, Wood Dale, IL, U.S.A.
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # L2-9798278372585
Seller: California Books, Miami, FL, U.S.A.
Condition: New. Print on Demand. Seller Inventory # I-9798278372585
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # L2-9798278372585
Quantity: Over 20 available
Seller: CitiRetail, Stevenage, United Kingdom
Paperback. Condition: new. Paperback. Become "the Excel person" in your office - without taking a long course.Most people waste hours clicking around Excel and guessing formulas. This short, no-fluff guide shows you the tiny set of functions that actually matter in real office work.Inside this book, you'll learn how to: - Clean messy names and text with PROPER and TRIM- Combine pieces of text (like first and last names) with simple formulas- Pull data from other sheets using XLOOKUP instead of clumsy VLOOKUP- Add numbers only when conditions are met with SUMIFS (for example, Sales by John)- Automatically label rows with IF (for example, Bonus vs No Bonus)- Work with dates using TODAY and DATEDIF for real-world reports- Follow a simple 7-day practice plan so the formulas actually stickYou don't need to become an Excel expert. You just need to master the 20% of formulas that do 80% of the work.Read this in about an hour. Keep it on your desk as a quick-reference cheat sheet. Use it to finish your spreadsheets faster and look like a pro at work. This item is printed on demand. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability. Seller Inventory # 9798278372585
Quantity: 1 available