Advanced Excel
Microsoft Excel is a tool that can be used in virtually all careers and is valuable in both professional and personal settings. Whether you need to keep track of medications in inventory for a hospital or create a financial plan for your retirement, Excel enables you to do these activities efficiently and accurately
About The Tutor
Ogechukwukwu Edozie
He graduated from Bayero University, Kano with a Computer Engineering degree. After School, he got a Systems Engineer/ Network Administrator job at Rainbownet. From there he moved to Starcomms Plc where he was a BTS Engineer. After the folding up of Starcomms Plc., he decided to be on his own and has helped set up strong networks and managed software for companies including Godfrey Okoye University, TESH, and Akaraiwe & Associates, to name a few. For the past few years, he delved into Data Science and has since continued to consult and teach database courses both offline and online of which this is one of them. As the founder and CEO of ClassRoom Solution, his mission is to democratize data science education and make it accessible to everyone, regardless of their background. He is committed to providing high-quality, practical training that prepares students and workers alike for real-world challenges and empowers them to succeed in their careers. Our ultimate goal is to bridge the gap between academia and industry and help create a more skilled and knowledgeable workforce.
He is married with two lovely sons.
In this course, we will be learning the following topics:
SORTING & FILTERING
a. Sorting Data
ADVANCED EXCEL TOOLS
a. Nested Functions & Macros
b. Conditional Formatting
PRESENTING DATA WITH CHARTS
a. Choosing a Chart Type
b. Formatting Charts
c. Using Charts With Microsoft Word and Microsoft Powerpoint
TABLES
a. Table Basics
b. Intermediate Table Skills
MULTIPLE SHEET FILES
a. Multiple Sheet Basics
b. Formulas With 3-D References
c. Templates
EXCEL PIVOT TABLES
a. Excel Pivot Tables