Search results for "excel"
Items in stock - 4 working days delivery time

Microsoft 365 Excel For Dummies
Make Excel work for you with this brand new guide to spreadsheet essentials Knowing a little about Excel is essential for almost every profession. Knowing a lot about Excel makes you one of the most valuable people in the office. Microsoft 365 Excel For Dummies helps you build your spreadsheet skills as it walks you through the basics of creating a spreadsheet, organizing data, performing calculations, and creating charts and graphs in Microsoft's powerful spreadsheet software. This brand new version of the book, written by an Excel guru and expert trainer, helps you develop the skills you need to impress your boss—or just to get things done faster. You'll also get ideas for using Excel to make daily life easier. Ready to become a number cruncher? Create your first spreadsheet and learn how to enter dataImport data from other sources, sort tables, and organize informationRun basic calculations and get more advanced with functionsBuild data visualizations, customize the look of your spreadsheets, and beyond These days, almost everyone who works with computers needs to have basic knowledge of Excel—and more is usually better. Microsoft 365 Excel For Dummies will help you get there.
R 730.00

Microsoft 365 Excel All-in-One For Dummies
Get into the nitty gritty of Excel, the all-important spreadsheet tool Microsoft 365 Excel All-in-One For Dummies offers an all-new way to tackle data in Excel. Start with the basics of inputting, formatting, and organizing data and work your way to pro techniques that help with any career field or reason for using the app. Gain the skills to apply advanced formulas and functions, create stunning data visualizations, build dashboards and reports, and automate your spreadsheets. You'll also get a glimpse into how AI tools can boost your work. Eight mini-books come together in this expanded Excel reference. With Microsoft 365 Excel All-in-One For Dummies, you'll soon be the go-to Excel guru in your office or school. Learn the basics of Excel—organizing data, performing calculations, and formatting your spreadsheet.Use functions to handle advanced math and financial analysis.Create data visualizations and summaries to help tell your storyApply basic programming skills using VBA This book is perfect for professionals or students who need to up their Excel game with insight from pros who know the classic spreadsheet app inside and out.
R 1,004.00
Items we need to order for you

R 794.00

R 611.00

Microsoft Excel 365 Bible
Your complete guide to Excel 365, written for newbies all the way to seasoned professionals Neatly organised and written using accessible language, Microsoft Excel 365 Bible contains everything that readers need to know to get up and running quickly with Excel. Covering the numerous updates to Excel 365 since the previous edition was published in 2022, this Second Edition contains many useful examples and tips and tricks that cover all essential aspects of Excel—from the basics, such as navigating the user interface, to more advanced topics, such as creating visualisations and crafting custom functions. Written by an accomplished team of authors with decades of Excel and business intelligence experience, this book explores topics including: Entering and editing worksheet data, with information on data types, formulas, dates, times and other cell contentsBuilding formulas with Excel table objects, correcting common formula errors and using formula variablesWorking with data series, changing basic chart elements and making use of chart customizationLoading data from other sources, performing common transformations and applying conditional logic Microsoft Excel 365 Bible earns a well-deserved spot on the bookshelves of all professionals and individuals seeking to get the most out of Excel 365, from beginners with limited knowledge of the software all the way to advanced users with years of experience under their belts.
R 1,335.00

R 446.00

R 4,884.00

R 550.00

R 496.00

Microsoft 365 Excel Formulas & Functions For Dummies
Turn Excel into an unstoppable data-and number-crunching machine Microsoft Excel is the Swiss Army knife of apps. With over 470 built-in functions and countless custom formulas, the program can help make you the smartest guy or gal in any room. And now that it's been supercharged with Copilot—Microsoft's AI-powered helper—it's even easier to produce accurate and useful results anywhere, anytime. Best of all, it doesn't take an advanced degree in mathematics or data science to take full advantage of Excel's functionality. Just grab a copy of this latest edition of Excel Formulas & Functions For Dummies and get a flying start on the Excel functions and formulas that power up your data superpowers. With this book, you'll: Learn to create and use hundreds of formulas and functions, correct common mistakes, and make calculationsDiscover how to analyze data and calculate statistics, and even work with dates and timesUse the ever-evolving, AI-powered Copilot to expand Excel's functionality and make it easier to use Get ready to transform your copy of Excel at home or at work into an unstoppable toolkit equipped for almost any occasion. Grab a copy of Excel Formulas & Functions For Dummies today!
R 798.00

