Microsoft Office Excel 2019: Part 1 Training in Pittsburgh
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of that data is becoming more and more challenging. Fortunately, this is where the power of Microsoft Office Excel 2019 can help. Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software. This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation.
Course Length: 1 Days
Course Tuition: $250 (US) |
Prerequisites |
|
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows 10 environment and be able to use Windows 10 to manage information on their computers. |
Course Outline |
Lesson 1: Getting Started with Excel 2019Topic A: Navigate the Excel User Interface Topic B: Use Excel Commands Topic C: Create and Save a Basic Workbook Topic D: Enter Cell Data Topic E: Use Excel Help Lesson 2: Performing CalculationsTopic A: Create Worksheet Formulas Topic B: Insert Functions Topic C: Reuse Formulas and Functions Lesson 3: Modifying a WorksheetTopic A: Insert, Delete, and Adjust Cells, Columns, and Rows Topic B: Search for and Replace Data Topic C: Use Proofing and Research Tools Lesson 4: Formatting a WorksheetTopic A: Apply Text Formats Topic B: Apply Number Formats Topic C: Align Cell Contents Topic D: Apply Styles and Themes Topic E: Apply Basic Conditional Formatting Topic F: Create and Use Templates Lesson 5: Printing WorkbooksTopic A: Preview and Print a Workbook Topic B: Set Up the Page Layout Topic C: Configure Headers and Footers Lesson 6: Managing WorkbooksTopic A: Manage Worksheets Topic B: Manage Workbook and Worksheet Views Topic C: Manage Workbook Properties Appendix A: Mapping Course Content to Excel Associate (Office 365 and Office 2019): Exam MO-200Appendix B: Mapping Course Content to Excel Expert (Office 365 and Office 2019): Exam MO-201Appendix C: Microsoft® Office Excel® 2019 Common Keyboard ShortcutsAppendix D: Adding Borders and Colors to WorksheetsAppendix E: Basic Excel Customization |
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
- ASP.NET Core MVC, Rev. 6.0
11 November, 2024 - 12 November, 2024 - RED HAT SATELLITE V6 (FOREMAN/KATELLO) ADMINISTRATION
21 October, 2024 - 24 October, 2024 - OpenShift Fundamentals
12 November, 2024 - 14 November, 2024 - Docker
21 October, 2024 - 23 October, 2024 - Artificial Intelligence Implementation Boot Camp
11 October, 2024 - 11 October, 2024 - See our complete public course listing