Microsoft Excel - Excel from Beginner to Advanced

Participants are encouraged to ask questions throughout the course to enhance their understanding.

Downloadable exercise files are provided to facilitate hands-on learning.

Upon course completion, participants have the opportunity to earn a certificate as recognition.

Learn how to open Microsoft Excel and access its features.

Explore the initial screen and its functionalities.

Get acquainted with the Excel user interface.

Discover how to personalize the Quick Access Toolbar for efficiency.

Dive deeper into Excel's interface components.

Gain insight into the structure of Excel workbooks.

Understand the process of saving Excel files.

Learn how to access and work with previously created Excel files.

Master essential keyboard shortcuts for increased productivity.

Test your knowledge of Excel fundamentals through a quiz.

Explore techniques for entering text to create informative spreadsheet titles.

Understand how to input and manipulate numeric data effectively.

Learn the ins and outs of entering date values accurately.

Master the use of cell references in Excel formulas.

Get hands-on experience in creating basic Excel formulas.

Differentiate between relative and absolute cell references.

Grasp the order in which Excel calculates formula operations.

Assess your proficiency with a quiz on text and formula entry and editing.

Learn about the components and structure of Excel functions.

Understand how to use the SUM function to total values.

Explore the MIN and MAX functions for finding minimum and maximum values.

Discover how to calculate averages using the AVERAGE function.

Learn to count cells containing data with the COUNT function.

Understand and troubleshoot errors that may occur in Excel calculations.

Simplify summation with the AutoSum command.

Speed up calculations with a handy keyboard shortcut.

Efficiently replicate formulas using the AutoFill command.

Test your knowledge of basic Excel functions with an interactive quiz.

Learn how to rearrange and duplicate data within a worksheet.

Discover methods for adding or removing rows and columns.

Customize cell dimensions to accommodate your data.

Control the visibility of rows and columns as needed.

Learn how to rename worksheets to improve organization.

Explore the process of removing unnecessary worksheets.

Master techniques for relocating or duplicating entire worksheets.

Test your skills in worksheet modification through a quiz.

Explore font formatting options to style your text.

Customize cell backgrounds for visual impact.

Apply borders to cells for improved data separation.

Delve deeper into cell border formatting.

Format numbers as currency for financial presentations.

Learn to display numbers as percentages.

Copy formatting from one cell to another with the Format Painter tool.

Create and apply custom styles to format data consistently.

Combine cells and center content for neat formatting.

Apply conditional formatting rules to highlight specific data conditions.

Modify and manage conditional formatting rules.

Assess your knowledge of Excel data formatting through a quiz.

Learn how to add images to Excel worksheets.

Discover how to insert various shapes into your Excel documents.

Customize the appearance and properties of shapes.

Explore SmartArt graphics to visually represent information.

Learn to create column charts to visualize data.

Explore chart-related options in the Excel Ribbon.

Modify chart data to reflect changes in your worksheet.

Customize chart elements for better presentation.

Relocate charts to different worksheets for organization.

Create and work with pie charts to represent data.

Download a quick reference guide for Excel charts.

Test your knowledge of Excel chart creation and management.

Review how your document will appear when printed.

Adjust page margins, scaling, and orientation for printing.

Explore margin settings for better page layout control.

Utilize Page Layout View to optimize your worksheet for printing.

Include custom headers and footers in printed worksheets.

Print only selected cells or ranges from your worksheet.

Test your knowledge of Excel printing options and settings.

Understand the concept of Excel templates.

Learn how to open pre-designed Excel templates.

Create your own custom Excel templates to streamline tasks.

Assess your understanding of Excel templates with a quiz.

Access practice exercises to apply and solidify your Excel skills.

Celebrate your achievement in building a strong foundation in Microsoft Excel.

Download exercise files for hands-on practice.