Microsoft Office 2013 - Excel

Select currency

Microsoft Office 2013 - Excel
Test scorm
Enquire Now

From Microsoft: Microsoft Excel 2013 is designed to help you get professional-looking results with features that let you get away from walls of numbers and draw more persuasive pictures of your data, guiding you to better, more informed decisions.read more

Microsoft Excel 2013 - Course Introduction

  • Section 1-1 - Create Worksheets and Workbooks
  • Creating New Blank Workbooks
  • Creating New Workbooks Using Templates
  • Importing Files
  • Opening Non-Native Files Directly in Excel
  • Adding Worksheets to Existing Workbooks
  • Copying and Moving Worksheets

Section 1-2 - Navigate Through Worksheets and Workbooks

  • Searching for Data Within a Workbook
  • Using Go To and Name Box
  • Changing Worksheet Order
  • Inserting Hyperlinks

Section 1-3 - Format Worksheets and Workbooks

  • Changing Worksheet Tab Color
  • Modifying Page Setup and Inserting Watermarks
  • Inserting and Deleting Columns and Rows
  • Changing Workbook Themes
  • Adjusting Row Height and Column Width
  • Inserting Headers and Footers
  • Setting Data Validation

Section 1-4 - Customize Options and Views for Worksheets and Workbooks

  • Hiding Columns - Rows - Worksheets
  • Customizing the Quick Access Toolbar and the Ribbon
  • Managing Macro Security
  • Changing Workbook Views
  • Recording Simple Macros
  • Adding Values to Workbook Properties
  • Using Zoom
  • Displaying Formulas
  • Freezing Panes
  • Splitting the Window

Section 1-5 - Configure Worksheets and Workbooks to Print or Save

  • Setting a Print Area
  • Saving Workbooks in Alternate File Formats
  • Printing Individual Worksheets and Scaling
  • Repeating Headers and Footers
  • Maintaining Backward Compatibility
  • Configuring Workbooks to Print
  • Saving Files to Remote Locations

Section 2-1 - Insert Data in Cells and Ranges

  • Appending Data to Worksheets
  • Finding and Replacing Data
  • Copying and Pasting Data
  • Using AutoFill Tool
  • Inserting and Deleting Cells

Section 2-2 - Format Cells and Ranges

  • Merging Cells
  • Modifying Cell Alignment and Indentation plus Changing Font and Font Styles
  • Using Format Painter
  • Wrapping Text Within Cells
  • Applying Number Formatting
  • Applying Highlighting and Cell Styles
  • Changing Text to WordArt

Section 2-3 - Order and Group Cells and Ranges

  • Applying Conditional Formatting
  • Transposing Columns and Rows
  • Inserting Sparklines
  • Creating Named Ranges
  • Creating Outline - Collapsing Groups of Data in Outlines and Inserting Subtotals

Section 3-1 - Create a Table

  • Creating a Table and Moving Between Tables and Ranges
  • Adding and Removing Cells Within Tables
  • Defining Titles

Section 3-2 - Modify a Table

  • Applying Styles to Tables
  • Banding Rows and Columns
  • Inserting Total Rows
  • Removing Styles From Tables

Section 3-3 - Filter and Sort a Table

  • Filtering Records
  • Changing Sort Order
  • Sorting Data on Multiple Columns
  • Removing Duplicates

Section 4-1 - Utilize Cell Ranges and References in Formulas and Functions

  • Utilizing References - Relative - Mixed - Absolute
  • Defining Order of Operations
  • Referencing Cell Ranges in Formulas

Section 4-2 - Summarize Data with Functions

  • Utilizing the SUM Function
  • Utilizing the MIN and MAX Functions
  • Utilizing the COUNT Function
  • Utilizing the AVERAGE Function

Section 4-3 - Utilize Conditional Logic in Functions

  • Utilizing the SUMIF Function
  • Utilizing the AVERAGEIF Function
  • Utilizing the COUNTIF Function

Section 4-4 - Format and Modify Text with Functions

  • Utilizing the RIGHT - LEFT and MID Functions
  • Utilizing the TRIM Function
  • Utilizing the UPPER and LOWER Functions
  • Utilizing the CONCATENATE Function

Section 5-1 - Create a Chart

  • Creating Charts and Graphs
  • Adding Additional Data Series
  • Switching Between Rows and Columns in Source Data
  • Using Quick Analysis

Section 5-2 - Format a Chart

  • Adding Legends
  • Resizing Charts and Graphs
  • Modifying Chart and Graph Parameters
  • Applying Chart Layouts and Styles
  • Positioning Charts and Graphs

Section 5-3 - Insert and Format an Object

  • Inserting Text Boxes
  • Inserting SmartArt
  • Inserting Images
  • Adding Borders to Objects
  • Adding Styles and Effects to Objects
  • Changing Object Colors
  • Modifying Object Properties and Positioning Objects
  • Course Close
  1. Excel 2013 Module 1
7
Start
Opening Non-Native Files Directly in Excel
8
Start
Adding Worksheets to Existing Workbooks
9
Start
Copying and Moving Worksheets
10
Start
Section 1-2 - Navigate Through Worksheets and Workbooks
11
Start
Searching for Data Within a Workbook
12
Start
Using Go To and Name Box
13
Start
Changing Worksheet Order
14
Start
Inserting Hyperlinks
15
Start
Section 1-3 - Format Worksheets and Workbooks
16
Start
Changing Worksheet Tab Color
17
Start
Modifying Page Setup and Inserting Watermarks
18
Start
Inserting and Deleting Columns and Rows
19
Start
Changing Workbook Themes
20
Start
Adjusting Row Height and Column Width
20
Start
Adjusting Row Height and Column Width
21
Start
Inserting Headers and Footers
22
Start
Setting Data Validation
23
Start
Section 1-4 - Customize Options and Views for Worksheets and Workbooks
24
Start
Hiding Columns - Rows - Worksheets
25
Start
Customizing the Quick Access Toolbar and the Ribbon
26
Start
Managing Macro Security
27
Start
Changing Workbook Views
28
Start
Recording Simple Macros
29
Start
Adding Values to Workbook Properties
30
Start
Using Zoom
31
Start
Displaying Formulas
32
Start
Freezing Panes
33
Start
Splitting the Window
34
Start
Section 1-5 - Configure Worksheets and Workbooks to Print or Save
35
Start
Setting a Print Area

latest hermes replica bags もうすぐ母の日です (スタッフブログ) eternity ring copy cartier http://www.latestbracelet.com/replica-cartier-love-diamond-ring-love-on-the-side.html

by
  • Clayton (not verified)
    user_default
    Microsoft Office 2013 - Excel | Destiny Village Institute
    http://www.motogp.com Here is my web page ... andre dovi
  • Clayton (not verified)
    user_default
    Microsoft Office 2013 - Excel | Destiny Village Institute
    http://www.motogp.com Feel free to visit my web-site: andre dovi