- Duration / Course length: Upto 2 Days Start now
- Accredited by: CPD Qualification Standards
- Certificates:
- Course delivery: This course is delivered in video format
Course details
Unlock the essential and advanced capabilities of Microsoft Excel to enhance your workplace efficiency with the Microsoft Excel Complete Course – Level 1, 2, and 3. In virtually every office setting, Microsoft Excel stands as the unparalleled and user-friendly spreadsheet program, streamlining organization and simplifying the handling of financial records and data. This comprehensive course takes learners on a chronological journey, catering to individuals at every proficiency level, from beginners to advanced users.
Navigate the application's user interface and grasp fundamental techniques, including calculating sums, averages, and totals. The course delves into cell counting, text wrapping, merging cells, and the creation of graphs and charts. Furthermore, it unveils strategies for utilizing Pivot tables, hyperlinks, and methods for inserting, editing, and deleting comments. Learn the correct approaches to tasks such as pasting, sorting, and converting columns to rows.
The curriculum extends to cover crucial formulas like IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF. In summary, this course comprehensively addresses all vital aspects and functionalities of Microsoft Excel.
Microsoft Excel Complete Guide A-Z Course Learning Outcomes:
Microsoft Excel Complete Guide A-Z Course Outline:
Microsoft Excel - Beginners
- Getting Started
- Opening and Closing Excel
- Working with the Interface
- Your First Worksheet
- Viewing Excel Data
- Building Formulas
- Using Excel Functions
- Using Quick Analysis
- Formatting Your Data
- Using Styles, Themes, and Effects
- Printing and Sharing Your Workbook
- Wrapping Up
- Excel for Newbies – Activities
- Getting Started
- Working with Permissions and Options
- Sharing Workbooks
- Performing Advanced Formula and Function Tasks
- Working with Array Formulas
- Working With Macros
- Working With Forms
- Applying Advanced Chart Features
- Working With Slicers and Timelines
- Working With Multiple Tables, Relationships and External Data
- Working With PowerView
- Wrapping Up
- Activities- Microsoft Excel – Intermediate Level
- Getting Started
- SmartArt and Objects
- Auditing
- Creating Charts
- Working with Charts
- Creating Pivot Tables and Pivot Charts
- Macros
- Solving Formula Errors
- Using What If Analysis
- Managing Your Data
- Grouping and Outlining Data
- Wrapping Up
- Activities-Microsoft Excel – Advanced Level
Eligibility / Requirements
Anyone Can Enrol in this Counseling Course
Job roles this course is suitable for:
Research Analyst , Data Analyst , Financial Analyst , Business Intelligence AnalystAbout St. Paul's College
With a rapidly growing international presence, we are a U.K. based provider of online courses. Not only are these courses aimed at the broad spectrum of individuals looking to acquire a qualification in order to boost their skills and expertise, but also at businesses. In addition to helping countless individuals, we also offer a range of services to many different types of organisation. Our courses help people and businesses become the best they can be, adding value and driving professional development forward.
We are aware that many individuals and companies are unable to access the right courses or training packages to meet their needs. As an online learning platform, we wish to offer the best possible solution to this problem, providing helpful and informative courses to individuals and comprehensive training packages to businesses.