Microsoft Excel Step by Step (Office 2021 and Microsoft 365)
The quick way to learn Microsoft Excel! This is learning made easy. Get more done, more quickly, with Microsoft Excel. Jump in wherever you need answers—brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for effective visual impactPerform calculations and find and correct errorsManage, filter, summarize, validate, reorder, and combine dataIdentify trends, illustrate processes and relationships, and dynamically analyze dataBuild sophisticated forecasts, key performance indicators (KPIs), and timelinesVisualize data with customized charts, 3D maps, and other powerful toolsImport, process, summarize, and analyze huge data sets with PowerPivot and Power QueryUse powerful Excel Data Models for advanced business intelligence
R 1,049.00

R 504.00

R 544.03

R 396.00

Excel Quick and Easy
A fast, up-to-date, and convenient desk reference for Excel users of any skill level Drawn from the most important tasks in the latest bestselling Excel Bible , Excel Quick and Easy is your ticket to data mastery. Excel veterans Michael Alexander and Dick Kusleika distil the most essential and useful tasks you need to understand about the world's most popular spreadsheet program, from functions to charts, graphs, formulas and more. Prepare for a whirlwind tour of Excel, packed with simple and step-by-step guides to common and lesser-known Excel features. This book shows you how to: Create new spreadsheets and workbooks by entering and editing worksheet dataSimplify working with large amounts of data by naming and moving rangesMake calculations and draw conclusions from your data by using formulasVisualize and present your data by creating functional charts The secret weapon in your productivity arsenal Being great at Excel is quickly becoming a standard expectation for a ton of employers and organizations, in all sorts of industries. Sharpening your skills can boost your workplace performance and make it easier to land promotions or find new roles. Excel Quick and Easy makes it a breeze to develop the proficiencies that help you stand out from your peers. Unique features of this book Step-by-step guides to the most commonly used and productive Excel tasks, from basic worksheet operations to formatting spreadsheets for hardcopy printingIntuitive explanations for making your data tell a compelling story with visualizations, including charts, graphs, and tablesAdvanced number-crunching techniques, including formulas and functions, that help you unlock fresh insights and new conclusions from your data Excel Quick and Easy is the perfect reference for brand-new Excel users trying to get up-to-speed quickly and confidently. It's also a must-read for anyone migrating from another spreadsheet program, like Google Sheets, or more experienced Excel users who need to solidify and improve their skills. If you're tired of stumbling through your spreadsheets and just “surviving” in Excel, grab a copy of Excel Quick and Easy and supercharge your productivity. You'll refine your understanding of the basics, learn brand-new skills and features, and become the Excel expert that every office desperately needs.
R 456.00

R 535.70

R 485.00

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
Conquer Microsoft Excel—from the inside out! Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel and its latest innovations, from advanced analysis and visualizations to dashboards. Discover how experts tackle today’s key tasks—and challenge yourself to new levels of mastery. Save time with galleries, keyboard accelerators, and other shortcuts.Enter formulas more efficiently, and fully control operators and dates.Use new data types to return photos, arrays, or weather history— and even create your own.Master Excel’s most widely-used functions.Integrate external data from the web and other sources.Use the new XLOOKUP function to retrieve data more efficiently, with fewer errors.Store powerful specialized logic in LAMBDA functions—and avoid their limitations.Easily transform complex datasets with Power Query.Quickly summarize millions of records with pivot tables.Perform ad hoc analyses and create advanced data mashups.Use Analyze Data’s artificial intelligence to get answers and auto-generate pivot tables.Solve complex problems with What-If, Scenario Manager, Goal Seek, and Solver.Automate repetitive tasks by editing recorded VBA code.Demystify data with conditional formatting and other visualization techniques.Make the most of Excel’s newest maps and charts.Add visual power with icons, 3D models, and animated 3D maps.
R 1,254.00

