Udemy
UdemyExcel 2016 (365) Intermediate Training Course | Office 365
4.5(583)18k studentsINTERMEDIATEEnglish
Korshub's take
Excel Beyond the Basics
If you've touched Excel before but feel like you're only scratching the surface, this intermediate course builds on your foundation with a comprehensive look at the functions that make spreadsheets powerful. You'll work through time and date functions, mathematical operations, logical reasoning, statistical analysis, text manipulation, financial calculations, lookup references, and database operations.
Beyond formulas, the course covers named ranges to organize your worksheets, cell formatting techniques to make data readable, worksheet manipulation for multi-sheet projects, templates for consistency, and the underrated paste-special options that unlock real efficiency. It's the bridge between basic data entry and building sophisticated spreadsheets.
About this course
Microsoft Excel 2016 (365) Intermediate Training Course
Excel 2016 is included with Microsoft Office 365
This course is designed for people with some limited experience of using PowerPoint 2016. It will also suit people who has studied my Excel 2016 Foundation level course.
The course starts by looking at Microsoft Excel 2016 Setup & Printing Issues
We then start looking at Excel Functions and Formulas including Time & Date Functions, Mathematical Functions, Logical Functions, Mathematical Functions, Statistical Functions, Text Functions, Financial Functions, Lookup Functions and finally Database Functions
Next we see how to create and use Named Ranges within an Excel worksheet.
The next chapter shows you how to use Cell Formatting techniques.
Then we see the various Worksheets manipulation techniques.
Finally we look at the use of Microsoft Excel Templates and the Microsoft Excel Paste Special Options.
Advertisement
