Microsoft Private Tutor (Basic To Advanced) View Course Outline

Posted Jun 13      Owerri North, Imo State, Nigeria
Post Ad like this for FREE
Services Rendering at Client Location

Ad details

Module 1: Getting Started
 Explore three common uses of excel
 Touring the interface
 Finding the commands you need
 Using the backstage view or the file tab
 Maintaining the compatibility
Module 2: Worksheet Basics
 Creating a worksheet
 Techniques for copying and pasting
 Entering data automatically with Auto Fill
 Targeting large data groups
 Changing a worksheet's structure
Module 3: Excel Formula Basics
 Understanding formulas and functions
 Entering data in a worksheet
 Adding numbers manually
 Adding numbers using Sum and AutoSum
 Adding a whole worksheet
 Working with numbers in columns
 Preventing errors using absolute references
 Working with times and dates
 Using IF
 Naming and using cell ranges
Module 4: Essential Formatting
 Formatting numbers and dates
 Applying fonts, backgrounds colors and borders
 Adjusting columns, rows and text
 Using conditional formatting
 Using custom conditional formatting
 Adding pictures and shapes
Module 5: Advanced Formatting
 Inserting SmartArt
 Coodinating a look using themes
 Applying built-in styles
 Creating and sharing styles
 Using templates
 Creating and using original templates
Module 6: Printing Preparation
 Making the pieces fit
 Inserting headers and footers
 Printing and PDFs
Module 7: Large Excel Projects
 Finding and replacing data
 Freezing panes
 Repeating row and column titles
 Creating multiple custom worksheet views
 Hiding or grouping rows and columns
 Managing worksheets
 Calculating formulas across worksheets
 Consolidating result in a single output
Module 8: Collaborating with Others
 Importing and exploring data in Excel
 Setting workbook permissions
 Inserting and editing comments
 Sharing a workbook
 Tracking changes
 Saving files in shared locations
Module 9: Exploring Excel's Database Features
 Splitting cell data into multiple cells
 Joining data from multiple cells
 Basic and multi-field sorting
 Using tables to sort and filter data
 Inserting automatic subtotals.
 Creating lookup tables
Module 10: Analyzing Data
 Using auditing to diagram
 Using evaluation in Excel
 Working with Goal Seek
 Using data tables in formulas
 Using scenarios in formulas
 Exploring the Analysis ToolPack
Module 11: Advanced Analysis with PivotTables
 Discovering PivotTables
 Creating a basic PivotTable
 Modifying a PivotTable
 Creating and modifying a PivotTable
Module 12: Creating and Using Charts
 Choosing chart types
 Inserting Sparklines
 Creating a column chart
 Modifying a column chart
 Creating and modifying a pie chart
 Placing charts into other office applications
Module 13: Creating and Using Macros
 Understanding macros
 Recording and using a simple macro
 Editing a macro
Module 14: Customizing
 Customizing the Quick Access toolbar
 Customizing the Ribbon bar
 Setting options
Module 15: Exercises and Review
070 xxx

Similar adverts

Show more ads >>>
Last seen 6 days ago
070 xxx
Tell seller that you found ad on
Please read safety tips
  • Do not pay in advance even for the delivery.
  • Please, check the background of the company!
  • DO NOT PAY for ANY certificates, form applications, etc.