Excel 2019 - Advanced

- Πληροφορική - Χρήστες

31 Ιαν 2024 17:13 31 Ιαν 2024 17:13
Αγγλικά
60 ώρες ( ημέρα )
Excel 2019 - Advanced

ΠΕΡΙΓΡΑΦΗ

DESCRIPTION

This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.


KEY OBJECTIVES

  • Importing and Exporting Data to a Text File and Using Text Functions
  • Ensuring Data Integrity, Formula Auditing and What-If Analysis
  • Collaborating and Customizing in Excel
  • Worksheet and Workbook Protection and Automating with Macros
  • Working with Form Controls and Lookup Functions
  • Analyzing Data with Logical Functions
  • Working with Date and Time Functions

COMPATIBILITY

  • Desktop
  • Mobile


SUPPORTED BROWSERS

Chrome, Microsoft Edge, Firefox, Internet Explorer 9/10/11, Safari

Αγορά: Excel 2019 - Advanced


€ 60.00
Σεμινάρια στην ίδια κατηγορία από τον ίδιο διοργανωτή
Mastering Access - Intermediate...

Everything You Need To Know About Microsoft Access -- Delivered In Easily Searchable, Highly Informative Video Modules  Microsoft Access lets ordinary users dev...

31/01/2024 17:13

Αγγλικά

eLearning

Mastering Access - Basics...

Everything You Need To Know About Microsoft Access -- Delivered In Easily Searchable, Highly Informative Video Modules  Microsoft Access lets ordinary users dev...

31/01/2024 17:13

Αγγλικά

eLearning

Mastering PowerPoint - Intermediate & Advanced...

DESCRIPTIONLearn advanced features to get the most out of PowerPoint 2019 or PowerPoint 365. Have you seen someone deliver a PowerPoint presentation that was re...

31/01/2024 17:13

Αγγλικά

eLearning

Excel 2019 - Intermediate...

This is our most requested training course!If you learn to use Excel 2019 or Excel 365, you will start to see how useful it is in your life—from formatting your...

31/01/2024 17:13

Αγγλικά

eLearning

Mastering Outlook - Beginner...

From Time-Waster To Productivity Booster: Change The Way You Use Microsoft Outlook  Few things have greater impact on your productivity than the way you employ ...

31/01/2024 17:13

Αγγλικά

eLearning

Excel 2019 - Beginner...

DESCRIPTIONMicrosoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A soli...

31/01/2024 17:13

Αγγλικά

eLearning

Excel 2019 - Advanced...

DESCRIPTIONThis course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and C...

31/01/2024 17:13

Αγγλικά

eLearning

Mastering PowerPoint - Beginner...

Making PowerPoint Easy and EffectiveUsing PowerPoint effectively is a crucial skill for any business professional. Whether its designing a presentation for a me...

31/01/2024 17:13

Αγγλικά

eLearning

Cyber Security Awareness Training...

Cyber Security Awareness  Course Description  Cybersecurity has never been more prominent in the news than these days. Colossal breaches made headlines across t...

31/01/2024 17:13

Αγγλικά

eLearning

Mastering Outlook - Advance...

From Time-Waster To Productivity Booster: Change The Way You Use Microsoft Outlook  Few things have greater impact on your productivity than the way you employ ...

31/01/2024 17:13

Αγγλικά

eLearning

Windows 10 for Beginner & Intermediate Users...

This Course Is For People New To Windows 10 Taking This Course Will Help You Understand The New Operating System Navigation, Advantages, And Functionality  Wind...

31/01/2024 17:13

Αγγλικά

eLearning