Your email was sent successfully. Check your inbox.

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

Proceed reservation?

Export
Filter
  • Online Resource  (266)
  • Safari, an O'Reilly Media Company.  (196)
  • Assemble You Limited,  (70)
  • Electronic videos ; local  (194)
  • Internet videos  (77)
  • Streaming video
Datasource
Material
  • Online Resource  (266)
Language
Years
Author, Corporation
Publisher
Keywords
  • 1
    Online Resource
    Online Resource
    Convert numbers to words 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: Ever wondered how to transform numerical values into descriptive text? From accessing the Visual Basic Editor to customising the formula and adapting it for different currencies, this lesson will equip you with a quick and efficient way to convert numbers to words. Learn how to easily integrate VBA code into your Excel workbook, enabling you to convert numbers into words effortlessly with just a simple function. Say goodbye to tedious manual processes and embrace the efficiency of converting numbers to words in Excel.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    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.
  • 3
    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.
  • 4
    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.
  • 5
    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.
  • 6
    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.
  • 7
    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.
  • 8
    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.
  • 9
    Online Resource
    Online Resource
    Sort columns horizontally 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) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: Ever struggled with chaotic data columns? In this lesson, we share a quick Excel hack: skip manual dragging and dropping by using a numbering system. Assign a numerical order to columns, select your dataset, and opt for left-to-right sorting in the Data tab. Whether it's a compact sheet or a vast dataset, this method streamlines Excel data management and is guaranteed to save you time. Join us to learn this efficient trick for hassle-free column sorting. Enhance your data analysis workflow and leave behind the tedious task of manually rearranging columns in Excel.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    The LARGE and SMALL functions 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: While many of us are familiar with the MIN and MAX functions, LARGE and SMALL offer a unique twist to data analysis. This lesson provides a step-by-step guide to help you maximise your Excel expertise. We demonstrate how LARGE and SMALL functions work seamlessly. We also explore combining these functions with XLOOKUP. If you're ready to elevate your Excel game and extract precisely the data you need, this lesson is for you. We’ll explore the LARGE and SMALL functions – Excel's hidden gems for refined data analysis.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    How to do a weighted average 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: This lesson examines calculation methods. If terms like AVERAGE function and SUMPRODUCT have left you confused, fear not – our step-by-step guide is here to simplify things for you. We start by demonstrating how to find a regular average using the AVERAGE function. However, the real game-changer comes when you explore the nuances of weighted averages, where certain disciplines hold more weight than others. We break down the process of assigning percentage-based weight values. Whether you're a beginner or an experienced Excel user, this lesson will ensure you confidently grasp the details of weighted averages.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Search folders in Outlook (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/7
    Keywords: Microsoft Outlook ; Electronic mail systems ; Business Computer programs ; Personal information management Computer programs ; Electronic mail messages ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: Discover the functionality of Outlook's Search Folders in this lesson. Learn how to create folders with different criteria and make email management efficient. We'll guide you through organising emails, flagging messages for follow-up, and managing large emails. In just a few clicks, you can transform your workflow and supercharge your success. Join us to boost your productivity — make your Outlook inbox work smarter for you and streamline your email management.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Split columns at line break 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: This lesson explains the process of breaking up information contained in a single cell into separate columns using Text to Columns. This technique is invaluable for enhancing clarity and organisation when dealing with product details, lists, or any other data. It ensures you can efficiently manage and present information in a more structured and visually appealing way. By the end of the lesson, you’ll be able to navigate Excel's Data Tab, understand the functionalities of Text to Columns, and confidently apply this valuable technique to streamline and elevate your data management capabilities.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Excel tables 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: This lesson will debunk common misconceptions and showcase the potential of Excel tables. Discover the ease of transforming your raw data into a table using various methods, and learn how tables enhance data manipulation. Establish the benefits of automatic formula replication and easy reference naming. We’ll explore features like dynamic expansion, ensuring your charts automatically adapt to growing datasets. Optimise your Excel experience and make Excel tables your most valuable asset for data analysis and presentation.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    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.
  • 16
    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.
  • 17
    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.
  • 18
    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.
  • 19
    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.
  • 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
    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.
  • 22
    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.
  • 23
    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.
  • 24
    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.
  • 25
    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.
  • 26
    Online Resource
    Online Resource
    How Outlook Groups, SharePoint and Teams link together in Microsoft 365 (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
    Keywords: Microsoft Office ; Microsoft Outlook ; Microsoft SharePoint (Electronic resource) ; Microsoft Team manager ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: This lesson explores how Outlook Groups, SharePoint, and Microsoft Teams can work together within the Microsoft 365 suite to simplify tasks and boost collaborative efficiency. We demonstrate how to create and manage a group directly from Outlook Online. Learn how to add members and utilise the unique group email address. Uncover the interconnected nature of Microsoft 365 applications and examine the synchronisation between Outlook and SharePoint, allowing you to manage and share documents within your team. Establish the time-saving benefits of using your Outlook group to create a team in Microsoft Teams, ensuring consistency across settings and members. Optimise your Microsoft 365 experience by understanding the seamless connection between features.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Stop using SUMIF 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: In this lesson, we examine a common practice in Excel that might be holding you back: the SUMIF function. While SUMIF has been a favourite for many, we're here to introduce you to a more powerful alternative – the SUMIFS (plural!) function. The SUMIFS function not only replicates the capabilities of SUMIF but takes it a step further by accommodating multiple criteria seamlessly. No longer bound by the limitations of SUMIF, SUMIFS empowers you to handle complex conditions. Join us as we showcase how SUMIFS can efficiently replace SUMIF in both single and multiple-criterion scenarios. Embrace the efficiency, simplicity, and versatility of SUMIFS to revolutionise the way you approach data analysis.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Create a conditional chart 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: This lesson will guide you through creating a dynamic and visually impressive conditional clustered column chart with a moving target line using Microsoft Excel. If you've ever wondered how to make your charts both informative and aesthetically pleasing, this one’s for you. Learn how to add extra columns strategically and use conditional formulas to highlight specific data points. By the end of this lesson, you'll have a visually appealing and insightful chart — demonstrating the power of conditional formatting and dynamic data visualisation in Excel.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Data validation lists with images 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: Ever wondered how to seamlessly integrate a data validation dropdown list with dynamic images in Excel? Look no further! This lesson will guide you through selecting criteria from a dropdown and making the corresponding images dynamically appear in your worksheet. We’ll explore creating a polished data validation dropdown and linking it with carefully aligned images. You’ll learn how to create named ranges and employ the Indirect formula for dynamic image referencing. Elevate your spreadsheet game and add a dash of creativity to your data validation process.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Manage emails with Quick Steps in Outlook (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.5/7
    Keywords: Microsoft Outlook ; Business Computer programs ; Time management ; Personal information management Computer programs ; Electronic mail systems Computer programs ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: QuickSteps in Outlook is ideal for personalised and on-the-spot email handling. We'll explore the often-overlooked QuickSteps group on the Home tab, revealing the power to create and execute personalised actions for more efficient inbox management. Unlike rules that apply broadly, QuickSteps empower you to perform targeted actions on individual emails at your discretion. By the end of this lesson, you'll have the skills to create and utilise QuickSteps in Outlook, transforming how you manage your emails. Say hello to a more tailored Outlook experience that aligns with your unique workflow. Join us to make your email management more personalised and efficient.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    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.
  • 32
    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.
  • 33
    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.
  • 34
    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.
  • 35
    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.
  • 36
    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.
  • 37
    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.
  • 38
    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.
  • 39
    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.
  • 40
    Online Resource
    Online Resource
    Custom formatting 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: Unlock the power of Custom Formatting in Excel as we guide you through transforming your data with style. Discover how to add colour, symbols, and flair to your spreadsheet. In this lesson, we'll explore custom formatting, and you’ll learn how to transform your data presentation from ordinary to extraordinary. Whether you're a beginner or an advanced user, this course is designed to empower you with the skills needed to create visually stunning and insightful spreadsheets.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Add a search box to a spreadsheet 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: This lesson explores the process of adding a dynamic Search Box to an Excel spreadsheet. Whether you're managing a vast dataset or something smaller, this lesson will guide you through creating a Search Box that performs both full and partial matches to highlight corresponding information. We'll utilise form controls, conditional formatting, and a carefully crafted formula to achieve this interactive functionality. Effortlessly enhance your Excel spreadsheets with the practical search feature that dynamically highlights relevant entries, making data exploration in Excel so much simpler.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    The advanced filter 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: The Advanced Filter feature provides an alternative to the more commonly used dropdown menus and the FILTER function. This lesson guides you through the steps of using the Advanced Filter to extract specific data based on criteria. While it proves effective in isolating desired information, we also address a drawback – the lack of automatic updates for changed criteria. However, we offer a quick solution: creating a user-friendly macro and assigning it to a button for seamless data refresh, making the Advanced Filter even more accessible and efficient. Whether you're a seasoned Excel user or just starting, this lesson is a valuable addition to your toolkit.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Wrap rows like a boss 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) ; Electronic spreadsheets Computer programs ; Business Computer programs ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: This lesson showcases efficient data organisation with WrapRows. It provides insights for both Microsoft 365 users and those on other Excel versions. We'll address the need to split a dataset into distinct columns with a streamlined approach and uncover how to utilise the WrapRows function, leveraging the latest Excel functions. You’ll become familiar with practical shortcuts and commands to simplify your data management process and elevate your Excel skills.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Do you know these pivot table hacks 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: This lesson covers data analysis and visualisation and confronts the challenge of deciphering a confusing sales chart. We'll explore the intricacies of data and the need for a strategic pivot table intervention. Explore various Excel table features and create a comprehensive PivotTable for a refined and organised dataset. The lesson presents solutions to technical challenges and provides a deeper understanding of data representation and manipulation. Learning Objectives Proficiently analyse and visualise data in Excel and master the use of pivot tables and line charts for effective data representation and manipulation.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    Convert values in a spreadsheet 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 ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: This lesson explores practical methods for converting data efficiently. We examine the CONVERT function in Excel, demonstrating how simple it is to switch between units. By following our step-by-step guide, you'll see how to seamlessly convert data and unlock the potential of the CONVERT function for various transformations, such as changing centimetres to feet, celsius to Fahrenheit or stones to kilograms. This lesson extends to currency conversion, showcasing another method using Microsoft 365's Data Types. We’ll guide you through creating a table, applying data types, and utilising live data to track exchange rates.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 20, 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
    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.
  • 47
    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.
  • 48
    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.
  • 49
    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.
  • 50
    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.
  • 51
    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.
  • 52
    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.
  • 53
    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.
  • 54
    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.
  • 55
    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.
  • 56
    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.
  • 57
    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.
  • 58
    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.
  • 59
    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.
  • 60
    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.
  • 61
    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.
  • 62
    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.
  • 63
    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.
  • 64
    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.
  • 65
    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.
  • 66
    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.
  • 67
    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.
  • 68
    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.
  • 69
    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.
  • 70
    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.
  • 71
    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.
  • 72
    Online Resource
    Online Resource
    Microsoft PolyBase Concepts and Configuration : Binding SQL Server and Other Platforms into a Single Data Source (2020)
    [Erscheinungsort nicht ermittelbar] : Apress | Boston, MA : Safari
    Details
    ISBN: 9781484261910
    Language: English
    Pages: 1 online resource (1 video file, approximately 60 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: This video provides an overview of PolyBase, Microsoft's technology for data virtualization. Modern data platform environments require that we deal with an increasingly heterogeneous array of technologies spanning the SQL and NoSQL worlds, including SQL Server, Oracle, Teradata, Hadoop, Spark, MongoDB, and more. Whether you are a database developer or administrator, application developer, business analyst, or data scientist, the allure of data virtualization through PolyBase is obvious: one central location where data may be queried regardless of where it lives. You will learn from this video the high-level concepts associated with PolyBase, starting with its origins and key benefits. You will see how to install and configure PolyBase for SQL Server 2019, and how to prepare for integration with various data platform technologies. From there, you will learn the three key concepts and external object types in PolyBase: external data sources, external file formats, and external tables. Finally, after understanding each of the three external object types, you will see how Microsoft makes it easy to write queries in one consistent language to access data from a variety of data sources, including from competing database brands. What You Will Learn Become familiar with the concept of data virtualization Discover where PolyBase fits in the SQL Server ecosystem Configure your SQL Server environment to work with PolyBase Specify configuration options for connecting to a Hadoop cluster Understand how external data sources, file formats, and tables work Query from many data sources at once using a single, T-SQL query Who This Video Is For Data platform specialists working on multiple data platforms who want to use one unifying language to tie those platforms together. For SQL Server and T-SQL professionals wanting to seamlessly query from other and even competing platforms using their preferred language. For data professionals wanting to combine the power of SQL Server with that of Hadoop.
    Note: Online resource; Title from title screen (viewed July 23, 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.
  • 73
    Online Resource
    Online Resource
    Reactive Spring Boot, 2nd Edition (2020)
    [Erscheinungsort nicht ermittelbar] : Addison-Wesley Professional | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 3 hr., 7 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    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. Reactive Spring Boot, 2nd Edition
    Note: Online resource; Title from title screen (viewed February 13, 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.
  • 74
    Online Resource
    Online Resource
    Starting Kanban (2020)
    [Erscheinungsort nicht ermittelbar] : Addison-Wesley Professional | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 3 hr., 51 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: 4+ Hours of Video Instruction Description Be the team everyone trusts. Overview Learn Kanban and master key strategies for improving the flow of work on your teams in this introductory video. Starting Kanban helps you find success in leading teams by bringing you inside the classroom, on to real teams, and into private sessions between Kanban's most celebrated experts. Enjoy access to world-class content and join a community of like-minded agilists who are pursuing mastery. About the Instructor Brendan Wovchko was the engineer-turned-manager you'd never want to work for-perpetually leaving a wake of distraction and disruption behind him. That is, until Kanban. Drawing from his experience as both a maker and a stakeholder, Brendan teaches that perfect leadership and flawless execution isn't a requirement to be the team that everyone trusts-it's mastering key strategies for improving the flow of work on your team. He is the founder of Huge IO, an Accredited Kanban Trainer, software entrepreneur, and community organizer. Skill Level Beginner Learn How To Unhide work Get organized Clarify priorities Stop overburdening Overcome gridlock Deliver predictability Collaborate effectively Communicate effectively Reduce emergencies Eliminate rework About HugeIO HugeIO is a company that teaches Kanban in the form of video courses, live workshops and Kanban games. It is an accredited training organization through Lean Kanban University, the global authority in Kanban education.
    Note: Online resource; Title from title screen (viewed February 7, 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.
  • 75
    Online Resource
    Online Resource
    Spotlight on Data : Refactoring a Million-Line Codebase with Maude Lemaire (2020)
    [Erscheinungsort nicht ermittelbar] : O'Reilly Media, Inc. | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 0 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: In late 2017, Slack's largest customers were plagued with relentless performance-related outages, due in part to the fact that public channels, private channels, and DMs were stored in completely distinct ways. Instead of shipping scrappy, short-term fixes, the company opted to address the root problem and completely refactor problematic functionality by consolidating any redundant database schemas. In this Spotlight on Data , Maude Lemaire explains how Slack succeeded by mapping out a precise plan that was careful to scope the effort to only its necessary components. Join in to learn real-world, successful techniques for modernizing your infrastructure from the ground up-live and in production. Recorded on November 18, 2019. See the original event page for resources for further learning or watch recordings of other past events . O'Reilly Spotlight explores emerging business and technology topics and ideas through a series of one-hour interactive events. In live conversations, participants share their questions and ideas while hearing the experts' unique perspectives, insights, fears, and predictions for the future. In every edition of Spotlight on Data , you'll learn about, discuss, and debate the tools, techniques, questions, and quandaries in the world of data. You'll discover how successful companies leverage data effectively and how you can follow their lead to transform your organization and prepare for the Next Economy.
    Note: Online resource; Title from title screen (viewed February 12, 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.
  • 76
    Online Resource
    Online Resource
    Spotlight on Cloud : Reliable Product Launches with David Huska and Stephen Thorne (2020)
    [Erscheinungsort nicht ermittelbar] : O'Reilly Media, Inc. | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 2 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Approach your product launches more strategically. David Huska and Stephen Thorne-senior engineers from Google's customer reliability engineering team-share best practices for successfully and reliably deploying new products, services, and features.In this Spotlight on Cloud, find out about choosing technology and feature sets for upcoming launches; integrating reliability practices into product development, failure domains, and graceful degradation for publicly visible features; and recovering quickly when services fail unexpectedly. Recorded on November 26, 2019. See the original event page for resources for further learning or watch recordings of other past events . O'Reilly Spotlight explores emerging business and technology topics and ideas through a series of one-hour interactive events. In live conversations, participants share their questions and ideas while hearing the experts' unique perspectives, insights, fears, and predictions for the future. In every edition of Spotlight on Cloud , you'll learn about the complex, ever-evolving world of the cloud. You'll discover how successful companies have adopted and embraced this massive network of shared information and how you can follow their lead to transform your organization and prepare for the Next Economy.
    Note: Online resource; Title from title screen (viewed February 12, 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.
  • 77
    Online Resource
    Online Resource
    ReactJS Fundamentals, 3rd Edition (2020)
    [Erscheinungsort nicht ermittelbar] : Addison-Wesley Professional | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 6 hr., 39 min.)
    Edition: 3rd edition
    Keywords: Electronic videos ; local ; Electronic videos
    Abstract: 7+ Hours of Video Instruction Get started with React.js for front-end web development Overview React.js Fundamentals LiveLessons, Third Edition, covers vanilla React and presents a refresher on some advanced JavaScript topics and essential ES6 features. You first learn how to create a modern React toolchain. Next, the training covers the advanced JavaScript concepts that regularly pop up in React and the modern ES6 features you'll need to write more idiomatic React code. Next, the training covers a conceptual understanding of React and takes an in-depth look at how React's virtual DOM works. Starting in Lesson 6, you dive into writing React code using the original create class syntax and begin to look at the JSX. Next, you see how to rewrite your earlier code using modern es6 features. From there, you learn the remaining vanilla React topics, such as component lifecycle and state management. The training wraps up with a discussion of how you can tweak performance in React apps, use styling, and create functional components. About the Instructor Charles Crawford III has more than ten years of software experience and five years of experience in software education. He is currently a lead instructor at Code Fellows, where he teaches full-stack web programming. He is also an active software and writing consultant and the director of marketing for Hack The People, a distributed nonprofit organization focused on fostering mentor-mentee relationships in software development. Additionally, Charles is an active blog contributor at The New Stack, a site featuring news about and analysis of an ever-changing software development ecosystem. Prior to this, Charles was a developer evangelist for Shippable, a SaaS that leverages Docker to provide continuous integration services. He was also a software engineer at Amazon Web Services on the Elastic Beanstalk team, where he worked on things such as the Elastic Beanstalk Ruby container, Nodejs container, and the Docker container. Skill Level Intermediate Learn How To Utilize the React toolchain Understand the advanced JavaScript features used with React Use ES6 features with React Understand basic React concepts Utilize React's virtual DOM Code a React app with traditional and ES6 Optimize React performance Utilize libraries to make React a complete front-end solution Use React router Use Flux Use Redux Test React applications Use React functional components Who Should Take This Course Intermediate t...
    Note: Online resource; Title from title screen (viewed January 16, 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.
  • 78
    Online Resource
    Online Resource
    Deep Learning for Natural Language Processing, 2nd Edition (2020)
    [Erscheinungsort nicht ermittelbar] : Addison-Wesley Professional | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 4 hr., 60 min.)
    Edition: 2nd edition
    Keywords: Electronic videos ; local
    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.
    Note: Online resource; Title from title screen (viewed February 4, 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.
  • 79
    Online Resource
    Online Resource
    Kotlin Design Patterns (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781839213021
    Language: English
    Pages: 1 online resource (1 video file, approximately 2 hr., 22 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Uncover essential design patterns with Kotlin About This Video Implement classical designs via creational, structural, and behavioral patterns and get insights into the advantages and possibilities they bring Use a wide range of design patterns to polish your Android code and write cleaner code effortlessly A practical course comprising small and straightforward examples in a friendly style to help you write high-quality programs and create customized applications In Detail Over the years, programmers have run into pretty much the same problems time and time again; not every problem is entirely unique. Therefore, over time programmers applied varying solutions to these problems, and this is how design patterns were born. This course will walk you through some centrally significant design patterns so that you can easily resolve programming issues encountered in your day-to-day tasks. You'll learn these patterns in one of the most modern languages: Kotlin! We cover the three major areas in design patterns: creational patterns, structural patterns, and behavioral patterns. We also implement one structural pattern-Decorators-that plays an important role in adding functionalities to your programs. We take a look at different kinds of problem and implement the required patterns while avoiding common pitfalls. We also supply useful tips and tricks to use design patterns more effectively. By the end of the course, you will be confident about using varying types of design patterns to solve common design problems. Please note that a basic familiarity with Kotlin is desirable to get the most out of this course, along with some experience working with Android Studio.
    Note: Online resource; Title from title screen (viewed January 30, 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.
  • 80
    Online Resource
    Online Resource
    IP Subnetting Video and Practice Questions Kit (2020)
    [Erscheinungsort nicht ermittelbar] : Cisco Press | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 38 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: IP Subnetting Video and Practice Questions Kit 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.
    Note: Online resource; Title from title screen (viewed February 12, 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.
  • 81
    Online Resource
    Online Resource
    AZ-900 Microsoft Azure Fundamentals Exam Quick Prep (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781800206175
    Language: English
    Pages: 1 online resource (1 video file, approximately 3 hr., 23 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local ; Electronic videos
    Abstract: Learn Microsoft Azure and become a certified expert to give your career a new direction About This Video Get to grips with Azure fundamental concepts Derive your own cloud solutions by understanding Microsoft Azure cloud Learn an important and mandatory skill for Windows server administrators and developers In Detail AZ-900 Azure Fundamentals exam is intended for candidates with non-technical backgrounds, such as those involved in selling or purchasing cloud-based solutions and services, as well as those with a technical background who have a need to validate their foundational-level knowledge around cloud services and Azure. This course starts off by setting up a blueprint of what the course covers and how you will travel through the concepts. You will begin by exploring the benefits of cloud services and how as-a-service offerings function. You will further cover cloud models and core Azure architectural components. In the concluding modules, you will understand the internet of things (IoT) on Azure. By the end of this course, you'll become skilled enough to confidently appear in the Microsoft Azure fundamentals examination.
    Note: Online resource; Title from title screen (viewed January 31, 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.
  • 82
    Online Resource
    Online Resource
    The Comprehensive Android Developer Bootcamp (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781800561083
    Language: English
    Pages: 1 online resource (1 video file, approximately 43 hr., 1 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local ; Electronic videos
    Abstract: Learn new Android APIs such as RoomDatabase, ML Kit for face recognition, Cloud Firestore, Firebase, Maps, and the Android Studio IDE (integrated development environment) About This Video Build Android apps from scratch by using the Android Studio IDE and Java Explore new Android APIs such as Firebase Realtime Database and ML Kit and the Room Persistence Library Upload your apps to Google Play Store and reach millions of Android users worldwide In Detail Android is one the most popular operating systems in the world, so Android app development can help you explore a wide range of opportunities to build a successful career. If you have creative app ideas but don't know where to start, are looking to switch careers and Android development has piqued your interest, or you simply want to add more value to the workplace, this fully updated course will help you build a strong foundation in Android development, Android Studio, and object-oriented Java programming. The course begins by teaching you how to install Android Studio for Windows, and takes you through the initial steps involved in Android development. You'll then delve into Java and get to grips with object-oriented programming in Java, along with focusing on Java inheritance and data structures. As you advance, you'll understand the Android app structure and learn how to build apps such as a trivia app and the Make It Rain app. Finally, you'll discover how to finalize the Android apps and run them on physical devices. By the end of this course, you'll have fully understood how to develop Android apps and be able to start building on your app ideas.
    Note: Online resource; Title from title screen (viewed May 29, 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.
  • 83
    Online Resource
    Online Resource
    SQL Server Transparent Data Encryption : Protecting Database Files at Rest (2020)
    [Erscheinungsort nicht ermittelbar] : Apress | Boston, MA : Safari
    Details
    ISBN: 9781484259221
    Language: English
    Pages: 1 online resource (1 video file, approximately 35 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Protect yourself against data theft through unauthorized access to the physical database files and their copies that may be found in backup sets and transaction logs. Thwart unauthorized access to those files by making use of SQL Server's Transparent Data Encryption (TDE) feature to provide at-rest encryption of an entire database such that only authorized instances of SQL Server can read the data, log, and backup files. This video explains how the TDE feature works and shows how to implement at-rest encryption using best practices. It also covers independent backup encryption for an additional layer of protection. The video begins with an introduction to TDE and the pros and cons of its implementation. It talks about the use case for applying this type of encryption. The video then walks you through implementing TDE on a new database or existing database. Next, it will cover how to manage the movement of these encrypted databases. Finally, you'll cover independent backup encryption. What You Will Learn Recognize use cases for Transparent Data Encryption Encrypt your entire database, including log and backup files Preserve encryption keys and restore from encrypted backups Manage encryption through dynamic management objects Encrypt database backups independently of TDE Move a TDE encrypted database, including log files Who This Video Is For Database administrators who need to encrypt a database at rest to meet IT audit requirements, or for reasons of data privacy and confidentiality. For system architects who want to understand their options for securing their organization's confidential data.
    Note: Online resource; Title from title screen (viewed April 20, 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.
  • 84
    Online Resource
    Online Resource
    React Native Projects (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781839210112
    Language: English
    Pages: 1 online resource (1 video file, approximately 3 hr., 17 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Expand and enhance your skills by building multiple practical, real-world projects with React Native. About This Video Develop practical cross-platform projects with React Native using several of its most popular packages Strengthen your React Native skills by building a scalable codebase that enhances code sharing Get to grips with React Native for Windows, a powerful framework for building native Windows apps with React In Detail Understanding essential React Native concepts and how it differs from React, can be difficult to translate into a working proof of concept. It is imperative to utilize your skills and knowledge in real-world projects in order to implement solutions when in the workplace or developing your own application. This course aims to bridge the gap between the primary knowledge of React Native and its implementation. Focusing on developing several practical applications to handle issues such as navigation, state management, and UI/UX concerns. You'll start by developing a Note application that uses Async storage to persist notes. Then learn how to fetch data and images from external APIs for your project and enhance your UI skills. Then finally, you'll learn how to perform effective state management and develop a useful project using the React Native for Windows framework. By the end of this course, you will have gained the experience needed to make confident decisions when it comes to application development with React Native.
    Note: Online resource; Title from title screen (viewed April 16, 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.
  • 85
    Online Resource
    Online Resource
    Meet the Expert : Tim O'Reilly and David Heinemeier Hansson (2020)
    [Erscheinungsort nicht ermittelbar] : O'Reilly Media, Inc. | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 58 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Join us for this special conversation between Tim O'Reilly, founder and CEO of O'Reilly Media, and David Heinemeier Hansson, creator of Ruby on Rails and cofounder and CTO at Basecamp. They cover some of the key themes from three of David's best-selling books-It Doesn't Have to Be Crazy at Work, REWORK, and REMOTE: Office Not Required-as they examine how remote work can lead to more innovation and personal satisfaction and discuss how to run a calm company by forgoing the lure of excessive growth and making your time count for more. Recorded on April 8, 2020. See the original event page for resources for further learning or watch recordings of other past events . O'Reilly Meet the Expert explores emerging business and technology topics and ideas through a series of one-hour interactive events. You'll engage in a live conversation with experts, sharing your questions and ideas while hearing their unique perspectives, insights, fears, and predictions.
    Note: Online resource; Title from title screen (viewed April 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.
  • 86
    Online Resource
    Online Resource
    Meet the Expert : Lee Atchison on the Cloud Mistakes You Didn't Know You Were About to Make (2020)
    [Erscheinungsort nicht ermittelbar] : O'Reilly Media, Inc. | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 59 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Did you think moving to the cloud would be easy? You're not alone. Countless CTOs admit now that they had no idea how hard it would be and that they would make many mistakes along the way. What these leaders missed is that cloud excellence is as much cultural as it is technical. In this Meet the Expert, Lee Atchison outlines how to create a culture of cloud excellence. Lee will show you how to instill the cultural changes necessary to transform your organization into a true cloud organization, with lessons drawn from the hard-fought wisdom of CTOs around the world. Recorded on April 15, 2020. See the original event page for resources for further learning or watch recordings of other past events . O'Reilly Meet the Expert explores emerging business and technology topics and ideas through a series of one-hour interactive events. You'll engage in a live conversation with experts, sharing your questions and ideas while hearing their unique perspectives, insights, fears, and predictions.
    Note: Online resource; Title from title screen (viewed April 23, 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.
  • 87
    Online Resource
    Online Resource
    Meet the Expert with Tim O'Reilly : Preparing for the Post-Covid Future (2020)
    [Erscheinungsort nicht ermittelbar] : O'Reilly Media, Inc. | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 0 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: The future will not be like the past. We're at an inflection point where the decisions our societies make now can have an enormous impact on the course of the next few decades. Those of us in business have difficult choices to make. And those choices have to be made with wildly uncertain futures in mind. We can no longer base our strategies on the old baselines of predictable consumer demand, globalization, office life and business travel, and access to talent, credit, or venture funding. In this edition of Meet the Expert, Tim O'Reilly discusses what skills will be needed to plan for the new world and how scenario planning will help you develop a robust strategy that will hold up well against a range of possible outcomes. Learn how to better prepare for a post-COVID future as you explore the technologies that will be most important in the 21st century. Recorded on June 15, 2020. See the original event page for resources for further learning or watch recordings of past events . O'Reilly Meet the Expert explores emerging business and technology topics and ideas through a series of one-hour interactive events. You'll engage in a live conversation with experts, sharing your questions and ideas while hearing their unique perspectives, insights, fears, and predictions.
    Note: Online resource; Title from title screen (viewed June 18, 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.
  • 88
    Online Resource
    Online Resource
    Meet the Expert : Nicole Sanchez on the Future of Diversity, Equity, and Inclusion in Tech (2020)
    [Erscheinungsort nicht ermittelbar] : O'Reilly Media, Inc. | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 60 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: For the last several years, diversity, equity, and inclusion (DEI) has dominated tech headlines. Companies are beginning to understand that DEI is a vital part of a healthy and successful company. But in the wake of COVID-19, how will this work shift? Will companies stay committed to DEI? And how can we leverage the best practices of inclusion to create sustainable businesses in this challenging time? In this Meet the Expert session, Nicole Sanchez-founder and managing partner of tech's leading DEI firm, Vaya Consulting-talks about where DEI is going next and how companies can move beyond rhetoric and into action. Recorded on June 17, 2020. See the original event page for resources for further learning or watch recordings of past events . O'Reilly Meet the Expert explores emerging business and technology topics and ideas through a series of one-hour interactive events. You'll engage in a live conversation with experts, sharing your questions and ideas while hearing their unique perspectives, insights, fears, and predictions.
    Note: Online resource; Title from title screen (viewed June 18, 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.
  • 89
    Online Resource
    Online Resource
    Meet the Expert : Jennifer Pahlka and Tim O'Reilly on Turbocharging Government's Response to the COVID-19 Crisis (2020)
    [Erscheinungsort nicht ermittelbar] : O'Reilly Media, Inc. | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 57 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: We've all seen the headlines: "States Overwhelmed by Previously Unimaginable Layoff Numbers"; "Here's What Is in the 'Families First' Coronavirus Aid Package"; "Local Governments Struggle to Obey Their Own Social Distancing Mandates." It's a perfect storm for government: unprecedented demand and urgent new programs to respond to the disaster at the same time as many government employees used to working face-to-face must suddenly work from home. Add to that a flood of stimulus money now, followed by a later drought as tax revenues are gutted by the economic shutdown, and two things are clear: people depend on government more than ever, and for government workers, getting better at providing digital services is no longer "nice to have" but "must have." In this Meet the Expert, Tim O'Reilly talks with Jennifer Pahlka, founder of Code for America, former deputy chief technology officer of the United States, and now cofounder of United States Digital Response, a new nonprofit connecting technology volunteers with governments that need their help. They discuss the new challenges governments face-and the resources that are available to meet them-and share case studies of how governments are fulfilling their mission in the present crisis. Recorded on April 21, 2020. See the original event page for resources for further learning or watch recordings of other past events . O'Reilly Meet the Expert explores emerging business and technology topics and ideas through a series of one-hour interactive events. You'll engage in a live conversation with experts, sharing your questions and ideas while hearing their unique perspectives, insights, fears, and predictions.
    Note: Online resource; Title from title screen (viewed April 28, 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.
  • 90
    Online Resource
    Online Resource
    Machine Learning for Finance (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781789535143
    Language: English
    Pages: 1 online resource (1 video file, approximately 4 hr., 31 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Machine Learning techniques for solving major financial issues About This Video Sets a foundation of what to follow by teaching visualization and exploratory analysis of financial data, the typical features like RSI and moving average. Predict stock prices by using Machine Learning models like Linear Regression, Random Forest, XGBoost and neural networks. Use modern portfolio theory, Sharpe ratio, investment simulation, and machine learning to create a rewarding portfolio of stock investments. In Detail Machine Learning for Finance is a perfect course for financial professionals entering the fintech domain. It shows how to solve some of the most common and pressing issues facing institutions in the financial industry, from retail banks to hedge funds. This video course focuses on Machine Learning and covers a range of analysis tools, such as NumPy, Matplotlib, and Pandas. It is packed full of hands-on code simulating many of the problems and providing working solutions. This course aims to build your confidence and the experience to go ahead and tackle real-life problems in financial analysis. The industry is adopting automatic, data-driven algorithms at a rapid pace, and Machine Learning for Finance gives you the skills you need to be at the forefront. By the end of this course, you will be equipped with all the tools from the world of Finance, machine learning and deep learning essential for tackling all these pressing issues in the area of Fintech.
    Note: Online resource; Title from title screen (viewed April 23, 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.
  • 91
    Online Resource
    Online Resource
    Lean AI (Audio Book) (2020)
    [Erscheinungsort nicht ermittelbar] : O'Reilly Media, Inc. | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 7 hr., 44 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local ; Audiobooks ; local
    Abstract: How can startups successfully scale customer acquisition and revenue growth with a Lean team? Out-of-the-box acquisition solutions from Facebook, Google, and others provide a good start, but the companies that can tailor those solutions to meet their specific needs, objectives, and goals will come out winners. But that hasn't been an easy task-until now. With this practical book, author Lomit Patel shows you how to use AI and automation to provide an operational layer atop those acquisition solutions to deliver amazing results for your company. You'll learn how to adapt, customize, and personalize cross-channel user journeys to help your company attract and retain customers-to usher in the new age of Autonomous Marketing. Learn how AI and automation can support the customer acquisition efforts of a Lean Startup Dive into Customer Acquisition 3.0, an initiative for gaining and retaining customers Explore ways to use AI for marketing purposes Understand the key metrics for determining the growth of your startup Determine the right strategy to foster user acquisition in your company Manage the increased complexity and risk inherent in AI projects
    Note: Online resource; Title from title screen (viewed April 30, 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.
  • 92
    Online Resource
    Online Resource
    Hands-On Transfer Learning with TensorFlow 2.0 (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781789953947
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 25 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Hands-on implementation with the power of TensorFlow 2.0 About This Video Refresh your knowledge of CNN with in-depth explanations of how transfer learning works Use transfer learning for both image and text classification, and compare/contrast with the training from scratch approach Learn new features of TensorFlow 2.0, tf.keras, TensorFlow Hub, TensorFlow Model Maker, and on-device training In Detail Transfer learning involves using a pre-trained model on a new problem. It is currently very popular in the field of Deep Learning because it enables you to train Deep Neural Networks with comparatively little data. In Transfer learning, knowledge of an already trained Machine Learning model is applied to a different but related problem. The general idea is to use knowledge, which a model has learned from a task where a lot of labeled training data is available, in a new task where we don't have a lot of data. Instead of starting the learning process from scratch, you start from patterns that have been learned by solving a related task. In this course, learn how to implement transfer learning to solve a different set of machine learning problems by reusing pre-trained models to train other models. Hands-on examples with transfer learning will get you started, and allow you to master how and why it is extensively used in different deep learning domains. You will implement practical use cases of transfer learning in CNN and RNN such as using image classifiers, text classification, sentimental analysis, and much more. You'll be shown how to train models and how a pre-trained model is used to train similar untrained models in order to apply the transfer learning process even further. Allowing you to implement advanced use cases and learn how transfer learning is gaining momentum when it comes to solving real-world problems in deep learning. By the end of this course, you will not only be able to build machine learning models, but have mastered transferring with tf.keras, TensorFlow Hub, and TensorFlow Lite tools.
    Note: Online resource; Title from title screen (viewed May 28, 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.
  • 93
    Online Resource
    Online Resource
    Getting Started with Microsoft Cosmos DB Using C# : Cloud Database Support for .NET Applications (2020)
    [Erscheinungsort nicht ermittelbar] : Apress | Boston, MA : Safari
    Details
    ISBN: 9781484260203
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 3 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: This video introduces Cosmos DB and highlights the benefits that using Cosmos DB can bring to your applications and clients. Watching this video helps to increase your toolbox of knowledge around Azure and build your skills on this important cloud platform. Examples in the video are built in C#, the language from which Cosmos DB is most commonly used. A running example throughout the video demonstrates the basics of entering data, querying and updating data, deleting data, and working with the Cosmos DB change feed. What You Will Learn Understand Cosmos DB and when it should be used Become familiar with the different APIs that are available Create a new service in Azure in support of a Cosmos DB database Develop applications locally using C# and the Table API Create a database and add data to it Query, update, and delete data as needed React to events and streaming data with the change feed Who This Video Is For Developers with knowledge of C#, but who have not used Cosmos DB before and who would like to know more about it and the scenarios in which Cosmos DB is useful. For developers who have come from a relational database background and want to understand how Cosmos DB can be used differently from the relational databases to which they are accustomed.
    Note: Online resource; Title from title screen (viewed May 1, 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.
  • 94
    Online Resource
    Online Resource
    Elegant Automation Frameworks with Python and Pytest (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781800561489
    Language: English
    Pages: 1 online resource (1 video file, approximately 5 hr., 50 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local ; Electronic videos
    Abstract: Leverage pytest's fast, scalable, and professional-grade framework design to build and run automated test suites like a pro About This Video Become proficient in automated testing using pytest Create a well-organized, scalable test framework on a professional level Find out how fixtures can eliminate up to 80% of code in a bloated codebase In Detail Python is one of the most popular programming languages in the world, with its demand increasing by the minute. Pytest - one of the most actively maintained testing frameworks in the industry - provides an incredible set of tools for faster, less stressful testing. In this course, you'll learn how to eliminate boilerplate setup and teardown code, run multiple tests simultaneously, and track your test run history to identify slow or problematic tests. Beginning with a brief introduction and a step-by-step setup of pytest, this course will walk you through each session. You'll discover what makes a good framework, and, more importantly, what makes a bad one. As you advance, you'll learn how to use test searching to avoid cumbersome test suites, and how fixtures can eliminate up to 80% of code in case of code bloat. This interactive course is also equipped with information-rich videos to help you grasp the concepts with ease. By the end of this course, you'll be ready to build high-performance, well-organized, scalable test frameworks on the professional level.
    Note: Online resource; Title from title screen (viewed May 28, 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.
  • 95
    Online Resource
    Online Resource
    Complete Bash Shell Scripting (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781800209695
    Language: English
    Pages: 1 online resource (1 video file, approximately 17 hr., 7 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local ; Electronic videos
    Abstract: Automate repetitive tasks with Bash Shell Scripting to save valuable time About This Video Learn the basics of Bash Shell Scripting Explore the input and output commands for shell scripting Understand arithmetic operators with detailed explanations In Detail This course is designed to help you automate repetitive tasks and master Bash Shell Scripting easily. With most organizations adopting the open source Linux and Unix operating systems, there is an ever-increasing demand for developers with Linux and Unix skills. This course covers command-line commands and Bash Shell Scripting extensively to help you become a Linux\Unix OS expert.
    Note: Online resource; Title from title screen (viewed April 30, 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.
  • 96
    Online Resource
    Online Resource
    C# and Unity by Example : 20+ Mini Game Development Projects (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781800561069
    Language: English
    Pages: 1 online resource (1 video file, approximately 13 hr., 13 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Get to grips with Unity game development by building over 20 mini projects using Unity and C# About This Video Build a 2D shooter game in just 1 hour Create your first 3D model and import it into Unity Integrate video ads in your games In Detail The Unity game engine is free and easy to learn and has excellent documentation. Equipped with Unity game development skills and knowledge of C# scripting, you will be able to build impressive games easily. Suitable for beginners, this course includes more than 100 lectures and over 20 hours of content. You'll learn Unity 2D and 3D game development by building 20+ mini projects and develop skills that you can use in any of your Unity projects later. Starting with the installation of Unity and Visual Studio, this course will take you through the process of learning game development with Unity by building a variety of projects. For budding programmers, a separate section covers the fundamentals of C# scripting for game development in Unity. Once you've mastered the basics, the course will take you through sample projects that demonstrate the process of creating games with Unity. By the end of the course, you'll have developed the knowledge to create fully-functional games with Unity and C# and use your C# skills to build any other non-game projects. Complete with working files, you'll be able to build game projects with the author and receive a verifiable certificate of completion at the end of the course.
    Note: Online resource; Title from title screen (viewed May 28, 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.
  • 97
    Online Resource
    Online Resource
    AZ-900 : Microsoft Azure Fundamentals Certification 2020 (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781800206946
    Language: English
    Pages: 1 online resource (1 video file, approximately 6 hr., 58 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local ; Electronic videos
    Abstract: Prepare for the Microsoft AZ 900 exam with the help of mock tests and case studies About This Video Explore diagrams, pictorial representations, and live demos to grasp concepts and reinforce the learning Understand the fundamentals of Azure using real-world, enterprise-level cloud projects Cover key points involved in migrating complex infrastructure In Detail Exam AZ-900 is designed for candidates looking to demonstrate foundation-level knowledge of Microsoft Azure cloud services. This exam can be taken as an optional first step in learning about cloud services and how those concepts are exemplified by Microsoft Azure. It can be taken as a precursor to Microsoft Azure or Microsoft cloud services exams. While it is a beneficial first step, validating your fundamental knowledge, taking this exam is not a prerequisite for any other Azure certifications. By the end of this course, you'll be fully equipped with the knowledge required to pass the AZ-900 exam. If you're looking for an entry point to Microsoft Azure, this AZ-900 exam prep course is what you need!
    Note: Online resource; Title from title screen (viewed April 27, 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.
  • 98
    Online Resource
    Online Resource
    Apache Kafka for Absolute Beginners (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781800202054
    Language: English
    Pages: 1 online resource (1 video file, approximately 5 hr., 6 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local ; Electronic videos
    Abstract: Explore the Apache Kafka ecosystem and architecture, and learn client API programming in Java About This Video Get to grips with the Apache Kafka ecosystem and components Delve into Kafka Producer API programming in Java In Detail This course is designed to get you up and running with the fundamentals and the working of Apache Kafka with the help of practical examples. You will also delve into client API programming in Java. As you progress, you will not only cover the Apache Kafka stack, but also the architecture of Kafka components and Kafka client APIs (Producers and Consumers). The course will even guide you on how to apply the knowledge you've gained through the course to create efficient Kafka programs in Java. This course is based on Apache Kafka 2.x. All the source code and examples used in this course on Apache Kafka 2.3 open-source distribution have been tested. Several examples in this course also make use of the Confluent Community Version of Kafka. The course will focus on the Confluent Community Version to explain and demonstrate functionalities that are only available in the Confluent Platform, such as Schema Registry and Avro Serdes. This course will be making extensive use of IntelliJ IDEA as the preferred development IDE. However, based on your prior experience, you should be able to work with any other IDE designed for Java application development. Although the course will be using Apache Maven as the preferred build tool, based on your prior experience, you should be able to use any other build tool designed for Java applications. In addition to this, the course will use Log4j2 to teach you industry-standard log implementation in your applications. This course is fully example-driven and several examples will be created in the class. By the end of this course, you will have gained the skills you need to confidently build Kafka programs in Java.
    Note: Online resource; Title from title screen (viewed April 29, 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.
  • 99
    Online Resource
    Online Resource
    The Complete Flutter and Dart App Development Course (2020)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781800563322
    Language: English
    Pages: 1 online resource (1 video file, approximately 21 hr., 30 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local ; Electronic videos
    Abstract: Learn Flutter - Google's mobile development framework - and build Flutter iOS and Android apps using a single codebase About This Video Get an introduction to Flutter and understand Flutter app anatomy Design, build, and debug Flutter Android and iOS apps Explore the capabilities of Flutter to build robust apps In Detail The Complete Flutter and Dart App Development Course is the first comprehensive Dart and Flutter course, fully updated to include the latest developments. Flutter is the new cross-platform mobile app development framework created by Google that allows developers to build Android and iOS apps using a single codebase, and it is the best way to develop cross-platform apps, which would otherwise require two distinct mobile development teams. Instead of having to learn Objective-C or Swift to build iOS apps, and Java or Kotlin to build Android apps, you can now use Flutter to build apps that run natively in both iOS and Android devices using the general-purpose programming language Dart. The course begins with an overview of Flutter's capabilities and helps you to download Flutter code and set up development tools for Windows and Mac. It then gives you a comprehensive introduction to Dart and covers the fundamentals and advanced concepts of object-oriented programming (OOP). As you advance, you'll get to grips with Flutter's intermediate concepts and themes. Toward the end, you will build a Flutter tip calculator app and take up quizzes and challenges relating to Flutter widgets and material design. By the end of this course, you'll have gained complete knowledge of Flutter and be able to build both iOS and Android apps like a professional.
    Note: Online resource; Title from title screen (viewed June 30, 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.
  • 100
    Online Resource
    Online Resource
    NEW! Microsoft MS-700 Certification : Managing Teams (2020)
    [Erscheinungsort nicht ermittelbar] : Skylines Academy, LLC | Boston, MA : Safari
    Details
    Language: English
    Pages: 1 online resource (1 video file, approximately 4 hr., 37 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local ; Electronic videos
    Abstract: Welcome to this Skylines Academy MS-700 Certification Course! This course will help you study for and pass the MS-700 exam by Microsoft, which will earn you the coveted Microsoft 365 Certified: Teams Administrator Associate badge. This course has over 4.5 hours of on-demand content and 52 practice questions to test your knowledge; It follows the Microsoft Skills Measured curriculum. David Hood, Instructor at Skylines Academy and Senior Technical Account Manager at Microsoft will lead you through this course. David is also the author and instructor of the MS-100 and MS-101 courses for Skylines Academy and has received an impressive average rating of 4.7 stars from thousands of students! Student Reviews for the Instructor David Hood: "Very, very good instructor. I am a non-native English speaker but I could clearly understand David and the course concepts. Many thanks and I will of course recommend SKYLINES ACADEMY to friends and colleagues." "This course is extremely awesome, for both ideas and practical demonstrations. I really love the contents and the instructor." "David Hood is another great instructor from the Skylines Academy team - great content and I passed the MS-100 exam. Now on to the MS-101 course by David Hood!" Course Description: With more and more professionals working from home, it has become imperative that organizations learn how to properly administer Microsoft Teams to remote workers. This course is the perfect place to learn all about Microsoft Teams so you can run your Teams environment like a pro while making sure all security measures are in place. During your journey, Skylines Academy will lead you through a series of sections, modules, and demos to prepare you for taking, and ultimately passing, the MS-700 exam. During this course, you will learn how to: Plan and Configure a Microsoft Teams Environment: Upgrade from Skype for Business to Microsoft Teams Plan and Configure Network Settings for Microsoft Teams Implement Governance and Lifecycle Management for Microsoft Teams Configure and Manage Guest Access Manage Security and Compliance Deploy and Manage Microsoft Teams Endpoints Monitor and Analyze Service Usage Manage Chat, Calling, and Meetings Manage Chat and Collaboration Experiences Manage Meeting Experiences Manage Phone Numbers Manage Phone Systems Manage Teams and App Policies Manage a Team Manage Members in a Team Implement Policies for Microsoft Teams Apps Lectures will educate you on the fundamental terms ...
    Note: Online resource; Title from title screen (viewed July 9, 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.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...