Welcome, Guest: Join Nairaland / LOGIN! / Trending / Recent / New
Stats: 2,775,740 members, 6,612,590 topics. Date: Thursday, 02 December 2021 at 05:43 AM

Microsoft Excel Master Class And Boot Camp - Business - Nairaland

Nairaland Forum / Nairaland / General / Business / Microsoft Excel Master Class And Boot Camp (521 Views)

Certified Data Protection Lead Auditor (CDPLA) Training And Boot Camp / Certified Data Protection Lead Auditor (CDPLA) Training And Boot Camp / Microsoft Excel Master Class And Boot Camp (2) (3) (4)

(1) (Reply)

Microsoft Excel Master Class And Boot Camp by Iiema: 11:39am On Mar 12, 2020
This Excel Masterclass is designed to equip you with the vital skills required to effectively use Microsoft Excel to create and edit workbooks and spreadsheets. Tailored especially to professionals who wish to use Excel in their work on a regular basis, the course focuses on practical tips for getting the most out of the program while improving productivity. Suitable for both those new to Excel and those with some previous experience, over 1 day of training, the course will show how to fully unlock Excel’s powerful capabilities for sorting and manipulating data. The course concludes with an exam to test your knowledge.

Learn the Top 10 Excel Shortcuts with this Excel Masterclass Training.
Gain knowledge of highlighting cells containing values, text, and duplicate values.Develop your skillset of using formulas and creating Pivot Tables.

COURSE OUTLINE

Module 1: Navigation of the Excel Interface

▪ Starting Excel
▪ The Excel Tab Interface
▪ The Main Components of the Workbook Screen
▪ Understanding the Backstage View
▪ Accessing the Backstage View
▪ Understanding Dialog Boxes
▪ Launching Dialog Boxes
▪ Understanding the Quick Access Toolbar
▪ Adding Commands to the QAT
▪ Changing the Location of the Bar
▪ Adding a New Command to the Toolbar
▪ Removing a Command from the Quick Access Bar
▪ Understanding the Status Bar
Module 2: Use of Lists and Tables

▪ Understanding Lists
▪ Applying a Filter
▪ Performing an Alphabetical Sort
▪ Performing a Numerical Sort
▪ Creating a Table
▪ Converting Selection to a Data Table
▪ Inserting or Deleting Table Records
▪ Deleting Table Records
▪ Removing Duplicates
▪ Modifying a Table
▪ Sorting Data in a Table
▪ Naming Tables
▪ Resizing Tables
▪ Converting a Table to a Range
▪ Deleting a Table
Module 3: Conditional Formatting

▪ Understanding Conditional Formatting
▪ Highlight Cells Containing Values
▪ Highlighting Cells Containing Text
▪ Highlighting Duplicate Values
▪ Using Top and Bottom Rules
▪ Using Data Bars
▪ Using Colour Scales
▪ Using Icon Sets
▪ Creating Custom Rules
▪ The Conditional Formatting Rules Manager
▪ Clearing Rules
Module 4: Using Formulas and Creating Pivot Tables

▪ Using Sparklines
▪ Using Formulas in Excel
▪ Exploring Excel Functions
▪ Insert Function Button
▪ Working with Names and Ranges
▪ Creating a Named Reference
▪ Removing a Named Reference
▪ What If Formulas
▪ Common Logical Functions
▪ Arguments used within If Functions
▪ Creating a PivotTable from an Excel Data List
▪ Add/Remove/Reorganise Data Fields
▪ Changing the PivotTable Design
▪ Refresh Data/Change Data Source
▪ Creating and Modifying a Pivot Chart
▪ VLOOKUP
▪ Zooming In and Out Quickly
▪ Undo, Redo, and repeat with keystroke
Who should attend this Excel Training Course?
The course is intended for anybody wishing to learn how to use Microsoft Excel

Excel Masterclass Prerequisites
There are no formal prerequisites, but you should have some familiarity with computers and Windows 10.

Contact us via our website: www.iiema.org

(1) (Reply)

Free Animation Training Today / King Tonto Hit Diamond 4 / Cream For Chocolate Skin - Branding, Bottles, Tubes, Jars Etc

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2021 Oluwaseun Osewa. All rights reserved. See How To Advertise. 108
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.