Video course · 15 chapters · 83 min · certificate
Excel Formatting and AI Automation: Boost Productivity with Advanced Techniques
A live class on Excel formatting: fonts, styles and colours, number formats, merging cells, borders and fills, a practical formatting exercise, row heights, plus Q&A on courses, careers, prompting and AI basics.
What you'll learn
- Change font face, style and colour
- Apply number formats
- Merge cells for long text
- Set border colour, thickness and fills
- Format a real dataset
- Adjust row heights
Chapters
15 chapters · 83:23-
6:58
01Intro Members
Attendance and warm-up
A live class begins.
-
4:18
02Fonts Members
Agenda and font face
Changing fonts.
-
6:13
03Fonts Members
Font style
Bold, italic, underline.
-
2:47
04Colour Members
Font colour
Coloured text.
-
6:31
05Numbers Members
Number format
Formatting numbers.
-
6:59
06Layout Members
Merging cells
Long strings.
-
12:17
07Borders Members
Borders and fills
Colour and thickness.
-
11:42
08Practice Members
Practical formatting
Formatting a real file.
-
3:09
09Layout Members
Row height
Adjusting rows.
-
5:26
10Info Members
Course enrollment information
Paid programme details.
-
2:25
11Careers Members
Career guidance
Student questions.
-
4:30
12Info Members
Class timings
Schedule questions.
-
3:44
13Info Members
ADF with Fabric and recordings
Related courses.
-
2:15
14AI Members
Prompts and next-word prediction
AI basics in Q&A.
-
4:09
15Wrap-up Members
Experience discussion and conclusion
Honest careers advice.
Jobs this course suits
Our AI checked this course against 500 jobs; these get the most out of it. Each job links to its learning path.