Aplikacje biurowe
Jak wykonać skomplikowane obliczenia w arkuszu kalkulacyjnym? Jak napisać i poprawnie sformatować urzędowe pismo w edytorze tekstu albo wykonać interesującą prezentację dla szefa? Tutaj znajdziecie odpowiedź.
Podręczniki w tym dziale pozwolą poznać tajniki najbardziej popularnych aplikacji biurowych jak pakiet MS Office czy Open Office, poczty elektronicznej jak Outlook, czy zagadnień języka programowania VBA oraz w pełni wykorzystać potencjał jaki te programy oferują. Nauczycie się jak aktywnie zarządzać budżetem w MS Project, tworzyć prezentację w PowerPoint slajd po slajdzie, oraz znajdziecie tu szereg wskazówek i porad jak usprawnić Waszą pracę z programami Excel czy Word.
Crystalynn Shelton
Unlock smarter, faster, and more confident bookkeeping with the new edition of the bestselling Mastering QuickBooks series – the most comprehensive guide to US QuickBooks Online. Written for small business owners, bookkeepers, accountants, and ProAdvisors, it takes you from setup and fundamentals through advanced workflows, real-world case studies, and Intuit’s newest AI-powered tools.You’ll learn how to automate invoices, payments, and expense tracking with AI Agents, and how to use Intuit Assist for reconciliations, cash flow analysis, and forecasting. Expanded coverage of eCommerce integrations with Shopify, Amazon, and Square helps you simplify multi-channel sales, while updated payroll, inventory, and compliance chapters ensure you stay aligned with the latest regulations. Three in-depth case studies – retail, services, and property management show QuickBooks in action, making it easy to apply your learning to real businesses. Whether you’re new to QuickBooks or a seasoned professional, this edition will help you save time, reduce errors, and make smarter financial decisions with confidence.
Crystalynn Shelton, Dr. Megan Hanna
Mastering QuickBooks® 2025 is the definitive guide for small-business owners, bookkeepers, and accounting students. This new edition covers both the fundamentals, like setting up the US version of QuickBooks Online, as well as advanced features, like integrating with e-commerce platforms. You'll grasp core business transactions such as sales, expenses, and payroll while ensuring compliance with tax regulations. You'll gain complete mastery of the US-based QuickBooks Online features—from setting up the platform to fi ling taxes like a professional.Updated for the latest QuickBooks 2025, this book introduces advanced topics like time tracking for hourly billing, inventory management techniques, and real-time financial reporting. Detailed guidance on payroll processing and 1099 contractor tracking is also included to help manage your financial operations. With the purchase of the book, you'll gain access to bonus chapters and video tutorials by the author, off erring deeper insights on how to navigate key reports, reconcile bank transactions, sharpen bookkeeping fundamentals, and generate detailed sales and expense reports.By the end of this book, you'll know how to effectively leverage QuickBooks Online for the fi nancial management of your business.
Mastering Salesforce CRM Administration. An Advanced Administration Certification Handbook
Rakesh Gupta
The book starts by refreshing your knowledge of common admin tasks. You will go over Lightning Experience and various security aspects. You will be shown how to implement territory management in your organization and make use of custom objects.From here, the book progresses to advanced configuration, data management, and data analytics before swiftly moving on to setting up advanced organization-wide features that affect the look and feel of the application. Extend the capabilities of your organization’s Salesforce implementation by optimizing and extending Sales Cloud, Salesforce1, and Service Cloud applications. This guide will equip you with the tools you need to build a successful career in Salesforce.
Andrew Kindred
Industry giants like RedHat and NetApp have adopted ServiceNow for their operational needs, and it is evolving as the number one platform choice for IT Service management. ServiceNow provides their clients with an add-on when it comes to baseline instances, where scripting can be used to customize and improve the performance of instances. It also provides inbuilt JavaScript API for scripting and improving your JavaScript instance.This book will initially cover the basics of ServiceNow scripting and the appropriate time to script in a ServiceNow environment. Then, we dig deeper into client-side and server-side scripting using JavaScipt API. We will also cover advance concepts like on-demand functions, script actions, and best practices. Mastering ServiceNow Scripting acts as an end-to-end guide for writing, testing, and debugging scripts of ServiceNow. We cover update sets for moving customizations between ServiceNow instances, jelly scripts for making custom pages, and best practices for all types of script in ServiceNow.By the end of this book, you will have hands-on experience in scripting ServiceNow using inbuilt JavaScript API.
Mastering Spring Boot 2.0. Build modern, cloud-native, and distributed systems using Spring Boot
Dinesh Rajput
Spring is one of the best frameworks on the market for developing web, enterprise, and cloud ready software. Spring Boot simplifies the building of complex software dramatically by reducing the amount of boilerplate code, and by providing production-ready features and a simple deployment model.This book will address the challenges related to power that come with Spring Boot's great configurability and flexibility. You will understand how Spring Boot configuration works under the hood, how to overwrite default configurations, and how to use advanced techniques to prepare Spring Boot applications to work in production. This book will also introduce readers to a relatively new topic in the Spring ecosystem – cloud native patterns, reactive programming, and applications. Get up to speed with microservices with Spring Boot and Spring Cloud. Each chapter aims to solve a specific problem or teach you a useful skillset. By the end of this book, you will be proficient in building and deploying your Spring Boot application.
Marleen Meier, David Baldwin
Tableau is one of the leading business intelligence (BI) tools used to solve BI and analytics challenges. With this book, you will master Tableau's features and offerings in various paradigms of the BI domain. This book is also the second edition of the popular Mastering Tableau series, with new features, examples, and updated code. The book covers essential Tableau concepts and its advanced functionalities. Using Tableau Hyper and Tableau Prep, you’ll be able to handle and prepare data easily. You’ll gear up to perform complex joins, spatial joins, union, and data blending tasks using practical examples. Following this, you’ll learn how to perform data densification to make displaying granular data easier. Next, you’ll explore expert-level examples to help you with advanced calculations, mapping, and visual design using various Tableau extensions. With the help of examples, you’ll also learn about improving dashboard performance, connecting Tableau Server, and understanding data visualizations. In the final chapters, you’ll cover advanced use cases such as Self-Service Analytics, Time Series Analytics, and Geo-Spatial Analytics, and learn to connect Tableau to R, Python, and MATLAB. By the end of this book, you’ll have mastered the advanced offerings of Tableau and be able to tackle common and not-so-common challenges faced in the BI domain.
Paolo Valsecchi, Karel Novak, Andrea Mauro
VMware vSphere 6.5 provides a powerful, flexible and secure foundation for next-generation applications which helps you create an effective digital transformation. This book will be based on VMware vSphere 6.5 which empowers you to virtualize any complex application with ease. You’ll begin by getting an overview of all the products, solutions and features of the vSphere 6.5 suite, comparing the evolutions with the previous releases. Next ,you’ll design and plan a virtualization infrastructure to drive planning and performance analysis. Following this , you will be proceeding with workflow and installation of components. New network trends are also covered which will help you in optimally designing the vSphere environment. You will also learn the practices and procedures involved in configuring and managing virtual machines in a vSphere infrastructure. With vSphere 6.5, you’ll make use of significantly more powerful capabilities for patching, upgrading, and managing the configuration of the virtual environment. Next we’ll focus on specific availability and resiliency solutions in vSphere. Towards the end of the book you will get information on how to save your configuration, data and workload from your virtual infrastructure. By the end of the book you’ll learn about VMware vSphere 6.5 right from design to deployment and management.
Mastering Zendesk. Click here to enter text
Cedric F. Jacob
Zendesk is a cloud-based customer service solution that is widely used because it is easy, efficienct, flexible, and low cost. It is highly scalable and is great for organizations of all sizes. If you’re a Zendesk administrator and are looking to explore advanced-level concepts, then this book is for you. It covers the core functionalities such as managing users, groups, and the organization, and creating and adding custom fields. You will learn how to add customized ticket channels to your account. Then, you will focus on customizing business rules and extending Zendesk with JIRA and Salesforce. Towards the end, the book emphasizes security and troubleshooting aspects as well as providing tips and tricks to create a more efficient support environment.By the end of this book, you will be able to turn a basic Zendesk setup into a highly customized working environment.
Sherry Li, Tomislav Piasevoli
MDX is the BI industry standard for multidimensional calculations and queries. Proficiency with this language is essential for the realization of your Analysis Services' full potential. MDX is an elegant and powerful language, and also has a steep learning curve.SQL Server 2012 Analysis Services has introduced a new BISM tabular model and a new formula language, Data Analysis Expressions (DAX). However, for the multi-dimensional model, MDX is still the only query and expression language. For many product developers and report developers, MDX is the preferred language for both the tabular model and multi-dimensional model.MDX with SSAS 2012 Cookbook is a must-have book for anyone who wants to be proficient in the MDX language and to enhance their business intelligence solutions.MDX with SSAS 2012 Cookbook is packed with immediately usable, practical solutions. It starts with elementary techniques that lay the foundation for designing advanced MDX calculations and queries. The discussions after each solution will provide you with a solid foundation and best practices. It covers a broad range of real-world topics and solutions and provides you with learning materials to become proficient in the language.This book will guide you through the hands-on and practical MDX solutions, best practices, and many intricacies that hide within the MDX calculations and queries.We will start by working with sets, creating time-aware, context-aware calculations, and business analytics solutions, through to the techniques of enhancing the cube design when MDX is not enough. We will then move on to capturing MDX generated by SSAS front-ends and using SSAS stored procedures, and we will explore the whole range of MDX solutions for real-world BI projects.
Nate Chamberlain
Organizations across the world have switched to Office 365 to boost workplace productivity. However, to maximize investment in Office 365, you need to know how to efficiently administer Office 365 solutions.Microsoft Office 365 Administration Cookbook is packed with recipes to guide you through common and not-so-common administrative tasks throughout Office 365. Whether you’re administering a single app such as SharePoint or organization-wide Security & Compliance across Office 365, this cookbook offers a variety of recipes that you’ll want to have to hand. The book begins by covering essential setup and administration tasks. You’ll learn how to manage permissions for users and user groups along with automating routine admin tasks using PowerShell. You’ll then progress through to managing core Office 365 services such as Exchange Online, OneDrive, SharePoint Online, and Azure Active Directory (AD). This book also features recipes that’ll help you to manage newer services such as Microsoft Search, Power Platform, and Microsoft Teams. In the final chapters, you’ll delve into monitoring, reporting, and securing your Office 365 services.By the end of this book, you’ll have learned about managing individual Office 365 services along with monitoring, securing, and optimizing your entire Office 365 deployment efficiently.
Nate Chamberlain
Organizations across the world have switched to Office 365 to boost workplace productivity. However, to maximize investment in Office 365, you need to know how to efficiently administer Office 365 solutions.Microsoft Office 365 Administration Cookbook is packed with recipes to guide you through common and not-so-common administrative tasks throughout Office 365. Whether you’re administering a single app such as SharePoint or organization-wide Security & Compliance across Office 365, this cookbook offers a variety of recipes that you’ll want to have to hand. The book begins by covering essential setup and administration tasks. You’ll learn how to manage permissions for users and user groups along with automating routine admin tasks using PowerShell. You’ll then progress through to managing core Office 365 services such as Exchange Online, OneDrive, SharePoint Online, and Azure Active Directory (AD). This book also features recipes that’ll help you to manage newer services such as Microsoft Search, Power Platform, and Microsoft Teams. In the final chapters, you’ll delve into monitoring, reporting, and securing your Office 365 services.By the end of this book, you’ll have learned about managing individual Office 365 services along with monitoring, securing, and optimizing your entire Office 365 deployment efficiently.
Gaurav Mahajan, Sudeep Ghatak, Nate Chamberlain, Scott...
Microsoft 365 offers tools for content management, communication, process automation, and report creation. Microsoft 365 and SharePoint Online Cookbook maximizes workplace collaboration and productivity using SharePoint Online, Teams, OneDrive, Delve, M365 Search, Copilot, Power Platform, Viva, Planner, and Microsoft Forms.You will find thoroughly updated recipes for SharePoint Online, covering sites, lists, libraries, pages, web parts, and learn SharePoint Framework (SPFx) basics for building solutions. You will explore many Microsoft Teams recipes to prepare it to be your organization’s central collaboration hub. You will be able to unlock Power Platform potential with recipes for Power Apps to enable low-code/no-code app development and learn to automate tasks with Power Automate and Power Automate Desktop. The book teaches you data visualization with Power BI, and chatbot creation with Power Virtual Agents (Copilot Studio). Finally, you will also learn about the cutting-edge Copilot and Gen AI functionality in Microsoft 365 and Power Platform. By the end, you will be equipped with skills to effectively use Microsoft 365, SharePoint Online, and the Power Platform.Whether it's enhancing career prospects or improving business operations, this book is a perfect companion on your journey through the Microsoft Office 365 suite.*Email sign-up and proof of purchase required
Gaurav Mahajan, Sudeep Ghatak, Nate Chamberlain, Scott...
Microsoft 365 offers tools for content management, communication, process automation, and report creation. Microsoft 365 and SharePoint Online Cookbook maximizes workplace collaboration and productivity using SharePoint Online, Teams, OneDrive, Delve, M365 Search, Copilot, Power Platform, Viva, Planner, and Microsoft Forms.You will find thoroughly updated recipes for SharePoint Online, covering sites, lists, libraries, pages, web parts, and learn SharePoint Framework (SPFx) basics for building solutions. You will explore many Microsoft Teams recipes to prepare it to be your organization’s central collaboration hub. You will be able to unlock Power Platform potential with recipes for Power Apps to enable low-code/no-code app development and learn to automate tasks with Power Automate and Power Automate Desktop. The book teaches you data visualization with Power BI, and chatbot creation with Power Virtual Agents (Copilot Studio). Finally, you will also learn about the cutting-edge Copilot and Gen AI functionality in Microsoft 365 and Power Platform. By the end, you will be equipped with skills to effectively use Microsoft 365, SharePoint Online, and the Power Platform.Whether it's enhancing career prospects or improving business operations, this book is a perfect companion on your journey through the Microsoft Office 365 suite.*Email sign-up and proof of purchase required
Gaurav Mahajan, Sudeep Ghatak
Microsoft Office 365 provides tools for managing organizational tasks like content management, communication, report creation, and business automation processes. With this book, you'll get to grips with popular apps from Microsoft, enabling workspace collaboration and productivity using Microsoft SharePoint Online, Teams, and the Power Platform.In addition to guiding you through the implementation of Microsoft 365 apps, this practical guide helps you to learn from a Microsoft consultant's extensive experience of working with the Microsoft business suite. This cookbook covers recipes for implementing SharePoint Online for various content management tasks. You'll learn how to create sites for your organization and enhance collaboration across the business and then see how you can boost productivity with apps such as Microsoft Teams, Power Platform, Planner, Delve, and M365 Groups. You'll find out how to use the Power Platform to make the most of Power Apps, Power Automate, Power BI, and Power Virtual Agents. Finally, the book focuses on the SharePoint framework, which helps you to build custom Teams and SharePoint solutions.By the end of the book, you will be ready to use Microsoft 365 and SharePoint Online to enhance business productivity using a broad set of tools.
Gaurav Mahajan, Sudeep Ghatak
Microsoft Office 365 provides tools for managing organizational tasks like content management, communication, report creation, and business automation processes. With this book, you'll get to grips with popular apps from Microsoft, enabling workspace collaboration and productivity using Microsoft SharePoint Online, Teams, and the Power Platform.In addition to guiding you through the implementation of Microsoft 365 apps, this practical guide helps you to learn from a Microsoft consultant's extensive experience of working with the Microsoft business suite. This cookbook covers recipes for implementing SharePoint Online for various content management tasks. You'll learn how to create sites for your organization and enhance collaboration across the business and then see how you can boost productivity with apps such as Microsoft Teams, Power Platform, Planner, Delve, and M365 Groups. You'll find out how to use the Power Platform to make the most of Power Apps, Power Automate, Power BI, and Power Virtual Agents. Finally, the book focuses on the SharePoint framework, which helps you to build custom Teams and SharePoint solutions.By the end of the book, you will be ready to use Microsoft 365 and SharePoint Online to enhance business productivity using a broad set of tools.
Aaron Guilmette, Yura Lee, Marcos Zanre
Microsoft 365 Certified Fundamentals certification demonstrates your foundational knowledge of adopting cloud services, specifically the software as a service (SaaS) model. Exam MS-900 tests your understanding of Microsoft 365 services, components, their implementation, security, licensing, and general cloud concepts. This updated second edition covers all the recent and important changes in the examination in detail to help you achieve certification.You’ll begin by exploring key topics such as Microsoft security and compliance policies, pricing and support, and cloud concepts. The book helps you to understand these concepts with the help of real-world scenarios, learning about platform services such as Microsoft Windows, SharePoint, Microsoft 365 apps, Teams, and Exchange. The content has been updated to include Microsoft Forms, Power Platform, Microsoft 365 Security Center, Windows Virtual Desktop, and Insider Risk Management. Each chapter contains a section that will test your knowledge of the core concepts covered. Finally, you’ll take a practice exam with extra questions to help prepare you for the actual test.By the end of this MS-900 book, you’ll be well-equipped to confidently pass the MS-900 certification exam with the help of the updated exam pattern.
Gustavo Moraes, Douglas Romao
With its extensive set of tools and features for improving productivity and collaboration, Microsoft 365 is being widely adopted by organizations worldwide. This book will help not only developers but also business people and those working with information to discover tips and tricks for making the most of the apps in the Microsoft 365 suite.The Microsoft 365 Fundamentals Guide is a compendium of best practices and tips to leverage M365 apps for effective collaboration and productivity. You'll find all that you need to work efficiently with the apps in the Microsoft 365 family in this complete, quick-start guide that takes you through the Microsoft 365 apps that you can use for your everyday activities. You'll learn how to boost your personal productivity with Microsoft Delve, MyAnalytics, Outlook, and OneNote. To enhance your communication and collaboration with teams, this book shows you how to make the best use of Microsoft OneDrive, Whiteboard, SharePoint, and Microsoft Teams. You'll also be able to be on top of your tasks and your team's activities, automating routines, forms, and apps with Microsoft Planner, To-Do, Power Automate, Power Apps, and Microsoft Forms.By the end of this book, you'll have understood the purpose of each Microsoft 365 app, when and how to use it, and learned tips and tricks to achieve more with M365.
Heather Ackmann, Bill Kulterman, Ramit Arora
If you’re proud of yourself for finally learning how to use keyboard shortcuts and the search function, but still skip a beat when asked to generate a table of contents, then this book is for you. Written by two experts who’ve been teaching the world about Word for decades, Microsoft 365 Word Tips and Tricks is a powerhouse of demystifying advice that will take you from Word user to Word master.This book takes you on a step-by-step journey through Word essentials with plenty of practical examples. With it, you'll explore different versions of Microsoft Word, its full functionality, and understand how these versions impact collaboration with others. Each chapter focuses on a different aspect of working with the legendary text editor, including a whole chapter dedicated to concentrating better with the help of Word. Expert advice will fill your knowledge gaps and teach you how to work more productively and efficiently with text, images, styles, and even macros.By the end of this book, you will be able to make better documents faster and troubleshoot any Word-related problem that comes your way. And because of its clear and cohesive structure, you can easily come back to refresh your knowledge whenever you need it.
Microsoft Access. Przewodnik dla użytkowników Excela
Michael Alexander
Rozszerz swój wachlarz narzędzi do analizy o Accessa! Kiedy wybrać Excela, a kiedy Accessa? Jak wykonać raport i wizualizować dane w Accessie? Jak zintegrować Excel z Accessem? Excel to obok Worda najpopularniejsze narzędzie znajdujące się w pakiecie Microsoft Office. Narzędzie, bez którego nie wyobrażają sobie pracy analitycy, księgowi i prezesi firm. Dzięki ogromnym możliwościom oraz łatwości użycia znajduje on zastosowanie wszędzie tam, gdzie trzeba dokonać obliczeń na dużych ilościach danych. Czy Excel jest jednak lekarstwem na wszystko? Otóż nie! Pakiet Microsoft Office posiada w swych szeregach jeszcze jednego asa - program Access. Jeżeli zależy Ci na bezproblemowej współpracy kilku osób nad jednym zbiorem danych, jeżeli chcesz oddzielić wygląd raportu od danych, a w dodatku wymagasz skalowalności, Access może okazać się lepszym wyborem. Nie obawiaj się nowego! Dzięki tej książce błyskawicznie zapoznasz się ze środowiskiem, filozofią pracy oraz możliwościami Accessa. Książka odpowiada na wiele pytań, w tym na jedno kluczowe - kiedy lepszy jest Excel, a kiedy Access. Ponadto znajdziesz tu odpowiedzi na pytania dotyczące danych, ich struktur oraz metod analizy. Dowiesz się, jak korzystać z kwerend agregujących, funkcjonalnych oraz krzyżowych. Z pewnością zainteresują Cię również rozdziały poświęcone analizom warunkowym oraz tworzeniu raportów i wizualizacji danych w programie Access. Ostatni rozdział pozwoli Ci połączyć świat, który znasz - świat Excela, z tym, który poznałeś w trakcie lektury - światem Accessa. Integracja tych dwóch narzędzi zdejmie z Ciebie wszelkie ograniczenia w codziennej pracy z danymi o dowolnej wielkości i złożoności. Przekonaj się o tym sam! Trudny wybór - Access czy Excel Podstawy Accessa - tabele, teoria relacyjnych baz danych, kwerendy Kwerendy wybierające, funkcjonalne, usuwające, aktualizujące Wykorzystanie kwerend krzyżowych Transformacja danych za pomocą programu Access Wykonywanie obliczeń oraz przetwarzanie dat Analizy warunkowe Zastosowanie podkwerend i domenowych funkcji agregacji Statystyki opisowe w Accessie Planowanie zadań Wykorzystanie VBA do usprawnienia procesu analizy Tworzenie raportów w Accessie Wykorzystanie tabel i wykresów przestawnych Przenoszenie danych z Accessa do Excela Integracja Accessa z Excelem Tworzenie zapytań SQL Znasz Excel? Poznaj też Access - szybko i przyjemnie!