Microsoft Excel 2013

Profile photo of Trainer #2 Teacher: Trainer #2
₦5,000.00
0 student

0 rating


Course Description

MsExcel
Learn Microsoft Excel 2013

Whether you’re a novice or an expert wanting to refresh your skill set with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks.

 

 

 

 

 

 

 

What Will I Learn?

    • Getting Started
    • Editing a Workbook
    • Formatting Worksheets
    • Formatting the Page
    • Building Formulas
    • Viewing and Managing Worksheets
    • Working with Charts
    • Printing Worksheets
    • Working with Data and Tables
    • Collaborating with Excel

<

Click here to enroll in this course.

Course Curriculum

  • Getting Started

    • Lesson 1a: Understanding the Excel Screen, Creating a Workbook, Navigating a Worksheet, Opening and Saving a Workbook
      Viewing Completed Lesson
    • Lesson 1b: Working with Multiple Windows, Printing a Workbook, Getting Help, Closing and Exiting
      Viewing Completed Lesson
  • Editing a Workbook

    • Lesson 2a: Selecting Cells and Cell Ranges, Entering Cell Data, Editing Cell Data, Cutting, Copying, and Pasting, More Pasting Options
      Viewing Completed Lesson
    • Lesson 2b: Using AutoFill, Inserting, Moving, and Deleting Cells, Checking Spelling, Finding and Replacing Text, Hiding Rows and Columns
      Viewing Completed Lesson
  • Formatting Worksheets

    • Lesson 3a: Formatting Text, Cell Alignment and Merging Cells, Formatting Numbers and Dates, Borders and Background Colors, Copying Formatting, Row Heights and Column Widths
      Viewing Completed Lesson
    • Lesson 3b: Applying Conditional Formatting, Applying and Removing Cell Styles, Creating and, Modifying Cell Styles, Find and Replace Formatting, Inserting an Image
      Viewing Completed Lesson
  • Building Formulas

    • Lesson 4a: Formula Basics, Working with Sums and Averages, Referencing External Worksheets, Absolute and Relative Cell References
      Viewing Completed Lesson
    • Lesson 4b: Working with Range Names, Financial Formulas, IF Formulas, Text Formulas, Lookup Formulas, Understanding Formula Errors
      Viewing Completed Lesson
  • Viewing and Managing Worksheets

    • Lesson 5: Viewing Worksheets, Moving and Copying Worksheets, Insert, Rename, and Delete Worksheets, Freezing Rows and Columns, Hiding Worksheets and Gridlines
      Viewing Completed Lesson
  • Working with Charts

    • Lesson 6a: Creating a Chart, Moving, Resizing, and Deleting a Chart, Understanding Chart Types, Changing Chart Layout and Style, Working with Titles and Legends
      Viewing Completed Lesson
    • Lesson 6b: Gridlines, Labels, and Data Tables, Formatting Chart Elements, Add, Rename and Reorder Chart Data, Filtering Charts, Creating Sparklines
      Viewing Completed Lesson
  • Printing Worksheets

    • Lesson 7a: Changing Page Size and Scale, Setting the Print Area and Viewing Page Breaks, Adding Titles, Gridlines and Headings
      Viewing Completed Lesson
    • Lesson 7b: Creating Headers and Footers, Adjusting Page Margins and Orientation
      Viewing Completed Lesson
  • Working with Data and Tables

    • Lesson 9a: Sorting Data, Filtering Data, Using Quick Analysis, Working with Tables, Remove Duplicates and Total
      Viewing Completed Lesson
    • Lesson 9b: Using Data Validation, Filtering with Slicers, Using Flash Fill, Grouping and Outlining Data, Importing and Exporting Text Files
      Viewing Completed Lesson
  • Collaborating with Excel

    • Lesson 9a: Working with Cell Comments, Sharing Workbooks, Tracking Changes in Workbooks, Protecting a Worksheet, Password Protecting a Workbook, Saving Worksheets as Web Pages
      Viewing Completed Lesson
  • Working with PivotTables

    • Lesson 10a: Creating a PivotTable, Adding Multiple Fields to a PivotTable, Specifying PivotTable Data, Changing a PivotTable’s Calculation, Filtering a PivotTable
      Viewing Completed Lesson
    • Lesson 10b: Working with Timelines, Working with PivotTable Layout, Grouping PivotTable Values, Refreshing a PivotTable, Formatting a PivotTable, Creating a PivotChart
      Viewing Completed Lesson