Microsoft Excel Functions and Formulas with Excel 2019/Office 365
In this completely updated edition covering Excel 2019, previous versions, and Office 365, Microsoft Excel Functions & Formulas 5/E demonstrates the secrets of Excel through the use of practical and useful examples in a quick reference format. Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of choice when it comes to crunching numbers, building charts, and analyzing tables. The book's extensive examples and added video tutorials make it an excellent resource for all Excel users who want to understand, create, and apply formulas. Experienced users will also find Microsoft Excel Functions & Formulas 5/E an excellent reference for many of the program's advanced formulas and functions. The text is easy to understand with numerous step-by-step instructions and the actual, ready to use, Excel screenshots of the input and output from the formulas. The book includes companion files with video tutorials, over 250 worksheet files of examples for numerous functions, formulas, and all the figures from the text.FEATURES:Includes companion files with video tutorials, over 250 Excel worksheet examples, and all of the figures from the text (including 4-color)Completely updated to cover Microsoft Excel 2019, previous versions, and Office 365Saves hundreds of hours with the latest Excel tips, worksheets, and shortcuts Written by a proven author with Microsoft Valued Professional(MVP) statusThe Companion Files are also available for downloading from the publisher by emailing proof of purchase to info@merclearning.com.
R 1,527.00

R 1,628.00

Microsoft Excel 2019 Step by Step
The quick way to learn Microsoft Excel 2019! This is learning made easy. Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers–brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for easier viewingPerform calculations and find and correct errorsCreate sophisticated forecast worksheets, key performance indicators (KPIs), and timelinesVisualize data with 3D maps, funnel charts, and other powerful tools Import, process, summarize, and analyze huge datasets with Excel’s improved PowerPivot and Power QueryBuild powerful data models and use them in business intelligence Look up just the tasks and lessons you need
R 912.00

Microsoft® Excel
Hochleistungsfahige Prozessoren im Bereich der Personal-Computer sowie hochaufl?sende Monitore und Drucker mit Buchdruck-Qualit't fordern eine neue Software, die in der Lage ist, die angebotenen M?glichkeiten zu nutzen. Diese neue Software er?ffnet eine vielf?ltige Anwendungsbreite und gewinnt durch eine graphische Benutzeroberfl?che ein Mehrfaches an Bedienerfreundlichkeit. Microsoft hat durch die Schaffung der Windows-Oberfl?che eine neue Softwareebene oberhalb der bekannten Produktfarnilie (Word, Chart, Multiplan) erschlossen, die auf die oben beschriebenen Hardwaredimensionen abgestellt ist. Mit Microsoft Excel ist eine Windowsapplikation vorgestellt worden, die alle Merkmale der Windows-Oberfl?che, wie graphische Benutzeroberfl?che, erweiterte Speicherausnutzung und dynarnischer Daten- austausch nutzt. Microsoft Excel ist ein leistungsfahiges Tabellenkalkulationsprogramm mit integrierter Datenbankfunktion und Gesch?ftsgraphik. Das bereitgestellte Leistungsspektrum ist der- art vielfliltig, d selbst wir, nach etwa einem Jahr intensiver Nutzung, immer wieder neue Dimensionen in diesem Prograrnmpaket entdecken. Der Benutzer wird aus dem gebote- nen Leistungsspektrum allenfalls die H?lfte der M?glichkeiten aussch?pfen, die Microsoft Excel bietet. Dieses Buch soll dem interessierten Excel-User besonders einen Einblick in die Bereiche bieten, die ihm im t?glichen Umgang mit einem solchen Programm die Arbeit wesentlich erleichtern. Dazu haben wir, an Beispielen aus der Praxis, die Grundfunktionen dieses Tabellenkalkulationsprogrammes dargestellt und dariiber hinaus erl?utert, wie die Arbeits- abl?ufe durch Makros automatisiert werden k?nnen. Nach dem Durcharbeiten der Bei- spiele dieses Buches haben Sie nicht nur vertiefte Excel-Kenntnisse erworben, sondern Sie besitzen auch Anwendungsprogramme, die der Verwaltung von Anlageverzeichnissen oder der Reisekostenabrechnung dienen.
R 1,678.74

