Microsoft Private Tutor (Basic To Advanced) View Course Outline

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

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
 Using SUMIF and AVERAGEIF
 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 >>>
₦10,000
Webmaster
Verified
Last seen 2 months ago
070 xxx
07064456833
Tell seller that you found ad on Jiji.ng
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.