Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
Filter
  • Assemble You Limited,  (52)
  • Safari, an O'Reilly Media Company.
  • Vidéos sur Internet  (55)
  • Application software ; Development
  • Computer security ; Management
Datasource
Material
Language
Years
Author, Corporation
Publisher
Keywords
  • 1
    Online Resource
    Online Resource
    Three ways to split text in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (8 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: In this lesson, we'll explore various methods for efficiently dividing text across columns in Excel, a common task with different approaches depending on your Excel version and the complexity of your data. We’ll demonstrate the power of Excel's Flash Fill function—a superhero function in the Excel world. With a simple pattern input, Flash Fill swiftly splits data, such as names, into designated columns. Learn the Text to Columns feature, offering control over delimiters like spaces between names. Lastly, for Microsoft 365 users, we introduce the TextSplit function, a versatile tool for text manipulation using. As we progress, we tackle more complex scenarios, such as dealing with middle initials, and explore newer Excel functions like TEXTBEFORE and TEXTAFTER, providing solutions for intricate text extraction tasks. These techniques will enhance your data manipulation skills and streamline your workflow.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 2
    Online Resource
    Online Resource
    Data validation input messages and error alerts in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (5 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Explore advanced data validation techniques, features and Excel's data validation capabilities in this lesson. While dropdown lists are commonly used to control data entry, in this lesson we will demonstrate how to integrate input messages and error alerts. Learn how to provide helpful hints with custom input messages, guiding users on what to select from the dropdown list. Moreover, master the art of error alerts that warn against invalid inputs, ensuring data integrity and preventing mistakes. Whether you're managing a team-shared spreadsheet or simply want to elevate your data validation skills, this lesson unlocks the full potential of Excel's capabilities, making your spreadsheets more user-friendly and error-resistant.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 3
    Online Resource
    Online Resource
    Use ChatGPT to write Excel formulas (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (7 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; ChatGPT ; Artificial intelligence ; Electronic spreadsheets Computer programs ; Business Computer programs ; Intelligence artificielle ; Tableurs ; Logiciels ; artificial intelligence ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson explores how ChatGPT can be used to generate formulas. It emphasises practicality by applying the generated formula to a real-world scenario. It’ll show the balance of human expertise and AI assistance. We’ll demonstrate using ChatGPT to create an XLOOKUP formula. We’ll guide you through constructing a prompt tailored to your dataset. We’ll acknowledge ChatGPT’s usefulness while underlining that optimal results come from having an understanding of Excel and being able to spot errors.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Get live audience feedback in Forms and PowerPoint (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (3 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.5/8
    Keywords: Microsoft PowerPoint (Computer file) ; Microsoft Forms ; Social surveys ; Presentation graphics software ; Enquêtes sociales ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Discover the power of combining Microsoft Forms with PowerPoint to collect real-time responses from your audience and display them directly on your presentation slides. This lesson guides you through the simple process of creating engaging surveys, quizzes, and polls using Forms. Learn how to insert these forms into your PowerPoint slides effortlessly, allowing your audience to participate and vote live during your presentation. With the bonus of a QR code feature, your audience can easily access and contribute to the feedback session using their smartphones. Transform your presentations into an interactive and dynamic experience.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 5
    Online Resource
    Online Resource
    Create a spotlight effect with Morph in PowerPoint (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (8 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.5/8
    Keywords: Microsoft PowerPoint (Computer file) ; Presentation graphics software ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson will guide you through using Morph transitions to craft a visually stunning spotlight effect, allowing you to highlight crucial elements in PowerPoint. Learn how to morph objects, text, and shapes to make your slides more dynamic and engaging. We’ll explore shaping and colouring as well as outlining and glowing effects. You’ll learn to transform static slides into a vibrant showcase, making your presentations more visually impressive.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 6
    Online Resource
    Online Resource
    New Functions TOCOL and TOROW in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (5 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: In this lesson, we'll be exploring two dynamic functions that are making waves in the world of data manipulation: TOCOL and TOROW. These functions, currently exclusive to Microsoft 365, introduce innovative ways to reshape and present data. We'll guide you through practical examples to demonstrate the power and versatility of these functions. First up is TOCOL, a function designed to effortlessly switch data from a row to a column format. With a straightforward syntax and optional arguments, TOCOL allows for seamless customization of data arrays. We'll also explore TOROW, a companion function that horizontally aligns data, providing an alternative perspective. Enhance your data manipulation skills and prepare for the evolving landscape of spreadsheet tools.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 7
    Online Resource
    Online Resource
    Permanently hide worksheets in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (4 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: If you're tired of worrying about unauthorized changes to your Excel spreadsheets, this lesson offers a clever solution that goes beyond the typical hiding methods. While conventional worksheet hiding can be easily reversed, this lesson will guide you in the Developer ribbon, the undiscovered territory for many Excel users. Learn how to access Visual Basic without writing a single line of code and discover the power of setting worksheets to SheetVeryHidden. This advanced technique makes it significantly harder for anyone to accidentally or intentionally unhide worksheets, providing an extra layer of security to your valuable data. Elevate your Excel skills and keep your sensitive information safe with this invaluable lesson.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 8
    Online Resource
    Online Resource
    Filter data like an expert in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (8 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson explores the fundamental distinction between filtering and conditional formatting. It covers how to hide and reveal data based on your specified criteria. Explore filter dropdowns and how to leverage them directly within your Excel table. Discover how to apply filters without converting your data into a table and learn the versatility of the FILTER function. Doing so allows you to filter data in place and extract refined lists to different parts of your spreadsheet. We'll guide you through setting up data validation and demonstrate how to use dynamic functions like UNIQUE to enhance filtering.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 9
    Online Resource
    Online Resource
    INDEX and MATCH with multiple criteria in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (5 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson will support you in performing complex two-way lookups with ease. We’ll explore the mechanics of the two-way lookup using the combination of INDEX and MATCH functions. The INDEX function will help us retrieve the sales value from the specified array, while the MATCH function will allow us to find the positions of the selected company and month within their respective lists. Combining these functions makes our formula flexible enough to handle various combinations, ensuring accurate and efficient data retrieval.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 10
    Online Resource
    Online Resource
    XLOOKUP with multiple criteria in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (7 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Business Computer programs ; Tableurs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Have you ever needed to quickly find data based on two distinct conditions? This one’s for you. Get the most out of Excel's XLOOKUP function and learn about two-way lookups with multiple criteria. We’ll introduce a scenario involving sales data spread across months, showing how XLOOKUP handles a two-way lookup. We’ll examine named ranges and data validation dropdowns too. We’ll use practical examples to support your learning and enhance your spreadsheet proficiency. Finding the data you need doesn’t have to be a challenge.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 11
    Online Resource
    Online Resource
    VLOOKUP approx match explained in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (9 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: While VLOOKUP may seem like old news, it remains a powerhouse in data analysis. This lesson focuses on the often misunderstood approximate match argument. You'll learn the details of VLOOKUP, tackling lookup values, table arrays, column indices, and the pivotal choice between an exact match and an approximate match. This lesson equips you with the skills to use VLOOKUP effectively, making your data work for you.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 12
    Online Resource
    Online Resource
    Lookups with duplicates in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (7 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Electronic spreadsheets ; Tableurs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: A standard VLOOKUP has its limitations. XLOOKUP offers additional search options but fails to provide the desired result. This lesson presents a familiar scenario involving a table with employee names, departments, and countries of residence, showcasing the complexity of traditional lookup functions when faced with duplicates. By combining multiple pieces of information, such as employee names and departments, we create a unique identifier for each record. Using this approach with XLOOKUP, we successfully achieve accurate lookups - highlighting the importance of finding unique identifiers when dealing with duplicate values in your data sets. Join us in mastering this essential skill for effective data management! Learning Objectives Perform accurate lookups in tables with duplicate values by creating unique identifiers - ensuring precision in data retrieval and management.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 13
    Online Resource
    Online Resource
    Export Form data to Excel the right way (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Microsoft Forms ; Electronic spreadsheets Computer programs ; Social surveys ; Business Computer programs ; Tableurs ; Logiciels ; Enquêtes sociales ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: If you've ever used Microsoft Forms in your Microsoft 365, you know the convenience of collecting responses and exporting them to Excel for analysis. However, a common issue arises when the exported Excel file doesn't automatically update with new responses, leading to potential data discrepancies. In this lesson, we'll walk you through the problem and provide a solution that ensures your Excel file stays up-to-date seamlessly. We'll guide you through an alternative approach using OneDrive to create your form. By doing so, you'll learn how to set up a dynamic Excel file that automatically incorporates new data as it is submitted. Say goodbye to the hassle of manual exports, and join us to streamline your data analysis process with Microsoft Forms and Excel!
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 14
    Online Resource
    Online Resource
    Most useful keyboard shortcuts in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (8 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson explores a variety of keyboard shortcuts grouped into categories like navigation, selection, and command execution. Whether you're a beginner or an experienced user, these shortcuts are sure to become valuable tools in your Excel toolbox. Discover time-saving navigation tricks, selection shortcuts, and ribbon commands with keyboard shortcuts. Uncover the power of the Alt key, which provides quick access to ribbons and their commands, enhancing your ability to navigate easily and execute tasks without frustration. These keyboard shortcuts are not just about speed but are designed to streamline your workflow. Boost your Excel skills with the magic of keyboard shortcuts!
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 15
    Online Resource
    Online Resource
    Find the closest match to a number in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson shows you how to find the closest match to a given number using two methods – one with a helper column and another where the formula is contained all in one cell. This lesson covers calculating differences, converting them to positive values and identifying the minimum difference. Learn how to use INDEX and MATCH functions as we guide you through their application, providing practical insights for effective data analysis. Elevate your Excel proficiency today by exploring these essential techniques.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 16
    Online Resource
    Online Resource
    The AND function with conditional formatting in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (4 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Using the AND function within the conditional formatting rule, we demonstrate how to highlight specific rows where two conditions must be met simultaneously. We’ll explain how to create a more tailored and responsive spreadsheet. You'll learn step-by-step how to adapt the existing conditional formatting rule. Seamlessly integrate multiple criteria using the AND function, providing flexibility in highlighting rows based on intricate conditions. Whether you're managing sales data or any other dataset with dual conditions, this lesson equips you with the skills to efficiently implement conditional formatting that adapts to changing parameters.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 17
    Online Resource
    Online Resource
    Create a custom theme in PowerPoint (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (9 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.5/8
    Keywords: Microsoft PowerPoint (Computer file) ; Presentation graphics software ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson will explore how to add a personal touch to your presentations. Forget the default themes; let's infuse some personality into your slides! We'll demonstrate how to tailor your presentation's look and feel to match specific images, logos, or corporate branding. This lesson will introduce custom themes. It’ll demonstrate how to pick colours from an image using the eyedropper tool and create a cohesive colour palette to integrate into your PowerPoint theme. We’ll share tips and tricks to make your PowerPoint presentations stand out.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 18
    Online Resource
    Online Resource
    Print headers and selections in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (4 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson shares essential tips and tricks for effectively managing large datasets, focusing specifically on printing. Whether you're dealing with extensive tables or spreadsheets, printing can sometimes pose challenges, and we're here to guide you through the process. We’ll establish how to adjust print settings and change from portrait to landscape to accommodate more columns on a page. Additionally, we'll uncover a handy trick to ensure that column headings are consistently printed on every page. We'll also address what to do when you only need to print a specific subset of your dataset. We'll cover methods like setting print areas and selecting particular rows to print. Join us to master the art of printing large datasets to make your data more accessible and visually appealing.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 19
    Online Resource
    Online Resource
    The IMAGE function in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (4 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: If you're a Microsoft 365 user or use Excel for the web, this lesson is for you – the IMAGE function is exclusive to these versions. We explore the application of the IMAGE function to import company logos into your spreadsheet. Use the IMAGE function to dynamically fetch company logos using URLs. Learn how to concatenate cell references, incorporate website URLs, and enhance your spreadsheet with this function. This lesson shares how to leverage the IMAGE function's capabilities, so watch, learn, and elevate your Excel game.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 20
    Online Resource
    Online Resource
    Combine files in power query in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Querying (Computer science) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Bases de données ; Interrogation ; Tableurs ; Logiciels ; online searching ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson explores how to merge multiple files housed in a designated folder using Power Query. We’ll guide you through the process of transforming and loading the data back into Excel, ensuring a streamlined approach for future updates. This lesson emphasises the significance of consistent column headings and table names across files, making the combination process in Power Query a breeze. As a bonus, explore how to update your consolidated data with new information using the refresh feature. Efficiently manage and integrate data sets for improved analysis and reporting.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 21
    Online Resource
    Online Resource
    COUNT and SUM by cell colour in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (5 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Ever found yourself grappling with the challenge of counting or summing cells based on their background fill color in Microsoft Excel? Look no further! In this lesson, we unravel the mysteries without delving into complex VBA code. We understand that not everyone is VBA-savvy, so we've devised a straightforward method using the SUBTOTAL function. Follow along as we demonstrate how to COUNT and SUM cells with specific background colours using Excel filters. Whether you're identifying students who need to retake a test or analysing sales figures, our step-by-step guide ensures you harness the power of SUBTOTAL with ease. No need to fear the gremlins of VBA—this is the simplest method to achieve quick results and gain insights into your data.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 22
    Online Resource
    Online Resource
    Excel 'pearl' charts and stacking (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (5 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Discover a unique option that adds a touch of magic to your charts. Picture a pearl chart created by stacking colourful circles representing data points. No matter what you need to create one for, the possibilities are endless. Learn how to format your chart, add custom elements like coloured circles, and add the stacking feature. With practical insights and useful tips, you'll witness how easy adjustments can turn a simple chart into an engaging visual representation.
    Note: Online r esource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 23
    Online Resource
    Online Resource
    Generate a practice dataset with ChatGPT in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; ChatGPT ; Artificial intelligence Computer programs ; Electronic spreadsheets Computer programs ; Business Computer programs ; Intelligence artificielle ; Logiciels ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson explores the effective use of ChatGPT to effortlessly create diverse datasets. Learn how to interact with ChatGPT to instruct it to generate specific datasets, whether it's a 100-row sales dataset or a customised HR dataset with specific fields. While ChatGPT can be a helpful tool, this lesson covers some of its limitations. It establishes how to overcome challenges, such as generating larger datasets, and shares practical tips for refining prompts to achieve optimal results. Learning Objectives Establish how to use ChatGPT to generate diverse practice datasets and supercharge your productivity.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 24
    Online Resource
    Online Resource
    Are you using data bars effectively in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (7 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This is a guide to making your data bars a precise and powerful tool for effective data communication. Explore the power of data bars for representing values more effectively. This lesson demonstrates how to use data bars efficiently, making it so much easier to interpret and communicate insights. We’ll navigate through practical examples and share essential keyboard shortcuts. We’ll look at customisation options that go beyond the default settings. Discover advanced techniques such as protecting sensitive information and fine-tuning the length of data bars based on percentage or specific numerical ranges.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 25
    Online Resource
    Online Resource
    Create a daily habit tracker in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson is a guide to building a habit tracker using Excel. You can add checkboxes for each day of the week, allowing you to visually mark off completed daily habits and receive a percentage update. Whether you want to track your fitness routine, study habits, or any other daily activities, this tutorial is customisable to suit your needs. Learn essential tips, such as hiding unnecessary information for a clean look and using formulas to calculate the percentage of completed tasks for the week. By the end of this lesson, you'll have a functional Daily Habit Tracker – ideal for supercharging your productivity – that you can adapt to monitor your progress.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 26
    Online Resource
    Online Resource
    Find and replace hack in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (3 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Electronic spreadsheets ; Tableurs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: If you've ever imported data from the web and found pesky wildcard characters like asterisks messing with your cell contents, this lesson is your solution. We'll demonstrate how to locate and replace wildcard characters efficiently. Using the standard Find and Replace might seem straightforward, but there's a catch – the asterisk (*) is a wildcard character in Excel. Clicking ""Replace All"" with the asterisk alone will erase everything in the cell, as the wildcard denotes ""all."" We've got a simple trick for you. We can precisely target and replace just the unwanted character. Learn this clever technique and save yourself from data cleanup frustration.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 27
    Online Resource
    Online Resource
    Slide Zoom in PowerPoint (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (9 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.5/8
    Keywords: Microsoft PowerPoint (Computer file) ; Presentation graphics software ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson explores the features of PowerPoint's Slide Zoom functionality. Slide Zoom makes your content much more appealing to your audience and enhances their experience. From half-screen image magic to personalised zoom styles, you’ll learn how to create presentations that stand out with vibrant visuals and morphing transitions. With customisable thumbnails and interactive features, you'll be able to transform your slideshows into captivating experiences.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 28
    Online Resource
    Online Resource
    Why word styles are useful in Word (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (9 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.52
    Keywords: Microsoft Word ; Microsoft Office ; Word processing ; Traitement de texte ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: If you find yourself grappling with the tedious task of manually formatting headings in your documents, this lesson is your game-changer. This lesson will guide you through the seamless application of Word Styles and how effortlessly creating a structured and visually appealing document becomes. Say goodbye to the arduous process of individually formatting each heading; instead, learn how to apply styles in one swift action. Beyond the time-saving convenience, delve into the strategic advantages of using styles, such as easy rebranding and quick updates to headings across lengthy documents. Uncover the power of Word Styles in generating a dynamic Table of Contents, ensuring your documents not only look polished but are also easily navigable and adaptable to changes. Don't miss out – revolutionise your Word document workflow with this essential lesson!
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 29
    Online Resource
    Online Resource
    A Simple LAMBDA in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (8 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: If you've mastered the basics of Excel and are ready for a challenge, this lesson is your ticket to understanding the powerful LAMBDA function. LAMBDA empowers you to craft custom functions within Excel, offering a game-changing ability to simplify lengthy and intricate formulas. In this lesson, we’ll explore the LAMBDA function by breaking down its components. By naming cell ranges and creating user-friendly variables, we transform complex calculations into reusable functions. Watch as we guide you through the step-by-step process of turning a conventional formula into a LAMBDA and converting it into a versatile function. Whether you're dealing with intricate financial models or complex data analyses, mastering LAMBDA opens the door to efficiency and flexibility in Excel.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 30
    Online Resource
    Online Resource
    Create usable barcodes in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (3 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Bar coding ; Electronic spreadsheets Computer programs ; Business Computer programs ; Codes à barres ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Learn to create barcodes using Excel. This lesson will guide you through turning product IDs into barcodes. We'll introduce you to the Libre Barcode 39 font and the share steps to customise your barcode. Unlock the potential of barcode creation by exploring font options. This lesson encourages you to explore different options based on your unique product requirements. Establish how to create barcodes and add to your Excel toolkit.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 31
    Online Resource
    Online Resource
    Data validation with conditional formatting in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Discover the power of data validation and conditional formatting with our comprehensive lesson on creating dynamic dropdown lists in Excel. This lesson will guide you through setting up a user-friendly interface that automatically highlights corresponding rows in a table. We’ll provide step-by-step instructions on using formulas, data validation, and conditional formatting to enhance your Excel skills. Discover how to organise your data by creating a table, giving it a name for easy reference, and generating a unique list using the UNIQUE function. Don't worry if you don't have access to the UNIQUE function – we've got you covered with an alternative method.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 32
    Online Resource
    Online Resource
    Power toys Colour Picker in Windows (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Ever wished for the eyedropper tool, commonly found in PowerPoint, to be available in Excel? Well, this one’s for you. This lesson explores the Colour Picker feature in Excel. You can pick colours from one element and apply them consistently across your spreadsheet. We’ll guide you through the installation process, highlight the tool’s capabilities, and even provide an easy shortcut for quick access – all to maintain consistent colours across your charts and shapes in Excel.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 19, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 33
    Online Resource
    Online Resource
    Conditional formatting with icon sets in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Electronic spreadsheets Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: If you've ever wondered how to enhance your data visualisation skills and make meaningful insights at a glance, this one's for you. In this lesson, we'll explore the power of icon sets within Excel's conditional formatting feature. Icon sets are a fantastic tool for visualising data trends, and we'll guide you through applying and customising them to suit the specifics of your data. So, let's dive in and make your Excel spreadsheets not only informative but visually compelling! Learning Objectives Apply and customise icon sets in Excel's conditional formatting to visually represent data trends and make informed data analysis decisions.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 34
    Online Resource
    Online Resource
    Calculate work days with custom days off in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (4 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Imagine a scenario where your work week is not the conventional Monday to Friday and you want to estimate project durations based on this unique schedule, excluding holidays. The tool of choice for this task is the NetworkDays.Intl function. The formula calculates the work days accurately and remains dynamic as you extend it across your dataset. Enhance your Excel skills with this lesson and ensure your project timelines align with your unique work schedule. Learning Objectives Explore the NetworkDays.Intl function in Excel to calculate project durations - including customised work days and excluding holidays.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 35
    Online Resource
    Online Resource
    4 efficiency tips in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (5 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Are you ready to transform your Excel game? In this lesson, we'll guide you through four essential efficiency tips that might just revolutionise how you work with Excel. We'll show you how to copy calculations directly from the status bar and streamline formula columns with paste values only. Plus, discover more about named ranges for navigation and formula creation. Ultimately, each tip is designed to enhance your efficiency and productivity. Learning Objectives Discover data navigation techniques, including copying calculations from the status bar, pasting values for streamlined formula columns, and using named ranges.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 36
    Online Resource
    Online Resource
    IF with partial match in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (5 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: In this lesson, we tackle the challenge of identifying data in a list using the IF function with a partial match. Imagine you're a fruit supplier armed with a spreadsheet containing customer names and their favourite fruits based on purchase data. Your task? To identify if the fruit listed in column B is a berry and label it accordingly in column D. We'll attempt an initial IF statement with a wildcard to find berries. Surprisingly, it won't work due to wildcard limitations in IF. So, join us in this lesson as we navigate the nuances of partial matching in Excel - with fruitful results! Learning Objectives Identify and categorise data with partial matches with IF, SEARCH, and ISNUMBER functions.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 37
    Online Resource
    Online Resource
    Calculate work days excluding time off in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: If you've ever needed to determine the end date of a project based on workdays (excluding weekends and holidays), this is the lesson for you. We explore three lesser-known functions in Excel: Workday, NetworkDays, and NetworkDays.intel. You'll learn how to integrate these functions into your formulas effectively. Whether you're managing projects and schedules or need to track days for any other reason, this lesson provides practical insights to boost your productivity. Learning Objectives Discover Excel's Workday, NetworkDays, and NetworkDays.intel functions.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 38
    Online Resource
    Online Resource
    Create an expiry alert in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Imagine having a dynamic and colour-coded dashboard at your fingertips, effortlessly keeping track of invoice statuses - it's a game-changer! In this lesson, we'll guide you through setting up a dynamic system in your spreadsheet to indicate whether invoices are expired, about to expire, or on time. We'll guide you through each step and throw in a handy formatting hack for good measure. By the end of this tutorial, you'll have a functional Expiry Alert system in your Excel spreadsheet, providing you with a quick and visually appealing overview of the status of invoices. Learning Objectives Efficiently track the status of invoices in Excel by calculating days left, using dynamic date functions, utilising nested IF statements, and applying conditional formatting.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 39
    Online Resource
    Online Resource
    Chat GPT to bulk send emails (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (7 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; ChatGPT ; Business Computer programs ; Artificial intelligence ; Electronic mail messages ; Electronic mail systems ; Intelligence artificielle ; Courrier électronique ; artificial intelligence ; electronic mail ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Streamlining your bulk email-sending process has never been easier. Say goodbye to the complexities of VBA coding and programming as we guide you through crafting precise prompts for ChatGPT to ensure optimal results. From generating VBA macros to converting Excel reports into PDF files, our step-by-step guide will supercharge your productivity. Whether you're an Excel veteran or a complete novice, this lesson empowers you to streamline your email processes. Learning Objectives Use ChatGPT to automate the bulk sending of emails directly from Excel and integrate generated VBA macros for enhanced productivity.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 40
    Online Resource
    Online Resource
    New checkboxes in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (8 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Whether you're tracking workouts or managing tasks, checkboxes offer a visual record and keep things organised. Discover the power of TRUE and FALSE outputs and their interactive possibilities. We'll show you how to use a formula and conditional formatting to mark tasks as complete. Say goodbye to tedious planning and welcome a dedicated checkbox feature for a more efficient and visually appealing Excel experience. Learning Objectives Insert, customise, and efficiently manage the new Checkbox feature in Excel. Enhance visual representations, streamline task tracking, and boost spreadsheet productivity.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 41
    Online Resource
    Online Resource
    Outlook search (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (8 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.57
    Keywords: Microsoft Outlook ; Electronic mail systems ; Business Computer programs ; Electronic mail messages ; Courrier électronique ; electronic mail ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson shares essential tips to enhance your email searching skills. Understanding the search scope is crucial; you can search within the current mailbox, subfolders, all mailboxes, or across everything in Outlook. We'll also guide you through instant search refinement tools, allowing you to narrow down results based on senders, attachments, categories, flags, importance, direct recipients, and unread status. Explore advanced search capabilities and embrace a fresh approach to refining your search criteria. Learning Objectives Efficiently navigate and optimise Outlook's search functionality, scope settings, instant search refinements, logical operators, and advanced search techniques.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 42
    Online Resource
    Online Resource
    Copilot in PowerPoint (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (9 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.5/8
    Keywords: Microsoft PowerPoint (Computer file) ; Presentation graphics software ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson focuses on harnessing the power of Copilot within PowerPoint. It covers the recent expansion of Copilot accessibility, the Designer feature, and a step-by-step demonstration of creating presentations. You'll learn how to use Copilot with external documents and integrate it with company templates, too. Learning Objectives Use Microsoft Copilot in PowerPoint to efficiently create, customise, and optimise presentations.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 43
    Online Resource
    Online Resource
    Organising data with subtotals in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Electronic spreadsheets Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: This lesson explores the feature that simplifies dataset summarisation. Subtotals enable you to calculate and display total values for different groups within a dataset. Unlike pivot tables, which may involve a more elaborate setup, Subtotals offer a quick and straightforward way to obtain insights without extensive data restructuring. Subtotals provide a clear breakdown, and the collapsible sections allow you to focus on specific details. You can also revert to the original dataset and restore your data to its initial state. Mastering Excel's Subtotals will simplify your processes and make data analysis easier. Learning Objectives Calculate and display total values for different dataset groups and enhance data summarisation with Subtotal in Excel.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 44
    Online Resource
    Online Resource
    Understand the slide master in PowerPoint (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (8 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.5/8
    Keywords: Microsoft PowerPoint (Computer file) ; Presentation graphics software ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: If you've ever felt overwhelmed by the intricacies of PowerPoint, then understanding the Slide Master is a game-changer. We'll guide you through the creation of a title slide with a gradient fill, title text box, subtitle, and company logo. You'll discover the importance of slide layouts and how they influence the formatting of your slides. Learn to navigate through the Slide Master view and explore various layouts. Understand the distinction between the root master slide and individual layouts, and discover how modifying the Slide Master can save you significant time and effort. No more repetitive formatting for each slide; instead, streamline your workflow and ensure a polished, consistent look for your entire presentation. Learning Objectives Explore PowerPoint's Slide Master feature to efficiently and consistently format presentations - incorporating gradient fills, title text boxes, subtitles, and logos for a polished and professional look.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 45
    Online Resource
    Online Resource
    Use VBA to create a message popup box in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (9 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Ready to level up your Excel game? This lesson will enhance your efficiency by automating invoice reminders using VBA to create a customised message pop-up box. We'll explore formulas for identifying due and past-due invoices, conditional formatting for visual cues based on reminder status, and VBA code setup for a pop-up message box. By the end of this lesson, you'll have the skills to implement a personalised reminder system in Excel using VBA, helping you stay organised and proactive in managing due dates. Learning Objectives Implement a customised VBA pop-up reminder system in Excel.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 46
    Online Resource
    Online Resource
    Create an index in Word (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (7 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.52
    Keywords: Microsoft Word ; Word processing ; Text processing (Computer science) ; Traitement de texte ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: We all know scrolling through lengthy documents to find specific information is a chore. The solution? An index is the unsung hero at the end of your document and its power lies in helping readers swiftly locate crucial information. We'll guide you through the process of marking index entries and define the differences between a table of contents and an index. An index allows you to locate specific words or phrases, making it a versatile tool for easy navigation. Learning Objectives Create an index in Microsoft Word - mark entries, customise the index, and improve document navigation.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 47
    Online Resource
    Online Resource
    Cleaning data in Excel with Power Query : Part 1 (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (8 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Querying (Computer science) ; Business Computer programs ; Electronic spreadsheets Computer programs ; Bases de données ; Interrogation ; Tableurs ; Logiciels ; online searching ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: If you've ever found yourself grappling with messy datasets or are new to the Power Query, this lesson is for you. In this lesson, we cover how to import your data and use Applied Steps, Power Query's editor, and the Undo functionality. By the end of this lesson, you'll be equipped with the knowledge and skills to efficiently clean datasets using Power Query and ensure accuracy in your data analyses. Learning Objectives Clean and organise datasets in Excel using Power Query - navigate the Power Query Editor and use Applied Steps for data cleaning processes.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 48
    Online Resource
    Online Resource
    Cleaning data in Excel with Power Query : Part 2 (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (10 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Querying (Computer science) ; Business Computer programs ; Electronic spreadsheets Computer programs ; Bases de données ; Interrogation ; Tableurs ; Logiciels ; online searching ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Ready for the second part of Cleaning Data in Excel with Power Query? In this lesson, we're transforming our unruly dataset for easy, organised data analysis. We'll start by removing unnecessary rows and blank spaces and getting rid of any unwanted elements. We'll explore techniques to align and split columns for a more structured layout. We'll explore clever tricks to handle any quirks in your data. By the end, you'll have a refined dataset ready for analysis. Learning Objectives Remove unnecessary rows, handle blank spaces, merge and split columns, and fine-tune data types.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 49
    Online Resource
    Online Resource
    Check for issues and accessibility in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (8 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Electronic spreadsheets Computer programs ; Tableurs ; Logiciels ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Before sharing your Excel spreadsheets with others, it's crucial to check for potential issues and ensure accessibility for all users. In this lesson, we'll explore often-overlooked features in Excel that can make your documents usable by everyone, including those using screen readers. Take a proactive approach to ensure your data remains secure and accessible. Regularly inspecting your spreadsheets for issues and ensuring accessibility are good practices. Removing sensitive information and adding alt text to images makes your documents inclusive for all users. Learning Objectives Identify and rectify potential issues in Excel spreadsheets to ensure accessibility for all users.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 50
    Online Resource
    Online Resource
    Cleaning data in Excel with Power Query : Part 3 (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (7 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Querying (Computer science) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Bases de données ; Interrogation ; Tableurs ; Logiciels ; online searching ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Welcome to the final instalment of our three-part series on Cleaning Data in Excel with Power Query. In this lesson, we'll briefly revisit the powerful transformations applied using Power Query in the previous lessons to achieve a clean dataset. We'll wrap up the data cleaning process and guide you through loading and analysing your cleaned data in Excel. By the end of this lesson, you'll be equipped to transform messy data into insightful analyses and effortlessly handle future data updates. Learning Objectives Integrate cleaned data into Excel and create insightful pivot tables and charts for efficient analysis with Power Query in Excel.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 51
    Online Resource
    Online Resource
    GROUPBY in Excel (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (9 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.54
    Keywords: Microsoft Excel (Computer file) ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Have you ever wondered how to perform data aggregations effortlessly within a single formula? GroupBy is your answer! We'll cover the essential components of GroupBy: row fields, values, and the aggregation function and guide you through creating a basic formula to aggregate your data. Discover the flexibility of GroupBy, allowing you to expand the range and include additional fields like areas. We'll also explore optional arguments, such as displaying column headings, grand totals, subtotals, sorting options, and even filtering results to meet specific criteria. Learning Objectives Discover GroupBy in Excel to aggregate and analyse data.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 52
    Online Resource
    Online Resource
    Blur effect in PowerPoint (2024)
    [Place of publication not identified] : Assemble You
    Details
    Language: English
    Pages: 1 online resource (1 video file (7 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.5/8
    Keywords: Microsoft PowerPoint (Computer file) ; Presentation graphics software ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Are you prepping a presentation that demands a stunning introduction? Look no further! In this lesson, we show you how to add a blur effect to your title slides. Explore colour coordination and fine-tune effects plus add dynamic animations to make your slides more captivating. From optimising images to adding text legibility, this lesson is your gateway to crafting more engaging slides. Learning Objectives Explore the blur effect in PowerPoint and develop skills in image optimisation, text legibility, colour coordination, and dynamic animations.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 2, 2024)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 53
    Online Resource
    Online Resource
    AI Superstream : Responsible AI (2021)
    [Erscheinungsort nicht ermittelbar] : O'Reilly Media, Inc.
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 3 hr., 39 min.)
    Edition: 1st edition.
    DDC: 006.3/1
    Keywords: Streaming video ; Internet videos ; Vidéo en continu ; Vidéos sur Internet ; streaming video ; Internet videos ; Streaming video ; Electronic videos
    Abstract: Join us for an event focused on the many aspects of designing, deploying, and maintaining responsible AI. Event chair and responsible AI expert Rumman Chowdhury offers overarching context, stitching together shorter tech talks and conversations with industry leaders. What you'll learn and how you can apply it Discover what responsible AI includes (and what it doesn't) See what responsible AI looks like in action, from data to deployment to debugging Learn how to debug your ML model Explore real-world applications of responsible AI Understand what industry leaders think about when they think about responsibility This course is for you because... You're a machine learning engineer or data scientist interested in responsible AI. You're engaged in conversations about ethics and AI. You're wondering how to improve your own AI and machine learning. You're responsible for implementing fair or ethical AI practices in your role or project and looking for hands-on examples. Recommended follow-up: Read Responsible Machine Learning (report) Read AI and the Law (report) Read Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow (book)
    Note: Online resource; Title from title screen (viewed June 16, 2021)
    URL: lizenzpflichtig
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 54
    Online Resource
    Online Resource
    Exam AZ-104 Microsoft Azure Administrator (Video) (2020)
    [Erscheinungsort nicht ermittelbar] : Microsoft Press | Boston, MA : Safari
    Details
    ISBN: 9780136823483 , 0136823483
    Language: English
    Pages: 1 online resource (1 video file, approximately 9 hr., 30 min.)
    Edition: 1st edition
    Keywords: Internet videos ; Streaming video ; Electronic videos ; local ; Vidéos sur Internet ; Vidéo en continu ; streaming video ; Internet videos ; Streaming video ; Electronic videos
    Abstract: 9 Hours of Video Instruction The Exam AZ-104 Microsoft Azure Administrator (Video) offers full coverage of the MS AZ-104 exam so you can learn everything you need to know to pass the exam. Coverage includes cloud concepts, core Azure Services, Azure pricing and support, and the fundamentals of cloud security, privacy, compliance, and trust, with the goal of passing the AZ-104 Exam. Description The Exam AZ-104 Microsoft Azure Administrator (Video) offers 9 full hours of video training on all core concepts in the AZ-104 exam so you can fully understand cloud concepts, core Azure Services, Azure pricing and support, and the fundamentals of cloud security, privacy, compliance, and trust. It will prepare Azure Administrators to implement, monitor, and maintain Microsoft Azure solutions, including major services related to compute, storage, network, and security. With 9 hours of hands-on demonstrations, it will provide the knowledge necessary to pass the exam and become Microsoft Certified: Microsoft Azure Administrator. With years of IT experience, numerous publications under his belt, and a wealth of expertise teaching in the field, Michael Shannon is uniquely qualified to prepare students for the Microsoft Azure Administrator AZ-104 exam. Topics include: Module 1: Manage Azure subscriptions and resources Module 2: Implement and manage storage Module 3: Deploy and manage virtual machines (VMs) Module 4: Configure and manage virtual networks Module 5: Manage identities About the Instructor Michael J. Shannon began his IT career when he transitioned from recording studio engineer to network technician for a major telecommunications company in the early 1990s. He soon began to focus on security and was one of the first 10 people to attain the HIPAA Certified Security Specialist. Throughout his 30 years in IT, he has worked as an employee, contractor, and consultant for several companies including Platinum Technologies, Fujitsu, IBM, State Farm, MindSharp, and Pearson, among others. Mr. Shannon has authored several books, training manuals, published articles, and CBT modules over the years as well. He is the senior technical instructor for Skillsoft Corporation, specializing in all things cloud and security. Skill Level Intermediate/Advanced Learn How To Manage Azure subscriptions and resources Implement and manage storage Deploy and manage virtual machines (VMs) Configure and manage virtual networks Manage identities Who Should Take...
    Note: Online resource; Title from title screen (viewed June 5, 2020) , Mode of access: World Wide Web.
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 55
    Online Resource
    Online Resource
    Take Control of macOS Media Apps (2020)
    [Erscheinungsort nicht ermittelbar] : Take Control Books | Boston, MA : Safari
    Details
    ISBN: 9781947282445
    Language: English
    Pages: 1 online resource (229 pages)
    Edition: 1st edition
    Keywords: Mac OS ; Application software Development ; Electronic books ; local ; Electronic books ; Mac OS ; Logiciels d'application ; Développement ; Application software ; Development
    Abstract: In macOS 10.15 Catalina, Apple finally did away with iTunes. In its place are three new apps-Music, TV, and Podcasts-with audiobooks now handled by the Books app and syncing of mobile devices handled by the Finder. Where once iTunes was an all-purpose media hub, now you may use up to five apps to accomplish the same things. The new apps also add more features (while, sadly, removing a few things too). Take Control of macOS Media Apps is your guide to this new, post-iTunes world. Kirk McElhearn, whose earlier books on iTunes 10, 11, and 12 collectively sold nearly 14,000 copies, is back with a new book that shows you how to manage your music, videos, podcasts, and audiobooks in Catalina. Whether you just want to play your media, or you want to go deeper with special features like Genius, Shuffle, Up Next, Apple Music, and iTunes Match, this comprehensive guide has the answers you need. Kirk also looks at various ways of bringing audio and video into Apple's media apps, tagging songs and videos so you can find them more easily later, creating playlists, sharing your library over a home network, and syncing media with your iPhone, iPad, or iPod. The book covers how to: Play Music: Learn the basics of playing audio (and even music videos) in the Music app. You'll also find tips on making quick playlists with Genius and Up Next, learn the best ways to search for the music you want to hear, stream music to other devices in your home, and view lyrics while tunes play. Stream Music: Use Apple Music, a paid service, to listen to any of 50 million tracks. Or listen to live broadcasts from Apple Music Radio (including Beats 1). View Your Music and Other Content: Learn how to use the sidebar, view your music library, and work with contextual menus in the Music app. Store Your Music Library in the Cloud: What are the pros and cons of Apple's Cloud Music Library? How do Music and iTunes Match figure out whether to upload your music when setting up your Cloud Music Library? You'll get answers to these questions and more. Use the iTunes Store: iTunes may be gone, but the iTunes Store is still open for business! Find tips on shopping in the iTunes Store, and get advice on sharing your purchases with family members and among your various Apple devices. Tag Your Music: Tags are bits of information (also known as "metadata") that can describe your media. Learn which tags to bother changing, the best ways to add lyrics and album art, how to rate songs with stars, ...
    Note: Online resource; Title from title page (viewed January 21, 2020) , Mode of access: World Wide Web.
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 56
    Online Resource
    Online Resource
    C++20 Fundamentals (2020)
    [Erscheinungsort nicht ermittelbar] : Pearson | Boston, MA : Safari
    Details
    ISBN: 9780136875185 , 0136875181
    Language: English
    Pages: 1 online resource (1 video file, approximately 10 hr., 20 min.)
    Edition: 1st edition
    Keywords: Internet videos ; Streaming video ; Electronic videos ; local ; Electronic videos ; Vidéo en continu ; streaming video ; Internet videos ; Streaming video ; Vidéos sur Internet
    Abstract: Sneak Peek The Sneak Peek program provides early access to Pearson video products and is exclusively available to Safari subscribers. Content for titles in this program is made available throughout the development cycle, so products may not be complete, edited, or finalized, including video post-production editing. C++20 Fundamentals LiveLessons with Paul Deitel is a code-oriented presentation of C++, one of the world,Äôs most versatile and powerful programming languages. C++ remains hugely popular for the development of systems software, embedded systems, operating systems, real-time systems, communications systems and other high performance computer applications. C++20 Fundamentals LiveLessons is comprehensive and covers all major versions of C++, including: C++11, C++17, and C++20. The code repository for this LiveLesson is kept at https://github.com/pdeitel/CPlusPlus20FundamentalsLiveLessons and will be kept up to date as lessons are added and as changes are made.
    Note: Online resource; Title from title screen (viewed June 10, 2020) , Mode of access: World Wide Web.
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 57
    Online Resource
    Online Resource
    21st Century Security and CPTED, 2nd Edition (2013)
    [Erscheinungsort nicht ermittelbar] : CRC Press | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (954 pages)
    Edition: 2nd edition
    Keywords: Information technology ; Security measures ; Computer security ; Management ; Computer networks ; Security measures ; Data protection ; Electronic books ; local
    Abstract: The concept of Crime Prevention Through Environmental Design (CPTED) has undergone dramatic changes over the last several decades since C. Ray Jeffery coined the term in the early 1970s, and Tim Crowe wrote the first CPTED applications book. The second edition of 21st Century Security and CPTED includes the latest theory, knowledge, and practice of CPTED as it relates to the current security threats facing the modern world: theft, violent crime, terrorism, gang activity, and school and workplace violence. This significantly expanded edition includes the latest coverage of proper lighting, building design-both the interior and exterior-physical security barriers, the usage of fencing, bollards, natural surveillance, landscaping, and landscape design. Such design concepts and security elements can be applied to address a wide variety of threats including crime prevention, blast mitigation, and CBRNE threat protection. Authored by one of the U.S.'s renowned security experts-and a premiere architect and criminologist-the book is the most comprehensive examination of CPTED and CPTED principles available. This edition includes a complete update of all chapters in addition to five new chapters, over 700 figure illustrations and photos, numerous tables and checklists, and a 20-page color plate section. This latest edition: Features five new chapters including green and sustainable buildings, infrastructure protection, and premises liability Presents step-by-step guidelines and real-world applications of CPTED concepts, principles and processes-from risk assessment to construction and post-occupancy evaluation Outlines national building security codes and standards Examines architectural surety from the perspective of risk analysis and premises liability Demonstrates CPTED implementation in high-security environments, such as hospitals, parks, ATMs, schools, and public and private sector buildings A practical resource for architects, urban planners and designers, security managers, law enforcement, CPTED practitioners, building and property managers, homeland security professionals, and students, 21st Century Security and CPTED, Second Edition continues to serve as the most complete and up-to-date reference available on next-generation CPTED practices today.
    Note: Online resource; Title from title page (viewed June 25, 2013) , Mode of access: World Wide Web.
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 58
    Online Resource
    Online Resource
    WebSphere Application Server V8.5 Concepts, Planning, and Design Guide (2012)
    [Erscheinungsort nicht ermittelbar] : IBM Redbooks | Boston, MA : Safari
    Details
    ISBN: 0738438464 , 9780738438467
    Language: English
    Pages: 1 online resource (638 pages)
    Series Statement: IBM Redbooks
    Parallel Title: Erscheint auch als
    DDC: 005.376
    Keywords: WebSphere ; Computational grids (Computer systems) ; Application software Development ; Client/server computing ; Web servers Computer programs ; Electronic books ; local ; WebSphere ; WebSphere ; Electrical & Computer Engineering ; Engineering & Applied Sciences ; Telecommunications ; Grilles informatiques ; Logiciels d'application ; Développement ; Architecture client-serveur (Informatique) ; Serveurs Web ; Logiciels ; Application software ; Development ; Client/server computing ; Computational grids (Computer systems) ; Web servers ; Computer programs
    Abstract: This IBM® Redbooks® publication provides information about the concepts, planning, and design of IBM WebSphere® Application Server V8.5 environments. The target audience of this book is IT architects and consultants who want more information about the planning and design of application-serving environments, from small to large, and complex implementations. This book addresses the packaging and features in WebSphere Application Server V8.5, and highlights the most common implementation topologies. It provides information about planning for specific tasks and components that conform to the WebSphere Application Server environment. Also in this book are planning guidelines for Websphere Application Server V8.5 and Websphere Application Server Network Deployment V8.5 on distributed platforms. It also includes guidelines for WebSphere Application Server for IBM z/OS® V8.5. This book contains information about migration considerations when moving from previous releases. Please note that the additional material referenced in the text is not available from IBM.
    Note: Online resource; Title from title page (viewed June 25, 2012) , Mode of access: World Wide Web.
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...