R 305.00

R 1,303.00

R 305.00

Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Microsoft Excel. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro developmentWork more efficiently with ranges, cells, and formulasGenerate automated reports and quickly adapt them for new requirementsLearn to automate PivotTables to summarize, analyze, explore, and present dataLeverage more of Excel VBA’s power with classes, collections, and Advanced FilterMake the most of User-Defined Functions (UDFs), including new LAMBDA functionsBuild sophisticated UserForm custom dialogs to collect data from other Excel usersIntegrate data from the Internet, Access and SQL Server databases, and other sourcesAutomatically generate charts, visualizations, sparklines, and Word documentsExtend Excel’s power by controlling other Office programs and Windows itselfCreate Office Add-ins to expand worksheet functionality or streamline retrieval of external informationGet started creating brand-new TypeScript applications for Excel Online About This Book • For everyone who wants to get more done with Microsoft Excel in less time • For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data
R 1,250.00

R 1,303.00

R 657.00

R 916.00

Microsoft Excel VBA and Macros
Renowned Excel experts Tracy Syrstad and Bill Jelen (MrExcel) help you automate Excel tasks to get more done faster than ever! This book is designed to equip you with a solid foundation in Microsoft Excel Visual Basic for Applications (VBA), and help you progress to advanced techniques like in-memory processing and custom object programming for efficient data manipulation. You will learn to write and understand VBA code, automate complex Excel tasks, import and export data, interact with cells programmatically, and manipulate data efficiently. You’ll also learn advanced reporting automation, enabling you to generate and update charts and pivot tables through code and develop programs that transform raw data into comprehensive reports with a single click of a button. With clear explanations and practical examples, Tracy Syrstad and Bill Jelen help make complex tasks a breeze! You’ll find simple, step-by-step instructions, real-world case studies, project specification solutions, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macros development —even if you’re starting with no prior experience.Learn the foundations of VBA through clear, step-by-step guidance.Gain insider techniques for cleaner code, better structure, and long-term maintainability.Go beyond how-to tutorials: learn how professionals approach automation.Design advanced userforms with multiple views, custom controls, and data validation.Use custom objects and collections to write scalable, object-oriented code.Extend Excel’s power by automating Word, Outlook, and other Office programs.Integrate data from the internet, Access, text fi les, and other sources.Leverage advanced filter techniques to isolate and manipulate large datasets efficiently.Share your programs using Excel Add-ins (XLAM), Office Add-ins (Office.js), and Office Scripts About This Book For everyone who wants to get more done with Microsoft Excel in less timeFor business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data
R 1,679.00

R 550.00

R 1,140.00


R 496.00

R 730.00

R 244.00

Excel's Not Dead
A new way of working with Excel spreadsheets never seen before that will transform how we work with Excel now and in the future. A game changing system of data manipulation based on a single discovery.This book will take you step by step from the discovery and it's simple application through to how to apply it to create fully dynamic dashboards. The things that you could previously only do with Pivot Tables are now available to everyone from Excel beginners to professionals. A comprehensive Excel toolkit to ensure you have all the tools you need to tackle all the exercises and complete your journey.I hear too often from IT professionals that "Excel is Dead" but every day I see It becoming more and more essential in every work environment from single person start ups to large corporations. This book will show that not only is excel not dead, with the system I will teach you it's getting stronger and stronger.
R 1,726.00

