COURSE SYLLABUS

  • 1.1 – About Excel
  • 1.2 – The Excel Environment
  • 1.3 – The Title Bar
  • 1.4 – The Ribbon
  • 1.5 – Scroll Bars
  • 1.6 – The Microsoft Office Button
  • 1.7 – The Quick Access Toolbar
  • 1.8 – The Formula Bar
  • 1.9 – The Workbook Window
  • 1.10 – The Status Bar
  • 1.11 – The Workbook View Buttons
  • 1.12 – The Zoom Slider
  • 1.13 – The Mini Toolbar
  • 1.14 – Keyboard Shortcuts
  • 2.1 – Creating New Workbooks
  • 2.2 – Saving Workbooks
  • 2.3 – Closing Workbooks
  • 2.4 – Opening Workbooks
  • 2.5 – Selecting Cells
  • 2.6 – Entering Text Into Cells
  • 2.7 – Entering Numbers Into Cells
  • 2.8 – AutoComplete
  • 2.9 – Pick From Drop-Down List
  • 2.10 – Using The “Window” Command Group
  • 2.11 – Switching to Full-Screen View
  • 2.12 – Renaming Workbooks
  • 2.13 – Working With Excel File Formats
  • 3.1 – Selection Ranges
  • 3.2 – Ranged Data Entry
  • 3.3 – Using AutoFill
  • 4.1 – Ranged Formula Syntax
  • 4.2 – Simple Formula Syntax
  • 4.3 – Writing Formulas
  • 4.4 – Using AutoSum
  • 4.5 – Inserting Function
  • 4.6 – Editing a Range
  • 4.7 – Formula AutoCorrect
  • 4.8 – AutoCalculate
  • 5.1 – Relative References and Absolute References
  • 5.2 – Cutting, Copying & Pasting Data
  • 5.3 – AutoFilling Cells
  • 5.4 – The Undo Button
  • 5.5 – The Rudo Button
  • 6.1 – Selecting Columns and Rows
  • 6.2 – Adjusting Column Width and Row Height
  • 6.3 – Hiding and Unhiding Columns and Rows
  • 6.4 – Inserting and Deleting Columns and Rows
  • 7.1 – Formatting Cells
  • 7.2 – The Format Cells Dialog Box
  • 7.3 – Clearing All Formatting from Calls
  • 7.4 – Copying All Formatting from Cells to Another Area
  • 8.1 – Moving Between Worksheets
  • 8.2 – Selecting Multiple Worksheets
  • 8.3 – Inserting and Deleting Worksheets
  • 8.4 – Renaming Worksheets
  • 8.5 – Coloring Worksheet Tabs
  • 8.6 – Copying or Moving Worksheets
  • 9.1 – Using Page Break Preview
  • 9.2 – Using the Page Layout View
  • 9.3 – The Page Setup Dialog Box
  • 10.1 – Using Print Preview
  • 10.2 – Printing Worksheets
  • 11.1 – Using Excel Help
  • 12.1 – Creating 3D Formulas
  • 12.2 – 3D Formula Syntax
  • 12.3 – Creating 3D Range References
  • 13.1 – Naming Ranges
  • 13.2 – Creating Names from Headings
  • 13.3 – Moving to a Named Range
  • 13.4 – Using Named Ranges in Formulas
  • 13.5 – Naming 3D Ranges
  • 13.6 – Managing Named Ranges
  • 14.1 – Conditional Formatting
  • 14.2 – Finding Cells With Conditional Formatting
  • 14.3 – Clearing Conditional Formatting
  • 14.4 – Using Table And Cell Styles
  • 15.1 – Using Paste Special
  • 15.2 – Pasting Linked Formulas
  • 16.1 – Sharing Workbooks
  • 16.2 – Highlighting Changes
  • 16.3 – Reviewing Changes
  • 16.4 – Using Comments
  • 16.5 – Compare and Merge Workbooks
  • 17.1 – Auditing Worksheets
  • 17.2 – Tracing Precedent and Dependent Cells
  • 17.3 – Tracing Errors
  • 17.4 – Errors Checking
  • 17.5 – Using the Watch Window
  • 17.6 – Call Validation
  • 18.1 – Using Outlines
  • 18.2 – Applying and Removing Outlines
  • 19.1 – Consolidating Data
  • 20.1 – Creating Charts
  • 20.2 – Selecting Charts and Chart Elements
  • 20.3 – Moving and Resizing Charts
  • 20.4 – Changing the Chart Type
  • 20.5 – Changing the Data Range
  • 20.6 – Switching Column and Row Data
  • 20.7 – Choosing a Chart Layout
  • 20.8 – Choosing a Chart Style
  • 20.9 – Printing Charts
  • 20.10 – Deleting Charts
  • 21.1 – Formatting Chart Objects
  • 21.2 – Inserting Objects into a Chart
  • 21.3 – Changing Chart Labels
  • 21.4 – Changing Axes Display
  • 21.5 – Changing the Chart Background
  • 21.6 – Applying Chart Analysis Lines
  • 21.7 – Naming Charts
  • 21.8 – Applying Shape Styles to Chat Elements
  • 21.9 – Applying WordArt Styles to Chart Elements
  • 21.10 – Saving Custom Chart Templates
  • 22.1 – Creating PivotTables and PivotChart
  • 22.2 – Manipulating a PivotTable
  • 22.3 – Changing Calculated Value Fields
  • 22.4 – Applying PivotTable Styles
  • 22.5 – Creating a PivotChart
  • 21.6 – Setting PivotTable Options
  • 22.7 – Sorting and Filtering PivotTable Data
  • 23.1 – Creating a Table
  • 23.2 – Adding and Editing Records
  • 23.3 – Inserting Records and Fields
  • 23.4 – Deleting Records and Fields
  • 24.1 – Sorting Data
  • 24.2 – Custom Sort Orders
  • 25.1 – Using AutoFilters
  • 25.2 – Using the Top 10 AutoFilter
  • 25.3 – Applying a Custom AutoFilter
  • 25.4 – Creating Advanced Filters
  • 25.5 – Applying Multiple Criteria
  • 25.6 – Using Complex Criteria
  • 25.7 – Copying Filtered Results to a New Location
  • 25.8 – Using Database Function
  • 26.1 – Using Data Tables
  • 26.2 – Using Scenario Manager
  • 26.3 – Using Goal Seek
  • 27.1 – The Hlookup and Vlookup Functions
  • 27.2 – Using the IF, AND, And OR Function
  • 28.1 – Unlocking Cells
  • 28.2 – Worksheet Protection
  • 28.3 – Workbook Protection
  • 28.4 – Password Protecting Excel Files
  • 29.1 – Recording Macros
  • 29.2 – Running and Deleting Recorded Macros
  • 29.3 – The Personal Macro Workbook

We bring you the best possible solutions for your business.

View All Services

On the cutting edge.

Curabitur ac leo nunc estibul et mauris vel ante finibus maximus nec ut leo. Integer consectetur luctus. Quisque eros quam, aliquet.

30

Years of experience

4,054

Connections

1200

Clients

89

Countries Served

Blog Insights

Business Insights

Curabitur ac leo nunc estibul et mauris vel ante finibus maximus nec ut leo. Integer consectetur luctus quisque.

Read the blog

Join to newsletter.

There are many variations of passages of Lorem Ipsum available.

Thank you for your message. It has been sent.
There was an error trying to send your message. Please try again later.