Microsoft Excel Complete Guide A-Z

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

Microsoft Excel - Intermediate Level

• 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

Microsoft Excel - Advanced 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

Updated on 05 December, 2023 - Read Less