Cargando…

Microsoft Excel 2021/365 : beginner to advanced.

Microsoft has released its latest stand-alone Excel version, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription. In the first section, we study some basics about how to use Excel 2021 and become familiar with what's new in it. We...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Formato: Electrónico Video
Idioma:Inglés
Publicado: [Place of publication not identified] : Packt Publishing, [2022]
Edición:[First edition].
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cgm a22000007i 4500
001 OR_on1350411224
003 OCoLC
005 20231017213018.0
006 m o c
007 vz czazuu
007 cr cnannnuuuuu
008 221108s2022 xx 000 o vleng d
040 |a ORMDA  |b eng  |e rda  |e pn  |c ORMDA  |d ORMDA  |d OCLCF  |d OCLCO 
019 |a 1362789618 
020 |a 9781804612262  |q (electronic video) 
020 |a 180461226X  |q (electronic video) 
029 1 |a AU@  |b 000072918883 
035 |a (OCoLC)1350411224  |z (OCoLC)1362789618 
037 |a 9781804612262  |b O'Reilly Media 
050 4 |a HF5548.4.M523 
082 0 4 |a 005.54  |2 23/eng/20221108 
049 |a UAMI 
245 0 0 |a Microsoft Excel 2021/365 :  |b beginner to advanced. 
250 |a [First edition]. 
264 1 |a [Place of publication not identified] :  |b Packt Publishing,  |c [2022] 
300 |a 1 online resource (1 video file (30 hr., 38 min.)) :  |b sound, color. 
306 |a 303800 
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 Simon Sez IT, presenter. 
520 |a Microsoft has released its latest stand-alone Excel version, which opens up many of the features and functionalities that are available only in Excel 365 through a subscription. In the first section, we study some basics about how to use Excel 2021 and become familiar with what's new in it. We will first navigate the Excel 2021 interface and create our first Excel spreadsheet. You will learn some useful keyboard shortcuts to increase productivity, learn how to effectively apply formatting to cells and use conditional formatting, learn how to use basic and intermediate Excel formulas and functions, and more. Then, in the second section, you will learn how to create intermediate-level formulas, prepare data for analysis using PivotTables and Pivot Charts, make use of WhatIf analysis tools, learn how to use validation rules to control data input, and explore the fundamentals of spreadsheet design. In the final section, we will build on the skills learned in the beginner and intermediate sections and fast-track our way to being an Excel power user. This section covers the latest updates from Microsoft, including the LET and LAMBDA functions, which allow us to create our own variables and even Excel functions. By the end of this course, you will be able to use Excel skills confidently. What You Will Learn Become familiar with what's new in Excel 2021 Use Excel lists and master sorting and filtering Represent data visually with Pivot Charts Use WhatIf analysis tools to see how changing inputs affect outcomes Analyze data with advanced PivotTable and PivotChart hacks Import and clean data using Power Query Audience If you are an absolute beginner who has never used Excel before, this course can give you a great foundation. You might have some basic Excel skills and want to improve your proficiency, or you are using an older version of Excel and want to check out what's new. Well, this course can help you get the ball rolling. About The Author Simon Sez IT: Simon Sez IT has offered technical courses since 2008 for individuals, small businesses, and Fortune 500 companies with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8000 video tutorials on a range of software programs. Simon Sez IT ensures stress-free eLearning and enhanced employee productivity--whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide. 
588 0 |a Online resource; title from title details screen (O'Reilly, viewed November 8, 2022). 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast 
650 0 |a Business  |x Computer programs. 
650 0 |a Electronic spreadsheets. 
650 6 |a Tableurs. 
650 7 |a Business  |x Computer programs  |2 fast 
650 7 |a Electronic spreadsheets  |2 fast 
655 7 |a Instructional films  |2 fast 
655 7 |a Internet videos  |2 fast 
655 7 |a Nonfiction films  |2 fast 
655 7 |a Instructional films.  |2 lcgft 
655 7 |a Nonfiction films.  |2 lcgft 
655 7 |a Internet videos.  |2 lcgft 
655 7 |a Films de formation.  |2 rvmgf 
655 7 |a Films autres que de fiction.  |2 rvmgf 
655 7 |a Vidéos sur Internet.  |2 rvmgf 
710 2 |a Packt Publishing,  |e publisher. 
710 2 |a Simon Sez IT (Firm),  |e presenter. 
856 4 0 |u https://learning.oreilly.com/videos/~/9781804612262/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
994 |a 92  |b IZTAP