Vi bøger
Levering: 1 - 2 hverdage

Regneark

Her finder du spændende bøger om Regneark. Nedenfor er et flot udvalg af over 53 bøger om emnet. Det er også her du finder emner som Excel, Lotus 1-2-3, osv.
Vis mere
Filter
Filter
Sorter efterSorter Populære
  • af Jens Koldbæk
    108,94 kr.

    Bruger du Excel meget og har du mange opgaver, som du gerne vil automatisere? Med denne titel lærer du at løse rutineopgaver i Excel hurtigt og effektivt. Lær bla. om pivottabeller, makroer og VBA programmering i VBA. Derudover gennemgås skjulte funktioner og genveje samt indspilning og redigering af makroer. Du bliver introduceret til den grundlæggende viden om VBA og en samling af Excel redskaber bl.a. makroer, der kan hjælpe med at udføre det hårde arbejde for dig. Du lærer at anvende makrooptageren til at indspille dine første makroer. Dernæst lærer du at redigere i makroernes kodelinje og blive mere fortrolig med VBA. VBA står for Visuel Basic for Applications og er et programmeringssprog, der er indbygget i Excel. Hvis du har Excel installeret på din computer, er du klar til at programmere i VBA. De fleste har hørt om pivottabeller, men få er klar over, hvor effektivt et værktøj det er til at få et hurtigt overblik over store datatunge regneark. Lær at oprette og tilpasse pivottabeller og få styr på de helt grundlæggede teknikker over beregnede felter til konsolidering og analyse af hele datasættet. Skrevet til begyndere og let øvede i Excel 2016, men kan anvendes til andre Excel versioner.

  • - Office 365
    af Libris Redaktion
    108,94 kr.

    Excel 2019 med Office 365 er et solidt og omfangsrigt program, som indeholder et hav af muligheder, som spænder lige fra typiske regnearksopgaver som fx budgetter og regnskaber, beregning af realkreditlån og valutaberegning, til blot til at holde styr på alle de oplysninger du ikke ved, hvor du ellers skal gemme. Det kan fx være fremmøderegistrering, optegnelse over værdigenstande til brug for din forsikring, projektplaner, timesedler, vagtplaner, styrketræningsskema – ja, det er kun din fantasi, der sætter grænser her.Vi gennemgår programmets brugerflade og værktøjer, og giver dig en grundig indføring i brug af formler og funktioner, formateringsmuligheder og databasefunktioner. Sidst men ikke mindst lærer du OneDrive at kende; dit lager i skyen, som bl.a. åbner for automatiske gemmefunktioner og samarbejde med andre i realtid. Med dette hæfte i hånden får du en grundig indføring i Excels mange indbyggede værktøjer, sådan at du selv bliver i stand til at håndtere dine data på en professionel og – ikke mindst – tidsbesparende måde.

  • - ... jeg vil BARE, LIGE, HURTIGT gerne bruge ...
    af Martin Jensen & Martin Georg Houlberg Jensen
    69,95 - 157,95 kr.

    Excel til rapporter, statistik, cockpit, overblik, planlægning, storskærm, kioskvisning, automation og og og ... Om at gøre regnearket til et værktøj der kan meget mere. Om automation, fejlminimering, forenkling, processer og at gøre det umulige muligt.

  • - Gmail, Google Docs, Google Sheets, Google Slides
    af Nima Pour
    108,94 kr.

    Bliv godt rustet til at få mest muligt ud af Googles mange (og ofte gratis) programmer. Lær hvordan du opretter en Google-konto, så du kan få adgang til den populære webbaseret email-service Gmail. Vi gennemgår Google Drev – stedet hvor du kan gemme og dele filer og på den måde samarbejde om et dokument, selvom du og din samarbejdspartner sidder langt fra hinanden. Du lærer også at mestre og arbejde meget smartere med tekstbehandlingsprogrammet Google Docs, regnearkprogrammet Google Sheets og præsentationsprogrammet Google Slides på computer, tablet og smartphone. Desuden indeholder titlen tips til Google Fotos og Google Play der inkluderer film, bøger og musik.Undervejs er der inkluderet masser af tips og tricks, som sikrer, at du får mest muligt ud af alle de smarte funktioner i Google-programmerne. Skrevet til både nybegyndere samt erfarne brugere.

  • - Excel til andet end forretningsprocesser og andre seriøse - og mere almindelige - anvendelser
    af Martin Georg Houlberg Jensen
    68,94 - 157,95 kr.

    Excel til andet end forretningsprocesser og andre seriøse - og mere almindelige - anvendelser Om at gøre regnearket til et værktøj der kan meget mere Om nye ideer, sjove indfald og at gøre det umulige muligt I denne omgang gælder det alt andet end noget seriøst, for ja, Excel kan sagtens benyttes til en masse underholdning og ikke kun anvendes forretningsmæssigt. Man skal nok være lidt ekstra vild med - eller skør med - Excel, kodning og at fordybe sig i denne tekniske og måske nok lidt smånørdede verden. Men når det er på plads, er der masser af sjove muligheder lige ved hånden. Formålet er stadig - ligesom de tidligere hæfter - at tænke alternativt, kigge udover hvad der i dag er muligt eller tænkeligt, og overgå det.

  • af Crispo Mwangi (Mvp)
    313,95 kr.

    Transform Your MS Excel Skills with this Ultimate Guide for Professional SuccessBook DescriptionThe Ultimate Excel with Power Query and ChatGPT is a revolutionary handbook to help you embark on a transformative journey through the intricate world of Excel's lookup functions. The book dives deep into Excel's lookup universe, offering a meticulous exploration of over 100 techniques. Each method is presented with clarity and precision, making even the most complex lookup scenarios comprehensible. From traditional functions to innovative problem-solving approaches, this book equips you with versatile tools to navigate any data challenge efficiently. What sets this book apart is its focus on job roles. You'll discover techniques that directly enhance productivity, streamline data management tasks, and elevate your efficiency in Excel-related responsibilities. With a comprehensive, engaging, and interactive approach, it transforms learning Excel formulas into a journey of building practical data lookup expertise.Table of Contents1. Excel Environment2. VLOOKUP Is Dead: Or is it?3. INDEX and MATCH4. LOOKUP5. Other LOOKUP Methods and Functions6. XLOOKUP7. FILTER: The Ultimate Lookup Function8. Power Query: One-Stop Solution9. ChatGPT: Using ChatGPT to solve lookup issues Index

  • af Américo Moreira
    137,95 kr.

    "Excel and VBA: Boosting Performance with Best Practices" is a comprehensive guide that focuses on optimizing the performance of Excel and VBA macros. Whether you are a beginner or an experienced user, this book provides valuable tips and tricks to help you write efficient macros. From understanding the basics of Excel and VBA to advanced techniques, each chapter covers a specific topic, providing clear explanations and practical examples. With a focus on best practices, this book will help you enhance your productivity and improve the performance of your Excel projects.The book starts with an introduction to Excel and VBA, explaining their benefits and guiding you through the setup of the VBA environment. It then dives into the fundamentals of Excel and VBA, covering topics such as working with cells and ranges, using formulas and functions, and managing data in Excel. The following chapters focus on optimizing VBA code, working with Excel objects, advanced techniques, debugging and error handling, performance optimization techniques, working with large data sets, automation and integration, security and protection, collaboration and sharing, and best practices for Excel and VBA. Each chapter provides in-depth knowledge and practical advice to help you boost your performance and efficiency when working with Excel and VBA.Whether you are a professional using Excel for data analysis or a VBA developer creating macros, "Excel and VBA: Boosting Performance with Best Practices" is a must-have resource. With its comprehensive coverage of topics and practical examples, this book will empower you to write efficient macros and optimize the performance of your Excel projects. By following the best practices outlined in this book, you will be able to enhance your productivity, save time, and achieve better results with Excel and VBA.

  • af René Martin
    236,95 kr.

    Schaltzentrale ExcelWenn Sie viel mit Excel arbeiten, kennen Sie das Problem sicherlich: von einem anderen Menschen oder einem System erhält man Daten, die man beim besten Willen so nicht weiterverarbeiten kann. Um solche Daten zu "putzen" gibt es nun mehrere Ansatzmöglichkeiten: Man kann sie mit einem der vielen Assistenten in Excel bereinigen, mit einer Funktion oder Formel oder mit Power Query. Natürlich stehen Ihnen auch Programmiersprachen zur Verfügung - aber darum soll es in diesem Buch nicht gehen. Neben dem zentralen Thema "Daten in Form bringen", besser: die Daten so aufzubereiten, dass man mit ihnen effektiv arbeiten oder dass ein anderes System sie weiterverarbeiten kann stehen einige weitere, kleinere Themen im Zentrum:- Excel schneller machen- Power Query schneller machen- Sachen "verstecken"- Sachen finden

  • af Kevin Wilson
    210,95 kr.

    Unlock the full potential of Microsoft Excel with this comprehensive guide written by best-selling technology author and trainer Kevin Wilson. Whether you're beginning with the basics or an experienced user aspiring to enhance your skills, Using Microsoft Excel is your indispensable guide to navigating and mastering one of the world's leading spreadsheet applications.Using Microsoft Excel is packed with easy-to-follow instructions, full color illustrative photos, screenshots, and helpful tips, including video demos for a hands-on learning experience. In this guide you'll learn:User-Friendly Navigation: Start with the basics of the Microsoft Excel's interface and learn how to use the ribbon menu and backstage view.Spreadsheet Mastery: Learn how to create spreadsheets, manage data entry, and master text formatting.Stylish Data Presentation: Learn how to style and present your work in Microsoft Excel with sophisticated formatting options, borders, color-coding, and conditional formatting.Formulas and Basic Functions: Construct custom formulas and use built in functions to calculate, analyze, and transform your data.Advanced Excel Functions: Go beyond the basics with Lookup, Index, IF/Date/Text/nested functions, cell referencing and other advanced tools to streamline your data processing.Compelling Charts and Analytics: Transform data from Microsoft Excel spreadsheets into informative charts and master layouts to visually communicate your data.Efficient Workbook Management: Manage your Microsoft Excel environment effectively. Learn about file management and workbook navigation as well as printing and exporting worksheets.In-Depth Data Analysis: Explore advanced tools such as goal seek and scenarios for professional-level data analysis. As well as a look at the ToolPak and Solver add-ins.PivotTable Proficiency: Become adept at creating pivot tables and pivot charts for dynamic data breakdowns and insights.Excel Extensions: Extend the functionality of Microsoft Excel with various add-ins to meet your specific analytical needs.Macros & VBA Introduction: Step into the world of Macros and VBA to automate tasks and boost your productivity.Seamless Collaboration: Discover strategies for effective teamwork in Microsoft Excel with workbook sharing, real-time co-authoring and commenting.Flawless Data Validation: Ensure data integrity with various validation techniques, essential for accurate data management.This guide is an indispensable resource for learning the intricacies of Microsoft Excel, designed to enhance your abilities and provide you with the expertise necessary to craft professional-quality spreadsheets with ease. So scroll up and get your copy of Using Microsoft Excel today!

  • af Ritu Arora
    194,95 - 222,95 kr.

  • af Andrew Blake
    275,95 kr.

    How to Master iWork Suite, Pages, Numbers and Keynote Even as a Non-Tech-Savvy!Here's the deal... On average most people use less than 5% of programs' full potential at any given time.I can't tell you enough how many people I see not just struggling to use a program like Pages, Numbers, Keynote, and others, but also... wasting so much time doing things that should take minutes and even seconds instead of hours and days.For this exact reason, I created this amazing, in-depth book BUNDLE - to help you master these programs in no time, even if you don't have any experience.Here is what's inside:BOOK #1: PAGESBOOK #2: NUMBERSBOOK #3: KEYNOTEIn this bundle you will quickly learn: · Ins and Outs of each program· How to learn the fundamentals fast and use main functions effectively· Different kinds of shortcuts and tips for smart use and speed· Differences between them and when you should choose which program for a specific task· Unique elements and functions you have to be aware of but probably have never used· So much more!And even if you don't have any experience whatsoever, or just bought your Apple device a few days ago and now you are wondering what the best and simplest way to master iWork Suite is, this book is for you!Get Your Copy Today and Become an iWork Suite Expert!

  • af Bolakale Aremu
    247,95 kr.

    Es ampliamente aceptado que cerca del 60 por ciento de los usuarios de Excel dejan el 80 por ciento de Excel intacto. Es decir, la mayoría de los usuarios no aprovechan todo el potencial de las utilidades integradas de Excel. De estas utilidades, las más prolíficas con diferencia son la tabla dinámica y los gráficos dinámicos. A pesar de que las tablas dinámicas y los gráficos han sido una piedra angular de Excel durante más de 16 años, siguen siendo una de las herramientas más infrautilizadas en toda la suite de Microsoft Office.Habiendo encontrado este libro, eres lo suficientemente inteligente como para haber oído hablar de tablas dinámicas y gráficos o incluso haberlos usado en ocasiones. Tiene la sensación de que las tablas dinámicas y los gráficos tienen algún poder que no está utilizando, y desea aprender a aprovechar ese poder para aumentar su productividad rápidamente.Con solo este libro, podrá crear tablas dinámicas y gráficos básicos, aumentar su productividad y producir informes en minutos en lugar de horas.Dentro de los primeros 3 capítulos, podrá generar informes dinámicos complejos con capacidades de desglose que acompañan a los gráficos. Al final del libro, podrá crear un sistema dinámico de informes de tabla dinámica.

  • af Meni Porat
    367,95 kr.

    Unleash the power of SEQUENCE to simplify complex array calculations and automate repetitive tasks. Discover techniques to efficiently perform calculations, text manipulation, financial and numerical analysis using SEQUENCE.

  • af Nathan George
    487,95 - 537,95 kr.

  • af Santosh Cholle
    227,95 kr.

    THE EXCEL EDGE This comprehensive guide is designed for those who wants to get familiar with Excel basics and are also ready to dive into the advanced features and techniques that will give them an advantage in business and beyond. From advanced formulas and functions to data analysis and automation, this book will empower you to excel in your data-driven endeavours. With step-by-step instructions, real-world examples, and practical tips, you'll unlock the full potential of Excel and become a proficient Excel power user. Inside ""The Excel Edge,"" you'll discover advanced Excel techniques, including:· Advanced formulas and functions· Data analysis and visualization · Automation and optimization· Power Query· Tips and tricks for advanced users ""The Excel Edge"" is your comprehensive guide to mastering advanced Excel techniques and taking your skills to the next level. Whether you're a business professional, data analyst, financial expert, or anyone who works with data, this book will equip you with the tools you need to excel in your field. Get ready to unlock the full power of Excel with ""The Excel Edge"" and gain a competitive advantage in your Excel endeavours.

  • af Nathan George
    272,95 kr.

    Gain expert Excel skills and easily perform complex tasksWhether you have basic Excel skills or you're a power user, Excel 365 Advanced Topics is full of tips, techniques, and tools that will save you time and effort in performing challenging tasks in Excel. When building complicated spreadsheet solutions, using the right tool in Excel can increase the accuracy and efficiency of your work. This book does not only show you how to use specific features but also in what context those features need to be used.Get real-world solutions for your dataExcel 365 Advanced Topics focuses on a selection of topics relevant to real-world productivity tasks you're likely to perform at home or at work requiring more than a basic knowledge of Excel. Even if you're an Excel power user, you'll find lots of ideas and tips in this book that will save you time and effort.Includes tons of examples and readymade formulas that you can copy and use in your own worksheets. The downloadable practice files enable you to follow the book hands-on, which is the best way to learn.This book covers Excel for Microsoft 365 (2023 update).In this book, you'll learn how to:Transform data in Excel using the Power Query Editor.Remove duplicate rows from a data list.Consolidate data from different worksheets or workbooks.Import and use data from external sources like Microsoft Access databases, CSV text files, and websites.Troubleshoot and fix formula errors with various tools.Use functions like IFS and SUMIFS to create simpler but more efficient conditional formulas in place of convoluted nested IF functions.Use modern dynamic array functions like TEXTBEFORE, TEXTAFTER, and TEXTSPLIT to manipulate text strings.Carry out financial calculations with functions like PV, FV, and NPV.Use Macros to automate Excel tasks.Analyze different data scenarios and create projections with What-If Analysis tools.Dynamically analyze large sets of data with Pivot Tables and Pivot Charts.Protect your workbook, worksheets, or specific cells in your worksheets from unauthorized or accidental changes.

  • af A. J. Wright
    317,95 kr.

    This book is for every Excel user. It is widely agreed that close to 60 percent of Excel users leave 80 percent of Excel untouched. That is, most users do not tap into the full potential of Excel's built-in utilities. Of these utilities, the most prolific by far are the pivot table and pivot charts. Despite the fact that pivot tables and charts have been a cornerstone of Excel for more than 16 years, they remain one of the most underutilized tools in the entire Microsoft Office Suite.Having discovered this book, you are savvy enough to have heard of pivot tables and charts or even have used them on occasion. You have a sense that pivot tables and charts have some power that you are not using, and you want to learn how to leverage that power to increase your productivity quickly.With only this book, you will be able to create basic pivot tables and charts, increase your productivity, and produce reports in minutes instead of hours. Within the first 3 chapters, you will be able to output complex pivot reports with drill-down capabilities accompanying charts. By the end of the book, you will be able to build a dynamic pivot table reporting system.

  • af Sophie Johnson
    132,95 kr.

    Are you tired of feeling overwhelmed by Excel and Google Spreadsheets? Are you ready to master the tools that will make you a valuable asset in the business world? Look no further! "Bossing Spreadsheets" is the ultimate guide for young women who are entering the business world and need to excel in their daily work life. Written by a woman, for women, this book is packed with concise, engaging and easy-to-understand information on how to use and become extraordinary with Excel and Google Spreadsheets. From setting up your spreadsheet to customizing the interface, from data analysis and visualization to collaboration and automation, this book covers it all. With real-life scenarios and advanced tips and tricks, you'll be able to apply your skills in practice and stay ahead in business. Don't let anyone tell you that spreadsheets are just for the boys, you're a girlboss and you're here to conquer the business world with data. Start your journey to becoming a spreadsheet queen!

  • af M. L. Humphrey
    107,95 kr.

    Pivot tables are one of the most valuable tools in Microsoft Excel. They let you quickly summarize a large data table and slice and dice that data any way that you want. You can even create a dynamic chart from that data using pivot charts.This book provides a detailed introduction to using pivot tables as well as pivot charts, although it does presume prior familiarity with regular charts in Excel. * * * This book is part of the Easy Excel 365 Essentials series of titles. These are targeted titles that are excerpted from the main Excel 365 Essentials series and are focused on one specific topic.If you want a more general introduction to Excel, then you should check out the Excel 365 Essentials titles instead. In this case, Intermediate Excel 365 which covers pivot tables as well as a number of other topics, such as charts and conditional formatting.

  • af M. L. Humphrey
    107,95 kr.

  • af M. L. Humphrey
    107,95 kr.

  • af M. L. Humphrey
    187,95 - 272,95 kr.

  • af M. L. Humphrey
    272,95 kr.

  • af M. L. Humphrey
    107,95 kr.

  • af M. L. Humphrey
    187,95 - 272,95 kr.

  • af Jonas Tritschler
    1.032,95 kr.

    Running accounting in SAP S/4HANA Finance? This is your hands-on guide! Learn how financial accounting works with the Universal Journal and understand key organizational structures. Get step-by-step instructions to perform your finance tasks for the general ledger, accounts payable, accounts receivable, fixed assets, and customer projects and billing. With details on both classic SAP GUI transactions and modern SAP Fiori apps, as well as coverage of new event-based revenue recognition, you'll find everything you need in these pages!In this book, you'll learn about:a. Finance Fundamentals Explore the processes that make up financial accounting: order to cash, purchase to pay, acquire to retire, and record to report. Understand the organizational structures and general ledger master data that provide the foundation to FI. b. Tasks and Transactions Walk through your core accounting activities, click by click. Post journal entries in the general ledger, create customer and vendor invoices, make payments, process bank statements, manage assets, set up customer projects, and more. c. Period-End Close and ReportingClose your books and report on your data. In each finance subarea, perform key tasks such as reconciliation, foreign currency valuation, and reclassifications. Learn about key transactions and apps that are available for reporting. Highlights include:1) General ledger accounting2) Accounts payable3) Accounts receivable4) Fixed assets5) Customer projects6) Event-based revenue recognition7) Organizational structure8) Period-end close9) Reporting10) SAP GUI transactions11) SAP Fiori applications

  • af Ina Koys
    132,95 kr.

  • af Nathan George
    257,95 - 327,95 kr.

  • af Isaac Gottlieb
    254,95 kr.

    No matter what your professional or academic status is, if you often engage in data analysis, summary creation, and report writing, this book is for you. You''ll be able to generate relatively strong reports and infographics from your data, thereby allowing you to make more well-informed decisions.

Gør som tusindvis af andre bogelskere

Tilmeld dig nyhedsbrevet og få gode tilbud og inspiration til din næste læsning.