Microsoft Office Excel 2019: Part 3 Training in Clifton
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will:
Course Length: 1 Days
Course Tuition: $250 (US) |
Prerequisites |
|
To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2019. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment. To meet these prerequisites, students can take the following Logical Operations courses, or should possess the equivalent skill level: Microsoft Office Excel 2019: Part 1 Microsoft Office Excel 2019: Part 2 |
Course Outline |
Lesson 1: Working with Multiple Worksheets and WorkbooksTopic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data Lesson 2: Sharing and Protecting WorkbooksTopic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks Lesson 3: Automating Workbook FunctionalityTopic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros Lesson 4: Using Lookup Functions and Formula AuditingTopic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas Lesson 5: Forecasting DataTopic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends Lesson 6: Creating Sparklines and Mapping DataTopic A: Create Sparklines Topic B: Map Data |
Course Directory [training on all levels]
- .NET Classes
- Agile/Scrum Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
- RHCSA EXAM PREP
9 September, 2024 - 13 September, 2024 - Ruby Programming
2 December, 2024 - 4 December, 2024 - Go Language Essentials
18 November, 2024 - 21 November, 2024 - VMware vSphere 8.0 with ESXi and vCenter
7 October, 2024 - 11 October, 2024 - Linux Fundaments GL120
16 September, 2024 - 20 September, 2024 - See our complete public course listing