Excel 2019 Essential Training Год выпуска: 24/09/2018 Производитель: LinkedIn Learning Сайт производителя: Excel 2019 Essential Training Автор: Dennis Taylor Продолжительность: 02:08:31 Тип раздаваемого материала: Видеоурок Язык: Английский Описание: Start mastering Excel, the world-renowned powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to enter data, organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of data and cells, build charts, and create PivotTables. Find out how to use the IF, VLOOKUP, and COUNTIF family of functions. See how to use data analysis tools, including Goal Seek and Solver. Discover how to automate tasks with macros, manage data, and more. Начните освоение Excel, всемирно известной мощной программы электронных таблиц, с экспертом Excel Деннисом Тейлором. Узнайте, как вводить данные, организовывать данные, выполнять вычисления с помощью простых функций, работать с несколькими листами, форматировать внешний вид данных и ячеек, строить диаграммы и создавать сводные таблицы. Узнайте, как использовать семейство функций IF, VLOOKUP и COUNTIF. Узнайте, как автоматизировать задачи с помощью макросов, управлять данными и многое другое.
Содержание
00 - Introduction Getting started with Excel 01 - Getting Started with Excel What is Excel used for? Using the Quick Access Toolbar and Ribbon menu Using shortcut menus and the mini toolbar Understanding workbooks and worksheets Using Excel Help 02 - Entering Data Exploring data entry, editing, and AutoFill Working with dates and times Using Undo and Redo Using Save or Save As 03 - Creating Formulas and Functions Using simple formulas Using SUM and AVERAGE Copying a formula into adjacent cells 04 - Formatting Exploring font styles and effects Applying borders and color backgrounds Adjusting row heights and column widths 05 - Adjusting Worksheet Layout and Data Rows and Columns Moving, copying, and inserting data Finding and replacing data 06 - Printing Using the Page Layout view and commands Using Page Break Preview and Print Setup Options 07 - Charts Creating charts Exploring chart types 08 - Adjusting Worksheet Views Freezing and unfreezing panes Splitting screens horizontally and vertically 09 - Multiple Worksheets and Workbooks Renaming, inserting, and deleting sheets Moving, copying, and grouping sheets 10 - Data Management Features Sorting data Using filters Creating PivotTables 11 - Security and Sharing Protecting worksheets and workbooks Sharing workbooks Tracking changes 12 - Conclusion Next steps Exercise Files
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum