Ms Office Excel Advanced Level 3
ENDED
Short Course by
Express Training Connections
Inquire Now
On-Site
/ Short Course
Details
The course is designed to provide participants with a comprehensive understanding of Microsoft Office applications, specifically Excel. The course will cover the fundamental skills needed to effectively use the software, with a focus on practical
application and hands-on learning. For a beginner to intermediate level course, the focus will be on mastering the basic functions and features of the software. Participants will learn how to create, format, and edit documents and spreadsheets, use basic formulas
and functions, work with charts and graphs, and collaborate and share documents with others. For an advanced level course, the focus will be on expanding and deepening the participants' understanding and skills. They will learn how to work with more complex
formulas and functions, create advanced charts and graphs, work with large datasets, automate tasks with macros, and use more advanced features such as Power Pivot and Solver. Overall, the course will equip participants with the knowledge and skills needed
to effectively use Microsoft Office applications in their personal and professional lives
Outline
Introduction to Excel and the Excel Interface Creating and Modifying Workbooks and Worksheets Formatting Cells, Rows, and Columns Working with Formulas and Functions Sorting and Filtering Data
Creating and Formatting Charts and Graphs Using Conditional Formatting Creating and Managing Tables Working with Data Validation and What-If Analysis Using PivotTables and PivotCharts
Importing and Exporting Data Collaboration and Sharing Features Creating and Formatting Basic Macros Protecting and Securing Excel Data.
Creating and Formatting Charts and Graphs Using Conditional Formatting Creating and Managing Tables Working with Data Validation and What-If Analysis Using PivotTables and PivotCharts
Importing and Exporting Data Collaboration and Sharing Features Creating and Formatting Basic Macros Protecting and Securing Excel Data.
Schedules
Apr 19, 2023
ENDED
Wed | 09:00 AM — 04:00 PM |
Apr 27, 2023 - Apr 28, 2023
ENDED
Wed | 09:00 AM — 04:00 PM |
No. of Days: | 2 |
Total Hours: | 14 |
Reviews
Be the first to write a review about this course.
Write a Review
etc…is Australian owned, based in Adelaide CBD since 2006. We offer course and content customization services. Training courses include Microsoft Technical Adobe-Crystal Report, Red Hat. Rooms are available for hire with high spec computers.
Our Adelaide venue is known for the superior set up both technically and aesthetically. Our service is of the highest standard and your comfort level is important to us. We are conveniently located in the heart of the CBD. In your lunch break you can shop in Rundle Mall, visit the Art Gallery, just meters away or enjoy the selection of eating venues which our catering includes.
We are in the business of organizing, providing or resourcing whatever training or specialized needs you have. We pride ourselves on knowing you will be more than satisfied and etc… will be your preferred solution for computer training androom hire.