Ms Excel Fundamentals

Mar 11, 2019

Do you know you can spend less than 2% of your time to complete that repetitive task with the mastery of Microsoft Excel? Do you know that the mastery of Microsoft Excel can cut time spent in data entry, data analysis and manipulation and data reporting by up to 99%? Stop stressing yourself, Learn the efficient way. Let our experts show you the way; We have helped over 2,000 professionals achieve the Mastery of Microsoft Excel. Course Outline

- Creating basic work sheet
o Explore the User Interface and the Ribbon Navigate and Select in Excel
o Obtain Help
o Enter Data and Save a Workbook
o Customize the Quick Access Toolbar

- Performing calculations
o Create Basic Formulas
o Calculate with Functions
o Copy Formulas and Functions

- Modifying a worksheet
o Manipulate Data
o Insert and Delete Cells, Columns, and Rows Search for Data in a Worksheet
o Spell Check a Worksheet
o Sorting
o Filtering data
o Formatting table
o Using data validation
o Advanced filter

- Formatting a worksheet
o Modify Fonts
o Add Borders and Color to Cells
o Change Column Width and Row Height
o Apply Number Formats
o Position Cell Contents
o Apply Cell Styles

- Managing large workbooks
o Format Worksheet Tabs

o Manage Worksheets in a Workbook
o Manage the View of Large Worksheets

- Calculating data and advanced formula
o Manage Cell and Range Names
o Calculate Data Across Worksheets
o Use Specialized Functions
o Analyze Data with Logical and Lookup Functions

- Organizing worksheet and table contents
o Create and Modify Tables
o Format Tables Sort or Filter Worksheet or Table Data
o Calculate Data in a Table or Worksheet

- Creating data using charts
o Create a Chart
o Modify Charts
o Format Charts

- Analyzing tables using pivot tables
- Create a PivotTable Report
- Analyze Data Using Pivot Charts

- Inserting graphic objects
o Insert and Modify Pictures and ClipArt
o Draw and Modify Shapes
o Illustrate Workflow Using SmartArt Graphics Layer and Group Graphic Objects

- Functions and formulas
o Formulas with multiple operators
o Inserting and editing a function
o Defining and tracing formulas
o Using data and time function

- Printing workbook contents
o Print Workbook Contents Using Default Print Options
o Set Print Options
o Set Page Breaks

Apply

For Who?

Account/ HR/ Audit officers 93%
Financial controllers 90%
Financial reporting staff and managers 96%

Schedule

Lagos Stream 1: Mar 11, 2019
Lagos Stream 2: Mar 11, 2019

Fee

₦40,000

Duration

2 Days
Apply