Your email was sent successfully. Check your inbox.

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

Proceed reservation?

Export
Filter
  • Safari, an O'Reilly Media Company.  (197)
  • Deza, Alfredo  (78)
  • Assemble You Limited,  (52)
  • Electronic videos ; local  (265)
  • Films de formation  (59)
  • Computer programs
Datasource
Material
Language
Years
  • 1
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 2
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 3
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 4
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 5
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 6
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 7
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 8
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 9
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 10
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 11
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 12
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 13
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 14
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 15
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 16
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 17
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 18
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 19
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 20
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 21
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 22
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 23
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 24
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 25
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 26
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 27
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 28
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 29
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 30
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 31
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 32
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 33
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 34
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 35
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 36
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 37
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 38
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 39
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 40
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 41
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 42
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 43
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 44
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 45
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 46
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 47
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 48
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 49
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 50
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 51
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 52
    Online Resource
    Online Resource
    [Place of publication not identified] : Assemble You
    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)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 53
    Online Resource
    Online Resource
    [Place of publication not identified] : Pragmatic AI Solutions
    Language: English
    Pages: 1 online resource (1 video file (1 hr., 26 min.)) , sound, color.
    Edition: [First edition].
    DDC: 006.3/5
    Keywords: Natural language processing (Computer science) ; Artificial intelligence ; Traitement automatique des langues naturelles ; Intelligence artificielle ; artificial intelligence ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Introduction to LLM vulnerabilities This introductory course on vulnerabilities for Large Language Models (LLMs) and language models in general. It provides a deep dive into the practical applications of large language models (LLMs) using Azure's AI services. Upon completion, learners will be able to: Explain the concept of model replication or model shadowing as a potential attack vector in large language models, and describe methods to mitigate it through techniques like rate limiting and buffering. Analyze the potential benefits and limitations of using pre-trained LLMs Develop strategies for mitigating risks and ethical considerations when deploying LLM-powered applications. Describe the high-level process of creating a large language model, including data collection, cleaning, and training. Explain the role of security in large language models and recognize potential security vulnerabilities and attack vectors. Identify insecure plugin designs in large language model software development kits (SDKs) that could lead to remote execution and implement strategies to secure plugins. You will learn how to secure your large language model (LLM) applications by addressing potential vulnerabilities. You will explore strategies to mitigate risks from insecure plugin design, including proper input validation and sanitization. Additionally, you will discover techniques to protect against sensitive information disclosure, such as using a redaction service to remove personally identifiable data from prompts and model responses. Finally, you will learn how to actively monitor your application dependencies for security updates and vulnerabilities, ensuring your system remains secure over time. Week 1: Foundations of Language Models This week you will get a brief overview of LLMs and how do they work Learning Objectives Analyze common types of generative applications and their architectures, including multi-model applications, and understand their challenges and benefits. Explain the functioning of a multi-model application, including the role of the framework and specialized machine learning models. Identify the advantages of smaller, specialized models in terms of resource usage, interaction speed, and deployment agility. Compare and contrast different generative AI application types, such as API-based, embedded models, and multi-model applications, and understand their use cases and challenges. Recognize the importance of large language models in various real-world applications, including text-based chatting, customer service, content creation, and daily tasks. Evaluate the benefits and drawbacks of large language models, considering aspects like accuracy, privacy, and potential misuse. Understand the basics of tokenization, indexing, and probability machines in the context of large language models. Describe the high-level process of creating a large language model, including data collection, cleaning, and training. Explain the role of security in large language models and recognize potential security vulnerabilities and attack vectors. Week 2: Language Model Vulnerabilities This week focuses on model-based vulnerabilities that you can explore with prompts. Learning Objectives Explain the concept of model replication or model shadowing as a potential attack vector in large language models, and describe methods to mitigate it through techniques like rate limiting and buffering. Identify and demonstrate insecure output handling in large language models, and understand the potential security threats and attack vectors associated with it. Understand prompt injection and its implications for large language models, including how certain applications define the initial behavior of these models and how to exploit implicit system prompts. Recognize model theft vulnerabilities and understand how handling and access to system components can impact model security, particularly in the context of dynamically loaded models from external sources. Week 3: System vulnerabilities This week you will learn how to deal with environments and system-based vulnerabilities as they relate to LLMs. Learning Objectives Identify insecure plugin designs in large language model software development kits (SDKs) that could lead to remote execution and implement strategies to secure plugins. Explain the potential risks of sensitive information disclosure in large language models and implement measures to redact personal identifiable information using HTTP APIs and regular expressions. Monitor and update dependencies in large language model applications to prevent potential security vulnerabilities and automate the process using tools like GitHub's Dependabot. Evaluate application vulnerabilities based on the programming language and framework, and implement measures to prevent potential security threats. Week 4: Other types of vulnerabilities Learning Objectives Identify potential security threats and vulnerabilities associated with large and small language models. Implement strategies to prevent security situations and guard against making environments more secure. Recognize the concept of excessive agency in large language models and its potential impacts on functionality. Explain the denial of service threat for large language models and describe methods to guard against API misuse.% About your instructor Alfredo Deza has over a decade of experience as a Software Engineer doing DevOps, automation, and scalable system architecture. Before getting into technology he participated in the 2004 Olympic Games and was the first-ever World Champion in High Jump representing Peru. He currently works in Developer Relations at Microsoft and is an Adjunct Professor at Duke University teaching Machine Learning, Cloud Computing, Data Engineering, Python, and Rust. With Alfredo's guidance, you will gain the knowledge and skills to understand and work with vulnerabilities within language models. Resources Introduction to Generative AI Responsible Generative AI and Local LLMS Practical MLOps book.
    Note: Online resource; title from title details screen (O'Reilly, viewed April 22, 2024)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 54
    Online Resource
    Online Resource
    [Place of publication not identified] : Pragmatic AI Solutions
    Language: English
    Pages: 1 online resource (1 video file (3 hr., 24 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.1
    Keywords: Rust (Computer program language) ; Computer software Development ; Rust (Langage de programmation) ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet
    Abstract: Rust For DevOps Learn how to use and apply DevOps principles using Rust This is an early release of the course. In this course, you will learn the basics of DevOps using the Rust programming language. DevOps helps you build, test, and deploy code faster while creating a robust foundation for your projects and teams. First, we will talk about what DevOps is. You will learn things like automation, monitoring, and working together as a team. Then, we will see how to use DevOps ideas in Rust code. You will learn about version control, testing, containers, and deploying Rust programs. Although this course explains the foundations of DevOps and using Rust which is ideal for beginners, experienced Rust developers will find solid advice in how to apply DevOps best practices to existing applications. Learning Objectives The core principles and practices of DevOps How to apply DevOps concepts to build, package, and deploy applications with Rust The basics of containerization and how to leverage containers for DevOps with Rust Course Content This course is divided into 4 weeks with 3 lessons that contain about 6 videos each. Each video is about 5 minutes long and contains a hands-on demonstration of the concepts covered in the lesson. The course is designed to be taken in order, but you can jump to any lesson you want to learn more about. Week 1: Introduction to DevOps Principles Introduction to DevOps Principles DevOps Considerations for Applications Basics of Containerization Week 2: Implementing monitoring and logging strategies Introduction to monitoring and logging strategies Tools and Services for monitoring and logging Logging with Rust About your instructor Alfredo Deza has over a decade of experience as a Software Engineer doing DevOps, automation, and scalable system architecture. Before getting into technology he participated in the 2004 Olympic Games and was the first-ever World Champion in High Jump representing Peru. He currently works in Developer Relations at Microsoft and is an Adjunct Professor at Duke University teaching Machine Learning, Cloud Computing, Data Engineering, Python, and Rust. With Alfredo's guidance, you will gain the knowledge and skills to build robust applications and infrastructure with the Rust programming language and for Rust applications. Resources Rust Bootcamp Deploy Rust on Azure Functions DevOps command-line tools in Python and Rust Switching to Rust from Python First Steps with Rust Learning Path.
    Note: Online resource; title from title details screen (O'Reilly, viewed September 05, 2023)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 55
    Online Resource
    Online Resource
    [Place of publication not identified] : Pragmatic AI Solutions
    Language: English
    Pages: 1 online resource (1 video file (4 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.13/3
    Keywords: Python (Computer program language) ; Computer programming ; Python (Langage de programmation) ; Programmation (Informatique) ; computer programming ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet ; Webcast
    Abstract: What is the if __name__ condition in Python for? If you've seen __main__ at the end of a Python script and wondered why that is there it is to avoid side effects when importing and allowing you to run the file as a script on the terminal. If you want more details, watch this short video where we work with a Python script to find out those side effects and how the Python script can change once the if condition with __name__ is done at the end. Next Steps Now that you know about the conditional at the end, you might want to explore writing Python scripts that use this trick. There are several examples you can follow in these GitHub repositories with argparse, the Click framework and using sys.argv: argparse GitHub repo examples sys.argv GitHub repo examples Build Python applications from scratch.
    Note: Online resource; title from title details screen (O'Reilly, viewed March 9, 2022)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 56
    Online Resource
    Online Resource
    [Place of publication not identified] : Pragmatic AI Solutions
    Language: English
    Pages: 1 online resource (1 video file (9 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.7
    Keywords: Big data ; Microsoft Azure (Computing platform) ; Données volumineuses ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet ; Webcast
    Abstract: Azure Databricks with Pandas and Open Datasets. Find out how to get a working cluster with Databricks using Azure and then use the full Pandas API operating in the cluster with Open Datasets and a Python Jupyter Notebook. This video will walk you through creating a workspace in Azure to create the Databricks service, then create the cluster that comes with the Pyspark Pandas API, and finally import the open datasets into the cluster. Although straightforward to create a Databricks cluster with Azure, it is a bit more involved to run a Python Jupyter Notebook that has Azure ML Open Datasets installed and availabe in the cluster along with the ability to use the full Pandas API you are used to working with and taking advantage of the clustering capabilities from Databricks.
    Note: Online resource; title from title details screen (O’Reilly, viewed March 10, 2022)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 57
    Online Resource
    Online Resource
    [Place of publication not identified] : Pragmatic AI Solutions
    Language: English
    Pages: 1 online resource (1 video file (1 hr., 28 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.26/2
    Keywords: Python (Computer program language) ; Computer programming ; Python (Langage de programmation) ; Programmation (Informatique) ; computer programming ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet ; Webcast
    Abstract: Python Command Line Tools Course This is a full Python CLI course that will take you from the most basic approaches to command line tools in Python to the more advanced featuers that use frameworks like argparse and Click. Everything on this course is available in the course Repository on GitHub, so that you can follow the examples closely and use that as a foundation with all examples and sample files. Building a CLI is the foundation for automation in your daily work By the end of the course you should feel confident in creating a tool, and the following: Create simple CLI tools without any frameworks Learn about arguments, flags, help menus and how to create them automatically Use the argparse framework to build more complex tools Build a CLI with the Click framework Use special features of Click like colored output and argument types Modularizing and project scaffolding in Python Packaging and packaging files in Python How to create tests and run them automatically Continuous Integration and Continuous Deployment with Github Actions for Python Packaging a CLI tool with an executable Distributing a CLI tool on PyPI (the Python Package Index) How to automatically test your project on a PR (GitHub pull request) How to automate publishing your tool to PyPI on a release We'll cover 3 different ways to create tools, from the very basic (with sys.argv) to using a framework that comes with Python ( argparse), and finally the more involved, by using an external library like Click. This flexibility is essential because it will let you decide when to use a simple single file with no dependencies to a fully featured framework like Click. Then you will learn about the project layout, modularizing and organizing your code in directories and files while keeping everything useful for a CLI. You will test your code using Pytest and then package your code using Python packaging files and tools. You will continue by automating everything, including the testing and linting using GitHub Actions, and finally publishing your project to the Python Package Index so that it can be installed by anyone in the world. Course Resources Course Repository on GitHub Build Python applications from scratch.
    Note: Online resource; title from title details screen (O'Reilly, viewed March 9, 2022)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 58
    Online Resource
    Online Resource
    [Place of publication not identified] : Pragmatic AI Solutions
    Language: English
    Pages: 1 online resource (1 video file (6 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.117
    Keywords: Python (Computer program language) ; Application software Development ; Python (Langage de programmation) ; Logiciels d'application ; Développement ; Application software ; Development ; Python (Computer program language) ; Instructional films ; Internet videos ; Nonfiction films ; Instructional films ; Nonfiction films ; Internet videos ; Films de formation ; Films autres que de fiction ; Vidéos sur Internet ; Webcast
    Abstract: What does the Yield keyword do in Python? This video covers the basics so you can understand what yield is, what is a generator, and why is it different than any other iterable in Python A yield keyword makes a function a lazy iterable. Producing values one at a time. The function becomes a generator, so when called, the code will not execute. A generator is a function that uses the yield keyword. This function is an iterable that produces values one at a time, or does a lazy production of values. I'll use a Jupyter Notebook that you can use to follow along with practical examples that will show you what are some of the key differences and when or why you would use the yield keyword. In this video you will learn: What is an iterable and how is it different from using yield? What does yield do to a function? What is a Python generator Potential uses for a Python generator like infinite results Useful Resources GitHub repository with examples Build Python applications from scratch Try Azure for Free Introduction to Azure Databricks.
    Note: Online resource; title from title details screen (O'Reilly, viewed March 21, 2022)
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 59
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 14 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to use optimization strategies and greedy algorithms in one hour.
    Note: Online resource; Title from title screen (viewed March 7, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 60
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 60 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Get started with Vim in this one-hour video. Everything you need to know to get up and running quickly. Topics include: * Opening, saving, and quiting files * Basic movements and operations, like copying and deleting * Updating the .vimrc configuration file for customization * Installing plugins and further customization
    Note: Online resource; Title from title screen (viewed January 8, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 61
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 6 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Get started with MLOps and Github Actions to package a container with an ONNX model that does live inferencing with a Flask application. By using Azure ML, learn how to download the large ONNX model into the Github Action workflow, package it as a container and then push it to a container registry. For reference use the https://github.com/alfredodeza/flask-roberta repository Topics include: * Create a container that does live inferencing with Flask and the ONNX runtime * Package the model and verify it works locally * Setup a Github Action to authenticate to Azure ML and download a previously registered model * Build the new container as a Github Action, authenticate to Docker Hub or Github Packages * Push the new container to the Github registry or any other registry like Docker Hub
    Note: Online resource; Title from title screen (viewed March 5, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 62
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 47 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Distribute the load of Jenkins builds with a remote Docker instance or Kubernetes server in this 1-hour long tutorial Topics include: * Configure a remote Docker instance to interact with the master Jenkins server * Modify an existing job to use Docker to do builds using labels * Setup a remote kubernetes instance to connect to Jenkins with JNLP * Use the right container image to connect back to Jenkins as a remote container node
    Note: Online resource; Title from title screen (viewed March 12, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 63
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 13 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Zero to One: Data Science to MLOps in One Hour. Learn to frame a problem, then convert it into a data science project and present it to stakeholders. Later, move that prediction system to producting using MLOps Topics include: * Big Tech Misinformation and what can be done about it using Data Science. * Doing MLOps with sklearn and Flask by creating Microservices * Using sklearn, pandas, plotly, matplotlib, KMeans clustering, ELI5, shap and other libraries * Putting code into production using the Python MLOps Cookbook found here: https://github.com/noahgift/data-story-telling
    Note: Online resource; Title from title screen (viewed March 20, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 64
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 56 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn all about distributed tracing in this 1 hour course. If you want to go beyond logging and monitoring, and trying to tell a story by connecting the dots, then distributed tracing is the way to go. Topics include: * Opentracing and the foundations of distributed tracing libraries like Jaeger * Micro-service strategies and other microservice implementations that make distributed-tracing a perfect use case * Implement distributed tracing instrumentation in a Github project using docker compose with multiple Docker containers * Leverage the knowledge to use hosted services like Datadog for querying and debugging traces
    Note: Online resource; Title from title screen (viewed April 15, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 65
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 21 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to build Machine Learning solutions without writing any code with CreateML from Apple. Topics include: * Computer Vision * Image Classification * OS X * Apple * Core ML
    Note: Online resource; Title from title screen (viewed April 22, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 66
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 22 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to use Google AutoML Vision to train models with out writing code. Topics include: * Google AutoML Vision with Corel.AI * Core ML * Tensorflow Lite * Edge Inference * MLOps for Edge Computer Vision
    Note: Online resource; Title from title screen (viewed April 27, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 67
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 32 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: What is an SBOM (Software Bill Of Materials) and why should you care? An SBOM is a critical cybersecurity component to keep track and catalog what is installed (and at what versions) in production environments. With recent cybersecurity threats, SBOMs play an important role to implement a remediation strategy when threats and vulnerabilities are reported. Without an SBOM, it is borderline impossible to detect what exactly is released into production, and what may be vulnerable today. Topics include: * Understand the concepts behind an SBOM * Create an SBOM and use different output formats like CycloneDX to import into other systems * Use an SBOM to detect CVE and other vulnerabilities associated with installed software * Capture information about pre-installed system dependencies and nested dependencies * Use CycloneDX and other machine-readable formats like JSON to import outputs into other systems A few resources that are helpful if you are trying to get started with SBOMs, generating them and using them to capture vulnerabilities: * A simple, user-friendly SBOM generator: Syft * A fast vulnerability matcher that uses SBOMs as input: Grype * The CycloneDX format
    Note: Online resource; Title from title screen (viewed May 18, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 68
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 59 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: The Go programming language is becoming more popular these days with cloud-native applications and the Kubernetes ecosystem. If you are coming from Python, you will find yourself surprised to see similar patterns, while at the same time see some things that are missing or plain impossible with Go. In this course, I will introduce you to some of the basics of Golang from a Python perspective, so that you can reduce the friction trying to learn it. Topics include: * Packages, imports and variable definitions * From lists to arrays and slices * From Python dictionaries to Go maps * Looping on data structures, retrieving and adding values or items * Error handling, and the surprising fact that there aren't any tracebacks or exceptions in Go A few resources that are helpful if you are trying to learn Go, some of them covered in the course: * Visual Studio Code for Go * The Go playground * An (interactive) tour of Go
    Note: Online resource; Title from title screen (viewed May 5, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 69
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 37 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: One of the important aspects of MLOps, also known as Machine Learning Operations or Operationalizing Machine learning, is to package ML models. How exactly do you package ML models? In this video I show you exactly what that means, and go through the process of packaging an ONNX model taken from the ONNX Model Zoo. I end up with a docker container that can be shared, exposing an API that is ready to consume and perform live predictions for sentiment analysis. Topics include: * What are the concepts behind packaging Machine Learning Models * Create a sentiment analysis API tool with Flask * Define dependencies and a Dockerfile for packaging * Create a container with an ONNX model that can be deployed anywhere with an HTTP API A few resources that are helpful if you are trying to get started with SBOMs, generating them and using them to capture vulnerabilities: * The RoBERTa ONNX Model * Schema labeling concetps for Docker containers * The Practical MLOps code respository full of examples
    Note: Online resource; Title from title screen (viewed May 27, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 70
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 27 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Packaging in Python has always been polarizing. From complicated beginnings where you couldn't uninstall libraries, to virtualenv that allows you to work in a self-contained environment that can be thrown away. In this video, I'll present an introduction to Conda, and to a chanel-specific variation of it that is maintained by the community called miniforge. If you are looking for a way to get scientific packages for the new Apple M1 silicon, this video will also help you out get everything sorted, including installing versions of Python that are pre-packaged and ready for data science tasks. Topics include: * Install Conda by using the community version called miniforge. * Use conda to install a specific version of Python, without system installs * Find more about the differences between virtualenv, pip, and conda * Install data science libraries in the new Apple M1 silicon Useful links: * Conda documentation * Conda Forge community documentation * Conda miniforge project
    Note: Online resource; Title from title screen (viewed August 18, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 71
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 2 hr., 30 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn about six key elements of MLOPs based on the best-selling book Practical MLOps Topics include: * Source Code Management * Continuous Integration and Continuous Delivery * Development Environment * Deploy Environment * Microservices including Flask and FastAPI * Business Logic
    Note: Online resource; Title from title screen (viewed September 2, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 72
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 59 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to build Computer Vision MVPs quickly using AutoML. Topics include: * Getting models into production * Apple Create ML * Google Vertex AI * Image Classification * CoreML * Tensorflow * Rapid Prototyping * GCP * Azure * Containers * Kaizen
    Note: Online resource; Title from title screen (viewed August 28, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 73
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 35 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn how to use AWS in one Hour
    Note: Online resource; Title from title screen (viewed January 9, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 74
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 9 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Get started with Google Cloud Platform (GCP) and Cloud Functions in this one-hour video. Everything you need to know to get up and running quickly using serverless technology from GCP. Topics include: * An introduction to serverless technologies * Create a cloud function, install dependencies, and use different runtimes like Python 3.8 * Debug issues when a cloud function deployment fails * Use Google's Machine Learning offering to do live translations to any language * Enable authentication for your cloud function
    Note: Online resource; Title from title screen (viewed January 14, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 75
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 3 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Get started with Machine Learning and Auto ML using Azure ML Studio easily building powerful models and deploy them in a scalable environment. Everything you need to know to get up and running quickly in Machine Learning using Azure, from datasets to containerized deployments and data validation. Topics include: * An introduction to Azure ML Studio and AutoML * Import datasets and version them within Azure - even from remote locations like Github * Create compute clusters for training and live inferencing * Select models for deployment into Kubernetes or Docker Container instances * Practice MLOps, operationalizing a deployed model with logs and metrics via Application Insights * Consume a live endpoint with a deployed model over an HTTP API * Use the generated Swagger files to grasp the HTTP endpoints
    Note: Online resource; Title from title screen (viewed February 4, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 76
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 56 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Get started with Docker and building powerful containers in this one-hour video. From the basics of containers, and its differences with virtual machines, to interactive commands and containerization of applications. Everything you need to know to get up and running quickly to use containers and grasp docker concepts. Topics include: * An introduction to containers and their differences with Virtual Machines * Start, stop, and manage containers. * Map container ports to local ports, mount volumes, and other startup flags for container images. * Get access to running containers to interactively debug a service like Nnginx. * Build a Python application with a Dockerfile, and deploy it running the latest Python version.
    Note: Online resource; Title from title screen (viewed January 28, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 77
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 30 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: AWS Machine Learning Certification In ONE HOUR!
    Note: Online resource; Title from title screen (viewed January 23, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 78
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 44 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Zero to One: AWS Lambda with SAM and Python in One Hour. Learn to use AWS Cloud9 to develop serverless applications with Python and SAM (Serverless Application Model) Topics include: * Building a Lambda inside of Cloud9 * Deploying a containerized service to Amazon ECR and AWS Lambda * Invoking API Gateway based AWS Lambda services using sam invoke and AWS Cloud9
    Note: Online resource; Title from title screen (viewed April 3, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 79
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 60 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Sometimes scraping is the only way to extract meaningful data when there are no options like an accessible API. Parsing raw HTML can be intimidating and full of failures if you aren't used to existing tooling that can help you parse faster and more efficiently. In this video, learn all the basics including some advanced techniques to parse HTML and extract data with the Scrapy library in Python. k Topics include: * Install, configure, and create a new project with Scrapy, a powerful scraping library written in Python * See what is required to start parsing a website, including looking at raw HTML, tags, and CSS. * Identify data to create a dataset or datasets to perform data science analysis later * Capture parsed data and save it in different formats locally * Ultra fast scraping techniques by using the filesystem directly A few resources that are helpful if you are trying to do scraping, some of them covered in the course: * Scrapy Library * Scrapy Getting started tutorial
    Note: Online resource; Title from title screen (viewed May 13, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 80
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 37 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to pass ANY AWS Certification Exam on the first try. Topics include: * AWS Certifications * AWS Certified Cloud Practitioner * AWS Exam Guide * AWS White Papers * AWS Sample Questions * AWS Cloud Shell * AWS Unofficial Questions * AWS Academy
    Note: Online resource; Title from title screen (viewed June 6, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 81
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 27 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn the foundations of MLOPs Topics include: * Linux and Bash * AWS Cloud9 and AWS Cloud Shell and other Cloud Topics * The intuition behind MLOps techniques: optimization, gradient descent and data science.
    Note: Online resource; Title from title screen (viewed August 7, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 82
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 15 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Use AWS Step Functions to solve problems
    Note: Online resource; Title from title screen (viewed September 12, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 83
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 26 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to use optimization techninques along with AWS Step Functions
    Note: Online resource; Title from title screen (viewed September 12, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 84
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 6 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to do GPU programming in Python in Five Minutes
    Note: Online resource; Title from title screen (viewed January 12, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 85
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 3 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Get started building powerful Command-line Tools with Python. From a single file with no dependencies to packaging and publishing your tool on the Python Package Index. Everything you need to know to get up and running quickly to create Python command-line tools. Topics include: * An introduction to Python scripts and Python packaging * Declare dependencies and package your script for installing and sharing. * Use argparse or upgrade to a more powerful framework like Click * Add flags, options and arguments to fine-tune and control your command-line tool
    Note: Online resource; Title from title screen (viewed January 22, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 86
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 44 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Python Devops in TWO HOURS!
    Note: Online resource; Title from title screen (viewed January 27, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 87
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 20 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to use AWS Elastic Beanstalk to deploy a Flask application. This tutorial covers Continuous Delivery of a Python Flask application using AWS Code Build. Elastic Beanstalk is a PAAS (Platform as a Service) that has powerful tools and integrations. This video course covers building out an development environment in Cloud9, a Makefile system and then finally, a full fledged CI/CD pipeline using Pylint and AWS Code Build of a Flask API. Follow along with the Github Resource: https://github.com/nogibjj/Flask-Elastic-Beanstalk.
    Note: Online resource; Title from title screen (viewed February 3, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 88
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 2 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Get started with Github and Github Actions in this introductory video to GitOps concepts, by building a container, setting some Github Actions to prevent problems, and finally, push to DockerHub in a fully automated way. These concepts are critical to get automation best-practices in place with Github. Particularly useful when collaborating with others and trying to run automated checks on Dockerfiles and git repos. Topics include: * Create a new Github repository * Enable Github Actions checks and steps for a new repository. * Find a Github Action to lint and check a Dockerfile to prevent issues before merging on pull requests. * Add Github Secrets and reuse them in a Github Action * Validate that a container builds correctly, and automatically push to dockerhub
    Note: Online resource; Title from title screen (viewed February 12, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 89
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 54 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to do Data Science with Python, Pandas and Colab Notebook in one hour! This video lesson takes you through a Covid-19 Dataset from the NyTimes and shows you how to explore it. The libraries involved include: Pandas, Colab, Plotly, sklearn, numpy and matplotlib. A suggested structure for Data Science projects is included: Ingest, EDA, Modeling and Conclusion. Finally, the course wraps up with how to integrate Cloud based business analytics including the following tools. AWS Cloud9, IPython, AWS Rekognition, AWS Translate and AWS Comprehend. These solutions are explored with both boto3 and the AWS Console. Follow along with the Github Resource: https://github.com/paiml/minimal-python/blob/master/Chapter7_data_science.ipynb
    Note: Online resource; Title from title screen (viewed February 6, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 90
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 14 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: In this video you walk through the foundational concepts of Machine Learning.
    Note: Online resource; Title from title screen (viewed February 27, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 91
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 53 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Get started with Jenkins, Jenkins Pipelines, and Github integration in this introductory video to the most widely used CI/CD platform in the world: Jenkins. Learn how to setup an example repository from Github into Jenkins using the same techniques you would need to scale a massive CI CD production environment. Topics include: * Install and configure Jenkins including plugins like Blue Ocean that enables pipelines * Create a Personal Access Token (PAT) in Github to connect a repository to Jenkins * Setup a trigger to run automated tests for the Github repository using a Jenkinsfile * Add a remote node or slave to the Jenkins master instance via SSH to quickly scale up operations * Validate that the project builds and deploys correctly
    Note: Online resource; Title from title screen (viewed February 18, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 92
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 54 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Get started with security vulnerability scanning and integrating that with Github, Github Actions and automated security checks in pull requests. Learn how to scan reported vulnerabilities in projects and Docker containers, so that you can publish images to Docker hub or merge pull requests while knowing that changes in dependencies are secure. Topics include: * Install and run locally a security vulnerability scanner * Catalog a project with an SBOM (Software Bill Of Materials) so that the scanner can do vulnerability matching. * Setup a Github Action to automatically scan vulnerabilities in a project and optionally fail a build to prevent a merge. * Scan a Docker container image that is built locally against the latest vulnerabilities, based on any CVE reported publicly
    Note: Online resource; Title from title screen (viewed February 25, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 93
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 14 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: How are you generating revenue in your business or career. This lesson talks about consulting, salary and MRR including investing. Topics include: * Consulting * Salary * Investments * Autonomy vs Dependency * MRR (Monthly Recurring Revenue)
    Note: Online resource; Title from title screen (viewed April 22, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 94
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 44 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Python exceptions are exceptional at helping your program take decisions. It is natural to feel the urge to catch them all and ignore them. But powerful programs can be created by learning how to leverage them in order to make robust scripts and take your coding skills to the next level. In this video, I cover several techniques that will help you improve your exception handling. Topics include: * Create a script that uses exception poorly, and then improve it * Slowly clean up broad catching exceptions to improve the script * Learn how to produce better errors from exceptions * Leverage other tools like logging to produce meaningful errors and tracebacks while keeping messages clean Follow along the repository to continue using more examples: https://github.com/alfredodeza/exceptions/
    Note: Online resource; Title from title screen (viewed April 22, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 95
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 18 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to use Google AutoML to build a computer vision prediction model via their Qwiklabs website. Later, compare Apple's CreateML with the same data set and build an AutoML prediction model that deploy to the edge. Topics include: * Google AutoML * Apple CreateML * Apple CoreML * Computer Vision * Cloud Computing * Single label image classification * Using AutoML as a prototyping Tool * Edge Computer Vision Models
    Note: Online resource; Title from title screen (viewed May 15, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 96
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 1 hr., 23 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to use the AWS (Amazon Web Services) platfrom to perform Computer Vision with the Python Language. This video course takes you from zero and introduces you to using the AWS Rekognition Console, AWS Cloud Shell and AWS Cloud9 environment to build computer vision solutions. Topics include: * Using AWS Rekognition to do Celebrity Recognition, Text Detection, PPE Detection and Image Labeling * Setting up AWS Cloud Shell to use the AWS SDK * Doing S3 copies with the AWS command-line SDK * Setting up AWS Cloud9 for development * Configuring bashrc file for use with Python * Using IPython with the AWS Boto3 SDK * Using Python Click to create command-line tools with colorized output * Using Github Actions to test and lint a computer vision project
    Note: Online resource; Title from title screen (viewed May 9, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 97
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 14 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to think like a Venture Capitalist about your career and design for failure. Topics include: * Cost of Living * Open Source Software * Investments * Designing your 1-3 year experiences * Being proactive vs reactive
    Note: Online resource; Title from title screen (viewed April 28, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 98
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 37 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Learn to AWS Sagemaker Autopilot from zero and deploy a model to production.
    Note: Online resource; Title from title screen (viewed June 29, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 99
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 25 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local
    Abstract: Topics include: * Solar * Tesla * Nest * Smart Home * Time of Use * Net metering * Battery Backup * EV (electric vehicle) * Artificial Intelligence * Level 1 Charging * Level 2 Charging * Level 3 Charging
    Note: Online resource; Title from title screen (viewed July 25, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 100
    Online Resource
    Online Resource
    [Erscheinungsort nicht ermittelbar] : Pragmatic AI Solutions | Boston, MA : Safari
    Language: English
    Pages: 1 online resource (1 video file, approximately 16 min.)
    Edition: 1st edition
    Keywords: Electronic videos ; local ; Electronic videos
    Abstract: It is essential to have a strategy defined when figuring out your career. Starting out is difficult. Regardless what your background is, you need to have a clear idea how to get to your dream job. Even if you are not in technology and want a data-science position, you have to have a clear path towards data-science. In this video I'll cover some of the stories that allowed me to gain perspective in my career in tech, along with some advice that can help you out. Topics include: * Find some techniques to define your career and next steps * Design a custom strategy to help answer career questions * Accurately determine what might be a good job or position Useful links: * Start a career in Tech * Learn Python from scratch
    Note: Online resource; Title from title screen (viewed September 13, 2021) , Mode of access: World Wide Web.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...