" />" />
Call us @ 08025102532 | admin@ilearnhubs.com

Login

Microsoft Excel Basics

In this Excel course, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.

0 STUDENTS ENROLLED

    Excel is a spreadsheet program that allows you to store, organize, and analyze information. While you may think Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program’s powerful features. Whether you’re keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data.

    Course Curriculum

    Module 1: Excel Basics
    Getting Started with Excel 00:15:00
    Learn your way around the Excel environment.
    Understanding OneDrive 00:15:00
    Learn all about working with your Microsoft account and OneDrive.
    Creating and Opening Workbooks FREE 00:15:00
    Learn how to create and open Excel workbooks.
    Saving and Sharing Workbooks FREE 00:15:00
    Learn how to save and share Excel workbooks.
    Module 2: Working with Cells and Sheets
    Cell Basics FREE 00:15:00
    Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions.
    Modifying Columns, Rows, and Cells FREE 00:15:00
    Learn how to modify rows, columns, and cells in Excel.
    Formatting Cells FREE 00:15:00
    Learn all about formatting text in Excel.
    Understanding Number Formats FREE 00:15:00
    Learn all about formatting numbers in Excel.
    Working with Multiple Worksheets FREE 00:15:00
    Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
    Using Find & Replace FREE 00:15:00
    Learn how to use Excel's Find and Replace features to search for specific data.
    Checking Spelling FREE 00:15:00
    Learn how to use Excel's spell check feature.
    Page Layout and Printing FREE 00:15:00
    Learn how to use Excel commands that let you control the way your content will appear on a printed page.
    Module 3: Formulas and Functions
    Intro to Formulas FREE 00:15:00
    Learn how to use cell references to create a simple formula in Excel.
    Creating More Complex Formulas FREE 00:15:00
    Learn how to create a complex formula in Excel.
    Relative and Absolute Cell References FREE 00:15:00
    Learn all about absolute and relative cell references and how they're used in Excel.
    Functions FREE 00:15:00
    Learn the different parts of a function and how to create arguments to calculate values and cell references.
    Module 4: Working with Data
    Basic Tips for Working with Data 00:15:00
    Learn these basic tips for working with data to help you organize it and find what you need.
    Freezing Panes and View Options FREE 00:15:00
    Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet.
    Sorting Data FREE 00:15:00
    Learn how to sort data to better view and organize the contents of your spreadsheet.
    Filtering Data FREE 00:15:00
    Learn how to filter the data in your worksheet to display only the information you need.
    Groups and Subtotals FREE 00:15:00
    Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
    Tables 00:15:00
    Learn how to use styles to format tables in Excel.
    Charts 00:15:00
    Learn how to insert and modify Excel charts to visualize comparisons in your data.
    Conditional Formatting 00:15:00
    Learn how to apply, modify, and delete conditional formatting rules in Excel.
    Comments and Co-authoring 00:15:00
    Learn how to use Excel's track changes and comments features when proofreading workbooks.
    Inspecting and Protecting Workbooks 00:15:00
    Learn how to inspect and protect your Excel workbook.
    Intro to PivotTables 00:15:00
    Learn how to use PivotTables in Excel for stronger data analysis.
    Doing More with PivotTables 00:15:00
    Learn how to do more with PivotTables to better summarize data.
    What-if Analysis 00:15:00
    Learn how to use what-if analysis to answer different types of questions.
    Module 5: Extras
    What is Office 365? 00:15:00
    Learn what Office 365 has to offer in this free lesson.
    New Features in Office 2019 00:15:00
    Discover some of the new features in Office 2019.
    What are Reference Styles? 00:15:00
    Learn all about using reference styles in Excel.
    Office Intelligent Services 00:15:00
    Learn more about the features available through Intelligent Services.
    Using the Draw Tab 00:15:00
    Learn how to use the features available on the Draw tab.
    Working with Icons 00:15:00
    Learn how to add and customize icons.

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    COMING SOON

    Course Categories

    Recent Posts

    top
    Copyright © 2018 iLearnHubs | Powered by: GLOBALTECH
    Need Help? Chat with us
    UA-114833202-7