Excel 2019 All-in-One For Dummies
Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making 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. The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Microsoft Power BI (Business Intelligence) to analyze, model, and visualize vast quantities of data from a variety of local and online sources. Get familiar with Worksheet designFind out how to work with charts and graphicsUse Excel for data management, analysis, modeling, and visualizationMake sense of macros and VBA If you’re a new or inexperienced user looking to spend more time on your projects than trying to figure out how to make Excel work for you, this all-encompassing book makes it easy!
R 912.00

R 759.13

R 488.00

Excel Basics to Blackbelt
This third edition capitalizes on the success of the previous editions and leverages the important advancements in visualization, data analysis, and sharing capabilities that have emerged in recent years. It serves as an accelerated guide to decision support designs for consultants, service professionals and students. This 'fast track' enables a ramping up of skills in Excel for those who may have never used it to reach a level of mastery that will allow them to integrate Excel with widely available associated applications, make use of intelligent data visualization and analysis techniques, automate activity through basic VBA designs, and develop easy-to-use interfaces for customizing use. The content of this edition has been completely restructured and revised, with updates that correspond with the latest versions of software and references to contemporary add-in development across platforms. It also features best practices in design and analytical consideration, including methodical discussions of problem structuring and evaluation, as well as numerous case examples from practice.
R 2,361.20

R 457.00

R 1,303.00

Advanced Excel Success
Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase your productivity. This book discusses new techniques such as power functions, chart tricks, and many more to master Excel.Advanced Excel Success starts with a few useful data tools in Excel followed by advanced formulas that will help you increase productivity. Here, you will learn power functions that aggregate, return ranges, and much more. Further, you will look at custom formatting tricks along with advanced charting tricks. These include automatically changing the color of key metrics, dynamically sorting chart data, and building creative labels. Next, you will understand the role of Power Query which is one of the most important upgrades in Excel. Power Query is the Microsoft Data Connectivity and Data Preparation technology that enables business users to seamlessly access data stored in hundreds of data sources and reshape it to fit their needs, with an easy–to-use, engaging, and no-code user experience. Finally, you will learn Power Pivot which is a distinct feature in Excel that goes beyond spreadsheets. After reading this book, you will be well equipped to work on Excel with its advanced features. What You Will LearnWork with the most useful data tools Understand formulas and the ten power functionsUse advanced chart and formatting tricks and techniques for dynamic and effective visualsWork with power tools Who This Book Is For Excel users looking to take the next step to expert level.
R 1,594.32

Microsoft Excel Formulas and Functions (Office 2021 and Microsoft 365)
Use Excel 365 and Excel 2021 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including recent improvements ranging from dynamic arrays to XLOOKUP and LET. McFedries’ step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate-to-advanced-level formula construction, and help you leverage Excel’s most useful functions in your everyday work. Becoming an Excel expert has never been easier! By reading this book, you will: Improve business analyses by adding intelligence and knowledge to your modelsReplace cumbersome formulas with convenient predefined functionsUse modern lookups to make your formulas more powerful and flexibleSimplify complex calculations with dynamic arrays in Excel 365 and Excel 2021Use conditional formatting to reveal anomalies, problems, or opportunitiesCalculate loan payments, interest costs, terms, and amortization schedulesProject the future value of investments, and plan to achieve investment goalsMaster essential discounting and cash-flow analysis tools, including NPV and IRRSort, filter, and analyze any tabular data, from customers to inventoryEasily analyze huge datasets with PivotTable calculationsPerform sophisticated what-if analyses, scenario planning, and forecastingOptimize profit, cost, or operational efficiency with Solver About This Book For everyone who wants to get more done with Microsoft Excel in less timeFor business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data
R 1,026.00

R 519.00

R 359.00
-
, by sungano kanjere Exclusive Books Recommends in October features Eben Etzebeth’s new release as Book of the Month, Elizabeth Gilbert’s luminous memoir, and standout South African voices in fiction and non-fiction.
Exclusive Books Recommends is a selection of monthly recommended titles.















































