Excel essentials.

Dive into Excel Essentials and transform your data analysis skills. Starting with Conditional Formatting, you will learn how to highlight key data points, manage rules, and visualize data with color scales and icon sets. The course then explores advanced filtering techniques, including text, number,...

Full description

Saved in:
Bibliographic Details
Online Access: Streaming Video (via O'Reilly/Safari)
Corporate Author: Skillshub Ltd (instructor.)
Format: Electronic Video
Language:English
Published: [Birmingham, United Kingdom] : Packt Publishing, [2024]
Edition:[First edition].
Subjects:

MARC

LEADER 00000ngm a22000007i 4500
001 in00000306923
006 m o c
007 vz czazuu
007 cr |||||||||||
008 240909s2024 enk097 o o vleng d
005 20241118153426.3
020 |a 9781836646297  |q (electronic video) 
020 |a 1836646291  |q (electronic video) 
035 |a (OCoLC)safo1455265858 
035 |a (OCoLC)1455265858 
037 |a safo9781836646297 
040 |a ORMDA  |b eng  |e rda  |e pn  |c ORMDA  |d OCLCO 
049 |a GWRE 
050 4 |a HF5548.4.M523 
245 0 0 |a Excel essentials. 
250 |a [First edition]. 
264 1 |a [Birmingham, United Kingdom] :  |b Packt Publishing,  |c [2024] 
300 |a 1 online resource (1 video file (1 hr., 37 min.)) :  |b sound, color. 
306 |a 013700 
336 |a two-dimensional moving image  |b tdi  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
344 |a digital  |2 rdatr 
347 |a video file  |2 rdaft 
380 |a Instructional films  |2 lcgft 
511 0 |a Skillshub Ltd., instructor. 
520 |a Dive into Excel Essentials and transform your data analysis skills. Starting with Conditional Formatting, you will learn how to highlight key data points, manage rules, and visualize data with color scales and icon sets. The course then explores advanced filtering techniques, including text, number, and date filters, ensuring you can quickly sift through large datasets. Learn to remove duplicates, outline data, and find unique values, enhancing your data accuracy and presentation. Progressing to sorting techniques, you'll discover how to organize data by various criteria, use custom sort orders, and even randomize lists. The course also covers essential cell formatting, including merging cells, wrapping text, and adjusting decimal places for precise data presentation. Printing essentials such as setting page breaks and formatting print areas are also detailed, ensuring your spreadsheets are print-ready. In workbook management, you'll master the ribbon, protect your files with passwords, and safeguard specific sheets and cells from unauthorized changes. Learn to use the Quick Access Toolbar, understand workbook themes, and recover unsaved work. The final sections focus on worksheets, covering viewing multiple sheets, spell checking, freezing panes, and consolidating data across sheets for comprehensive data management. 
588 0 |a Online resource; title from title details screen (O'Reilly, viewed September 9, 2024) 
630 0 0 |a Microsoft Excel (Computer file) 
650 0 |a Microsoft software. 
650 0 |a Electronic spreadsheets  |x Computer programs. 
710 2 |a Packt Publishing,  |e publisher. 
710 2 |a Skillshub Ltd.,  |e instructor. 
856 4 0 |u https://go.oreilly.com/UniOfColoradoBoulder/videos/~/9781836646297/?ar  |z Streaming Video (via O'Reilly/Safari) 
915 |a 7 
956 |a O'Reilly-Safari eBooks 
956 |b O'Reilly Online Learning: Academic/Public Library Edition 
956 |a Quesnalia testing - EUI 
994 |a 92  |b COD 
998 |b Added to collection ProQuest.ormac 
999 f f |s 4b7b7223-a0e8-4294-94e0-0cd16aea375a  |i e10e7523-16cd-41a4-97ed-7185571e77d1 
952 f f |p Can circulate  |a University of Colorado Boulder  |b Online  |c Online  |d Online  |e HF5548.4.M523   |h Library of Congress classification  |i web