Search results for """ "Vba Excel 2021 y Microsoft 365""
Pearson Education (US) Microsoft Excel VBA and Macros Office 2021 and
Book SynopsisBill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 2,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 57 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenchesworking as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives in Merritt Island, Florida, with his wife, Mary Ellen. Tracy Syrstad is a Microsoft Excel developer and author of nine Excel books. She has been helping people with Microsoft Office issues since 1997, when she discovered free online forums where anyone could ask and answer questions. Tracy found out she enjoyed teaching others new skills, and when she began working as a developer, she was able to integrate the fun of teaching with one-on-one online desktop sharing sessions. Tracy lives on an acreage in eastern South Dakota with her husband, one dog, two cats, one horse, and a variety of wild foxes, squirrels, and rabbits.Table of ContentsIntroduction 1. Unleash the Power of Excel with VBA 2. This Sounds Like BASIC, So Why Doesn't It Look Familiar? 3. Referring to Ranges 4. Looping and Flow Control 5. R1C1-style Formulas 6. Creating and manipulating Names in VBA 7. Event Programming 8. Arrays 9. Creating Classes and Collections 10. Userforms: An Introduction 11. Data Mining with Advanced Filter 12. Using VBA to Create Pivot Tables 13. Excel Power 14. Sample User-Defined Functions 15. Creating Charts 16. Data Visualizations and Conditional Formatting 17. Dashboarding with Sparklines in Excel 18. Reading from the Web using M and VBA 19. Text File Processing 20. Automating Word 21. Using Access as a Back End to Enhance Multiuser Access to Data 22. Advanced Userform Techniques 23. Windows Application Programming Interface (API) 24. Handling Errors 25. Customizing the Ribbon to Run Macros 26. Creating Excel Add-Ins 27. An Introduction to Creating Office Add-ins 28. What's New in Excel 365 and What's Changed
£30.59
Tablas dinámicas con Excel Analice sus datos de forma eficaz versiones 2021 2024 y Microsoft 365
Book SynopsisDestinado a todas las personas cuya función requiere la realización de análisis de datos a partir de fuentes variadas, este libro sobre la creación de tablas dinámicas con Excel, le permitirá convertirse en un verdadero experto en la creación, explotación y análisis de tablas dinámicas. Redactado con la versión Microsoft 365 de Excel y cubriendo también las versiones 2021 y 2024, esta guía práctica le acompaña paso a paso en el dominio de esta poderosa herramienta. Gracias a los numerosos ejemplos concretos y ejercicios prácticos propuestos, aprenderá a realizar análisis profundos, agrupaciones pertinentes, filtros eficaces y a utilizar segmentos y cronologías para afinar sus datos. Así, los campos, los elementos calculados y los gráficos dinámicos ya no tendrán secretos para usted. Será capaz de diseñar tablas de análisis pertinentes, funcionales y variadas utilizando una o varias hojas de cálculo de Excel. Podrá automatizar el formato de sus tablas aplicando formatos condicionales, y también podrá automatizar las tareas repetitivas gracias a los numerosos trucos proporcionados. Para profundizar en el uso de las tablas dinámicas, descubrirá cómo utilizar Power Query para importar, transformar y combinar datos provenientes de diversas fuentes, facilitando así la preparación de sus datos. También aprenderá a crear modelos de datos sofisticados con Power Pivot, lo que permitirá realizar análisis más complejos y cálculos avanzados. El último capítulo aborda las herramientas de IA que facilitan la realización de tablas dinámicas (Copilot) y el análisis de datos Los archivos necesarios para la realización de los ejercicios están disponibles para su descarga en el Ediciones ENI: https:// .
£19.85
McGraw-Hill Companies Microsoft Office 365 In Practice 2021 Edition
Book Synopsis
£234.99
OM Book Service Microsoft Office 365
£235.86
McGraw-Hill Education Microsoft Excel 365 Complete In Practice 2019
Book SynopsisTable of ContentsWindows & Office Intro Chapter: Windows 10, Office 365/2019 and File ManagementChapter 1: Creating and Editing WorkbooksChapter 2: Working with Formulas and FunctionsChapter 3: Creating and Editing ChartsChapter 4: Formatting, Organizing, and Getting DataChapter 5: Consolidating and Linking Data and Inserting ObjectsChapter 6: Exploring the Function LibraryChapter 7: Working with Templates and Co-AuthoringChapter 8: Working with MacrosChapter 9: Exploring Data Analysis and MapsChapter 10: Exploring Business IntelligenceChapter 11: Customizing Excel and Using OneDrive and Office Online
£201.92
Pearson Education (US) Microsoft Excel Inside Out Office 2021 and
Book SynopsisTable of ContentsPart I The Excel interface Chapter 1 What's new in Microsoft 365 Excel Chapter 2 Using the Excel interface Chapter 3 Customizing Excel Chapter 4 Keyboard shortcuts Part II Calculating with Excel Chapter 5 Understanding formulas Chapter 6 Controlling formulas Chapter 7 Understanding functions Chapter 8 Using everyday functions: math, date and time, and text functions Chapter 9 Using powerful functions: logical, lookup, and database functions Chapter 10 Using names, LET, LAMBDA, and Data Types in Excel Chapter 11 Connecting worksheets and workbooks Chapter 12 Dynamic array formulas and names in Excel Part III Data analysis with Excel Chapter 13 Transforming data with Power Query Chapter 14 Summarizing data using subtotals or filter Chapter 15 Using pivot tables to analyze data Chapter 16 Using slicers and filtering a pivot table Chapter 17 Mashing up data with Power Pivot Chapter 18 Using What-If, Scenario Manager, Goal Seek, and Solver Chapter 19 Automating repetitive functions using VBA macros Chapter 20 More tips and tricks for Excel Part IV Excel visuals Chapter 21 Formatting worksheets Chapter 22 Using data visualizations and conditional formatting Chapter 23 Graphing data using Excel charts Chapter 24 Using 3D Maps Chapter 25 Using sparklines Chapter 26 Formatting spreadsheets for presentation Chapter 27 Printing Chapter 28 Collaborating in Excel Part V Appendixes Appendix A Excel functions Appendix B Excel functions with DAX or Power Query equivalents Appendix C Adding functionality to Excel with add-ins Index
£34.84
Amazon Digital Services LLC - Kdp Microsoft Office 365
£18.61
John Wiley & Sons Inc Microsoft Excel 365 Bible
Book SynopsisYour 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 Excelfrom 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, chang
£34.00
John Wiley & Sons Inc Mastering VBA for Microsoft Office 365
Book SynopsisCustomize and ramp-up Office 365 applications NOTE:Please click Downloads (located in the menu on the left) to download Full Code Download.The revised 2019 edition of Mastering VBA Microsoft Office 365 offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. To enhance understanding, the content is explored in real-world projects in Word, Excel, Outlook, and PowerPoint. Since the technical programming methods in the Office applications continue to evolve, the updated 2019 edition reviews the changes to the program. Code libraries, the API, and the object model for each Office program have bTable of ContentsIntroduction xxix Part 1 Recording Macros and Getting Started with VBA 1 Chapter 1 Recording and Running Macros in the Office Applications 3 What Is VBA and What Can You Do with It? 3 The Difference between Visual Basic and Visual Basic for Applications 4 What Are Visual Basic NET and Visual Basic Express? 5 Understanding Macro Basics 5 Recording a Macro 6 Displaying the Developer Tab on the Ribbon 7 Planning the Macro 8 Starting the Macro Recorder 10 Naming a Macro 13 Running a Macro 24 Recording a Sample Word Macro 25 Recording a Sample Excel Macro 27 Create a Personal Macro Workbook If You Don’t Have One Yet 28 Record the Macro 29 Specifying How to Trigger an Existing Macro 30 Assigning a Macro to a Quick Access Toolbar Button in Word 30 Assigning a Macro to a Shortcut Key Combination 31 Deleting a Macro 31 The Bottom Line 33 Chapter 2 Getting Started with the Visual Basic Editor 35 Opening the Visual Basic Editor 35 Opening the Visual Basic Editor with a Macro Selected 36 Opening the Visual Basic Editor Directly 37 Navigating to a Macro 37 Using the Visual Basic Editor’s Main Windows 38 The Project Explorer 39 The Object Browser 42 The Code Window 43 The Properties Window 48 The Immediate Window 50 Setting Properties for a Project 51 Customizing the Visual Basic Editor 53 Choosing Editor and View Preferences 54 Choosing and Laying Out the Editor Windows 61 Customizing the Toolbar and Menu Bar 61 Customizing the Toolbox 62 The Bottom Line 66 Chapter 3 Editing Recorded Macros 69 Testing a Macro in the Visual Basic Editor 70 Stepping Through a Macro 71 Setting Breakpoints 73 Commenting Out Lines 74 Stepping Out of a Macro 75 Editing a Word Macro 75 Stepping Through the Transpose_Word_Right Macro 77 Running the Transpose_Word_Right Macro 77 Creating a Transpose_Word_Left Macro 77 Saving Your Work 79 Editing an Excel Macro 79 Unhiding the Personal Macro Workbook 79 Opening a Macro for Editing 81 Editing a Macro 82 Editing a PowerPoint Macro 84 Reducing the Size of Your Macro 88 Saving Your Work 89 The Bottom Line 90 Chapter 4 Creating Code from Scratch in the Visual Basic Editor 93 Setting Up the Visual Basic Editor to Create Macros 93 Creating a Procedure for Word 95 Creating a Macro for Excel 101 Creating a Procedure for PowerPoint 106 Creating a Procedure for Access 112 The Bottom Line 113 Part 2 Learning How to Work with VBA 115 Chapter 5 Understanding the Essentials of VBA Syntax 117 Getting Ready 117 Procedures 118 Functions 119 Subprocedures 119 Statements 119 Keywords 123 Expressions 124 Operators 124 Variables 124 Constants 126 Arguments 126 Specifying Argument Names vs Omitting Argument Names 127 When to Include the Parentheses around an Argument List 128 Objects 129 Collections 129 Properties 130 Methods 130 Events 130 The Bottom Line 132 Chapter 6 Working with Variables, Constants, and Enumerations 135 Working with Variables 136 Choosing Names for Variables 136 Declaring a Variable 138 Choosing the Scope and Lifetime of a Variable 141 Specifying the Data Type for a Variable 148 Working with Constants 155 Declaring Your Own Constants 155 Choosing the Scope or Lifetime for Constants 156 Working with Enumerations 156 The Bottom Line 157 Chapter 7 Using Array Variables 159 What Is an Array? 159 Declaring an Array 161 Storing Values in an Array 163 Multidimensional Arrays 164 Declaring a Dynamic Array 165 Redimensioning an Array 165 Returning Information from an Array 166 Erasing an Array 166 Determining Whether a Variable Is an Array 166 Finding the Bounds of an Array 167 Sorting an Array 167 Searching an Array 171 Performing a Linear Search Through an Array 172 Binary Searching an Array 177 The Bottom Line 182 Chapter 8 Finding the Objects, Methods, and Properties You Need 185 What Is an Object? 185 The Benefits of OOP 185 Understanding Creatable Objects 187 Properties 187 Methods 188 Working with Collections 190 Working with an Object in a Collection 191 Adding an Object to a Collection 192 Finding the Objects You Need 192 Using the Macro Recorder to Add Code for the Objects You Need 192 Using the Object Browser 195 Using Help to Find the Object You Need 201 Using the Auto List Members Feature 205 Using Object Variables to Represent Objects 206 Team Programming and OOP 209 The Bottom Line 211 Part 3 Making Decisions and Using Loops and Functions 213 Chapter 9 Using Built-In Functions 215 What Is a Function? 215 Using Functions 217 Passing Arguments to a Function 219 Using Functions to Convert Data 220 Using the Asc Function to Return a Character Code 221 Using the Val Function to Extract a Number from the Start of a String 221 Using the Str Function to Convert a Number into a String 223 Using the Format Function to Format an Expression 224 Using Predefined Numeric Formats 225 Creating a Numeric Format 226 Creating a Date or Time Format 227 Creating a String Format 228 Using the Chr Function and Constants to Enter Special Characters in a String 229 Using Functions to Manipulate Strings 230 Using the Left, Right, and Mid Functions to Return Part of a String 230 Using the Left Function 232 Using the Right Function 232 Using the Mid Function 233 Using InStr and InStrRev to Find a String Within Another String 235 Using LTrim, RTrim, and Trim to Remove Spaces from a String 237 Using Len to Check the Length of a String 238 Using StrConv, LCase, and UCase to Change the Case of a String 240 Using the StrComp Function to Compare Apples to Apples 241 Using VBA’s Mathematical Functions 242 Using VBA’s Date and Time Functions 244 Using the DatePart t Function to Parse Dates 244 Calculating Time Intervals Using the DateDiff f Function 245 Using the DateAdd d Function to Add or Subtract Time from a Date 246 Using File-Management Functions 246 Checking Whether a File Exists Using the Dir Function 246 Returning the Current Path 248 The Bottom Line 248 Chapter 10 Creating Your Own Functions 251 Components of a Function 252 Creating a Function 254 Starting a Function Manually 254 Starting a Function by Using the Add Procedure Dialog Box 254 Passing Arguments to a Function 256 Declaring the Data Types of Arguments 257 Specifying an Optional Argument 257 Controlling the Scope of a Function 258 Examples of Functions for All VBA-Enabled Office Applications 258 How Functions Return Information 260 Returning Text Data from a Function 260 Creating a Function for Word 263 Creating a Function for Excel 265 Creating a Function for PowerPoint 267 Creating a Function for Access 269 The Bottom Line 271 Chapter 11 Making Decisions in Your Code 273 How Do You Compare Things in VBA? 274 Testing Multiple Conditions by Using Logical Operators 275 If Blocks 278 If Then 278 If Then Else Statements 280 If Then ElseIf Else Statements 282 Creating Loops with If and GoTo 287 Nesting If Blocks 289 Select Case Blocks 291 Syntax 291 Example 292 When Order Matters 294 The Bottom Line 294 Chapter 12 Using Loops to Repeat Actions 297 When Should You Use a Loop? 297 Understanding the Basics of Loops 298 Using For Loops for Fixed Repetitions 299 For Next Loops 299 For Each Next Loops 308 Using an Exit For Statement 308 Using Do Loops for Variable Numbers of Repetitions 309 Do While Loop Loops 310 Do Loop While Loops 314 Do Until Loop Loops 316 Do Loop Until Loops 318 Using an Exit Do Statement 319 Is the Exit Do Statement Bad Practice? 320 While Wend Loops 321 Nesting Loops 322 Avoiding Infinite Loops 325 The Bottom Line 326 Part 4 Using Message Boxes, Input Boxes, and Dialog Boxes 327 Chapter 13 Getting User Input with Message Boxes and Input Boxes 329 Opening a Macro 330 Displaying Status-Bar Messages in Word and Excel 331 Message Boxes 333 The Pros and Cons of Message Boxes 333 Message-Box Syntax 334 Displaying a Simple Message Box 335 Displaying a Multiline Message Box 336 Choosing Buttons for a Message Box 337 Choosing an Icon for a Message Box 338 Setting a Default Button for a Message Box 339 Controlling the Modality of a Message Box 340 Specifying a Title for a Message Box 341 Title Bars Can Provide Useful Information 342 Adding a Help Button to a Message Box 342 Specifying a Help File for a Message Box 343 Using Some Arguments Without Others 344 Retrieving a Value from a Message Box 344 Input Boxes 345 Input-Box Syntax 346 Retrieving Input from an Input Box 348 Forms: When Message Boxes and Input Boxes Won’t Suffice 348 The Bottom Line 349 Chapter 14 Creating Simple Custom Dialog Boxes 351 When Should You Use a Custom Dialog Box? 351 Creating a Custom Dialog Box 352 Designing a Dialog Box 354 Inserting a User Form 354 Choosing User-Form Grid Settings 355 Renaming a User Form 358 Adding Controls to the User Form 360 Grouping Controls 363 Renaming Controls 364 Moving a Control 365 Changing the Caption on a Control 367 Key Properties of the Toolbox Controls 368 Working with Groups of Controls 386 How to Group Controls 386 Ungrouping Controls 386 Sizing Grouped Controls 387 Deleting Grouped Controls 387 Working with One Control in a Group 387 Aligning Controls 388 Placing Controls 389 Adjusting the Tab Order of a Form 389 Linking a Form to a Procedure 391 Loading and Unloading a Form 392 Displaying and Hiding a Form 392 Setting a Default Command Button 393 Retrieving the User’s Choices from a Dialog Box 393 Returning a String from a Text Box 393 Returning a Value from an Option Button 394 Returning a Value from a Check Box 395 Returning a Value from a List Box 395 Returning a Value from a Combo Box 396 Examples Showing How to Connect Forms to Procedures 397 Word Example: The Move-Paragraph Procedure 397 General Example: Opening a File from a List Box 409 Building the User Form 409 Creating the Code for the User Form 411 Using an Application’s Built-In Dialog Boxes 415 Displaying a Built-In Dialog Box 415 Setting and Restoring Options in a Built-In Dialog Box 419 Which Button Did the User Choose in a Dialog Box? 419 Specifying a Time-Out for a Dialog Box 420 The Bottom Line 421 Chapter 15 Creating Complex Forms 423 Creating and Working with Complex Dialog Boxes 424 Updating a Dialog Box to Reflect the User’s Choices 424 Revealing a Hidden Part of a Form 424 Tracking a Procedure in a Form 429 Using Multipage Dialog Boxes and TabStrip Controls 432 Creating a Modeless Dialog Box 443 Specifying a Form’s Location Onscreen 444 Using Events to Control Forms 445 Events Unique to the UserForm Object 448 Events That Apply to Both UserForms and Container Controls 453 Events That Apply to Many or Most Controls 458 Events That Apply Only to a Few Controls 471 The Bottom Line 472 Part 5 Creating Effective Code 473 Chapter 16 Building Modular Code and Using Classes 475 Creating Modular Code 475 What Is Modular Code? 476 Advantages of Using Modular Code 476 The Bottom Line 503 Chapter 17 Debugging Your Code and Handling Errors 505 Principles of Debugging 505 The Different Types of Errors 507 Language Errors 507 Compile Errors 507 The Bottom Line 551 Chapter 18 Building Well-Behaved Code 537 What Is a Well-Behaved Macro? 537 Retaining or Restoring the User Environment 539 Chapter 19 Exploring VBA’s Security Features 553 Understanding How VBA Implements Security 553 Signing Your Macro Projects with Digital Signatures 557 What Is a Digital Certificate? 557 The Bottom Line 574 Part 6 Programming the Office Applications 575 Chapter 20 Understanding the Word Object Model and Key Objects 577 Examining the Word Object Model 577 Working with the Documents Collection and the Document Object 581 Creating a Document 581 The Bottom Line 609 Chapter 21 Working with Widely Used Objects in Word 611 Using Find and Replace via VBA 611 Understanding the Syntax of the Execute Method 613 Putting Find and Replace to Work 616 Working with Headers, Footers, and Page Numbers 617 The Bottom Line 642 Chapter 22 Understanding the Excel Object Model and Key Objects 645 Getting an Overview of the Excel Object Model 645 Understanding Excel’s Creatable Objects 646 Managing Workbooks 647 Creating a Workbook 647 The Bottom Line 670 Chapter 23 Working with Widely Used Objects in Excel 671 Working with Charts 671 Creating a Chart 671 Specifying the Source Data for the Chart 673 The Bottom Line 685 Chapter 24 Understanding the PowerPoint Object Model and Key Objects 687 Getting an Overview of the PowerPoint Object Model 687 Understanding PowerPoint’s Creatable Objects 688 Working with Presentations 689 The Bottom Line 707 Chapter 25 Working with Shapes and Running Slide Shows 709 Working with Shapes 709 Adding Shapes to Slides 709 Deleting a Shape 715 The Bottom Line 729 Chapter 26 Understanding the Outlook Object Model and Key Objects 731 Getting an Overview of the Outlook Object Model 731 The Outlook Object Model 732 Understanding Where Outlook Stores VBA Macros 733 Understanding Outlook’s Most Common Creatable Objects 734 The Bottom Line 752 Chapter 27 Working with Events in Outlook 755 How Event-Handler Procedures Differ from Ordinary Macros 755 Working with Application-Level Events 756 Using the Startup Event 758 The Bottom Line 773 Chapter 28 Understanding the Access Object Model and Key Objects 775 Getting Started with VBA in Access 775 Creating a Module in the VBA Editor 778 Creating a Function 778 The Bottom Line 800 Chapter 29 Accessing One Application from Another Application 801 Understanding the Tools Used to Communicate Between Applications 801 Using Automation to Transfer Information 802 Understanding Early and Late Binding 803 The Bottom Line 830 Appendix A The Bottom Line 833 Chapter 1: Recording and Running Macros in the Office Applications 833 Chapter 2: Getting Started with the Visual Basic Editor 835 Chapter 3: Editing Recorded Macros 836 Chapter 4: Creating Code from Scratch in the Visual Basic Editor 836 Chapter 5: Understanding the Essentials of VBA Syntax 839 Chapter 6: Working with Variables, Constants, and Enumerations 840 Chapter 7: Using Array Variables 842 Chapter 8: Finding the Objects, Methods, and Properties You Need 843 Chapter 9: Using Built-in Functions 844 Chapter 10: Creating Your Own Functions 846 Chapter 11: Making Decisions in Your Code 847 Chapter 12: Using Loops to Repeat Actions 849 Chapter 13: Getting User Input with Message Boxes and Input Boxes 850 Chapter 14: Creating Simple Custom Dialog Boxes 851 Chapter 15: Creating Complex Forms 855 Chapter 16: Building Modular Code and Using Classes 856 Chapter 17: Debugging Your Code and Handling Errors 858 Chapter 18: Building Well-Behaved Code 859 Chapter 19: Exploring VBA’s Security Features 860 Chapter 20: Understanding the Word Object Model and Key Objects 862 Chapter 21: Working with Widely Used Objects in Word 863 Chapter 22: Understanding the Excel Object Model and Key Objects 864 Chapter 23: Working with Widely Used Objects in Excel 865 Chapter 24: Understanding the PowerPoint Object Model and Key Objects 866 Chapter 25: Working with Shapes and Running Slide Shows 867 Chapter 26: Understanding the Outlook Object Model and Key Objects 868 Chapter 27: Working with Events in Outlook 869 Chapter 28: Understanding the Access Object Model and Key Objects 870 Chapter 29: Accessing One Application from Another Application 871 Index 873
£32.00
Pearson Education (US) Microsoft Excel Step by Step Office 2021 and
Book SynopsisJoan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people seeking certification of their computer skills or who simply want to get things done efficiently. She has written more than 50 books about Windows, Office, and SharePoint technologies, including dozens of Step by Step books and five generations of Microsoft Office Specialist certification study guides. Students who use the GO! with Microsoft Office textbook products may overhear her cheerfully demonstrating Office features in the videos that accompany the series. Table of ContentsIntroduction Part 1: Create and format workbooks 1 Set up a workbook 2 Work with data and Excel tables 3 Perform calculations on data 4 Change workbook appearance Part 2: Analyze and present data 5 Manage worksheet data 6 Reorder and summarize data 7 Combine data from multiple sources 8 Analyze alternative data sets 9 Create charts and graphics. 207 10 Create PivotTables and PivotCharts Part 3: Collaborate and share in Excel 11 Print worksheets and charts 12 Automate tasks and input 13 Work with other Microsoft 365 apps 14 Collaborate with colleagues Part 4: Perform advanced analysis 15 Perform business intelligence analysis 16 Create forecasts and visualizations
£29.69
Pearson Education (US) Microsoft Office Inside Out Office 2021 and
Book SynopsisJoe Habraken is an educator, digital media and computer technology professional, best-selling author, and documentary filmmaker with more than 30 years of experience in the information technology and digital media production fields. He has written more than 40 books, which include numerous titles on the Microsoft Office application suite, computer networking, and Microsoft's Windows Server network platform. His titles have been translated into numerous languages and read around the world. Joe is currently an associate professor of Communication at the University of New England in Biddeford, Maine, where he teaches a variety of digital media, film, and handsTable of Contents Part I Getting started with the Microsoft 365 apps Chapter 1 Getting oriented to the Microsoft 365 applications Chapter 2 Navigating and customizing the 365 interface Chapter 3 Managing and sharing 365 files Chapter 4 Using and creating graphics Chapter 5 Using the 365 Online apps Part II Word Chapter 6 Essential Word features Chapter 7 Enhancing Word documents Chapter 8 Working with tables, columns, and sections Chapter 9 Managing mailings and forms Chapter 10 Creating special documents Part III Excel Chapter 11 Essential Excel features Chapter 12 Worksheet formatting and management Chapter 13 Getting the most from formulas and functions Chapter 14 Enhancing worksheets with charts Chapter 15 Using Excel tables and pivot tables Chapter 16 Validating and analyzing worksheet data Part IV PowerPoint Chapter 17 Essential PowerPoint features Chapter 18 Advanced presentation formatting, themes, and masters Chapter 19 Better slides with pictures, objects, and SmartArt Chapter 20 Enhancing slides with animation, transitions, and multimedia Chapter 21 Delivering a presentation and creating support materials Part V Outlook Chapter 22 Outlook configuration and essential features Chapter 23 Managing email in Outlook Chapter 24 Using the calendar for appointments and tasks Chapter 25 Working with contacts and planning meetings Chapter 26 Securing and maintaining Outlook Part VI Publisher Chapter 27 Essential Publisher features Chapter 28 Advanced Publisher features Part VII Appendixes Appendix A Microsoft 365 application integration Appendix B Microsoft 365 macros
£36.89
Cengage Learning, Inc Illustrated Series Collection Microsoft Office
Book SynopsisIncluding the latest Microsoft 365 features and enhanced support for Mac users, Cengage's Illustrated Series Collection, Microsoft Office 365 & Excel 2021 Comprehensive, 1st edition, helps you quickly master the nuances of Microsoft Office. Its concise, student-friendly approach uses a proven two-page layout that allows you to work through an entire task without turning the page. Each module begins with a brief overview of the principles covered while large, full-color screen images illustrate what you see on your computer. Module Learning Objectives are mapped to Microsoft Office Specialist (MOS) certification objectives, and module scenarios are based on Burning Glass market insights data -- helping you sharpen the critical skills you need for real-world success. In addition, MindTap and SAM (Skills Assessment Manager) online resources help maximize your study time -- and results.Table of Contents1. Getting Started with Excel. 2. Formatting a Worksheet. 3. Analyzing Data Using Formulas. 4. Working with Charts. 5. Working with Tables. 6. Managing Workbook Data. 7. Working with Images and Integrating with Other Programs. 8. Analyzing Data with PivotTables. 9. Automating Worksheet Tasks. 10. Advanced Worksheet Management. 11. Advanced Formulas and Functions. 12. Performing What-if Analysis. Index.
£69.99
McGraw-Hill Companies Microsoft Excel 365 Complete In Practice Evergreen Release
£233.51
Wiley-VCH GmbH Microsoft 365 Excel AllesineinemBand für Dummies
£20.25
McGraw-Hill Companies Microsoft Excel 365 Complete
£225.36
John Wiley & Sons Microsoft 365 Excel AllinOne For Dummies
Book Synopsis
£27.99
McGraw-Hill Education Microsoft Office 365 In Practice 2019 Edition
Book SynopsisMicrosoft Office365/2019: In Practice offers a fresh approach to teaching today's students Microsoft Officeskills by clearly introducing skills in logical order: 1) Topic 2) Instructionand 3) Practice. Nordell's TIP approach builds a foundation for success by helpingstudents apply what they learn, and provides transferable skills that allowstudents to grasp critical thinking beyond the textbook assignments. In Practice seamlessly integrates with SIMnet,McGraw-Hill Education's learning and assessment solution, which houses contentto help students practice and master computing concepts and Microsoft Officeskills. In Practice auto-graded projectTable of ContentsIntro. 2- Using Microsoft OfficeIntro. 3 - Creating, Saving, Closing, and Opening Office FilesIntro. 4 - Working with FilesIntro. 5 - Using the Ribbon, Tabs, and Quick Access ToolbarIntro. 7 - Using Context Menus, the Mini Toolbar, and Keyboard ShortcutsIntro. 8 - Organizing and Customizing Folders and FilesWordChapter 1: Creating and Editing DocumentsChapter 2: Formatting and Customizing DocumentsChapter 3: Collaborating With Others and Working With ReportsChapter 4: Using Tables, Columns, and GraphicsExcelChapter 1: Creating and Editing WorkbooksChapter 2: Working with Formulas and FunctionsChapter 3 Creating and Editing ChartsChapter 4: Formatting, Organizing, and Getting DataAccessChapter 1: Creating a Database and TablesChapter 2: Using Design View, Data Validation, and RelationshipsChapter 3: Creating and Using QueriesChapter 4: Creating and Using Forms and ReportsPowerPoint:Chapter 1: Creating and Editing PresentationsChapter 2: Illustrating with Pictures and Information GraphicsChapter 3:Preparing for Delivery and Using a Slide Presentation
£237.80
BILDNER Verlag PowerPoint 2024 2021 Microsoft 365
£17.91
John Wiley & Sons Microsoft 365 Excel For Dummies
Book Synopsis
£19.54
The Shelly Cashman Series Microsoft Office 365Â
Book SynopsisKaye's THE SHELLY CASHMAN SERIES MICROSOFT OFFICE 365 & EXCEL COMPREHENSIVE, 1st Edition, includes updated Microsoft 365 features and enhanced support for Mac users in introductory-level modules. The trademark step-by-step, screen-by-screen, project-based approach encourages you to expand your understanding of Office applications through experimentation and critical thinking. Module Learning objectives are mapped to Microsoft Office Specialist (MOS) certification objectives. In addition, MindTap and updated SAM (Skills Assessment Manager) digital resources are available to guide additional study and ensure successful results.
£186.37
Pearson Education GO with Microsoft Office 365 2019 Edition
Book SynopsisAbout our authors Shelley Gaskin (series editor) is a professor in the Business and Computer Technology Division at Pasadena City College in Pasadena, California. She holds a bachelor's degree in Business Administration from Robert Morris College (Pennsylvania), a master's degree in Business from Northern Illinois University, and a doctorate in Adult and Community Education from Ball State University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer industry, where she was a systems analyst, sales representative, and director of Customer Education with Unisys Corporation. She also worked for Ernst & Young on the development of large systems applications for their clients. She has written and developed training materials for custom systems applications in both the public and private sector and has also written and edited numerous computer application textbooks. Alicia Vargas (Word and Excel author) isTable of ContentsTable of Contents MICROSOFT OFFICE Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management Explore Microsoft Office Create a Folder for File Storage Download and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office Program Perform Office Commands and Apply Office Formatting Finalize an Office Document Use the Office Help Features Explore Windows 10 Prepare to Work with Folders and Files Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files Start Programs and Open Data Files Create, Rename, and Copy Files and Folders WORD Introducing Microsoft Word 2019 Chapter 1: Creating Documents with Microsoft Word Create a New Document and Insert Text Insert and Format Graphics Insert and Modify Text Boxes and Shapes Preview and Print a Document Change Document and Paragraph Layout Create and Modify Lists Set and Modify Tab Stops Insert a SmartArt Graphic and an Icon Chapter 2: Creating Cover Letters and Using Tables to Create Resumes Create a Table for a Resume Format a Table Present a Word Document Online Create a Letterhead for a Cover Letter Create a Cover Letter and Correct and Reorganize Text Use the Word Editor to Check Your Documents Print an Envelope, Change Style Sets, Create a Word Template and Use Learning Tools Chapter 3: Creating Research Papers, Newsletters, and Merged Mailing Labels Create a Research Paper Insert Footnotes in a Research Paper Create Citations and a Bibliography in a Research Paper Use Read Mode and PDF Reflow Format a Multiple-Column Newsletter Use Special Character and Paragraph Formatting Create Mailing Labels Using Mail Merge EXCEL Introducing Microsoft Excel 2019 Chapter 1: Creating a Worksheet and Charting Data Create, Save, and Navigate an Excel Workbook Enter Data in a Worksheet Construct and Copy Formulas and Use the SUM Function Format Cells with Merge & Center, Cell Styles, and Themes Chart Data to Create a Column Chart and Insert Sparklines Print a Worksheet, Display Formulas, and Close Excels Check Spelling in a Worksheet Enter Data by Range Construct Formulas for Mathematical Operations Edit Values in a Worksheet Format a Worksheet Chapter 2: Using Functions, Creating Tables, and Managing Large Workbooks Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions Move Data, Resolve Error Messages, and Rotate Text Use COUNTIF and IF Functions and Apply Conditional Formatting Use Date & Time Functions and Freeze Panes Create, Sort, and Filter an Excel Table View, Format, and Print a Large Worksheet Navigate a Workbook and Rename Worksheets Enter Dates, Clear Contents, and Clear Formats Copy and Paste by Using the Paste Options Gallery Edit and Format Multiple Worksheets at the Same Time Create a Summary Sheet with Column Sparklines Format and Print Multiple Worksheets in a Workbook Chapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools Chart Data with a Pie Chart Format a Pie Chart Edit a Workbook and Update a Chart Use Goal Seek to Perform What-If Analysis Design a Worksheet for What-If Analysis Answer What-If Questions by Changing Values in a Worksheet Chart Data with a Line Chart ACCESS Introduction to Microsoft Access 2019 Chapter 1: Getting Started with Microsoft Access 2019 Identify Good Database Design Create a Table and Define Fields in a Blank Desktop Database Change the Structure of Tables and Add a Second Table Create a Query, Form, and Report Close a Database and Close Access Use a Template to Create a Database Organize Objects in the Navigation Pane Create a New Table in a Database Created with a Template View a Report Chapter 2: Sort and Query a Database Open and Save an Existing Database Create Table Relationships Sort Records in a Table Create a Query in Design View Create a New Query From an Existing Query Sort Query Results Specify Criteria in a Query Specify Numeric Criteria in a Query Use Compound Criteria in a Query Create a Query Based on More Than One Table Use Wildcards in a Query Create Calculated Fields in a Query Calculate Statistics and Group Data in a Query Create a Crosstab Query Create a Parameter Query Chapter 3: Forms, Filters, and Reports Create and Use a Form to Add and Delete Records Filter Records Create a Form by Using the Form Wizard Modify a Form in Layout View and in Design View Create a Report by Using the Report Tool and Modify the Report in Layout View Create a Report by Using the Report Wizard Modify the Design of a Report Keep Grouped Data Together in a Printed Report POWERPOINT Introducing Microsoft PowerPoint 2019 Chapter 1: Getting Started with Microsoft PowerPoint Create a New Presentation Edit a Presentation in Normal View Add Pictures to a Presentation Print and View a Presentation Edit an Existing Presentation Format a Presentation Use Slide Sorter View Apply Slide Transitions Chapter 2: Formatting PowerPoint Presentations Format Numbered and Bulleted Lists Insert Online Pictures Insert Text Boxes and Shapes Format Objects Remove Picture Backgrounds and Insert WordArt Create and Format a SmartArt Graphic Chapter 3: Enhancing a Presentation with Animation, Video, Tables, and Charts Customize Slide Backgrounds and Themes Animate a Slide Show Insert a Video Create and Modify Tables Create and Modify Charts INTEGRATED PROJECTS Chapter 1: Integrating Word, Excel, Access, and PowerPoint
£194.02
OM Book Service Microsoft Office 365
£233.61
BPB Publications Microsoft Office 365 The Most Updated AllinOne Guide
Book SynopsisBy the end of this book, you will be ready to lead a team, manage a classroom, build low-code apps, collaborate in real-time with your team, and automate everyday tasks. This all-in-one guide will elevate your digital capabilities and help you stay future-ready.
£34.19
Independently Published Office 365 Microsoft Teams
£13.39
New Perspectives Microsoft 365 OfficeÂ
Book SynopsisUsing a unique in-depth, case-based approach, Campbell/Carey/Shaffer/Shellman's THE NEW PERSPECTIVES MICROSOFT 365 & OFFICE INTRODUCTORY, FIRST EDITION, thoroughly prepares you for the Microsoft Office Specialist (MOS) certification exam and success in your future career. As you apply Microsoft Office skills to real-world business scenarios based on data from market insights, you will sharpen your critical-thinking and problem-solving skills. Professional skills, tips and insights incorporated throughout provide context and relevancy to real-world practice. The text also offers updated coverage of Microsoft 365 features as well as enhanced support for Mac users. In addition, MindTap and up-to-date SAM (Skills Assessment Manager) digital resources provide interactive study tools to help maximize your study time -- and your results.
£76.94
Pearson Education (US) Microsoft Word Step by Step Office 2021 and
Book SynopsisJoan Lambert is a certified expert in accessibility, training, Adobe InDesign, Intuit QuickBooks, Dynamics, Windows Server technologies, and many Microsoft applications and systems including Access, Excel, OneNote, Outlook, PowerPoint, SharePoint, Windows, and Word. A former small business owner and recovering workaholic, she has worked for over 36 years with Microsoft and Microsoft technologies and for over 26 years in the training and certification industry. As a member of the Pearson VUE Accessibility team since 2022, Joan has gained a new perspective on computer interactions and the importance of providing equitable access to technology and content. Through her books, Joan enjoys helping people gain confidence and increase their productivity. She has written more than 50 books about Windows, Office, and SharePoint technologies, including dozens of Step by Step books and five generations of Microsoft Office Specialist certification study guides. Students wTable of ContentsPart 1: Get started with Microsoft Word 365 Chapter 1: Word basics Chapter 2: Create and manage documents Chapter 3: Enter and edit text Part 2: Create professional documents Chapter 4: Modify the structure and appearance of text Chapter 5: Organize information in columns and tables Chapter 6: Add simple graphic elements Part 3: Enhance document content Chapter 7: Insert and modify diagrams and 3D models. Chapter 8: Insert and modify charts Chapter 9: Format document elements Chapter 10: Organize and arrange content Part 4: Review and finalize documents Chapter 11: Collaborate on documents Chapter 12: Finalize and distribute documents Part 5: Use advanced Word functions Chapter 13: Reference content and content sources Chapter 14: Merge data with documents and labels Chapter 15: Create custom document elements Chapter 16: Customize options and the user interface
£26.99
APress Creating Business Applications with Microsoft 365
Book SynopsisLearn how to automate processes, visualize your data, and improve productivity using Power Apps, Power Automate, Power BI, SharePoint, Forms, Teams, and more. This book will help you build complete solutions that often involve storing data in SharePoint, creating a front-end application in Power Apps or Forms, adding additional functionality with Power Automate, and effective reports and dashboards in Power BI.This new edition greatly expands the focus on Power Apps, Power BI, Power Automate, and Teams, along with SharePoint and Microsoft Forms. It starts with the basics of programming and shows how to build a simple email application in .NET, HTML/JavaScript, Power Apps on its own, and Power Apps and Power Automate in combination. It then covers how to connect Power Apps to SharePoint, create an approval process in Power Automate, visualize surveys in Power BI, and create your own survey solution with the combination of a number of Microsoft 365 tools. You''ll work with an eTable of ContentsChapter 1. Programming in the Power Platform In this chapter, we will cover the basics of programming: properties, methods, and events. We will then look at how their implementation differs between in each of the Power Platform applications compared with traditional environments like .NET (Windows Forms and ASP.NET) and JavaScript. For Power Apps, we will see how you can set the properties of other objects directly but instead need to make the value of what you want to change (such as the text of a button) a variable and then change the value of that variable elsewhere in the application. We will also explore its Visual Basic-like syntax. In Power Automate, we will look at the different types of actions (variables, loop, parallel branches, conditions, etc.). Finally, in Power BI we will look at the Power Query M formula language. Chapter 2. Updating a SharePoint List Using Power Apps Chapter 3. Creating an Approval Process with Power Automate Chapter 4. Creating a Survey Response Dashboard with Microsoft Power BI Chapter 5. Creating a Survey Solution with Microsoft Forms, Flow, SharePoint, and Power BI Chapter 6. Power BI Challenges with JSON, XML, and Yes/No Data Chapter 7. Power BI Case Study: Monitoring BMC Remedy Help Tickets Chapter 8. Building a Help Ticketing System in PowerApps and SharePoint – New Ticket Form Chapter 9. Continuing the Help Ticketing System – Technician Form Chapter 10. Using Power BI for the Help Ticketing System Chapter 11. Overcoming Power Apps Delegation Issues with SharePoint Data Sources In this chapter, we look at how to use the technique described in https://tinyurl.com/twzvbgl to overcome delegation limits in Power Apps using a SharePoint data source. We also implement a corresponding Power Automate Flow to copy the ID value to a numeric column each time we create a record. Chapter 12. Creating a Class Sign-Up Solution in SharePoint and Power Apps Chapter 13. Visualizing Learning Management Data from SQL Server using Power BI This chapter gives several examples of connecting to multiple tables in a SQL Server database in order to visualize test score, completion, assignments and similar learning management data. It demonstrates custom columns, merging tables, slicers, and much more. Chapter 14. Dynamic Information in Power Apps and Sending an Adaptive Card to Teams using Power Automate In this chapter, we create linked SharePoint lists that display status levels, colors, and associated steps. We then read these lists from PowerApps to create a status display that we display in a tab in Teams. Finally, we create a Power Automate flow so that each time the status changes, we automatically post that to our Teams channel. Chapter 15. Dynamically Setting Object Properties in Power Apps Based on a SharePoint List In this chapter, we explore how to approximate dynamic object references/reflection in Power Apps. We take an "Actions" list in SharePoint and use it to set Text, Tooltip, and Visible properties of each corresponding button in Power Apps. Chapter 16. Uploading Files from PowerApps to SharePoint and Emailing Links using Power Automate In this chapter, we see how to upload multiple attachments from Power Apps to a SharePoint document library using Power Automate. While we are in Power Automate, we create an email of links to these documents and email it to the designated recipient. Chapter 17. Working with SharePoint Lookup Columns in Power BI In this chapter, we explore how to use the FieldValuesAsText functionality in Power BI to get the data from within a SharePoint Lookup column. We also explore creating custom columns and filtering by Content Type. Chapter 18. Joining SharePoint/Excel Tables in Power BI This chapter shows two different examples on how to join data in Power BI to make effective visualizations. The first example shows how to access lookup columns in SharePoint lists by doing a join on the lists once you bring them into Power BI. The second one is an extended example on how to verify data between two Excel spreadsheets that share a common value. We first show how to accomplish the task with Microsoft Access with a join query and a set of custom columns that reflect whether columns between the two spreadsheets actually match. We then show how it is easier and more reproducible with later data to do the same thing with Power BI using a merge query. Chapter 19. Copying Microsoft Forms Answers to SharePoint using Power Automate and then Showing the Most Current Submission in Power BI In this chapter, we take a simple Microsoft Form, copy each entry to SharePoint with Power Automate, and then visualize the data in Power BI. The main insight on the Power BI side is to show only the most recent form submission by grouping within Power BI, creating a MaxDate column, and then filtering. Chapter 20. Copying Microsoft Forms Attachments to a SharePoint List Item using Power Automate In this chapter, we see how to create a group form in Microsoft Forms, create an associated SharePoint List to hold the data, use Power Automate to copy the form responses to the list, and, most importantly, copy each file uploaded with the form and attach it to the corresponding list item. Chapter 21. Creating an Employee Recognition App in Power Apps, Power Automate, Power BI, Teams, and SharePoint In this chapter, we demonstrate how to create a Power Apps and Power Automate employee recognition solution that can post the recognition to a Teams channel, send a Teams chat, and/or send via email. We try to make it optional for submitters to include their information, finding it works for chats and email but not posts. We store the information in SharePoint and then use Power BI to visualize the values demonstrated and other data. Chapter 22. Creating a Reservations Booking Solution in Power Apps and SharePoint In this chapter, we demonstrate how to create a SharePoint list of available appointments and then use Power Apps to allow users to select an available appointment and make that not available to anyone else. It also shows how to allow users to edit or delete their appointments (or those created on their behalf). Chapter 23. Creating a Scoring Application in Power Apps and SharePoint In this chapter, we create a scoring application where we patch three different SharePoint records at the same time. Along the way, we use cascading drop-down lists, collections, data tables, and variables.
£37.49
OM Book Service Microsoft PowerPoint 365
£230.20
McGraw-Hill Education ISE Microsoft Office 365 In Practice 2019 Edition
Book SynopsisMicrosoft Office365/2019: In Practice offers a fresh approach to teaching today''s students Microsoft Office skills by clearly introducing skills in logical order through the TIP approach:1) Topic2) Instruction and3) Practice.Nordell''s TIP approach builds a foundation for success by helping students apply what they learn and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignments.In Practice seamlessly integrates with SIMnet, McGraw Hill''s online learning and assessment solution which houses content to help students practice and master computing concepts and Microsoft Office skills in a fully simulated Office environment.In Practice auto-graded projects allow students to practice their skills in a live Office application and upon completion receive immediate feedback and insights saving instructors time.The integrationTable of ContentsWindows & OfficeIntro. 1: Explore Select Features of Microsoft OfficeIntro. 2: Use Basic Features of Microsoft Office and Navigate the Office Working EnvironmentIntro. 3: Create, Save, Close and Open Office FilesIntro. 4: Customize the View and Display Size in Office Applications and Work with Multiple Office FilesIntro. 5: Print, Share and Customize Office FilesIntro. 6: Use the Ribbon, Tabs, Groups, Dialog Boxes, Task Panes, Galleries and the Quick Access ToolbarIntro. 7: Use Context Menus, Mini Toolbar, Keyboard Shortcuts, and Function Keys in Office ApplicationsIntro. 8: Organize and Customize Windows Folders and Office FilesWordChapter 1: Creating and Editing DocumentsChapter 2: Formatting and Customizing DocumentsChapter 3: Collaborating with Others and Working with ReportsChapter 4: Using Tables, Columns, and GraphicsExcelChapter 1: Creating and Editing WorkbooksChapter 2: Working with Formulas and FunctionsChapter 3: Creating and Editing ChartsChapter 4: Formatting, Organizing, and Getting DataAccessChapter 1: Creating a Database and TablesChapter 2: Using Design View, Data Validation, and RelationshipsChapter 3: Creating and Using QueriesChapter 4: Creating and Using Forms and ReportsPowerPoint:Chapter 1: Creating and Editing PresentationsChapter 2: Illustrating with Pictures and Information GraphicsChapter 3: Preparing for Delivery and Using a Slide PresentationAppendices:Appendix A: Microsoft Office Shortcuts Appendix B: Business Document Formats
£56.99
OM Books International Looseleaf for Microsoft Excel 365 Complete In Practice Evergreen Release
£183.83
John Wiley & Sons Inc Excel 2019 Bible
Book SynopsisTable of ContentsIntroduction xli Part I: Getting Started with Excel 1 Chapter 1: Introducing Excel 3 Chapter 2: Entering and Editing Worksheet Data 29 Chapter 3: Performing Basic Worksheet Operations 51 Chapter 4: Working with Excel Ranges and Tables 71 Chapter 5: Formatting Worksheets 117 Chapter 6: Understanding Excel Files and Templates 153 Chapter 7: Printing Your Work 173 Chapter 8: Customizing the Excel User Interface 195 Part II: Working with Formulas and Functions 205 Chapter 9: Introducing Formulas and Functions 207 Chapter 10: Using Formulas for Common Mathematical Operations 239 Chapter 11: Using Formulas to Manipulate Text 253 Chapter 12: Using Formulas with Dates and Times 269 Chapter 13: Using Formulas for Conditional Analysis 295 Chapter 14: Using Formulas for Matching and Lookups 315 Chapter 15: Using Formulas for Financial Analysis 333 Chapter 16: Using Formulas for Statistical Analysis 365 Chapter 17: Using Formulas with Tables and Conditional Formatting 385 Chapter 18: Understanding and Using Array Formulas 399 Chapter 19: Making Your Formulas Error-Free 423 Part III: Creating Charts and Other Visualizations 443 Chapter 20: Getting Started with Excel Charts 445 Chapter 21: Using Advanced Charting Techniques 489 Chapter 22: Creating Sparkline Graphics 523 Chapter 23: Visualizing with Custom Number Formats and Shapes 537 Chapter 24: Implementing Excel Dashboarding Best Practices 567 Part IV: Managing and Analyzing Data 577 Chapter 25: Importing and Cleaning Data 579 Chapter 26: Using Data Validation 613 Chapter 27: Creating and Using Worksheet Outlines 627 Chapter 28: Linking and Consolidating Worksheets 637 Chapter 29: Introducing PivotTables. 655 Chapter 30: Analyzing Data with PivotTables 679 Chapter 31: Performing Spreadsheet What-If Analysis 715 Chapter 32: Analyzing Data Using Goal Seeking and Solver r 733 Chapter 33: Analyzing Data with the Analysis ToolPak 755 Chapter 34: Protecting Your Work 769 Part V: Understanding Power Pivot and Power Query 781 Chapter 35: Introducing Power Pivot 783 Chapter 36: Working Directly with the Internal Data Model 807 Chapter 37: Adding Formulas to Power Pivot 817 Chapter 38: Introducing Power Query. y 835 Chapter 39: Transforming Data with Power Query. 859 Chapter 40: Making Queries Work Together r 887 Chapter 41: Enhancing Power Query Productivity 903 Part VI: Automating Excel 915 Chapter 42: Introducing Visual Basic for Applications 917 Chapter 43: Creating Custom Worksheet Functions 947 Chapter 44: Creating UserForms 961 Chapter 45: Using UserForm Controls in a Worksheet 983 Chapter 46: Working with Excel Events 997 Chapter 47: Seeing Some VBA Examples 1011 Chapter 48: Creating Custom Excel Add-Ins 1027 Index x 1037
£36.00
Illustrated Microsoft 365 Office Introductory
Book SynopsisIncluding the latest Microsoft 365 features and enhanced support for Mac users in introductory level modules, Beskeen/Cram/Duffy/Wermers/Wilson's ILLUSTRATED MICROSOFT 365 & OFFICE INTRODUCTORY, FIRST EDITION, helps you quickly master the nuances of Microsoft Office. A concise, student-friendly approach uses a two-page layout, allowing you to work through an entire task without turning the page. Modules begin with an overview of the principles covered while large, full-color screen images illustrate what you see on your computer. Module Learning Objectives are mapped to Microsoft Office Specialist (MOS) certification objectives, and module scenarios are based on data from market insights, helping you sharpen the critical skills you need for real-world success. In addition, MindTap and SAM (Skills Assessment Manager) digital resources help maximize your study time and results.
£210.36
John Wiley & Sons Microsoft 365 Excel Office Scripts For Dummies
£22.94
McGraw-Hill Companies Microsoft Word 365
£231.90
In Easy Steps Limited Microsoft Excel in easy steps: Illustrated using
Book SynopsisMicrosoft Excel in easy steps guides you through the essential functions of Microsoft Excel whether you are new to Excel and the spreadsheet concept, or just upgrading from an older version. This edition is illustrated using the most up-to-date version of Excel in Microsoft 365 at the time of printing. Microsoft Excel in easy steps starts with the basics then reveals the key clever features on offer all in easy steps! Areas covered include:Creating, editing, and manipulating worksheets.Formulas, functions, tables and importing data. Handy templates to give you a head start. Macros for everyday tasks to save time. Charts to get an overview of your data. What-if, Goal Seek and Optimization. Using the Excel Online app to share and collaborate on spreadsheets and workbooks. Adding images and illustrations to your spreadsheets to impress your colleagues! Whether you're new to Microsoft Excel or new to spreadsheets, use this guide to get more out of Microsoft Excel, and manage your finances and data effectively both at home and at work!
£11.39
John Wiley & Sons Microsoft 365 Office AllinOne For Dummies
Book Synopsis
£24.79
Excel 365. Curso Práctico
Book Synopsis
£23.65
Amazon Digital Services LLC - Kdp The Microsoft Office 365 Bible
£22.45
Amazon Digital Services LLC - Kdp Microsoft 365 Copilot
£14.61
McGraw-Hill Education Microsoft Outlook 365 Complete In Practice 2019
Book SynopsisMicrosoft Office 365/2019: In Practice for Outlook offers a fresh approach to teaching today's students Microsoft Office skills by clearly introducing skills in logical order: 1) Topic2) Instruction and 3) Practice. Nordell's TIP approach builds a foundation for success by helping students apply what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignments.Table of ContentsIntro Chapter: Windows 10, Office 365/2019 and File ManagementChapter 1: Outlook Overview and Email basicsChapter 2: Email Special FeaturesChapter 3: ContactsChapter 4: CalendarChapter 5: Tasks, To-do items and User InterfaceChapter 6: Folders, Rules, Quick Steps, and Search FoldersChapter 7: Multiple Email Accounts, Advanced Email Options, RSS Feeds, and SearchChapter 8: Advanced ContactsChapter 9: Advanced Calendars and SharingChapter 10: Notes, Journal, Shortcuts, Archiving and Security
£199.50
McGraw-Hill Education Microsoft Office 365 A Skills Approach 2019
Book SynopsisOverviewMicrosoft Office Skills on Demand!Microsoft Office 365/2019: A Skills Approach provides a unique approach to learning Office Suite by isolating skills for customized learning. Authored by the platform developers of SIMnet, McGraw-Hill Education's online training and assessment program, this textbook has 1:1 content with SIMnet activities and content. As a result, studentsTable of Contents Introduction 365 1 Essential Skills for Office word 365 Word 1 Getting Started with Word 2 Formatting Text and Paragraphs 3 Formatting Documents 4 Working with Pictures, Tables, and Charts 5 Working with Reports and Collaborating with Others Excel 1 Word Addendum: Mailings excel 365 1 Getting Started with Excel 2 Formatting Cells 3 Using Formulas and Functions 4 Formatting Worksheets and Managing the Workbook 5 Adding Charts and Analyzing Data access 365 Access 1 Getting Started With Access 2 Working with Tables 3 Using Queries and Organizing Information 4 Working with Forms and Report PowerPoint 1 Getting Started with PowerPoint 2 Adding Content to Slides 3 Formatting Presentations 4 Managing and Delivering Presentations
£194.40
McGraw-Hill Companies Microsoft Access 365
£198.45
John Wiley & Sons Teach Yourself VISUALLY Microsoft 365 2nd Edition
Book Synopsis
£22.09
Amazon Digital Services LLC - Kdp Microsoft Excel
£10.56
In Easy Steps Limited Excel VBA in easy steps
Book SynopsisGet more out of Microsoft Excel and save time by learning Excel VBA (Visual Basic for Applications). Excel VBA in easy steps, 4th edition demonstrates VBA macro programming in a clear and concise manner, and will take your Excel proficiency to the next level:Write your own Excel macros so that you can do a series of tasks at the click of a button.Use VBA to automate repetitive tasks, and for functions and commands beyond Excel. Create dialog boxes for user interactions and then define processes to handle user input. Develop and share your Excel apps with colleagues they'll be impressed! Whether you're upgrading to Excel in Office 365 or new to macro programming, use this guide to master Excel VBA essentials in easy steps! Comes with free downloadable code to help you get started with Excel VBA right away!
£12.34
New Perspectives Microsoft 365 AccessÂ
Book SynopsisUsing a unique in-depth, case-based approach, Shellman's NEW PERSPECTIVES MICROSOFT 365 ACCESS, COMPREHENSIVE, FIRST EDITION, thoroughly prepares you for the Microsoft Office Specialist (MOS) certification exam and success in your future career. As you apply Microsoft Office skills to real-world business scenarios based on data from market insights, you will sharpen your critical-thinking and problem-solving skills. Professional skills, tips and insights incorporated throughout provide context and relevancy to real-world practice. The text also offers updated coverage of Microsoft 365 features as well as enhanced support for Mac users. In addition, MindTap and up-to-date SAM (Skills Assessment Manager) digital resources provide interactive study tools to help maximize your study time -- and your results.
£201.52
John Wiley & Sons Inc Microsoft 365 Excel Formulas Functions For
Book SynopsisTurn 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 CopilotMicrosoft's AI-powered helperit'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
£22.94
Amazon Digital Services LLC - Kdp Microsoft Forms
£10.56