Microsoft Excel Core & Intermediate

16 Hours

Beginner

10 Modules

LE 1,499.00
LE 2,000.00
LE 1,499.00
10 customers are viewing this product
This Microsoft Excel Core & Intermediate course is designed to build a solid foundation in Excel, covering core functionalities and progressing to more advanced features that enhance productivity and data analysis. The course begins with Excel basics, including navigating the interface, formatting cells, and managing worksheets. Participants will gain practical skills in creating and editing formulas, using functions, and working with data through sorting, filtering, and basic data validation. The intermediate level introduces more complex functionalities such as advanced formula construction, conditional formatting, PivotTables, and chart creation for data visualization. Learners will explore functions like VLOOKUP, HLOOKUP, and IF statements, which are essential for data analysis. By the end of the course, participants will be able to efficiently manage large datasets, automate tasks, and apply analytical tools to support data-driven decision-making, making this training ideal for those looking to advance their Excel skills for professional or personal use.
Hurry up! Sale ends in:
151Days 8Hours 23Minutes 0Seconds
Vendor: Cloud Learning Academy
Categories: Excel,
Product Type: Excel Courses
    • Course Outline
    • What you will learn
    • Audience profile
    This module covers the basics of creating and working with Excel workbooks and worksheets. Key lessons include: Starting and saving workbooks Navigating the Status Bar Adding, deleting, and organizing worksheets Splitting worksheet views Outcome: Students will confidently create, save, and organize workbooks.
    Learn how to efficiently navigate and customize Excel's Ribbon and Quick Access Toolbar. Lessons include: Understanding tabs, groups, and commands Adding commands to the Quick Access Toolbar for quick access Outcome: Students will enhance workflow by customizing Excel’s interface.
    Gain familiarity with the Backstage View to manage files and templates. Lessons cover: Opening, saving, and printing workbooks Customizing Excel with personal settings and themes Outcome: Students will effectively use Backstage View for file management.
    This module dives into entering and formatting data in Excel worksheets. Topics include: Entering text, numbers, and dates Adding hyperlinks and using AutoComplete Using the Fill Handle and WordArt Outcome: Students will enter and format data efficiently.
    Learn to apply advanced formatting to make worksheets more readable. Key areas include: Selecting cell ranges and adding colors and themes Using the Font, Alignment, and Number groups to adjust text and number display Outcome: Students will enhance data presentation through styling and formatting.
    This module introduces formula basics and functions in Excel. Lessons cover: Math operators and AutoSum Copying formulas and understanding cell references Outcome: Students will use formulas to perform calculations and understand referencing.
    This module explains efficient row, column, and table management. Topics include: Inserting, deleting, transposing, and resizing rows and columns Converting data lists into tables and filtering data Outcome: Students will organize data effectively using rows, columns, and tables.
    Learn to create, edit, and format various charts to visually represent data. Lessons include: Inserting and customizing charts Using the Chart Tools and Quick Analysis Tool Outcome: Students will represent data visually through different chart types.
    Deepen formula knowledge with advanced functions. Covered topics: IF, PMT, LOOKUP, and date functions Working with named ranges and formulas across worksheets Outcome: Students will enhance data analysis with advanced formulas.
    Prepare workbooks for sharing and printing. Key lessons: Setting page orientation, margins, and print area Adding headers, footers, and scaling for print Outcome: Students will finalize worksheets for professional sharing and presentation.
    Create basic worksheets using Microsoft Excel. Perform calculations in an Excel worksheet. Modify an Excel worksheet. Modify the appearance of data within a worksheet. Manage Excel workbooks. Print the content of an Excel worksheet. Learn how to use handy features. Use formulas and functions. Create and modify charts. Convert, sort, filter, and manage lists. Insert and modify illustrations in a worksheet. Work with tables.
    Students who have little or no familiarity with Microsoft Excel.

    Related Products

    CLA
    Example course title
    LE 1,499.00
    LE 2,000.00
    LE 1,499.00
    CLA
    Example course title
    LE 1,499.00
    LE 2,000.00
    LE 1,499.00
    CLA
    Example course title
    LE 1,499.00
    LE 2,000.00
    LE 1,499.00
    CLA
    Example course title
    LE 1,499.00
    LE 2,000.00
    LE 1,499.00