Standard Microsoft Excel TrainingCourse Duration : 2 Week (6 Meetings)
2 Hours per meetingGH₵500.00
TRAINING FOR THE FUTURE TODAY
MICROSOFT EXCEL COURSE PART 1 (Standard Level)
This course is designed for the Excel beginner or the Excel user looking for a refresher. In this course you’ll learn how to work with text and numeric data, create basic Excel functions, build impactful charts, and construct basic PivotTables. You’ll also learn a variety of tips and tricks to improve your productivity in Excel
| Lessons | Course Details | |
|---|---|---|
Ribbon| Quick Access Toolbar | Developer Tab | | |
| Workbook | Save in 97-2003 Format | View Multiple Workbooks | Auto Recover | |
| Worksheets | Zoom | Split | Freeze Panes | Group Worksheets | Consolidate | View Multiple Worksheets | Get Sheet Name | Spell Check | |
| Format Cells | Decimal Places | Date and Time Formats | Fractions | Currency vs Accounting | Text to Numbers | Numbers to Text | Custom Number Format | Format Painter | Cell Styles | Themes | Wrap Text | Merge Cells | Strikethrough | Superscript and Subscript | Check Mark | |
| Find & Select | Find Features | Delete Blank Rows | Row Differences | Copy Visible Cells Only | Search Box | |
| Templates | Calendar | Budget | Meal Planner | Invoice | Automated Invoice | Default Templates | BMI calculator | |
| Data Validation | Reject Invalid Dates | Budget Limit | Prevent Duplicate Entries | Product Codes | Drop-down List | Dependent Drop-down Lists | Kg to lbs | |
| Keyboard Shortcuts | Function Keys | Insert Row | Save As | Delete Row | Scroll Lock | Bullet Points | Line Break | Show Formulas | |
| Workbook Views | Page Breaks | Headers and Footers | Page Numbers | Print Titles | Center on Page | Print Gridlines & Headings | Print Area | ||
| Share | Embed | PDF | Share Workbooks | OneDrive | Online | Import Access Data | Microsoft Query | Import/Export Text Files | XML | |
| Protect | Protect Workbook | Protect Sheet | Lock Cells | Read-only Workbook | Mark as Final | |
| Range | AutoFill | Fibonacci Sequence | Custom Lists | Comments | Hide Columns or Rows | Skip Blanks | AutoFit | Transpose | Union and Intersect | Flash Fill | Move Columnsl | |
| Formulas and Functions | Subtract | Multiply | Divide | Square Root | Percentage | Names in Formulas | Dynamic Named Range | Paste Options | Status Bar | Quick Operations | Not Equal To | Cm to inches | Discount | |
Training Sessions
| Day | Morning | Afternoon | Evening |
|---|---|---|---|
| Weekday | 09:00am - 11:00am | 01:00pm - 03:00pm | 06:00pm - 08:00pm |
| Weekend (Saturday) | 09:00am - 12pm (1st batch), 01:00pm - 05:00pm (2nd batch) | ||
| Weekend (Sundays) | 02:00pm - 4:00pm (1st batch), 04:00pm - 06:00pm (2nd batch) | ||
| Course Duration | 2 Weeks (6 Meetings) | ||
| Location: | Nadkan Plaza, in the same building with Societe Generale Bank, Dansoman Asoredanho. | ||
- GH₵500.00