-
03. Entering and Editing Data in Cells
11 Lessons-
Start0301.Entering Text, Numbers, And Dates.mp4
-
Start0302.Entering Numbers As Text.mp4
-
Start0303.Editing The Contents Of A Cell.mp4
-
Start0304.Undo And Redo Actions.mp4
-
Start0305.Cut, Copy, And Paste.mp4
-
Start0306.Dragging And Dropping Cells.mp4
-
Start0307.The Fill Handle.mp4
-
Start0308.Inserting And Deleting Cells Columns And Rows.mp4
-
Start0309.Changing Column Widths And Row Heights.mp4
-
Start0310.Hiding And Un-Hiding Columns And Rows.mp4
-
Start0311.Searching For Values In A Workbook.mp4
-
-
05. Formatting Worksheets
10 Lessons-
Start0501.Selecting Cells For Formatting.mp4
-
Start0502.Modifying Typeface Font, Size, And Colour.mp4
-
Start0503.Merging And Wrapping Cell Contents.mp4
-
Start0504.Using Number Formats.mp4
-
Start0505.Cell Content Alignment And Orientation.mp4
-
Start0506.Adding And Removing Borders From A Selection.mp4
-
Start0507.Applying A Date Format To A Cell Or Range.mp4
-
Start0508.The Format Painter.mp4
-
Start0509.Finding And Replacing Formats.mp4
-
Start0510.Clearing Cell Contents Vs Clearing Cell Formatting.mp4
-
-
06. Workbook and Worksheet Management
5 Lessons-
Start0601.Worksheet Navigation And Coloured Worksheet Tabs.mp4
-
Start0602.Moving Or Copying Worksheets Within And Between Workbooks.mp4
-
Start0603.Viewing And Scrolling Multiple Workbooks At The Same Time.mp4
-
Start0604.Hiding And Un-Hiding Sheets.mp4
-
Start0605.Modifying More Than One Worksheet At A Time.mp4
-
-
07. Page Setup and Printing
7 Lessons-
Start0702.Paper Size, Orientation, Margins, And Scaling Options.mp4
-
Start0701.Using Print Titles And Print Areas.mp4
-
Start0703.Creating Headers and Footers.mp4
-
Start0704.Using The Page Break And The Page Layout Views.mp4
-
Start0705.Printing A Range Of Cells.mp4
-
Start0706.Running The Spell Checker.mp4
-
Start0707.Controlling Most Print Settings In One Place.mp4
-
-
08. Mathematical Formulas
7 Lessons -
12. Graphics Objects
7 Lessons-
Start1201.Obtaining And Inserting Online Images.mp4
-
Start1202.Using SmartArt Graphics.mp4
-
Start1203.Inserting Shapes And Screenshots.mp4
-
Start1204.Formatting Graphical Objects.mp4
-
Start1205.The Stacking Order.mp4
-
Start1206.Grouping Multiple Objects Together.mp4
-
Start1207.Using Graphical Objects And Mathematical Formulas.mp4
-
-
13. Using Charts in Excel
8 Lessons-
Start1301.The New Recommended Charts Option.mp4
-
Start1302.Create A Chart Using The Long Or The Short Method.mp4
-
Start1303.Formatting A Chart With The 2013 Shortcut Options.mp4
-
Start1304.Modifying The Chart Type.mp4
-
Start1305.Formatting Chart Elements.mp4
-
Start1306.Adding A Trendline.mp4
-
Start1307.The Pie Chart In Detail.mp4
-
Start1308.Mini Graphs Sparklines.mp4
-
-
14. Excel As a Database
8 Lessons-
Start1401.Fixing On Screen Rows And Columns.mp4
-
Start1402.Fixing Print Rows And Columns.mp4
-
Start1403.Sorting Data In Excel.mp4
-
Start1404.Filtering Data To Reduce Dataset Size.mp4
-
Start1405.Removing Duplicate Entries In The Data.mp4
-
Start1406.Adding Subtotals To A Worksheet Of Data.mp4
-
Start1407.Using Text To Columns Effectively.mp4
-
Start1408.Linking To Data On A Webpage.mp4
-
-
15. Advanced Formulas
9 Lessons-
Start1501.Using An If Formula.mp4
-
Start1502.Use Of The If Function To Hide Excel Error Messages.mp4
-
Start1503.Datedif A Useful But Hidden Formula.mp4
-
Start1504.Text Manipulation Using Functions.mp4
-
Start1505.Use The Text Function To Format Numbers.mp4
-
Start1506.Date Manipulation Functions.mp4
-
Start1507.Introducing Sumif, Countif, And Averageif.mp4
-
Start1508.Use Of Rank To Calculate Placings.mp4
-
Start1509.Flash Fill The Magic Touch.mp4
-
-
16. Conditional Formatting
5 Lessons
Microsoft Excel 2013 for Beginners
This course takes you through the basics of Excel 2013, no experience is required. Call 0243188830 for any details.
Course Summary
This course is a comprehensive set of tutorials that takes the absolute beginner in excel from novice to advance user. This tutorial contains all the topics every beginner needs to master the fundamental concepts of excel. You will never walk alone as you take this course, as we will always be present to answer your questions and provide help. Begin your journey today.
Course Curriculum
Ernest Owusu
