Get this course

Technical or IT → Generic Systems

Excel Essential Training (C200)


Content
  • Getting started
  • 02_01-What is Excel used for.mp4
  • Using the menu system
  • 01 - Examples
  • 01 - Getting Started.xlsx
  • Using the Quick Access Toolbar
  • Understanding workbooks and worksheets
  • Using the Formula bar
  • Using the Status bar
  • Using navigation tools
  • Using shortcut menus and the Mini toolbar
  • Creating new workbooks
  • Using Excel Help
  • Entering Data
  • Exploring data entry and editing techniques
  • Entering data with AutoFill
  • Working with dates and times
  • Using Undo and Redo
  • Adding comments
  • Using Save or Save As
  • creating formulas and functions
  • Creating simple formulas
  • Copying a formula into adjacent cells
  • Calculating yeartodate totals
  • Creating a percentagechange formula
  • Working with relative, absolute, and mixed references
  • Using SUM and AVERAGE
  • Using other common functions
  • Formatting
  • Exploring font styles and effects
  • Adjusting row heights and column widths
  • Working with alignment and Wrap Text
  • Designing borders
  • Exploring numeric and special formatting
  • Formatting numbers and dates
  • Using conditional formatting
  • Creating and using tables
  • Inserting shapes, arrows, and other visual features
  • Adjusting Worksheet Layout and Data
  • Inserting and deleting rows and columns
  • Hiding and unhiding rows and columns
  • Moving, copying, and inserting data
  • Finding and replacing data
  • Printing
  • Exploring the Page Layout tab and Page Layout view
  • Previewing page breaks
  • Working with Page Setup and printing controls
  • Charts
  • Creating charts
  • Exploring chart types
  • Formatting charts
  • Working with axes, titles, and other chart elements
  • Creating incell charts with sparklines
  • Adjusting Worksheet Views
  • Freezing and unfreezing panes
  • Splitting screens horizontally and vertically
  • Collapsing and expanding data views with outlining
  • Multiple Worksheets and Workbooks
  • Displaying multiple worksheets and workbooks
  • Renaming, inserting, and deleting sheets
  • Moving, copying, and grouping sheets
  • Using formulas to link worksheets and workbooks
  • Locating and maintaining link
  • IF, VLOOKUP, and Power Functions
  • Using IF functions and relational operators
  • Getting approximate table data with the VLOOKUP function
  • Getting exact table data with the VLOOKUP function
  • Using the COUNTIF family of functions
  • Security and Sharing
  • Unlocking cells and protecting worksheets
  • Protecting workbooks
  • Assigning passwords to workbooks
  • Sharing workbooks
  • Tracking changes
  • Data Management Features
  • Sorting data
  • Inserting subtotals in a sorted list
  • Using filters
  • Splitting data into multiple columns
  • Splitting and combining columnar data with Flash Fill
  • Removing duplicate records
  • Using validation tools
  • Data Analysis Tools
  • Using Goal Seek
  • Using Solver
  • Using Scenario Manager
  • Using data tables
  • PivotTables
  • Creating PivotTables
  • Manipulating PivotTable data
  • Grouping by date and time
  • Grouping by other factors
  • Using slicers to clarify and manipulate fields
  • Using PivotCharts
  • Introduction to Macros
  • Exploring the need for macros
  • Creating a simple macro
  • Running a macro
Completion rules
  • All units must be completed
Back